Hi Mike,
From the code you provided, you seems want to concate a certain sql
statement string depend on some checkbox's value, yes?
Your code is as
==================
strSQL = "update table1 set " & _
if chActive.checked = true then
"active='Yes'
end if
==================
the above code may cause compile error due to syntax problems. We should
change it as following
Dim strSQL As String
strSQL = "update table1 set"
If chActive.checked = True Then
strSQL = strSQL & "active='Yes'"
End If
Also, are you write the code directory in aspx file via <script
runat=server>......</script> block rather than using code behind? I
recommend that you use codebehind , that'll help avoid many syntax
mistakes. In addition, here is the reference on processing the asp.net
checkbox control's value in page code:
http://msdn.microsoft.com/library/en...gSettingCheckb
oxWebControlValueProgrammatically.asp?frame=true
Hope also helps. Thanks.
Regards,
Steven Cheng
Microsoft Online Support
Get Secure!
www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)