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 >
