>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]|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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279112 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
