Well, that did work and it worked through a few entries, so I suspect that it's reasonably sound now.
BUT, it's breaks down on third entry with a "missing comma" entry again. Back to debugging... oh the entry looks like (nothing special): 1/7/2005|21:25:05|[EMAIL PROTECTED]|Nicki|Burch|1|1|1|1|1|1|1|1|2|2|2|1|||||||1|dont really know how to shop.||1||||||| > >Daniel Kessler wrote: > >> ORA-00936: missing expression > > > >> <!--- tmp_line is read in else where, then in the following lines > > >> made into an array ---> > >> <cfset tmp_line = "12/2/2004|20:38:25|[EMAIL PROTECTED] > com|annteeka| > >> gilmore|2|2|1|2|2|2|3|1|2|1|3|2||1|1|1||||||||1|1||||"> > >> <cfset tmp_line = replace(tmp_line,"||","| |","ALL")> > >> <cfset tmp_line = replace(tmp_line,"||","| |","ALL")> > >> <cfset tmp_trn_ar = listToArray(tmp_line,"|")> > > > >So here you are inserting spaces for your empty list elements. > > That does appear to be the problem. I figured entering empty would be > fine and would leave it empty. It's one-time-use code so I didn't do > any extra work. > > Now, I check to see if it's empty and don't add it if it is, so it > seems to be working fine. Or at least it's giving no errors. > > Thanks everyone. I appreciate the assistance. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279118 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
