Nathan
If you let CF cache the query, this can be done quite efficiently....
the same query is reused and only your position pointer need change.
As the same query is reused, prior data will *not* be returned in
subsequent segments that *you* extract from the query.
HTH
Dick
At 4:30 PM -0600 11/12/00, Nathan Stanford wrote:
>Is anyone reading my posts?
>
>-----Original Message-----
>From: Nathan Stanford [mailto:[EMAIL PROTECTED]]
>Sent: Saturday, November 11, 2000 11:26 PM
>To: CF-Talk
>Subject: Complicated Search.
>
>
>I have several drop downs in a search and with multiple choices the user can
>select.
>
>If the user returns 10 or more hits on their search, I want to be able to
>create a page 1, 2, 3 kind of like a prev and next button situation.
>
>
>I already know how to do this normally but the problem is if the query has
>multiple form fields with multiple choices. I also want the data to return
>in random order and not be repeated in other pages.
>
>How can I do this?
>
>What if more then 1000 hits are made?
>
>
>Thanks,
>Nathan
>Mr.ColdFusion
>
>----------------------------------------------------------------------------
>--------------------
>Archives: http://www.mail-archive.com/[email protected]/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
>message with 'unsubscribe' in the body to [EMAIL PROTECTED]
>
>---------------------------------------------------------------------
>---------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or
>send a message with 'unsubscribe' in the body to
>[EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
