I am having a strange problem with a fairly simple query I am running on an Access DB. After running the query, I am populating a drop down list with the results. For some strange reason, when I loop through the results and insert each record into the <option> tags, it is skipping the very first record.
If I write the results from the query directly to the page, instead of populating the list, no problems at all. The first records shows up just fine.
Basically, if I query the database and only one result is being returned, I am presented with an empty drop down list.
Has anyone encountered this problem before? Am I missing something somewhere?!
Thanks in advance!
If I write the results from the query directly to the page, instead of populating the list, no problems at all. The first records shows up just fine.
Basically, if I query the database and only one result is being returned, I am presented with an empty drop down list.
Has anyone encountered this problem before? Am I missing something somewhere?!
Thanks in advance!