I am baffled by this problem and hope someone can help. I have a perennial plant website that takes online orders. For most customers, including me when I place test orders, things work as designed. However some customers generate errors. When a new customer order comes in I create a customer ID and an order ID: <cfset variables.CustID = #CreateUUID()#> <cfset variables.CustOrderID = #CreateUUID()#> I have tried this without the # signs and the result seems to be the same. In the usual case a Coldfusion UUID is created in the form 8-4-4-16. I write the customer ID to the customer table into an nvarchar(max) column and write both the customer ID and order ID into the order table into nvarchar(max) columns. I also have an order item detail table into which I write the custOrderID into an nvarchar(max) column. As noted, this works for most customers. However, for some customers - at least one that I am working with - two odd things occur that I can't figure out. Here's the error reported to the customer: [Macromedia][SQLServer JDBC Driver][SQLServer]Conversion failed when converting the varchar value 'b9b8bc49fcad6e0f-9C03B2A0-B0A9-5D8C-6FE0A4C952F8BD4F' to data type int. MY QUESTIONS: The two mysteries for me are (1) where does this long string come from, that looks like a UUID, but is in the form 16-8-4-4-16, so it has an extra 16 characters at the beginning and (2) why is a conversion to INT being attempted? My code simply writes the uuids into the columns that are set up as nvarchar(max). A typical insert query that I use looks like this: <cfquery name="qryCreateOrderRecord" datasource="bussesql"> Insert into tblCustOrders (CustOrderID,CustID) <cfoutput> values('#custorderid#','#custid#') </cfoutput> </cfquery> FINAL QUESTION: Lastly, why does my code work for some users without any problem and generates this error for at least one. There are other customers who have had problems, but they were not specific o the error messages. Any thoughts greatly appreciated. Gary
... View more
AdChoices