You could always get a unique licence number from a table, then increment it, so operator A and B will have 900012 and 900013. If operator A then discards the operation...by hitting a button, the 900012 is inserted in an 'available' licences table. Your other option is to date stamp each licence generation. If it is not 'completed' within a 24 hour period, then the licence number goes onto an available licence number table. Make sure you to do all the SQL in one transaction. I would use both techniques as you cannot guarantee the operator will log out cleanly. Adam Reynolds ColdFusion Consultant HJ Heinz Tel: 01344 397016 Fax: 01344 397010 Mobile: 07973 386620 Email: [EMAIL PROTECTED] > ---------- > From: Joseph Eugene[SMTP:[EMAIL PROTECTED]] > Sent: 19 May 2000 02:59 > To: [EMAIL PROTECTED] > Subject: Re: Help! > > Baig, > Couple of ways top of my head. > > 1. When the Operator A is attending the call or if the user is online, and > the license is approved , write it to > a table in the database, "this table should have a unique field with > auto number turned on and this will be the user's > license" read this field back and email or some. here you are only > writing into the database only when the license is approved" > > 2. You could use session varaibles to generate the License # and write > them > into the database, where the application.cfm resides in a subdirectory hit > only on approval. > > Hope this works for you. > > > > ----- Original Message ----- > From: "aslam bajaria" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, May 18, 2000 3:09 PM > Subject: Help! > > > > Hi All, > > > > I have a problem. > > The way the system works right now at my company is > > that the operator opens up a customer's account using > > the customer id and gives the customer a license > > number. The license number is generated automatically. > > Each time a license number is assigned, the file > > having the license number gets incremented > > automatically. > > > > For example operator A approved cust_id 111 and > > assigned him license number 90000011. > > > > If operator A opens up another customer account, say > > customer number 212, the available license number will > > be 90000012. > > > > The problem I am facing is that if operator A and > > operator B open up two different customers (say > > cust_id 250 and cust_id 366), then it shows to both of > > them that the available license number is 90000012. > > > > The available license number gets incremented ONLY > > when the operator approves the customer's request for > > license form. > > > > Is there a that if operator A see's 90000012, then > > operator B should see 90000013. But again, the > > question is if operator A cancels the application, > > then the available number for operator B should be > > 90000012 and not 90000013. > > > > Is it possible that if operator A cancels the > > application, then the operator B's screen should > > automatically change and the available number should > > be 90000012. > > > > Does someone have an idea on how to solve this? > > Has any of you encountered this problem before? > > > > Thanks. > > M Baig > > > > > > > > __________________________________________________ > > Do You Yahoo!? > > Send instant messages & get email alerts with Yahoo! Messenger. > > http://im.yahoo.com/ > > > -------------------------------------------------------------------------- > ---- > > Archives: http://www.eGroups.com/list/cf-talk > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > > > -------------------------------------------------------------------------- > ---- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > ********************************************************************** This email and any attachments are confidential and solely for the use of the intended recipient. They may contain material protected by legal professional or other privilege. If you are not the intended recipient or the person responsible for delivering to the intended recipient, you are not authorised to and must not disclose, copy, distribute or retain this email or its attachments. Although this email and its attachments are believed to be free of any virus or other defect, it is the responsibility of the recipient to ensure that they are virus free and no responsibility is accepted by the company for any loss or damage arising from receipt or use thereof. ********************************************************************** ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
