Hi Erika.
Could you please be more specific as to what you want to eliminate. If it's
just the top 5 at the time (which could change) then I would do it right
within the query since it's always best to let your DB do the work!
Access or SQL2K:
select *
from whatevs
where id not in (
select top 5 ID
from whatevs
)
SQL2k5 and 2K8 you can use the row_number() function:
(mySQL has a similar function but don't remember the syntax)
select *
from whatevs
where row_number() over 5
Let us know if that's not really what you're looking for. :)
On Tue, Mar 17, 2009 at 8:54 AM, Erika L. Walker <[email protected]>wrote:
>
> Hidy ho.
>
> I've got a page that displays the top 5 records sorted by a date entered in
> the DB by the user. There's a "more" link at the bottom to go to the rest
> of
> the records. Client doesn't want the top 5 records from the front page to
> display on the "all" pages. I'm of the mind set that they should repeat so
> a
> user can page thru ALL the records however they want .. but in the event I
> cant change their minds ...
>
> What's the easiest way to eliminate those first 5 when they have the
> capacity to change all the time and I need to pass the info via URL vars?
>
> Thankies.
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:292026
Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
