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:138358
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

ColdFusion MX 6.1, now 2.5 times faster. 
http://www.macromedia.com/software/coldfusion/productinfo/upgrade/jump/introducing.html?trackingid=ColdFusion_468x60g_HouseofFusion_carat_082803

Reply via email to