Hi experts, how to send two data via response.write to clients?
asp serverside:
<%
dim user, sta
user = request.querystring("q")
sta = "post"
response.expires=-1
set cn=Server.CreateObject("ADODB.Connection")
cn.ConnectionString = "driver={SQL Server};server=MYSERVER;uid=;pwd=;database=MobileOrder"
cn.Open
'cn.Execute("Update Trxno set db_docno = db_docno +1 where code='WebTrx'")
Set rs = cn.Execute("Select messages, name from PublicNotice where status='" & sta & "' And destination='" & user & "'")
With rs
If not .BOF = True And not .EOF = True Then
''found record
response.write(rs("messages")) //here I want to include the "name"
cn.Execute("Update PublicNotice set status='Read' where status='post'")
else
response.write("No record!")
End If
end with
%>
Our community of experts have been thoroughly vetted for their expertise and industry experience.