At 11:30 AM 7/25/2003 -0400, you wrote: >I need to add a ticket number to a submission form, any suggestions?
Could you be more specific? Like "1", "2", or "T0001", "T0002", etc.? Generally if you want the ticket # to be unique... you're going to need to wait until just before inserting the record to determine it. Snag the most recent ticket #, increment that value, insert it in the next record - to make sure two folks putting in a ticket around the same time don't get the same ticket #. Transactional processing on the DB calls there. If it's something as simple as using an identity (auto-incremented) integer field in your table as the ticket number, then you've got no worries. The above assumes you're talking about putting in a record and not trying to retrieve one (i.e. "type in your ticket number and hit submit")... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Get the mailserver that powers this list at http://www.coolfusion.com
