Alert Message

[kirubagari]

<%        
set cn = server.CreateObject("ADODB.CONNECTION")
cn.open Session("IE_conn")
set rsuser= server.CreateObject("ADODB.RECORDSET")             
sql = "SELECT * FROM SIL_WAFERSTART_LOGIN Where logouttime is null"
set rsuser= cn.execute(sql)
if not (rsuser.eof) then
Response.Write "<script type='text/javascript'>alert(" & rsuser("login") & ");</script>"
 

Hi im having problem when pass d value in alert message?
There is no alert message prompt.If i replace with string the alert message prompt without any problem.
Please help

[Rabbit]

You need to enclose the parameter to alert in quotes.

Response.Write "<script type='text/javascript'>alert('" & rsuser("login") & "');</script>" 

[kirubagari]

Hi,

Thanks.
I have assigned the value into variable but the alert is not prompt up.

Alert message is prompt up if the variable is string:

<%        
set cn = server.CreateObject("ADODB.CONNECTION")
cn.open Session("RE_conn")
set rsuser= server.CreateObject("ADODB.RECORDSET")             
sql = "SELECT * FROM SIL_ABC_LOGIN Where logouttime is null"
set rsuser= cn.execute(sql)
if not (rsuser.eof) then
MyVariable = "Yet to be developed."
Response.Write "<script type='text/javascript'>alert('" & MyVariable & "');</script>"
 
end if 
%>

Alert message is not prompt up if i replace with sql data.Please help.I have attached the error for expert reference.

<%        
set cn = server.CreateObject("ADODB.CONNECTION")
cn.open Session("RE_conn")
set rsuser= server.CreateObject("ADODB.RECORDSET")             
sql = "SELECT * FROM SIL_ABC_LOGIN Where logouttime is null"
set rsuser= cn.execute(sql)
if not (rsuser.eof) then
MyVariable = rsuser ("login")
Response.Write "<script type='text/javascript'>alert('" & MyVariable & "');</script>"
end if 
%>

[Rabbit]

If there are any single quotes in the variable data, you will have to escape them.