[thelist] Select QRY problem

[Pringle, Ron]

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.