Yeah, no kidding, BUT, I'm stepping into this after this system was established. I'm putting a web face on a set of Foxpro 5 freetables.
I don't know why it's done that way but I'm stuck with it. :P sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -----Original Message----- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 04:41 pm To: CF-Talk Subject: Re: Anyone know of a more elegant way to do this? Importance: Low >>I don't think it's HEX, the formula is Job (10000) >>First Level Job(10000 A-Z) (10000A, 10000B, 10000C etc) >>when you hit Z it becomes a Second Level Job (10000 A(1-9, A-Z)) (10000A1, >>100000A2) when you run >>out of numbers... 10000AA, 10000AB etc, etc. I don't know if there a more elegant way to write the code, but I swear I could find a far much more elegant way to assign job numbers! ;-) -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207083 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54