Need Order ID Number Creator

Try something similar with an application variable.

If you are using oracle, you could create a sequence starting at 601. Then you can pad it with zeros and prepend the letter I.

PopcornCoder wrote:
> Employer wants an Order number starting with I and haveing 6-8 characters in.
> So for example first order would be I000601. Anyone have any ideas of scripts
> or items that would create this. Need to make sure that it doesn't duplicate.
> I know CreateUUID would be perfect for this but it is way too long.

> Suggestions.

That's fine, what are the rest of the business rules? I.E. are these
random numbers or sequential, etc.

Otherwise this is just basic logic and string manipulation probably
combined with a look up of existing recorded order numbers to ensure
uniqueness.

A super basic example.

<cfscript>
i = randRange(1,99999999);
invoiceNum = 'I' & replace(rJustify(i,6),' ','0','ALL');
writeOutput(invoiceNum);
</cfscript>