ASP.NET

funciton abc()<br />
{<br />
if(confirm('navigate to logout'))<br />
            {<br />
                location.href('logout.aspx');<br />
                return false;<br />
            }<br />
<br />
}

krishnavaradharajan wrote:

mssql....

SET ANSI_WARNINGS OFF<br />
Declare @ono varchar(50)<br />
DECLARE My_Cursor CURSOR FOR<br />
SELECT distinct ProductID<br />
FROM Products<br />
<br />
drop table tmp<br />
create table tmp(ono varchar(50),allname varchar(50))<br />
<br />
OPEN My_Cursor<br />
<br />
FETCH NEXT FROM My_Cursor into @ono<br />
WHILE @@FETCH_STATUS = 0<br />
BEGIN<br />
DECLARE @MyList varchar(100)<br />
set @MyList = null<br />
SELECT  @MyList = COALESCE(@MyList + ', ', '') + <br />
   CAST(CategoryID AS varchar(5))<br />
FROM Products where ProductID = @ono<br />
insert into tmp(ono,allname) values(@ono,@MyList)<br />
    FETCH NEXT FROM My_Cursor into @ono<br />
END<br />
<br />
CLOSE My_Cursor<br />
DEALLOCATE My_Cursor<br />
<br />
select * from tmp<br />
<br />