Nothing, I've found a couple of CF blogs that point to <cfqueryparam> as being the culprit... But it's in very specific cases:
http://www.petefreitag.com/item/677.cfm However, mine is a basic insert statement. the error code(s) returned are: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 28: Incorrect syntax near '@P10'. [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared. the main weirdness that I've found is that cfqueryparam is returning "true" or "false" which is a valid response for a boolean but not what a SQL server bit field is expecting. (IE: 1 or 0) Thanks sas Tom Chiverton wrote: > On Monday 11 Aug 2008, Scott Stewart wrote: > >> I've run into an issue that I need opinions on. We've run into some SQL >> server issues, where MS is saying "patch the driver". >> > > And what has Adobe said ? > > -- -- Scott Stewart ColdFusion Developer Office of Research Information Systems Research & Economic Development University of North Carolina at Chapel Hill Phone:(919)843-2408 Fax: (919)962-3600 Email: [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310730 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
