count digits

Hi Guys,

I need to make a pin like ADD - 00001 through ADD - 99999. I used the ID colomn in the table to generate this number like below:

<cfset #Pin# = #RIGHT('ADD - 0000'& #MyQuery.id#,13)#>

Now I have problem replacing the 0000 with numbers without loosing the 5 digit format. for example if the id value is 29 my pin should be ADD - 00029. any Idea?

re: count digits

Make a pad UDF which adds the required number of zeros and use that:

re: count digits

Never mind. I fixed it. I'd love to post it if someone else has the same problem just let me know.

re: count digits

Just post it anyway. You never know when it might prove useful to someone.

re: count digits

I used very simple cfif statement and the same cfset as below;
But I'm working on your suggestion, because I saw it after I wrote my simple if statement. Here is the UDF so far. Thanks anyway.

re: count digits

You'll want to replace myQuery.id, 0 and 5 with variables. Also, your padding function won't work as desired because you've not made a check on the length of the string passed. You'll want to get the length of the string and subtract that from the pad-length to pass to RepeatString().