What I'm thinking, from this thread and others I've read in the past, is that if keeping your code database-independent is priority..... inserting some unique identifier and then querying for that in a second query ....might be the best option.
Or do you folks find that you can't really stay uncoupled from your DB? On Tue, Aug 19, 2008 at 11:35 AM, Brian Kotek <[EMAIL PROTECTED]> wrote: > While it probably won't happen often, depending on load, even the Now() > logic can result in two records with the same value if they come in at the > same time. And cftransaction will only work if you go all the way to > "serializable" for isolation level, which essentially single-threads access > and, again depending on how often the query is run, can be a performance > issue. > > If this query isn't hit a lot by multiple threads none of this may be an > issue, but it is definitely something that must be kept in mind. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311511 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4