asked on Set value of checkbox when not checked
I have an insert statement that requires a value from a certain field.
This field is a checkbox that saves a text value into the database, the value in this case is "Mon"
When its selected all works well, but if the checkbox is not selected it doesn't pass any value. I need it to pass:
"N" if not checked and "Mon" if checked
This field is a checkbox that saves a text value into the database, the value in this case is "Mon"
<input <%If (CStr((UserLogin.Fields.Item("loginmon").Value)) = CStr("Mon")) Then Response.Write("checked=""checked""") : Response.Write("")%> <%If (((UserLogin.Fields.Item("loginmon").Value)) = ("Mon")) Then Response.Write("checked=""checked""") : Response.Write("")%> name="loginmon" type="checkbox" id="loginmon" value="Mon">
When its selected all works well, but if the checkbox is not selected it doesn't pass any value. I need it to pass:
"N" if not checked and "Mon" if checked
ASPWeb DevelopmentHTML
Last Comment
Dave Baldwin
ASKER
got it. Can I do that in my update statement ?
I had this same page in ASP/JavaScript and this part worked, when moved to ASP/VB script it stopped working.
This is the line that updates on of the fields that has this issue:
MM_editCmd.Parameters.Appe
The value that the checkbox passes is "Mon" if not then its blank. How can I enter "" instead of null if not checked ?
I had this same page in ASP/JavaScript and this part worked, when moved to ASP/VB script it stopped working.
This is the line that updates on of the fields that has this issue:
MM_editCmd.Parameters.Appe
The value that the checkbox passes is "Mon" if not then its blank. How can I enter "" instead of null if not checked ?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks for the idea, this worked:
MM_editCmd.Parameters.Appe
MM_editCmd.Parameters.Appe
You're welcome, glad to help.
You need to provide your own default value and change it only when you get a value from that checkbox.