Problem with Access query in ASP Error Too few parameters. Expected 1.

[Matsam]

Hi,

I am using ADODB connection in ASP and want to run a select query depending on a runtime criteria.
But its not working and giving error "Too few parameters. Expected 1." But the same thing is working when pasted in Access query. The problem comes when including a LIKE criteria.
can anybody help me ??

Matsam

[danp129]

In the very least you should provide the line of code that is giving the error and if it's failing on a query, an output of the query (response.write strSQL).

[Matsam]

Hi,
thx for responding. i m sorry tht i left out the query.

it is as follows

PublTitle = trim(Request.Fo rm.Item("txtTit le"))
sqlQuery = "Select Authors, Year, PaperTitle, Source, Volume, Number, PageNo from Bibliography where [SlNo] > 0 "

cond = " and [PaperTitle] like ""*" & PublTitle & "*"""
sqlQuery = sqlQuery & cond

the response.write returns the following

Select Authors, Year, PaperTitle, Source, Volume, Number, PageNo from Bibliography where [SlNo] > 0 and [PaperTitle] like "*the*"

the same query works when pasted to access..

it works in ASP ony if condition is avioded.

pls help me

matsam

[danp129]

Did you include the line it's failing on?

[Matsam]

It fails on the open line of the select query.

rs.Open sqlQuery, cn1, adOpenStatic

Problem comes when <and [PaperTitle] like "*the*" > is added. Otherwise it works fine.
I think it is not working for any string expressions. Numerics are ok.

Error is :
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.


matsam

[danp129]

It fails on the open line of the select query.

rs.Open sqlQuery, cn1, adOpenStatic

Problem comes when <and [PaperTitle] like "*the*" > is added. Otherwise it works fine.
I think it is not working for any string expressions. Numerics are ok.

Error is :
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.


matsam

It may be expecting you to specify a locktype like:

rs.Open sqlQuery, cn1, adOpenStatic, adLockOptomisti c

Also, when written out to the page the SQL should be looking like this
[PaperTitle] like '*the*' < note the single qoutes instead of double.

You may also want to use % instead of * cause I think * only works as a wildcard within Access but I could be mistaken.

[Matsam]

It may be expecting you to specify a locktype like:

rs.Open sqlQuery, cn1, adOpenStatic, adLockOptomisti c

Also, when written out to the page the SQL should be looking like this
[PaperTitle] like '*the*' < note the single qoutes instead of double.

You may also want to use % instead of * cause I think * only works as a wildcard within Access but I could be mistaken.

Hi,

Many many thanks to you..
My problem solved. As u said, it was bcoz of the double quotation instead of single. I also changed * to %. Now it worked. I was trying the same in Access query too, but it was working fine. And when I replaced * with % in Access, it was not working. Thatz why i didnt tried it in ASP code..
Any way, I wasted my 3 days for this simple thing..

Once again thanks a lot

Matsam