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