Filter Problems

[Peter Oulman]

I have been having trouble getting the filter to work with our data.
We are retrieving the data via stored procedure and the grid works fine.
The filter screen also displays fine, but when applying a filter I get the following error message:

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.
/ANS/main_grid.asp, line 29

Below is the sytax I am using for the filter fields.. it is pretty basic.

MySummary.dbfilterflds="0,1,2,3,Heading=Filter Database Records"

We are using the AspDB PRO version

Thank you for your assistance

[John]

Hi Peter,

Can't tell from your one line of code where the problem is. Suggestions:

1) Paste your code here
2) Turn on MySummary.dbDebug=true then post the output results when you click the filter screen. I think your answer will be there.

Also, you don't say what kind of database you're using. If it's SQL Server or Oracle, make SURE you set MySummary.dbDBTYPE = "SQL", etc. - see the manual.

Let us know what happens. Thanks,

John



------------
Peter Oulman at 3/11/99 12:27:21 PM

I have been having trouble getting the filter to work with our data.
We are retrieving the data via stored procedure and the grid works fine.
The filter screen also displays fine, but when applying a filter I get the following error message:

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.
/ANS/main_grid.asp, line 29

Below is the sytax I am using for the filter fields.. it is pretty basic.

MySummary.dbfilterflds="0,1,2,3,Heading=Filter Database Records"

We are using the AspDB PRO version

Thank you for your assistance