[thelist] Select QRY problem
Pringle, Ron
RPringle at aurora-il.org
Mon Mar 14 13:19:20 CST 2005
Peter et al-
Thanks for the tips, it ended up being the simple fact that I hadn't
converted my querystring into an integer, so of course it wasn't matching,
and of course it wasn't selecting any records.
Der.
However, I would have thought it would have thrown a type mismatch error.
Live and learn!
Ron
> When this happens, the first thing to do is to
> response.write the SQL statement so you can see what it's
> really saying to the DB. Chances are you have an empty
> "detailsID" parameter.
>
> From: "Pringle, Ron" RPringle at aurora-il.org
>
> I'm using VBScript and Access 2000.
>
> I'm trying to select a specific record from my DB and am getting the
> following error:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
> [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
> Expected 1.
More information about the thelist
mailing list