Will it be able to figure out what the last number is if it's a character type and the number is something like 00003? So it'll add one to make it 00004 and not something like 10003.
?? --- "Chris W. Parker" <[EMAIL PROTECTED]> wrote: > > yeah that makes sense. hmm.. well i'll give you my > idea.. but it's very > possible there's a better way to do it (than what > i'm going to suggest). > > ok. one field will be used. it'll be a text > (varchar) field. before you > do an insert you'll need to find out what's in there > ahead of time and > then adjust accordingly. i'd select the last record > that contained the > two letter abbreviation, find out what the number > was, increment it, > then reconstruct the id and insert the new one. > > this of course won't prevent the exact same process > from happening at > the exact same time. i mean, two sessions could pull > the same id and > then reconstruct the (new, but) same id. > > make sense? > > > chris. > __________________________________ Do you Yahoo!? Yahoo! Search - Find what you’re looking for faster http://search.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
