<cfloop query="pullinfo">
<cfif condition="meets some sort of criteria">
<cfquery name="newquery">
Select * from xyz table
where xyz_id = prevrowid and xyz_sent = 1
</cfquery>
</cfif>
<cfset prevrowid = xyz_id>
</cfloop>
_____
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 1:14 PM
To: CF-Talk
Subject: Previous Row in a table
Hi,
I'm running a query with a specific row ID. From there, I'm trying to
extract a
previous row's information where the row meets a bit value of 1. Example,
(SQL
logic written out, pseudo)
queryname=pull_info
Query all entries
from xyz table
where xyz_id = value passed from form
Once this row has been identified, I now need to get the xyz_id of the row
before it that meets a certain criteria.
(SQL logic written out, pseudo) Here's where I'm stuck
query all entries
from xyz table
???
look before pull_info.xyz_id AND where xyz_sent = 1
Does this make sense?
Thanks,
D
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
