FYI One of the things that we found here was that CF8 has to have the NOCOUNT in SQL Server set to ON. CF7 handled this without any issues. We had to modify all of our stored procedures to include this.
Robert At 02:26 AM 12/6/2007, you wrote: >Date: Wed, Dec 5 2007 12:11 pm >From: "Zerr, Randell (JSC-IS)[TES]" > > >Thanks for the input. I just figured out the problem - a problem >that just happened to be common with all three apps I tested. The >sql is being created as a string and passed into the cfquery which, >in effect, disabling the escaping mechanism. > ><cfset theSql = "Select x from y"> > ><cfquery> >#theSql# ></cfquery> > >I missed this in my initial analysis because the page I was >examining was a 700 line include file with all 700 lines being a >series of inserts into different places with cfif's all over the >place. I finally realized that there was no cfquery on the page and >then found that there was a cfquery on another page that was >cfincluding the page with all of the inserts: > ><cfquery> ><cfinclude template="x.cfm"> ><cfquery> > >Ug. I think I am just going to use a udf to wrap all of the >variables with that will escape the single quotes, create a keyboard >shortcut in Dreamweaver, and start typing. This will alleviate the >problem until we can rebuild these older apps. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [EMAIL PROTECTED] For more options, visit http://groups.google.com/group/houcfug?hl=en -~----------~----~----~----~------~----~------~--~---
