> Yup, spot on Leigh, they're not working right with the jDTS > driver either :O
Ugh. Is this with CF8 or CF9? A lot of the weirdness I saw in CF8 had to do with INSERT/VALUES statements in particular, due to the generated keys feature of the "result" attribute. http://www.mischefamily.com/nathan/index.cfm/2008/1/28/Problems-with-CF-8s-Generated-Keys-Feature I am not sure if anything has changed in CF9. But if you are modifying the code anyway, you might want to experiment a little. Try using the result attribute, cfqueryparam, etcetera and see what works best and is the cleanest code. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330312 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
