RE: cfc/sql strange behavior

2006-04-21 Thread Dawson, Michael
ubject: RE: cfc/sql strange behavior 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 ~| Message: http://www.houseoffusion.com/list

RE: cfc/sql strange behavior

2006-04-21 Thread FROEHLING, ROBERT \(ASI-AIT\)
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/s

RE: cfc/sql strange behavior

2006-04-20 Thread Dawson, Michael
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 behavio

RE: cfc/sql strange behavior

2006-04-20 Thread Paul
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

RE: cfc/sql strange behavior

2006-04-20 Thread FROEHLING, ROBERT \(ASI-AIT\)
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 would result in the following SQL being sent to the DB. INSERT INTO myTable(some_f