strDriver = Request("driver")
'Response.Write strDriver
Set rsResults = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT tblResults.* "
strSQL = strSQL & "FROM tblResults "
strSQL = strSQL & "WHERE tblResults.Driver like " & strDriver & " ;"
rsResults.CursorType = 3
Line 58>>> rsResults.Open strSQL, adoCon
I get the folowing error when I do>> RaceResult.asp?driver=amiller
Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/res/RaceResult.asp, line 58
The field in the db is a text field.......I am confused, if I change the
coloumn to my RaceID column and pass a value it works.
Does strDriver end up containing anything? Add this line after the
"Response" line.
Response.Write strDriver
Response.end
If it does show containing data then....
What about changing this...
> strDriver = Request("driver")
...to this...
strDriver = Request.Querystring("driver")
--
Phillip Windell
pwin...@wandtv.com
WAND-TV (ABC Affiliate)
www.wandtv.com
both ways show data but same error when i take out response.end
Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/res/RaceResult.asp, line 61
line>>rsResults.Open strSQL, adoCon
This is strange,,,,I feel stupid....if I use a column that has a number it
works
"Phillip Windell" <pwin...@wandtv.com> wrote in message
news:eRFXkB$7CHA...@TK2MSFTNGP11.phx.gbl...
Create the query in the Access Query Builder then switch to SQL View. Does
it look like this:
WHERE tblResults.Driver like amiller
or like this:
WHERE tblResults.Driver like "amiller"
I bet it looks like the second one. String data needs to be delimited by
quotes. You need to make your query in ASP look like this. BTW, why are you
using Like? Without wildcards, you may as well use the more efficient =.
I like to avoid this delimiter issue by using saved parameter queries.
Create a saved query in Access with this SQL:
SELECT tblResults.* FROM tblResults
WHERE tblResults.Driver = [pDriver]
Save the query as GetResults. In ASP, do this:
Set rsResults = server.createobject("adodb.recordset")
adoCon.GetResults strDriver, rsResults
HTH,
Bob Barrows
"CD" <mcd...@hotmail.nospam.com> wrote in message
news:eSIMPI$7CHA...@TK2MSFTNGP12.phx.gbl...
"Bob Barrows" <reb_...@yahoo.com> wrote in message
news:ukS$6S$7CHA...@TK2MSFTNGP11.phx.gbl...