Wouldn't it be simpler to do something like:
where AppID in (#form.appid#)
HTH
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - The Intelligent Mail Server
Join the DevCon community at www.coolfusion.com/devcon
----- Original Message -----
From: "Jones, Becky" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, August 27, 2001 5:00 PM
Subject: loop question
> my query below keeps putting an OR after the last appid.
> how can i fix that?
> thanks,
> bec.
> <cfquery name="qryGetApp" datasource="ITDATA">
> SELECT *
> FROM qryCHECKOUT
> WHERE <cfloop list="#form.appid#" index="h">
> AppID = #h#
> <cfif qryDetails.recordcount is not qryDetails.currentrow>
> <cfoutput>or </cfoutput>
> </cfif>
> </cfloop>
> AND CheckIn IS NULL
> ORDER BY AppName, AppVersion DESC
> </cfquery>
>
>
> *************************************************
> This e-mail, including any attachments, is intended for the
> receipt and use by the intended addressee(s), and may contain
> confidential and privileged information. If you are not an intended
> recipient of this e-mail, you are hereby notified that any unauthorized
> use or distribution of this e-mail is strictly prohibited.
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
