shanegarcia
Programmer
Hi, I have an ASP program that queries a SQL database based on multiple user selections stored in an array. I then SPLIT() the array to get at individual items.
My problem is that after the initial pass (which gets data successfully), the second call of the sub with the corresponding parameters dies with an EOF. Consequently, the other items don't display. I know that there are other records which match the query coz I've checked it manually. It doesn't occur in VB though. Just in this ASP program....
I've been trying to figure out this weird behavior but can't seem to hack it... any help would be greatly appreciated.
Actually, I'm pretty desperate... Help!!! =)
If you need to take a look at the code, I can post it... Thanks for the assist...
My problem is that after the initial pass (which gets data successfully), the second call of the sub with the corresponding parameters dies with an EOF. Consequently, the other items don't display. I know that there are other records which match the query coz I've checked it manually. It doesn't occur in VB though. Just in this ASP program....
I've been trying to figure out this weird behavior but can't seem to hack it... any help would be greatly appreciated.
Actually, I'm pretty desperate... Help!!! =)
If you need to take a look at the code, I can post it... Thanks for the assist...