> Actually what I do more frequently nowdays is use > createUUID() to > generate a primary key of my own and insert that instead > of using > identity fields. All of these issues go away then.
> The only reason I use identity fields nowdays is if I > think it's > likely I might have to be typing queries out in the query > editor > using the primary key on a regular basis. I sometimes use epoch dates for these (it's a roughly 10 digit number), although it's important to ensure that the epoch-date is created from UTC / GMT dates to eliminate the possibility of DST modifications raising the likelyhood of duplication (though you need to exclusive-lock the creation of the epoch-date and use java to pause the thread for 1 second anyway). But then this for me isn't because I plan to use the value in Query Analyzer or SQL+ but rather I choose this approach when I expect to use the value in a URL which will be sent to people via email. So ultimately my real reason for doing this is because we (programmers) are waiting for the standard for email to join the rest of us in the current century and eliminate the 70-whatever character per line limitation. Just as an 8-character limitation for file names was once eliminated because it failed to meet human needs, the standard for email now fails to meet human needs, as evidenced by all our cavorting about to accomodate it. The same is true of "search engine safe" URLs -- we cavorted about an awful lot because search engines were slow to meet our needs, although this is no longer an issue because the search engine providers have been faster to accomodate us than those responsible for the email standard. s. isaac dealey 434.293.6201 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236964 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
