Vin
There isn't an easy way of doing this in SQL.
The usual way AFAIK is to grab the entire query
each time and then navigate to the right row of
the query results.
If you cache the CFQUERY it's not a problem
preformance-wise. Otherwise it is!
Nick
-----Original Message-----
From: Vincent [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 29, 2000 6:36 AM
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
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
------------------------------------------------------------------------------
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.
