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 : 08:41:04
|
| 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?Many Thanks & Kind Regards, GraziGrazi |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
vganesh76
Yak Posting Veteran
64 Posts |
Posted - 2004-05-26 : 00:05:52
|
| The value of the Checkbox is not assigned , Assign the checkbox with appropriate values like Yes <input type=checkbox name=chkYes value=1>No <input type=checkbox name=chkYes value=2>if the value is not set it will return as On if checked else off.Enjoy working |
 |
|
|
|
|
|
Checkbox and Stored Procedure data type problem