Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

send a hidden checkbox value

Status
Not open for further replies.

danieljoo

MIS
Oct 9, 2002
43
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top