RE: Real head Scratcher
Richard, This error might occur when you make any changes to the ipi_photographer table adding or deleting a column. Are you changing that table at all? Also, is arguments .photographerID a numeric value? Do you qualify it somehow - perhaps by cfargument? -Mark -Original Message- From: Richard Steele [mailto:r...@photoeye.com] Sent: Wednesday, April 20, 2011 12:04 AM To: cf-talk Subject: Real head Scratcher Ok, I have a page that loads most of the time. However, occasionally it gives an error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. In verbose debugging the query that fails should be no problem whatsoever and in fact in runs fine in SQL but only 70% of the time when the page is refreshed. We are on CF8 Enterprise with two instances. What could be happening? Here's the verbose error message: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. The error occurred in C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 321 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 205 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 197 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 165 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 162 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results. cfm: line 63 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results. cfm: line 54 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results. cfm: line 1 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results_ page.cfm: line 210 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\search_results.cfm: line 5 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 321 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 205 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 197 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 165 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 162 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results. cfm: line 63 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results. cfm: line 54 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results. cfm: line 1 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results_ page.cfm: line 210 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\search_results.cfm: line 5 319 : cfquery name=qPhotographer dataSource=#ipi_dsn# 320 : SELECT * FROM ipi_photographers 321 : WHERE id = cfqueryparam CFSQLType=CF_SQL_INTEGER value=#arguments.photographerid# / 322 : /cfquery 323 : cfreturn qPhotographer / SQLSTATE HY000 SQLSELECT * FROM ipi_photographers WHERE id = (param 1) DATASOURCEphotoeyecom Resources: * Check the ColdFusion documentation to verify that you are using the correct syntax. * Search the Knowledge Base to find a solution to your problem. Browser Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2.16) Gecko/20110319 Firefox/3.6.16 Remote Address 10.10.47.254 Referrer Date/Time 20-Apr-11 01:08 AM Stack Trace at cfsearch_brain2ecfc271777505$funcGETPHOTOGRAPHER.runFunction(C:\inetpub\wwwr oot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:321) at cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor1(C:\inetpub \wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:205) at cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor2(C:\inetpub \wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:197) at cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor3(C:\inetpub \wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:165) at cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR.runFunction(C:\inet pub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:162) at cfdsp_search_results2ecfm265917465.._factor0(C:\inetpub\wwwroot\Clients\phot oeyecom\html\iPi\includes\dsp_search_results.cfm:63) at cfdsp_search_results2ecfm265917465._factor6(C:\inetpub\wwwroot\Clients\photo eyecom\html\iPi\includes\dsp_search_results.cfm:54) at cfdsp_search_results2ecfm265917465.runPage(C:\inetpub\wwwroot\Clients\photoe yecom\html\iPi\includes\dsp_search_results.cfm:1) at cfdsp_search_results_page2ecfm2071414576.runPage(C:\inetpub\wwwroot\Clients\ photoeyecom\html\iPi\includes\dsp_search_results_page.cfm:210
RE: Real head Scratcher
Try adding Val() around the arguments.photographerid as 319 : cfquery name=qPhotographer dataSource=#ipi_dsn# 320 : SELECT * FROM ipi_photographers 321 : WHERE id = cfqueryparam CFSQLType=CF_SQL_INTEGER value=#val(arguments.photographerid)# / 322 : /cfquery 323 : cfreturn qPhotographer / IF it works, it means occasionally you are sending in a blank value when it requires an integer ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343873 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Real head Scratcher
Ok, I have a page that loads most of the time. However, occasionally it gives an error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. In verbose debugging the query that fails should be no problem whatsoever and in fact in runs fine in SQL but only 70% of the time when the page is refreshed. We are on CF8 Enterprise with two instances. What could be happening? Here's the verbose error message: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. The error occurred in C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 321 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 205 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 197 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 165 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 162 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm: line 63 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm: line 54 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm: line 1 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results_page.cfm: line 210 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\search_results.cfm: line 5 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 321 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 205 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 197 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 165 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc: line 162 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm: line 63 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm: line 54 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm: line 1 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results_page.cfm: line 210 Called from C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\search_results.cfm: line 5 319 : cfquery name=qPhotographer dataSource=#ipi_dsn# 320 : SELECT * FROM ipi_photographers 321 : WHERE id = cfqueryparam CFSQLType=CF_SQL_INTEGER value=#arguments.photographerid# / 322 : /cfquery 323 : cfreturn qPhotographer / SQLSTATE HY000 SQLSELECT * FROM ipi_photographers WHERE id = (param 1) DATASOURCEphotoeyecom Resources: * Check the ColdFusion documentation to verify that you are using the correct syntax. * Search the Knowledge Base to find a solution to your problem. Browser Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.2.16) Gecko/20110319 Firefox/3.6.16 Remote Address 10.10.47.254 Referrer Date/Time 20-Apr-11 01:08 AM Stack Trace at cfsearch_brain2ecfc271777505$funcGETPHOTOGRAPHER.runFunction(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:321) at cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor1(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:205) at cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor2(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:197) at cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor3(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:165) at cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR.runFunction(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:162) at cfdsp_search_results2ecfm265917465.._factor0(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm:63) at cfdsp_search_results2ecfm265917465._factor6(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm:54) at cfdsp_search_results2ecfm265917465.runPage(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results.cfm:1) at cfdsp_search_results_page2ecfm2071414576.runPage(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\includes\dsp_search_results_page.cfm:210) at cfsearch_results2ecfm1795000755.runPage(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\search_results.cfm:5) at cfsearch_brain2ecfc271777505$funcGETPHOTOGRAPHER.runFunction(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:321) at cfsearch_brain2ecfc271777505$funcGET_KEYWORD_RESULTS_FOR._factor1(C:\inetpub\wwwroot\Clients\photoeyecom\html\iPi\cfc\search_brain.cfc:205)
Re: Real head Scratcher
Bad data. You have at least one data record with a value that is either null or not an integer. On Tue, Apr 19, 2011 at 10:04 PM, Richard Steele r...@photoeye.com wrote: Ok, I have a page that loads most of the time. However, occasionally it gives an error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. In verbose debugging the query that fails should be no problem whatsoever and in fact in runs fine in SQL but only 70% of the time when the page is refreshed. We are on CF8 Enterprise with two instances. What could be happening? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343860 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm