send null parameter to access with asp

G

gefilte

I have an asp form that has text input boxes on it in order to allow users to
query the recordset that is displayed. It uses a stored procedure in access
with [origin] as one of the parameters.

Here's the code in asp that creates and assigns the parameter:

SET OBJPARAM = OBJCOMM.CREATEPARAMETER("ORIGIN", ADVARCHAR,ADPARAMINPUT, 50)
qryparam1 = request.form("orig city")
OBJCOMM.PARAMETERS("ORIGIN") = QRYPARAM1

It works fine if someone types in the textbox a value and queries the
recordset. However, if they want to "show all", it gives an error, asking for
the object value for the parameter. How do you send a null, or "like *" value
to a stored procedure.

The criteria in my stored procedure is: 'Like "*" & [origin]'

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime valu 0
How do you call a stored procedure that returns a value? 3
How do you pass parameters to a stored procedure 2
Text in middle of concatenated values 3
Too few parameters error with a IIF statement 5
append parameter - data types in adp that correspond to sql data types 1

Top