Forums
This topic is locked
Checkbox values
Posted 15 Mar 2004 20:34:22
1
has voted
15 Mar 2004 20:34:22 Greg LeBreck posted:
In ASP with a MS SQL dbaseI have a form with 4 checkboxes. I notice that when the user selects the checks he wants the form submits to the dbase as N for an empty box and Y for a checked box.
I would like it to submit a 0 or a 1.
Is this possible?
Replies
Replied 15 Mar 2004 20:53:46
15 Mar 2004 20:53:46 Rene Bandsma replied:
When you see at the 'Insert Record' in the Server Behavior section and you select the right checkbox in de 'submit as' dropdown menu you will see the following options:
- Text
- Numeric
- Date
- Date (MS Access)
- Checkbox (Y, N)
- Checkbox (1, 0)
- Checkbox (-1, 0)
- Checkbox MS Access
Just select your 1, 0 opion are you're done.
In the code-view you'll see something like this:
<pre id=code><font face=courier size=2 id=code> MM_editConnection = MM_xtreme_STRING
MM_editTable = "Fieldname"
MM_editRedirectUrl = ""
MM_fieldsStr = "checkbox|value"
MM_columnsStr = "Amount|none,-1,0" </font id=code></pre id=code>
- Text
- Numeric
- Date
- Date (MS Access)
- Checkbox (Y, N)
- Checkbox (1, 0)
- Checkbox (-1, 0)
- Checkbox MS Access
Just select your 1, 0 opion are you're done.
In the code-view you'll see something like this:
<pre id=code><font face=courier size=2 id=code> MM_editConnection = MM_xtreme_STRING
MM_editTable = "Fieldname"
MM_editRedirectUrl = ""
MM_fieldsStr = "checkbox|value"
MM_columnsStr = "Amount|none,-1,0" </font id=code></pre id=code>
Replied 15 Mar 2004 20:55:05
15 Mar 2004 20:55:05 Greg LeBreck replied:
Just caught that, but thank you for the quick answer!