Problems viewing a recordset

[KB in FL]

I am so confused......

I am using ASPVB to attempt to query a database and return values to a dynamic data table. If I build the query using the dynamic table button in the data tab, and use only 1 WHERE parameter, all is well. If, on the other hand, I attempt to add multiple parameters to the WHERE statement, the wheels come off.

When I build the query in the Recordset dialog box as shown and hit Test, I get the proper response from the database.

When I complete the dialog for the dynamic table and then attempt to run the page, I get only the table headings and no data. (No errors are displayed)

What am I missing?

[bregent]

You are using AND condition so both conditions must be true to return results. Is that the case?

[KB in FL]

Thanks for the reply!!!

Yes, the condition was deliberately set up. As I mentioned, when I click on the Test button, the correct records are displayed in the test window, but no records show when the page is run.

[bregent]

KB in FL wrote:

Thanks for the reply!!!

Yes, the condition was deliberately set up. As I mentioned, when I click on the Test button, the correct records are displayed in the test window, but no records show when the page is run.

I would then guess that something is not being passed correctly from the form to the script. Do you have a url for this page?