the delimiter argument to the list functions is not a multicharacter string,
it's a set of delimiter characters.  So listGetAt(myList, 3, ">>") isn't
looking for the third item using ">>" as the delimiter, it's looking for the
third item using ">" OR ">" as the delimiter.  More clearly,
listGetAt(myList, 3, ";,") isn't looking for the third item using ";," as
the delimiter, it's looking for the third item using ";" OR "," as the
delimiter.

listGetAt("i,like;cheese", 3, ";,") will return 'cheese'

barneyb

> -----Original Message-----
> From: Owens, Howard [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 24, 2003 3:48 PM
> To: CF-Talk
> Subject: Maybe You'll See Something I Don't
>
>
> I have this file that I'm sucking into a database.  I'm treating each line
> as a list.  The delimiters (out of my contro) are ">>".
>
> Here's a sample line:
>
> 1405 >> 09-17-2003 >> Mike Keys Re-Spray/Painted/Removed Water/Smoke/Crack
> Damage. Wall Repair/Texturing Free Estimate -  Lic.#416345 r
> (805)659-6356 r
> r (805)494-1915 r   <CENTER><IMG
> SRC="http://web.insidevc.com/classified/logos/6596356.jpg";></CENTER> >>
> 619620
>
> This particular line is choaking the thing.  It wants to read the text
> starting with the image tag as the fourth element in the list,
> which creates
> a bad SQL query.  I can't see what is causing this. Do you?
>
> Here's the list code:
>
>       <cfset CATEGORY_NUM="#ListGetAt(tmp, 1, ">>")#">
>       <cfset START_DATE="#ListGetAt(tmp, 2, ">>")#">
>       <cfset AD_TEXT="#ListGetAt(tmp, 3, ">>")#">
>       <cfset AD_NUM="#ListGetAt(tmp, 4, ">>")#">
>
>
>
> H.
>
>
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Howard Owens
> Internet Operations Coordinator
> Ventura County Star / E.W. Scripps Co.
> www.venturacountystar.com
> [EMAIL PROTECTED]
> AIM: GoCatGo1956
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> > -----Original Message-----
> > From:       Claude Schneegans [SMTP:[EMAIL PROTECTED]
> > Sent:       Wednesday, September 24, 2003 1:57 PM
> > To: CF-Talk
> > Subject:    Verifying an email address exists
> >
> > Hi,
> >
> > I'd like to know if there exists any method to check if an email address
> > actually exists?
> > I mean not only be syntactically valid, but does correspond to
> a true mail
> > box in a true server.
> >
> >
> >
> >
> 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:138360
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://affiliates.macromedia.com/t.asp?id=2439&p=go/dr_text_aff1

Reply via email to