ADODB.Recordset error '800a0bb9'

[Guest_imported]

I'm having a problem connecting to my database, as I keep getting the following error: ADODB.Recordset error '800a0bb9' The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.
The offending line of code is the line contained in this segment, ``rsFieldEntry.Filter = "FieldTestID = " & Request("FieldTestID&quot``


Dim rsFieldEntry
Dim blnNew
Set rsFieldEntry=Server.CreateObject("ADODB.Recordset&quot
rsFieldEntry.Open "FieldTest",objConn, adOpenForwardOnly, adLockOptimistic, adCmdTable
If Request.Form(&quot;Delete&quot <> &quot; &quot; Then 'user wishes to delete an item
rsFieldEntry.Filter = &quot;FieldTestID = &quot; &amp; Request(&quot;FieldTestID&quot
If Not rsFieldEntry.EOF Then rsFieldEntry.Delete

My table name is FieldTest and the record in the db is FieldTestID
Thanks for any answers.

 

[RealQuiet]

Not sure what the datatype of your db field is, but if it is not numeric, you need to surround your variable with single quotes. Try this.
Try rsFieldEntry.Filter = &quot;FieldTestID = '&quot; &amp; Request(&quot;FieldTestID&quot &amp; &quot;'&quot;