This is not an actual solution, but doesn't <cfqueryparam cfsqltype="cf_sql_idstamp" value="#id#"/> work (if id is a GUID?)
George On 12/1/06, Johnny Le <[EMAIL PROTECTED]> wrote: > > 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? > > Johnny > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:262448 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
