I have an asp page that sends data to another page that is formatted for printing. The page for printing needs to have a hidden check that will update the database to let the user know the page has been printed. Please help. Thank you.g
Can I do something similar to the following? This page reads in the attendee information filled in on the previou page and prints it along with information about the customer. I would like to send a checkmark back to the attendee table to show that the attendee arrived and information has been printed (sending a check back if customernumber, attendeefirstname, attendeelastname equals what has been read in).
set conn = Server.CreateObject("ADODB.Connection"
conn.Open xDb_Conn_Str
MyVar1 = Request.Querystring("CustomerNumber"
MyVar2 = Request.QueryString("AttendeeFirstName"
MyVar3 = Request.QueryString("AttendeeLastName"
strsql = "select * from Customer WHERE CUSTOMERNUMBER='" & myVar1 & "'"
sql = "insert into Attendee(Printed) Values(True) WHERE Attendee='" & myVar1 & "' and AttendeeFirstName='" & myVar2 & "' and AttendeeLastName='" & myVar3 & "'"
set rs = Server.CreateObject("ADODB.Recordset"
conn.Execute(sql)
rs.Open strsql, conn, 1, 2
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.