Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gbaia
Yak Posting Veteran
52 Posts |
 Posted - 2004-04-13 : 12:22:26
|
| Hi! I have a form in ASP which has a checkbox, this value is a parameter required by the stored procedure to insert the selected value.When the checkbox is not checked I have an error: 'spAdmin_insert_image' expects parameter @BW which was not supplied.If the checkbox is checked then I have another error:Application uses a value of the wront type for the current operation. This is because when the checkbox is checked the value passed is 'on' rather than 1.Any ideas of how I can solve this?Thank you so much for any help!GraziGrazi |
|
|
web7junkie
Starting Member
6 Posts |
Posted - 2004-04-13 : 15:07:49
|
| HIdo a validation if checkbox is checked or not before u call the sp. Set a value of 1 to the input variable when the checkbox is checked and 0 if its not checked. |
 |
|
|
gbaia
Yak Posting Veteran
52 Posts |
Posted - 2004-04-17 : 13:18:09
|
| Thanks!Grazi |
|
|
|
|
|
|
Stored procedure and checkbox (bit) type