Well I have been using JDBC Statement call from CF and it will return you number of records effected for updated, inserts or deletes.
Thanks Qasim On 4/19/06, Claude Schneegans <[EMAIL PROTECTED]> wrote: > > Not sure on which kind of database it will work. > All I know is that it wont work with Access database. > > Another way to get the same result would be to store a date time value > in the same query > as the INSERT or UPDATE, then count them in another query. > If the field is indexed, it should take a breeze. > > Now for DELETE, it's another story. > First count them, then delete them? > > -- > _______________________________________ > REUSE CODE! Use custom tags; > See http://www.contentbox.com/claude/customtags/tagstore.cfm > (Please send any spam to this address: [EMAIL PROTECTED]) > Thanks. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238224 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
