if checkbox true insert value problem ?

[Fary4u]

Hi

is any body know where is actual problem is coz it's look me some problem ?
to insert value into the MS ACCESS DATABASE after the value is true form html

 
<input type="checkbox" name="1" value="1">
<input type="checkbox" name="2" value="2">
 
st1 = Request.Form("1")
st2 = Request.Form("2")
 
If st1 = "True" Then
            sql = "INSERT INTO Search(v) values " _
                      & "( '" & st1 & "')"
            response.write "insert value 1"
end if
else If st2 = "True" Then
            sql = "INSERT INTO Search(v) values " _
                      & "( '" & st2 & "')"
            response.write "insert value 2"
end if
 
 

but after true value it has to be insert the value into the specificed field ?

[markrawlingson]

2 problems here..

1. Checkboxes, by default, return a value of "on" if they are checked, and do not return any value if they are not checked. However, since you are supplying a value for your checkboxes, they will return that value if they are checked, rather than "on", and will not return a value if they are not checked. So first of all you are checking to see if the checkboxes are "true" which they aren't.

Second thing is that your if.. else.. statement is wrong.

try the following..

<input type="checkbox" name="1" value="1">
<input type="checkbox" name="2" value="2">
 
st1 = Request.Form("1")
st2 = Request.Form("2")
 
If st1 = "1" Then
            sql = "INSERT INTO Search(v) values " _
                      & "( '" & st1 & "')"
            response.write "insert value 1"
end if
If st2 = "2" Then
            sql = "INSERT INTO Search(v) values " _
                      & "( '" & st2 & "')"
            response.write "insert value 2"
end if
 

hope this helps.
Sincerely,
Mark