You wrote:
>>i dont wannt to call both queries everytime... i'm prefer call the first query only
>>once and store the ID in a variable, like session or anything else...
I can't ?
Can you use an in/out variable? Just pass the count back in and test for a non-null
integer around the rowcount query.
If using Oracle, you might do something like the following for the primary query...
SELECT *
FROM (SELECT rownum row_sequence, v.*
FROM (SELECT fulfiller_name,
quantity,
shipto_name,
shipto_street1,
shipto_street2,
shipto_city,
shipto_state,
shipto_zip_code,
serial_number
FROM SOME_FULFILLMENT_TABLE
WHERE process_log_id = 12345
AND (upper(shipto_name) like upper ('%ar%'))
ORDER BY fulfiller_name) v
)
WHERE row_sequence between 1 and 20
Lonny Eckert
Mi Services Group, Inc.
Work Phone: 610-230-2500 x147
E-mail: [EMAIL PROTECTED]
www.mi-services.com <http://www.mi-services.com/>
-----Original Message-----
From: Rodrigo Cohen [mailto:[EMAIL PROTECTED]
Sent: Friday, July 04, 2003 8:17 AM
To: CF-Talk
Subject: Pagination issues
Cedric,
i dont wannt to call both queries everytime... i'm prefer call the first query only
once and store the ID in a variable, like session or anything else...
I can't ?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
