Last post May 18, 2008 11:42 PM by mah-skeet
May 18, 2008 12:46 PM|mah-skeet|LINK
I know this forum is for .NET, but I thought someone would be able to help or send me in the right direction because frankly, I'm running out of options.
I have a query in Access that runs fine if you enter empty parameters, but when I run the query from ASP I'm not getting any results (like I do in Access). Can anyone offer any advice? The code I'm using comes from
Any help is greatly appreciated.
May 18, 2008 01:37 PM|Mikesdotnetting|LINK
I prefer to pass the name of the procedure (query) as a method of the connection object:
Set rs = Server.CreateObject("ADODB.RecordSet")
conn.MySavedQuery param1, param2, rs
May 18, 2008 11:42 PM|mah-skeet|LINK
Thanks Mike. Instead of sending a empty parameter, I changed my sql a bit (instead of is null...I use Like). From asp I replace the null parameter with %. I'll certainly consider using a method next time. Thanks again for your help.