As Brad notes, messageid is your best bet for uniqueness ... messagenumber is a query column, too, but it changes per request (recalculated based on what's in the folder on the server). If you need a unique value in the DB, I would go with messageid rather than subject, but it sounds like you're handling that at the point of creating the email, so perhaps it's no biggie.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320581 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
