Fine so change 16 in my code to 36, same idea, different radix. Levels would be base 36, starting at 10. This will be rendered as "A" initially.
FormatBaseN(InputBaseN(alphaString,36)+1,36) -dov -----Original Message----- From: SStewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 3:01 PM To: CF-Talk Subject: RE: Anyone know of a more elegant way to do this? 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. 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: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 02:46 pm To: CF-Talk Subject: RE: Anyone know of a more elegant way to do this? Importance: Low Looks like the second part of the number is hex... Perhaps this would work? <cfset myStr=qry_getLastPnum.lPnum> <Cfset myIdx=#REFind(myStr,"[A-Z]")#"> <cfset NumericString=left(mystr,myIdx)> <CFSET alphaString=right(mystr,len(mystr)-myIdx)> <Cfset NumericString=NumericString+1> <Cfset alphaString= FormatBaseN(InputBaseN(alphaString,16)+1,16)> -----Original Message----- From: SStewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 2:34 PM To: CF-Talk Subject: Anyone know of a more elegant way to do this? I'm incrementing a project number, it's an alpha-numeric "number" (001000A or 001000AA) if it's a new project I just grab the first six numbers and increment, if it's an extended project I have to increment the letter with the next one. My code works but it's kind of a battering ram approach, is there a more elegant way to do this? Thanks sas <cfif Right(qry_getLastPnum.lPnum,2) CONTAINS "A"> <cfset lPnum = Left(qry_getLastPNum.lPnum,6)&"B"> <cfelseif Right(qry_getLastPnum.lPnum,2) CONTAINS "B"> <cfset lPnum = Left(qry_getLastPNum.lPnum,6)&"C"> <cfelseif Right(qry_getLastPnum.lPnum,2) CONTAINS "c"> <cfset lPnum = Left(qry_getLastPNum.lPnum,6)&"D"> <cfelseif Right(qry_getLastPnum.lPnum,2) CONTAINS "D"> <cfset lPnum = Left(qry_getLastPNum.lPnum,6)&"E"> <cfelseif Right(qry_getLastPnum.lPnum,2) CONTAINS "E"> <cfset lPnum = Left(qry_getLastPNum.lPnum,6)&"F"> 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: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 11:08 am To: CF-Talk Subject: RE: Good Site Stats Tag Recommendation Importance: Low I like the look of Statistex however, I was going to obtain The full version but the wellmanweb site does not exist any Longer. I know awstats is off of sourceforge and is free, just never Was able to get mine to work. Sorry.. My 2 cents -----Original Message----- From: Steve Kahn [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 11:05 AM To: CF-Talk Subject: Good Site Stats Tag Recommendation Anyone have a good site stats tag recommendation? Thanks Steve ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207072 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
