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. > <CFQUERY NAME="addItem" DATASOURCE="eatart"> > INSERT INTO fsnep_ha_budgeting > ( > budgeting_id, > login_id,stage, > <cfloop from="1" to="#arrayLen(field_list)#" > index="ii"> > #field_list[ii]#, > </cfloop> > > date_added > ) > VALUES > ( > unique_ha_budgeting_s.NEXTVAL, > <cfqueryparam value="#getID.login_id[1]#" > cfsqltype="CF_SQL_NUMERIC">,<cfqueryparam value="1" > cfsqltype="cf_sql_varchar">, > <!--- skips date, time, email, > first name, last name ---> > <cfloop from="6" to="#arrayLen(tmp_trn_ar)#" > index="ll"> > #trim(tmp_trn_ar[ll])#, > </cfloop> > > #the_date_added# > ) > </CFQUERY> And in the loop you are trimming them again so the result is an empty value. Inserting an empty value seems a likely cause of a missing expression error. For the loop in the insert try something like: <cfloop from="6" to="#arrayLen(tmp_trn_ar)#" index="ll"> <cfqueryparam value="#trim(tmp_trn_ar[ll])#" null="#NOT Len(trim(tmp_trn_ar[ll]))#">, </cfloop> Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279099 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
