sql

S

Strow

here is the statement


strSQL = "UPDATE SPECIALPAGE SET Title='" & Upload.Form("Title") & "',

Description='" & Replace(Upload.Form("txtDescription"), "'", "''") &"'
Where
ID =" & Upload.Form("txtID")


now i have a check box that i also need to update but i want to pass
the
checkbox as a numerical value, how would i i add that into my statement

Active="& Replace(Upload.Form("cboActive")) im not sure???

this is for a website
 
Top