Reference number for teh submitted form

[MBLR]

I have created a form to submit some entries and the same will be emailed to a person. Once the user submits the form, can ASP throw a reference number for the particilar form submission? So that it can be referred later. Or do we need to have database for this?

faster help appreciated.

 

[culshaja]

You could use an application variable which is global to your whole web application. You can then increment this value every time a mail is sent. The only downside of this is that when you shut the website down you loose the value and start again from 0.

James James Culshaw
james@miniaturereview.co.uk

http://www.miniaturereview.co.uk

http://www.caninerescue.co.uk

 

[MBLR]

Thanks for the reply. Can I use SQL to overcome this "RESET" counter problem?

Do you have a sample script for this?

 

[Tarwn]

I think the database idea would be best. This way you could also store the information you are mailing to the person along with the reference number you assign them. Not only does this keep the reference number for your records, but it allows you to retrieve there information if they ever contact you with there reference number and a question.
I would consider a table with both an auto-incrementing integer field as the primary key and a reference number that is a combination of the id field and other relevant data (perhaps a several letter prefix for certain people, or part of the date or what not) to keep the reference number for being to short. Either that or seed the starting id with something a number starting at 1000 or 10000 so that the first few people don't get reference numbers of 1, 2, 3 etc.

-Tarwn ________________________________________________________________________________
Want to get great answers to your Tek-Tips questions? Have a look at faq333-2924

 

[MBLR]

Thanks for the reply.