"fails miserably" and "blows up" are kinda vague. got an error message?
but a couple of points: 1) look up the numberFormat() function. you can pad a number with leading zeros. seems <cfset order_number = numberFormat(form.reorder, '00000000') /> should be all the logic you need. 2) you've got some pound signs that aren't needed. len(form.reorder) works a treat and is a bit easier to read. <cfset order_number = "00" & form.reorder /> is preferred ofer <cfset order_number = "00" & "#form.reorder#" />. On 6/26/07, Michael Stevens <[EMAIL PROTECTED]> wrote: > 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 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282273 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4