9 is right next to the 0! :-) That would of course be... Numberformat(var, '00000000')
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 26, 2007 7:33 PM To: CF-Talk Subject: Re: Having problems with LEN()... 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 > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282352 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4