When you do the next 10, add in part of the where clause to be
WHERE column not in (choices already shown) It'll be longer the deeper you
go, but will avoid doing any duplicates.
> 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/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
