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\)
Not sure why. Has anyone else come across this? Robert -Original Message- From: Paul [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 4:24 PM To: CF-Talk Subject: cfc/sql strange behavior I'm essentially creating a glorified import process to join data from two of our sy

cfc/sql strange behavior

2006-04-20 Thread Paul
I'm essentially creating a glorified import process to join data from two of our systems and I'm seeing some strange things from CF/SQL Server 2000. It's fairly simple - I'm looping over one query and inserting data into a second database, calling private functions within the same CFC to retrieve s