Andrew
|
| Posted: 12/03/2004, 1:59 PM |
|
 I have a custom insert of type SQL where I am attempting to insert the values of 2 label's (type integer) into integer fields. ..and I keep getting that datatype error.....one or more required parameters are missing........when I stick integers in instead of variable/expressions/etc....the insert works perfectly....is there any detailed info on custom inserts like this? I am doing it in an editable grid so it has to happen for each record. THANKS!!
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 12/03/2004, 2:02 PM |
|
Quick thought: this could be because labels never submit any values, thus on submission (before insert) the label values are blank (and should be because this is just a text displayed on the page and never submitted with forms).
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
Andrew
|
| Posted: 12/03/2004, 2:16 PM |
|
Thanks Peterr...it happenning with hidden and text boxes too 
|
|
|
|
Andrew
|
| Posted: 12/03/2004, 2:21 PM |
|
imagine a commerce site selling towels....a user need a grid to enter quantities of each towel size they want. The editable grid is the only way I know to process the records one at a time after they are acted on by a user......
so I trick it by allowing update......then I can code the insert in the before update event and get a shopping cart record for each row. Am I making sense?
|
|
|
|
peterr
Posts: 5971
|
| Posted: 12/03/2004, 4:24 PM |
|
I understand what the Editable Grid can be used for.
My first response was just a guess, and based on the fact that you're using labels which always have empty values.
The problem with the hidden and textbox fields could be different, thus you could have several combined issues that are more difficult to analyze.
Anyway, I don't know too much about your project, your code, etc., so just a generic advice would be to debug your program. Print and analyze the values of your hidden field and text boxes, print the SQL, etc. For example if the values of the controls are null then you'll know that the problem is not in the SQL. Otherwise it may be in the SQL.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Andrew
|
| Posted: 12/03/2004, 6:43 PM |
|
Thanks Peter! I appreciate what you do here!
|
|
|
|
