My page takes input from another CFM page. One variable, reorder, is a a reorder number that is 8 digits in length but probably 90% of the reorder numbers are 6 digits preceeded with two 0s so customers will omit the leading 0s. It can also be as short as 4 digits. To make it a valid reorder number for our database I have to add enough 0s to make it 8 digits in length. My first pass at this ended up with this code which works for 90% of the reorder numbers since 90% of them are 6 digits: <cfset Order_Number = "00" & "#form.reorder#">
Now I'm trying to accomodate older orders that are 4+ digits in length and either my LEN statements or my logic is flawed. I have this code and it fails miserably: <cfset Order_Number = ""> <cfif LEN(#form.reorder#) EQ 4> <cfset Order_Number = "0000" & "#form.reorder#"> <cfelseif LEN(#form.reorder#) EQ 5> <cfset Order_Number = "000" & "#form.reorder#"> <cfelseif LEN(#form.reorder#) EQ 6> <cfset Order_Number = "00" & "#form.reorder#"> <cfelseif LEN(#form.reorder#) EQ 7> <cfset Order_Number = "0" & "#form.reorder#"> <cfelse> <cfset Order_Number = "#form.reorder#"> </cfif> Nothing else changes on the form other than deleting the first <cfset> and adding the second <cfset> and <cfif>. Where does my argument blow up? It seems like such a simple thing I'm just stumped... Thanks, Mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282232 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
