I always just use triggers for when inserting, but it seemed like the worry here was to know the ID after the insert to I'd guess display to the user. How would a trigger help for that need?
On 7/11/05, Eddie Awad <[EMAIL PROTECTED]> wrote: > > > Of course, you could also just create a "when-insert" trigger on the > table to automatically populate the id column so you do not have to > worry about it in your "insert" statements. > -- > Eddie Awad. > http://awads.net/ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211554 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
