How about
select top 1 * from xyz
where xyzID < '#form.xyz_id#'
Or does the xyz_id from the form represent something else?
--Ben Doom
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
> 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]
- Previous Row in a table coldfusion . developer
- Re: Previous Row in a table Joe Eugene
- RE: Previous Row in a table Ben Doom
- RE: Previous Row in a table Sandy Clark
- Re: Previous Row in a table David Delbridge