Wednesday, January 16, 2013

JAVASCRIPT Validation by css class


function validate(matchClass) {
var reg = new RegExp("^[a-zA-Z0-9 *]*$");
var elems = document.getElementsByTagName('*'), i;
for (i in elems) {
if ((" " + elems[i].className + " ").indexOf(" " + matchClass + " ") > -1) {
if (reg.test(elems[i].value) == false) {
alert('Please enter a valid search keyword');
elems[i].value = "";
elems[i].focus();
return false;}}}
return false;}

SQL Split function


CREATE FUNCTION dbo.Split(@String VARCHAR(8000), @Delimiter CHAR(1)) 
RETURNS @temptable TABLE (items VARCHAR(8000)) 
AS 
BEGIN DECLARE @idx INT 
DECLARE @slice VARCHAR(8000) 
SELECT @idx = 1 
IF LEN(@String)<1 font="font" is="is" nbsp="nbsp" null="null" or="or" return="return" tring="tring">
WHILE @idx!= 0 
BEGIN 
SET @idx = CHARINDEX(@Delimiter,@String) 
IF @idx!=0 
SET @slice = LEFT(@String,@idx - 1) 
ELSE 
SET @slice = @String IF(LEN(@slice)>0) 
INSERT INTO @temptable(Items) VALUES(@slice) 
SET @String = RIGHT(@String,LEN(@String) - @idx) 
IF LEN(@String) = 0 
BREAK 
END 
RETURN 
END