I have a product search page that uses two different SQL queries. If they search by size it is just a regular SQL query, but also retrieves all the size info. If they search by brand only, it uses a select distinct and excludes and size info. It all works other than when the person tries to go to the next results page. If they are searching by size it works perfectly. If they search by brand it stays on the first page. Does objRS.AbsolutePage not work with a SELECT Distinct? It seems to be the only major difference between the two queries. I'd rather not have to loop through the recordset, but it might be my only option.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SELECT Distinct and Absolute Page
- Thread starter Jeremy21b
- Start date
RhythmAddict112
Programmer
I dont know anything about objRS.AbsolutePage so I cannot comment on that, but if you're stuck loopin through an r/s use the getRows() method and loop through you array instead. It will be a lot faster...also, it wouldn't hurt to show us some code...
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question