When I upload records im getting the below error
Error (The Value 2F cannot be converted to number)
But when i remove this piece of code it works fine, but then as for the other
records (which had not this 2F value problem), its not uploading them correctly
What can i change on this line of code so it will all work correctly
<!--- <cfset linenumber = right(linenumber + vvalue2,1)> --->
Heres where that code is inserted:
<cfset tempvvalue1 = trim(left(i,4))>
<!--- Invoice Line Text --->
<cfset stringvalue = left(right(i,Len(i)-5),130)>
<!--- Calculate Line Numbers --->
<cfif isNumeric(tempvvalue1)>
<cfset linenumber = right(tempvvalue1,2)>
<cfelse>
<cfset vvalue2 = trim(left(i,6))>
<!--- <cfset linenumber = right(linenumber + vvalue2,1)> --->
</cfif>
<cfif linenumber eq 26>
<cfset invoicenumber = trim(right(left(i,74),20))>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:326890
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
