i have a plain html page containing a form asking which tests request no the user wish to view then submit to an asp page for processing.

asp page:

<%
dim TestRequest

TestRequest = request.form ("txtTestRequestNo")

set conn=server.createobject("adodb.connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/inetpub/wwwroot/database/HTC.mdb"

sql="Select * from tblCustomers, tblAbrasions where CustID=ID AND TestRequestNo = TestRequest"

Set rs=conn.execute(SQL)
%>

i got the following error when i add the part "AND TestRequestNo = TestRequest":

Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/project/report-sample.asp, line 18


without adding the part "AND TestRequestNo = TestRequest"; it just display all available test request nos (with its information), but i only want to display the request test requests by the user.

thanks

You must use the ASP concatenation like

"Select * from tblCustomers, tblAbrasions where CustID=" & ID & " AND TestRequestNo = " &TestRequest & " "

BTW, on your connection string. It is wierd.

I use it like

gblDB = "c:/inetpub/wwwroot/database/HTC.mdb"
Set gblConn	= Server.CreateObject("ADODB.Connection")
gblDBConnString = "Provider=Microsoft.Jet.OLEDB.4.0;" &_
				          "Persist Security Info=False;" &_
				          "Data Source=" & gblDB
gblConn.Open gblDBConnString

now i got this error message:

Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression 'CustID= AND TestRequestNo = TS3000'

with the changing code as:

dim TestRequest

TestRequest = Request.Form ("txtTestRequestNo")
response.write TestRequest


gblDB = "c:/inetpub/wwwroot/database/HTC.mdb"
Set gblConn = Server.CreateObject("ADODB.Connection")
gblDBConnString = "Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Persist Security Info=False;" &_
"Data Source=" & gblDB
gblConn.Open gblDBConnString

sql="Select * from tblCustomers, tblAbrasions where CustID= " &ID& " AND TestRequestNo = " &TestRequest & " "

Set rs=gblconn.execute(SQL)
%>

---------------------------------------

when i take out the parenthesis around "ID":

sql="Select * from tblCustomers, tblAbrasions where CustID= ID AND TestRequestNo = " &TestRequest & " "

it gives me this error message:

Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/project/report-sample1a.asp, line 22


thanks

I finally got it to work with slight modification to the sql statement:

sql="Select * from tblCustomers, tblAbrasions where ID = CustID and TestRequestNo = '" &TestRequest& "'"

thanks