Skip to main content
K
KB in FL
Inspiring
October 30, 2009
Question

Problems viewing a recordset

  • October 30, 2009
  • 2 replies
  • 611 views

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?

This topic has been closed for replies.

2 replies

K
KB in FLAuthor
Inspiring
November 2, 2009

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.

B
bregent
Participating Frequently
November 2, 2009

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?

B
bregent
Participating Frequently
October 30, 2009

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

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices