Store the values of a checkbox in a SQL table from ASP form

Will that work for .NET?

what data type does the database column have?
how are you doing it now?

you can use that while building a sql statement as well.

query = "insert into table (txt1, txt2, txt3, chk1,num1) values (" & _
        "'" & request.form("text1") & "'," & _
        "'" & request.form("text2") & "'," & _
        "'" & request.form("text3") & "',"
if request.form("chkbox") = "givenvalue" then
  query = query & "1,"
else
  query = query & "0,"
end if
query = query & request.form("number1") & ")"

conn.execute query

this method will work for .net, but there might be a better syntax.  since you posted in asp (classic) and didnt specify .net though, that is why i gave you vbscript syntax.  

I am adding the values via strong-typed datasets, so the queries are already built, and I am just calling an insert statement from the page to load the values into the SQL table.

you are developing this page in asp.net?  you will need to ask your question in the asp.net topic area because classic asp doesnt have all those fancy pre-built objects. :)

k thanks.

one thing I found was that depending on the type of data connection you have-- or datasource--you might have to use a synax for passing the parameters into the update and insert statements. Usually most examples show using @variable in the update syntax but for example with the MySql ODBC driver you have to put the update string together like this:  "update tablename set var1=?, var2=? where columnX=?"

Like WMIF said though, this is the oldschool ASP topic area.

It's best to forget about T/F and store it as character data.  

Interpret the results and decide if f=0 and t=1 and then store the right data.

Then you can make it "stickY" by doing
<%if recordset.fields.item("importantdata")=1 then response.write("checked")%> in your <input> tag.

The corresponding code is

<input type="checkbox" <see above code> name="thischeckbox"> check here

{this is an example so it's designed to hit the highlights, not execute properly}

<%if request.form("thischeckbox"<>"" then recordset.fields.item("importantdata")=1 else recordset.fields.item("importantdata")=0%>

at the end of your row do a recordset.update
-make sure the recordset is updateable

this keeps your code compact and simple, it lets you execute and update at the same time.

IT's not as "clean" but it's easier to debug IMHO and simpler to find when you are chasing down a bug or an update.