Try Numberformat(var, '99999999') ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com
-----Original Message----- From: Michael Stevens [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 26, 2007 1:21 PM To: CF-Talk Subject: Having problems with LEN()... 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 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282270 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
