Forums
This topic is locked
Filtered recordset not navgating properly!
Posted 31 Aug 2001 10:00:13
1
has voted
31 Aug 2001 10:00:13 camille seaman posted:
<font face='Arial'>I have quite a few of these recordsets that filter on a certain criteria usually from a list in a dynamic form, it displays the correct number of records found only when the "next"or"last" link is clicked it returns zero as the results ? Has anyone seen this can tell me what I may be doing wrong or how to make this work ? It would be very appreciated!</font id='Arial'>Replies
Replied 31 Aug 2001 15:33:14
31 Aug 2001 15:33:14 Joel Martinez replied:
you've got to make sure that you're sending the search criteria along when they click the next link...
I assume that you'd be using the querystring, so just always append it to the next and last button so that when it posts back with the offset info, the query can pick up the criteria.
Joel Martinez [ ]
----------
set rs = conn.execute("SELECT answer FROM brain WHERE question = "& forumPost &"
'2nd place is just 1st Loser
E-Commerce Concepts with Ultradev...pre-order yours at
www.basic-ultradev.com/ecomm_concepts/
I assume that you'd be using the querystring, so just always append it to the next and last button so that when it posts back with the offset info, the query can pick up the criteria.
Joel Martinez [ ]
----------
set rs = conn.execute("SELECT answer FROM brain WHERE question = "& forumPost &"
'2nd place is just 1st Loser
E-Commerce Concepts with Ultradev...pre-order yours at
www.basic-ultradev.com/ecomm_concepts/
Replied 03 Sep 2001 06:48:28
03 Sep 2001 06:48:28 camille seaman replied:
<font face='Trebuchet MS'>Thanks Joel, but I haven't got an inkling as to how to append querystrings to my links.. any clues?</font id='Trebuchet MS'>