Yep that runs fine. This is really strange. The value of the qText variable is the same as the query below yet when I stuff #qText# in there, it somehow doubles the quotes by itself. Damn I just don't get how it could or would do that.
If I output the value of the qText variable on a page, quotes are correct. Have you ever seen anything like this? Thanks, Dusty On Wed, Jan 27, 2010 at 3:00 PM, Teddy R. Payne <[email protected]>wrote: > Dusty, > As a source of troubleshooting, have you put the SQL string into the > cfquery statement in its final form? I am wondering if the SQL runs > correctly in the cfquery before the dynamic evaluation. > > <cfquery name="q" datasource="#application.dsn_name#" > username="#application.db_user#" password="#application.db_ > pword#"> > **Select donorid, occupation, race, haircolor, hairtexture, eyecolor, > religion, bloodtype, height, weight, heightmetric, weightmetric, > reportedpregnancy, opendonorid, infomp3avail, ethnicity, cmvstatus, > DateEntered, ARTavail, ARTonly, SelectDonors FROM v_websearch where > > available = 1 AND donorid like '%9986%' ORDER BY donorid > </cfquery> > > Does this run correctly? > > > > Teddy R. Payne, ACCFD > Google Talk - [email protected] > > > > On Wed, Jan 27, 2010 at 2:47 PM, Dusty Hale <[email protected]> wrote: > >> Teddy here's how I build the qText string part where the quotes are: >> >> if(len(txtDonorId)){ >> qText = qText & "AND donorid like '%" & txtDonorId & "%' "; >> } >> >> >> >> On Wed, Jan 27, 2010 at 2:28 PM, Teddy R. Payne <[email protected]>wrote: >> >>> Dusty, >>> What type of single quotes are those? What is the source of the text? >>> Was the query copied and pasted from a Microsoft document? >>> >>> >>> Teddy R. Payne, ACCFD >>> Google Talk - [email protected] >>> >>> >>> >>> >>> On Wed, Jan 27, 2010 at 2:24 PM, Dusty Hale <[email protected]>wrote: >>> >>>> Hi: >>>> >>>> I've run into a very strange issue. I have a cfc which has a <cfquery> >>>> tag in it. I recently added one field the SQL in the query and am getting >>>> an >>>> error I've never seen before. I can't seem to dig out any info to solve >>>> this. If anyone is familiar, please share. >>>> >>>> Of course when I output the SQL and run in a SQL Studio Query window, >>>> the query runs fine with no errors. >>>> >>>> Here the error I see in CF: >>>> >>>> >>>> >>>> ----------------------------------------------------------------------------------------------------------------------------- >>>> [Macromedia][SQLServer JDBC Driver][SQLServer]Divide by zero error >>>> encountered. >>>> >>>> The error occurred in >>>> *D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: >>>> line 149* >>>> *Called from* D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: >>>> line 139 >>>> *Called from* D:\websites\xytexcom_stage2\htdocs\search.cfm: line 48 >>>> *Called from* D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: >>>> line 149 >>>> *Called from* D:\websites\xytexcom_stage2\htdocs\cfc\donorsearch.cfc: >>>> line 139 >>>> *Called from* D:\websites\xytexcom_stage2\htdocs\search.cfm: line 48 >>>> >>>> 147 : </cfscript> >>>> 148 : <cfquery name="q" datasource="#application.dsn_name#" >>>> username="#application.db_user#" password="#application.db_pword#"> >>>> *149 : #qText#* >>>> >>>> >>>> >>>> >>>> 150 : </cfquery> >>>> ----------------------------------------- >>>> >>>> >>>> Here's the SQL code in the qText variable. Please note that it runs fun >>>> in Query Analyzer. Also note that no division is being used. >>>> >>>> ---------------------------------------------------------------- >>>> Select donorid, occupation, race, haircolor, hairtexture, eyecolor, >>>> religion, bloodtype, height, weight, heightmetric, weightmetric, >>>> reportedpregnancy, opendonorid, infomp3avail, ethnicity, cmvstatus, >>>> DateEntered, ARTavail, ARTonly, SelectDonors FROM v_websearch where >>>> available = 1 AND donorid like '%9986%' ORDER BY donorid >>>> >>>> ---------------------------------------------------------------------------------- >>>> >>>> Any advise or thought on this of course is greatly appreciated. >>>> >>>> Dusty >>>> >>> >>> >> >> >> -- >> Dusty Hale >> Email: [email protected] >> Phone (Atlanta): 404.474.3754 >> Phone (Toll Free USA): 877.841.3370 >> Website: www.DustyHale.com >> > > -- Dusty Hale Email: [email protected] Phone (Atlanta): 404.474.3754 Phone (Toll Free USA): 877.841.3370 Website: www.DustyHale.com
