Very creative solution...thanks
-----Original Message-----
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 11, 2000 9:31 AM
To: [EMAIL PROTECTED]
Subject: RE: Can you pass a query??
> Let's say I had a query that has 10 rows, but I only want to
> display 5 rows
> at a time. A link will then call the same tag do display the next 5 rows.
> How can I do this without running the query each time?
>
> Can I pass a query as a url variable?
> Can I put the query into an array and pass the array?
Here's an idea - if you can't cache the query, run it once completely, Now
pass the list of Identities to every page.
On the specific page, break-out the small part of the list you need, and run
a query on those entries...
select myFields
from myTable
where ID in (#smallIDList#)
Might spark some ideas...
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
