> 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.
It's often easier to use CFQUERYPARAM, actually - for example, you don't have to worry about single quotes. As for the ODBC vs JDBC thing, that shouldn't be very hard to set up, as long as your administrator knows about connecting to SQL Server via TCP/IP. If your SQL Server is set up to only listen on named pipes, you would have to change it to use TCP/IP. If you can look at the ODBC settings on your server, you can get the information you need. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279615 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
