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

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).

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

it is as follows

PublTitle = trim(Request.Form.Item("txtTitle"))
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

Did you include the line it's failing on?

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 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, adLockOptomistic

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.

It may be expecting you to specify a locktype like:

rs.Open sqlQuery, cn1, adOpenStatic, adLockOptomistic

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