> We have an insert SQL statement that we use <cfqueryparam > cfsqltype="cf_sql_varchar" value="#id#"/>. We have three > servers. Two servers work perfectly fine. One server kept > throwing errors "[Macromedia][SQLServer JDBC > Driver][SQLServer]Syntax error converting from a character > string to uniqueidentifier". Anyone has run into this > problem before and did you find out why?
Presumably, either the database drivers on the three servers are different, or one of the three servers is using a different database schema. 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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262460 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
