And... I haven't written the second level yet... I wanted to see if a more elegant approach would save me from several thousand lines of code...
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: 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:207071 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
