Unable to pass parameter to SP from a listbox.

[uncleroydee]

Man, I'd be in deep doody if it weren't for you guys...

When trying to pass parameter to stored procedure from listbox and 3 textboxes.

Recordset1.setParameter 1, Listbox4.getvalue
Recordset1.setParameter 2, Textbox1.value
Recordset1.setParameter 3, Textbox2.value
Recordset1.setParameter 4, Textbox3.value
Recordset1.open()

I get the following error:
ADODB.Parameter error '800a0d5d'

The application is using a value of the wrong type for the current operation.

When I replace listbox4 with textbox4.value and key in a value on the web page the SP executes correctly.

The listbox is populated from a recordset, but seems to be working OK; the datatype and length is the same in the listbox source as the target table.

 

[uncleroydee]

Sorry for the false alarm, guys. I see that I missed the "()" after listbox4.getvalue...

I would be introuble without this forum and I appreciate very much the time and effort that people put into it.

Hopefully someday I can repay the kindness.