Tony,
I agree! Once you get used to using lists, you start using them all over
the place. Attached is an example of some code I wrote last week to output
a non-formatted xml packet (one without any spaces between the <> tags like
you see when you output a wddx packet) into the nested format that you'd
expect. It uses the "<" as the delimter.
Nelson
----- Original Message -----
From: "Tony Schreiber" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, August 27, 2001 5:56 PM
Subject: Re: loop question
> Ah, the joy of finding lists in everything we do... ;p
>
> I find that when doing funky text processing or parsing, it's helpful to
> find lists where you wouldn't think there are...for example:
>
> A text file is a list ( delimiter CHR(10) ) of records,
> A hostname is a list (delimeter ".")...
>
> And as Howie points out, HTML form elements with more than one value are
> lists ( "," ) - very helpful for checkboxes with the same name...
>
> > 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
