Thanks all for the quick responses, I've changed the field name from Date to AccessDate, makes more sense too. I used cfqueryparam on my insert and just trying to get this thing to work in the raw first ;). As for using jdbc instead of odbc, I have yet to get cf to register the ds using the SQL driver it offers. I'm not an admin and have very little to go on where configuring cf is concerned since there's not anyone here that has the know how to get it working correctly using jdbc drivers.
Thank you all for the help, update statement working now ;) Bob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279611 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4