Microsoft Jet Database Engine Error 80040e10

Please Help!

[carlh2003]

Hi

I have this code at the top of my ASP page:

<%
Dim strConnect, SQL
Dim rs
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../db/mydata.mdb")
SQL = "SELECT * FROM ProdInfo WHERE ProdID=" &request("ID")
Set rs = Server.CreateObject("Adodb.Recordset") 
rs.Open SQL, strConnect << LINE 7
aa=rs("itemDesc")
%>

Then somewhere in the middle i have:

<%=aa%>

Then at the bottom i have:

<%
rs.close
set rs=nothing
%>

I seem to be getting this error message (really starting to bug me now! :)

Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/common/file1.asp, line 7

And whenever i query the page with www.mydomain.com/common/file1.asp?id=IPP420 it returns the above error message.

I dont understand why the message is coming up because the column 'ProdID' does exist in the table 'ProdInfo'

Thanks in advance,

Carl

[txbakers]

&request("ID")

You need a space between the "&" and the request

[dupati1]

Instead of this:

Set rs = Server.CreateObject("Adodb.Recordset")
rs.Open SQL, strConnect

TRY THIS:

Set rs = Server.CreateObject("Adodb.Recordset")
Set Conn = Server.CreateObject("ADODB.Connection")

Conn.Open strConnect
rs.Open SQL, Conn

Thanks

VJ

[macrost]

You also might want to look at using Request.QueryString("var")

Mac

[Zaphod Beeblebrox]

Add single quotes in ProdID=" &request("ID") so it reads ProdID='" &request("ID") & "'"

[carlh2003]

Cheers Zaphod_Beeblebrox

It works gr8 now, thanks to everyone else as well.

Carl.