Mike, In my case, I am using CFFUNCTION and output is set to false. I tried trimming the returned value, but I still get the same result.
Robert -----Original Message----- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 5:26 PM To: CF-Talk Subject: RE: cfc/sql strange behavior If you are using CFFUNCTION, are you also using OUTPUT="NO"? If this is a CFSCRIPT-type function, just trim the return value. M!ke -----Original Message----- From: Paul [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 5:19 PM To: CF-Talk Subject: RE: cfc/sql strange behavior Well it must be true, misery does love company. It's comforting I'm not the only one! Incidentally I suspected it might be something about the value returned by the function so I added output="false" to the function definition but it was of no consequence - same funky error. I'll be interested to see how this ends up. Thanks for the info, Robert. -----Original Message----- From: FROEHLING, ROBERT (ASI-AIT) [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 3:58 PM To: CF-Talk Subject: RE: cfc/sql strange behavior Paul, I ran into this same issue the other day. It seems that ColdFusion is adding line breaks before the value returned by your function, which generates an error on your DB. So calling the function from within <cfquery> would result in the following SQL being sent to the DB. INSERT INTO myTable(some_field) VALUES(' value_returned_by_function_directly') But setting a variable to the value returned by the function (which is the way that I had to setup my query) would send this. INSERT INTO myTable(some_field) VALUES('value_returned_by_variable_calling_function') Not sure why. Has anyone else come across this? Robert ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238376 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54