Can anyone help me out with the below:
Im trying to pick up an invNumber and CustAccNum which is either on line 26 or
27, at the minute the below code seems to be doubling up, and not importing
anything into the database
any tips would be great
Thanks
<cfif left(trim(Variables.aryLoop), 3) is "026">
<cfif trim(right(left(Variables.aryLoop, 74), 20)) neq "">
<cfset
Variables.invArray[Variables.invoiceCounter].invNumber =
trim(right(left(Variables.aryLoop, 74), 20))>
<cfset
Variables.invArray[Variables.invoiceCounter].CustAccNum =
trim(right(left(Variables.aryLoop, 32), 17))>
<cfelse>
<cfset
Variables.invArray[Variables.invoiceCounter].invNumber =
trim(right(left(Variables.fArray[counter+1], 74), 20))>
<cfset
Variables.invArray[Variables.invoiceCounter].CustAccNum =
trim(right(left(Variables.fArray[counter+0], 32), 17))>
</cfif>
</cfif>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328736
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
