problem about db connection

[hu68]

hi, there
I have some problem in my asp page the error message like this:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
a couple of weeks ago , I use the same asp page,it's fine.
but now it doesn't work. Could any one give me some suggestion? thanks in advance.

 

[Turkbear]

Code please...The error can be caused by too many thing to guess at..

 

[hu68]

Thanks,Turkber
the followings are code:
......
set cnn = server.createobject("adodb.connection&quot
cnn.open "WEBORDER"
sql5= "select Inquery.ID,Inquery.Section, Inquery.Length, Inquery.Qty, Inquery.RequiredDate from inquery where jobnum='"&job &"' order by Inquery.Id"
Set rs = Server.CreateObject("ADODB.Recordset&quot
rs.Open sql5, cnn, adOpenStatic [according to error message this line cause error!]
rs.PageSize =90
.............
thanks for any hint!

 

[link9]

Chances are, you don't have a value for the variable, 'job', which you are trying to insert into the sql statement.

Right before the line that throws the error, put this:

response.write(sql5)

and see what the statement looks like. Your error will most likely be apparent.

 

[hu68]

Hi,Link9 & Turkbear
Thanks for your suggestion,I've already fixed my problem as what you suggested.
Thanks alot!