I suggest trying to utilise the STARTROW and MAXROWS with your query.
<CFOUTPUT QUERY="query_name" GROUP="query_column"
GROUPCASESENSITIVE="yes/no" STARTROW="start_row" MAXROWS="max_rows_output">
> -----Original Message-----
> From: Vincent [SMTP:[EMAIL PROTECTED]]
> Sent: 29 September 2000 06:36
> To: CF-Talk
> Subject: A <cfquery> problem.
>
> hi,
> I guess this is more of an SQL problem... what I wanted was
> for me to be able to select a group of rows in my cfquery statement.
> eg:
> <cfquery name="get_items" datasource="users" maxrows = 10>
> SELECT itemnum
> FROM items
> WHERE user_id = 12345
> </cfquery>
>
> Now this will get me the top 10 rows, yes! Now what Im looking at is
> rows 10-20, then 20-30....etc
>
> Is this possible. I know of one way, but its kinda a long cut.
>
> thanks
> regards,
>
> VIN
>
> --------------------------------------------------------------------------
> ----
> Archives: http://www.mail-archive.com/[email protected]/
> 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.
-----------------------------------------------
Any opinions expressed in this message are those of the individual and not necessarily
the company. This message and any files transmitted with it are confidential and
solely for the use of the intended recipient. If you are not the intended recipient
or the person responsible for delivering to the intended recipient, be advised that
you have received this message in error and that any use is strictly prohibited.
Sapphire Technologies Ltd
http://www.sapphire.net
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
