and when that doesn't work, try it with 0's :) On 6/26/07, Bobby Hartsfield <[EMAIL PROTECTED]> wrote: > 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 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:282282 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
