in query
Uh, why not just use cfoutput query=foo startrow=3
maxrows=2 out of
curiosity?
-Original Message-
From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 3:20 PM
To: CF-Talk
Subject: RE: Finding next 2 items in query
You're explaining
, 2002 6:20 PM
To: CF-Talk
Subject: RE: Finding next 2 items in query
You're explaining yourself just fine. No worries.
Basically, you're looking at some conditional logic a few queries.
Something like this:
1) Query DB for currently active items, sort by ID.
2) Discard the 1st record
First I'd deactivate the old 2.
UPDATE tablename
SET active = 'NO'
WHERE active = 'YES'
I think you'll have to fill us in on why 33, and 12 meet the criteria.
I guess if you have a nice query you use to get the 2 records you want
to update you can plug that query into:
UPDATE tablename
SET
--
ID* - Active - Approved
--
12 - No - Yes
23 - No - No
24 - No - Yes
29 - Yes - Yes
32 - Yes - Yes
33 - No - Yes
40 - No - No
I think you'll have to fill us in on why 33, and 12 meet the
criteria
Because
PROTECTED]
WWW: http://www.evoch.com/
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 12:08 PM
To: CF-Talk
Subject: Re: Finding next 2 items in query
--
ID* - Active - Approved
--
12
Uh, why not just use cfoutput query=foo startrow=3 maxrows=2 out of
curiosity?
-Original Message-
From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 3:20 PM
To: CF-Talk
Subject: RE: Finding next 2 items in query
You're explaining yourself just fine
6 matches
Mail list logo