Filters

[GIGN]

I am having trouble getting RecordSet.Filters to work.

This works RecordSet.Filter = ""

But anything else just fails with an 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.
Any ideas?

IIs/4.0 PWS Windows98

 

[Guest_imported]

Why don't you post the piece of code where you use this property of the recordset?

 

[GIGN]

because I am pretty sure it's right. And the page is large.

...
Set the Record set up for paging
SQL_DATA = "SELECT * FROM items WHERE field6 =" & "'" & Request("category&quot & "' ORDER BY field7 ASC"
Set Conn = Server.createObject("ADODB.Connection&quot
Conn.open ("inventory_link&quot
Response.write Application("conn_string&quot
Set RecordSet = Server.createObject("ADODB.Recordset&quot



RecordSet.CursorLocation = 3 'adUseClient
RecordSet.CursorType = 3 'adOpenStatic
RecordSet.ActiveConnection = Conn




RecordSet.open SQL_DATA,Conn,3,3
RecordSet.Filter = "field7 LIKE F*" '--error here
...

 

[GIGN]

I have found the filter does work - it is just that I had the wrong wildcard.

devguru said either "*" OR "%" works.

I have found with my current setup, only "%" will work

phew problem solved!

;-)