Startrow would work if only the one ID were in the table, but what are you
going to get if there is 15 or 20 rows between that particular ID? It won't
work correctly. You really need to cache the query and use startrow and
maxrow in your cfoutput tag.
Dave
From: "Mike Connolly" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 29, 2000 4:03 AM
Subject: RE: A <cfquery> problem.
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.
------------------------------------------------------------------------------
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.
