Article Discussion: Portable Database Functions

Want to write a rock-solid dependable application but in record time? Code efficiency is the key! This article provides useful tools and ideas to speed up your database interactions in ASP as well as a best-practice you just might be convinced to adapt for your database-driven applications.


Read the full article here:
Portable Database Functions

Great artical only its a pitty that while copying the code I had to change the “” to "". Maby you can also tell the reader that you can make a function.asp and include it to all your pages where you need to access the functions.

Good luck
Cya
Bjorn

The problem of course with using the Max Id in a table is that two transactions could potentially use the same id if they both access the function at similar times.

An alternative is to have a table that stores the unique id's and increments them when one is requested. This way you can lock the record at the time of the request add 1 to it and then release it, to await the next request.

Just a thought.

Still a handy article, thanks