Recordset Parameters Problems

[LSD57]

Hi,

I can't understand why my recordset won't work when I put Textbox3.value in the value box of the parameter tab in recordset properties. I keep geeting the message that it is of the wrong type but I know through writing the value to the screen that it is an integer.

Can anyone help?

 

[fhlee]

Try:
voRecordset("FieldName&quot = cint( Textbox3.value )
- or -
voRecordset("FieldName&quot = clng( Textbox3.value )

depending on the type of your database column.
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Visit -->

http://www.replicaSi.com

for (Replica) Watches, Pen, Handbags, Hats, Jerseys and more ... at prices that makes your code spin ...
~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

 

[MerlinB]

You probably need to prefix the value with an = sign.

Actually, I do not use the parameters bit of the recordset properties. I set the recordset to be 'do not automatically open'. Then in the thisPage_onenter event, you can specify the parameters and then open the recordset. Its easier to control and to see whats going on.

http://www.websitedesign.co.uk

http://www.zentext.com

(Content Management)