RE: Finding next 2 items in query

2002-09-23 Thread Mosh Teitelbaum
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

RE: Finding next 2 items in query

2002-09-23 Thread Mosh Teitelbaum
, 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

RE: Finding next 2 items in query

2002-09-20 Thread Greg Luce
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

Re: Finding next 2 items in query

2002-09-20 Thread W Luke
-- 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

RE: Finding next 2 items in query

2002-09-20 Thread Mosh Teitelbaum
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

RE: Finding next 2 items in query

2002-09-20 Thread Costas Piliotis
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