Catch
Entries: 18
additional
Struct (ordered)
SQL
stringselect * from( SELECT ROW_NUMBER() OVER(ORDER BY r.rd_uid desc) AS rownum, UID,SubscriptionID,RD_FIRST_NAME,r.RD_UID,RD_LAST_NAME, RD_PREFIX, RD_CREDENTIALS, RD_OFFICE_ADDRESS, RD_OFFICE_ADDRESS2, RD_OFFICE_CITY, RD_OFFICE_STATE, RD_OFFICE_ZIP, RD_OFFICE2_ADDRESS, RD_OFFICE2_ADDRESS2, RD_OFFICE2_CITY, RD_OFFICE2_STATE, RD_OFFICE2_ZIP, RD_OFFICE3_ADDRESS, RD_OFFICE3_CITY, RD_OFFICE3_STATE, RD_OFFICE3_ZIP, RD_COMPANY_NAME, RD_CONTACT_PHONE, RD_CONTACT_EMAIL, RD_DIRECTORY_URL, RD_OFFICE_TOWN, RD_OFFICE_COUNTY, RD_OFFICE2_COUNTY, RD_WORK_HISTORY, RD_EDUCATION, RD_SUMMARY, RD_DESCRIPTION, RD_AWARDS, RD_ADA_REGISTRATION, RD_LICENSE_STATE, RD_LICENSE_NUMBER, RD_CERTIFICATION_STATE, RD_FOCUS_AGE, RD_MEMBERSHIPS, RD_NEARBY_CITIES, RD_NEARBY_COUNTIES, RD_NEARBY_TOWNS, RD_NEARBY_ZIPS, RD_PAYMENT_METHODS, RD_PAYMENT_DESCRIPTION, RD_VERIFIED, ReadyForReview, Active, ActivateDate, ExpirationDate, datascope, rd_image, comments, isTelehealthProvider ,telehealthProviderNotes , isTakesInsurance , takesInsuranceNotes , showEmailMeButton, count(*) over() tot_Records FROM patino_diet.rd R WHERE 1=1 AND ( 1=1 AND ( (len(rtrim(ltrim(rd_office_zip))) = 5 and rd_office_zip in (99999999,90292)) OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,90292)) OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,90292)) ) ) AND R.RD_Verified = '1' AND R.Active = 'true' AND datascope <> 'PT' AND (R.expirationdate > 07/18/24 OR (R.UID in (SELECT UID FROM users WHERE unlimitedRDListing = 'true'))) ) AS A WHERE rownum >=1 and rownum<=50 ORDER BY RD_LAST_NAME, RD_FIRST_NAME
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string16.00.4095
DriverName
stringMicrosoft JDBC Driver 12.4 for SQL Server
DriverVersion
string12.4.2.0
Datasource
stringpatino_diet
Cause
Struct
Entries: 15
additional
Struct (ordered)
SQL
stringselect * from( SELECT ROW_NUMBER() OVER(ORDER BY r.rd_uid desc) AS rownum, UID,SubscriptionID,RD_FIRST_NAME,r.RD_UID,RD_LAST_NAME, RD_PREFIX, RD_CREDENTIALS, RD_OFFICE_ADDRESS, RD_OFFICE_ADDRESS2, RD_OFFICE_CITY, RD_OFFICE_STATE, RD_OFFICE_ZIP, RD_OFFICE2_ADDRESS, RD_OFFICE2_ADDRESS2, RD_OFFICE2_CITY, RD_OFFICE2_STATE, RD_OFFICE2_ZIP, RD_OFFICE3_ADDRESS, RD_OFFICE3_CITY, RD_OFFICE3_STATE, RD_OFFICE3_ZIP, RD_COMPANY_NAME, RD_CONTACT_PHONE, RD_CONTACT_EMAIL, RD_DIRECTORY_URL, RD_OFFICE_TOWN, RD_OFFICE_COUNTY, RD_OFFICE2_COUNTY, RD_WORK_HISTORY, RD_EDUCATION, RD_SUMMARY, RD_DESCRIPTION, RD_AWARDS, RD_ADA_REGISTRATION, RD_LICENSE_STATE, RD_LICENSE_NUMBER, RD_CERTIFICATION_STATE, RD_FOCUS_AGE, RD_MEMBERSHIPS, RD_NEARBY_CITIES, RD_NEARBY_COUNTIES, RD_NEARBY_TOWNS, RD_NEARBY_ZIPS, RD_PAYMENT_METHODS, RD_PAYMENT_DESCRIPTION, RD_VERIFIED, ReadyForReview, Active, ActivateDate, ExpirationDate, datascope, rd_image, comments, isTelehealthProvider ,telehealthProviderNotes , isTakesInsurance , takesInsuranceNotes , showEmailMeButton, count(*) over() tot_Records FROM patino_diet.rd R WHERE 1=1 AND ( 1=1 AND ( (len(rtrim(ltrim(rd_office_zip))) = 5 and rd_office_zip in (99999999,90292)) OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,90292)) OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,90292)) ) ) AND R.RD_Verified = '1' AND R.Active = 'true' AND datascope <> 'PT' AND (R.expirationdate > 07/18/24 OR (R.UID in (SELECT UID FROM users WHERE unlimitedRDListing = 'true'))) ) AS A WHERE rownum >=1 and rownum<=50 ORDER BY RD_LAST_NAME, RD_FIRST_NAME
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string16.00.4095
DriverName
stringMicrosoft JDBC Driver 12.4 for SQL Server
DriverVersion
string12.4.2.0
Datasource
stringpatino_diet
DataSource
stringpatino_diet
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringAn error occurred during the current command (Done status 0). Conversion failed when converting the nvarchar value '-----' to data type int.
NativeErrorCode
number245
queryError
stringselect * from( SELECT ROW_NUMBER() OVER(ORDER BY r.rd_uid desc) AS rownum, UID,SubscriptionID,RD_FIRST_NAME,r.RD_UID,RD_LAST_NAME, RD_PREFIX, RD_CREDENTIALS, RD_OFFICE_ADDRESS, RD_OFFICE_ADDRESS2, RD_OFFICE_CITY, RD_OFFICE_STATE, RD_OFFICE_ZIP, RD_OFFICE2_ADDRESS, RD_OFFICE2_ADDRESS2, RD_OFFICE2_CITY, RD_OFFICE2_STATE, RD_OFFICE2_ZIP, RD_OFFICE3_ADDRESS, RD_OFFICE3_CITY, RD_OFFICE3_STATE, RD_OFFICE3_ZIP, RD_COMPANY_NAME, RD_CONTACT_PHONE, RD_CONTACT_EMAIL, RD_DIRECTORY_URL, RD_OFFICE_TOWN, RD_OFFICE_COUNTY, RD_OFFICE2_COUNTY, RD_WORK_HISTORY, RD_EDUCATION, RD_SUMMARY, RD_DESCRIPTION, RD_AWARDS, RD_ADA_REGISTRATION, RD_LICENSE_STATE, RD_LICENSE_NUMBER, RD_CERTIFICATION_STATE, RD_FOCUS_AGE, RD_MEMBERSHIPS, RD_NEARBY_CITIES, RD_NEARBY_COUNTIES, RD_NEARBY_TOWNS, RD_NEARBY_ZIPS, RD_PAYMENT_METHODS, RD_PAYMENT_DESCRIPTION, RD_VERIFIED, ReadyForReview, Active, ActivateDate, ExpirationDate, datascope, rd_image, comments, isTelehealthProvider ,telehealthProviderNotes , isTakesInsurance , takesInsuranceNotes , showEmailMeButton, count(*) over() tot_Records FROM patino_diet.rd R WHERE 1=1 AND ( 1=1 AND ( (len(rtrim(ltrim(rd_office_zip))) = 5 and rd_office_zip in (99999999,90292)) OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,90292)) OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,90292)) ) ) AND R.RD_Verified = '1' AND R.Active = 'true' AND datascope <> 'PT' AND (R.expirationdate > 07/18/24 OR (R.UID in (SELECT UID FROM users WHERE unlimitedRDListing = 'true'))) ) AS A WHERE rownum >=1 and rownum<=50 ORDER BY RD_LAST_NAME, RD_FIRST_NAME
Sql
stringselect * from( SELECT ROW_NUMBER() OVER(ORDER BY r.rd_uid desc) AS rownum, UID,SubscriptionID,RD_FIRST_NAME,r.RD_UID,RD_LAST_NAME, RD_PREFIX, RD_CREDENTIALS, RD_OFFICE_ADDRESS, RD_OFFICE_ADDRESS2, RD_OFFICE_CITY, RD_OFFICE_STATE, RD_OFFICE_ZIP, RD_OFFICE2_ADDRESS, RD_OFFICE2_ADDRESS2, RD_OFFICE2_CITY, RD_OFFICE2_STATE, RD_OFFICE2_ZIP, RD_OFFICE3_ADDRESS, RD_OFFICE3_CITY, RD_OFFICE3_STATE, RD_OFFICE3_ZIP, RD_COMPANY_NAME, RD_CONTACT_PHONE, RD_CONTACT_EMAIL, RD_DIRECTORY_URL, RD_OFFICE_TOWN, RD_OFFICE_COUNTY, RD_OFFICE2_COUNTY, RD_WORK_HISTORY, RD_EDUCATION, RD_SUMMARY, RD_DESCRIPTION, RD_AWARDS, RD_ADA_REGISTRATION, RD_LICENSE_STATE, RD_LICENSE_NUMBER, RD_CERTIFICATION_STATE, RD_FOCUS_AGE, RD_MEMBERSHIPS, RD_NEARBY_CITIES, RD_NEARBY_COUNTIES, RD_NEARBY_TOWNS, RD_NEARBY_ZIPS, RD_PAYMENT_METHODS, RD_PAYMENT_DESCRIPTION, RD_VERIFIED, ReadyForReview, Active, ActivateDate, ExpirationDate, datascope, rd_image, comments, isTelehealthProvider ,telehealthProviderNotes , isTakesInsurance , takesInsuranceNotes , showEmailMeButton, count(*) over() tot_Records FROM patino_diet.rd R WHERE 1=1 AND ( 1=1 AND ( (len(rtrim(ltrim(rd_office_zip))) = 5 and rd_office_zip in (99999999,90292)) OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,90292)) OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,90292)) ) ) AND R.RD_Verified = '1' AND R.Active = 'true' AND datascope <> 'PT' AND (R.expirationdate > 07/18/24 OR (R.UID in (SELECT UID FROM users WHERE unlimitedRDListing = 'true'))) ) AS A WHERE rownum >=1 and rownum<=50 ORDER BY RD_LAST_NAME, RD_FIRST_NAME
SQLState
stringS0001
StackTrace
stringlucee.runtime.exp.DatabaseException: An error occurred during the current command (Done status 0). Conversion failed when converting the nvarchar value '-----' to data type int. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259) at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer$FetchBufferTokenHandler.onDone(SQLServerResultSet.java:5456) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:103) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:42) at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:5559) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1821) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1079) at lucee.runtime.type.QueryImpl.fillResult(QueryImpl.java:712) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:314) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:243) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1134) at lucee.runtime.tag.Query._doEndTag(Query.java:701) at lucee.runtime.tag.Query.doEndTag(Query.java:566) at cfc.search_cfc$cf.udfCall(/cfc/Search.cfc:206) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:356) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:667) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:589) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1993) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1777) at rd.rd_search_results_cfm$cf$125.call(/rd/rd_search_results.cfm:320) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1027) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:950) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:931) at application_cfc$cf.udfCall(/Application.cfc:483) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:356) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:667) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:589) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1993) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:446) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:220) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2494) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2480) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2451) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1219) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1165) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:765) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1790) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:829)
TagContext
Array
1
Struct
codePrintHTML
string204: WHERE rownum &gt;=#arguments.startRow# and rownum&lt;=#arguments.endRow#<br> 205: ORDER BY RD_LAST_NAME, RD_FIRST_NAME <br> <b>206: &lt;/cfquery&gt;</b><br> 207: <br> 208: &lt;cfif cgi.remote_addr contains '42.111.'&gt;<br>
codePrintPlain
string204: WHERE rownum >=#arguments.startRow# and rownum<=#arguments.endRow# 205: ORDER BY RD_LAST_NAME, RD_FIRST_NAME 206: </cfquery> 207: 208: <cfif cgi.remote_addr contains '42.111.'>
column
number0
id
string??
line
number206
Raw_Trace
stringcfc.search_cfc$cf.udfCall(/cfc/Search.cfc:206)
template
string/opt/lucee/tomcat/webapps/ROOT/dietitian-central/cfc/Search.cfc
type
stringcfml
2
Struct
codePrintHTML
string318: &lt;!---&lt;cfdump var=&quot;#form#&quot;&gt;&lt;cfdump var=&quot;#url#&quot;&gt;&lt;cfabort&gt;---&gt;<br> 319: <br> <b>320: &lt;cfset Variables.qResults = application.searchObject.getResults(form.Country,form.Tele,form.Insurance,form.specialty&lt;!---,url.Country---&gt;,url.city,form.state,usezipflag,ziplist,todaydate,numresults,form.name,form.startRow,form.endRow)&gt;</b><br> 321: <br> 322: &lt;!---TODO:cfdump---&gt; &lt;!---&lt;cfdump var = &quot;#Variables.qResults#&quot;&gt;&lt;!---&lt;cfdump var = &quot;#form.name#&quot;&gt;---&gt;&lt;cfexit&gt;---&gt;<br>
codePrintPlain
string318: <!---<cfdump var="#form#"><cfdump var="#url#"><cfabort>---> 319: 320: <cfset Variables.qResults = application.searchObject.getResults(form.Country,form.Tele,form.Insurance,form.specialty<!---,url.Country--->,url.city,form.state,usezipflag,ziplist,todaydate,numresults,form.name,form.startRow,form.endRow)> 321: 322: <!---TODO:cfdump---> <!---<cfdump var = "#Variables.qResults#"><!---<cfdump var = "#form.name#">---><cfexit>--->
column
number0
id
string??
line
number320
Raw_Trace
stringrd.rd_search_results_cfm$cf$125.call(/rd/rd_search_results.cfm:320)
template
string/opt/lucee/tomcat/webapps/ROOT/dietitian-central/rd/rd_search_results.cfm
type
stringcfml
3
Struct
codePrintHTML
string481: &lt;cfinclude template=&quot;#ARGUMENTS.targetPage#&quot;&gt;<br> 482: &lt;cfelse&gt;<br> <b>483: &lt;cfinclude template=&quot;#ARGUMENTS.targetPage#&quot;&gt;</b><br> 484: &lt;/cfif&gt;<br> 485: &lt;/cffunction&gt;<br>
codePrintPlain
string481: <cfinclude template="#ARGUMENTS.targetPage#"> 482: <cfelse> 483: <cfinclude template="#ARGUMENTS.targetPage#"> 484: </cfif> 485: </cffunction>
column
number0
id
string??
line
number483
Raw_Trace
stringapplication_cfc$cf.udfCall(/Application.cfc:483)
template
string/opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc
type
stringcfml
type
stringdatabase
where
string
DataSource
stringpatino_diet
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringAn error occurred during the current command (Done status 0). Conversion failed when converting the nvarchar value '-----' to data type int.
name
stringonRequest
NativeErrorCode
number245
queryError
stringselect * from( SELECT ROW_NUMBER() OVER(ORDER BY r.rd_uid desc) AS rownum, UID,SubscriptionID,RD_FIRST_NAME,r.RD_UID,RD_LAST_NAME, RD_PREFIX, RD_CREDENTIALS, RD_OFFICE_ADDRESS, RD_OFFICE_ADDRESS2, RD_OFFICE_CITY, RD_OFFICE_STATE, RD_OFFICE_ZIP, RD_OFFICE2_ADDRESS, RD_OFFICE2_ADDRESS2, RD_OFFICE2_CITY, RD_OFFICE2_STATE, RD_OFFICE2_ZIP, RD_OFFICE3_ADDRESS, RD_OFFICE3_CITY, RD_OFFICE3_STATE, RD_OFFICE3_ZIP, RD_COMPANY_NAME, RD_CONTACT_PHONE, RD_CONTACT_EMAIL, RD_DIRECTORY_URL, RD_OFFICE_TOWN, RD_OFFICE_COUNTY, RD_OFFICE2_COUNTY, RD_WORK_HISTORY, RD_EDUCATION, RD_SUMMARY, RD_DESCRIPTION, RD_AWARDS, RD_ADA_REGISTRATION, RD_LICENSE_STATE, RD_LICENSE_NUMBER, RD_CERTIFICATION_STATE, RD_FOCUS_AGE, RD_MEMBERSHIPS, RD_NEARBY_CITIES, RD_NEARBY_COUNTIES, RD_NEARBY_TOWNS, RD_NEARBY_ZIPS, RD_PAYMENT_METHODS, RD_PAYMENT_DESCRIPTION, RD_VERIFIED, ReadyForReview, Active, ActivateDate, ExpirationDate, datascope, rd_image, comments, isTelehealthProvider ,telehealthProviderNotes , isTakesInsurance , takesInsuranceNotes , showEmailMeButton, count(*) over() tot_Records FROM patino_diet.rd R WHERE 1=1 AND ( 1=1 AND ( (len(rtrim(ltrim(rd_office_zip))) = 5 and rd_office_zip in (99999999,90292)) OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,90292)) OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,90292)) ) ) AND R.RD_Verified = '1' AND R.Active = 'true' AND datascope <> 'PT' AND (R.expirationdate > 07/18/24 OR (R.UID in (SELECT UID FROM users WHERE unlimitedRDListing = 'true'))) ) AS A WHERE rownum >=1 and rownum<=50 ORDER BY RD_LAST_NAME, RD_FIRST_NAME
rootCause
Struct
Entries: 15
additional
Struct (ordered)
SQL
stringselect * from( SELECT ROW_NUMBER() OVER(ORDER BY r.rd_uid desc) AS rownum, UID,SubscriptionID,RD_FIRST_NAME,r.RD_UID,RD_LAST_NAME, RD_PREFIX, RD_CREDENTIALS, RD_OFFICE_ADDRESS, RD_OFFICE_ADDRESS2, RD_OFFICE_CITY, RD_OFFICE_STATE, RD_OFFICE_ZIP, RD_OFFICE2_ADDRESS, RD_OFFICE2_ADDRESS2, RD_OFFICE2_CITY, RD_OFFICE2_STATE, RD_OFFICE2_ZIP, RD_OFFICE3_ADDRESS, RD_OFFICE3_CITY, RD_OFFICE3_STATE, RD_OFFICE3_ZIP, RD_COMPANY_NAME, RD_CONTACT_PHONE, RD_CONTACT_EMAIL, RD_DIRECTORY_URL, RD_OFFICE_TOWN, RD_OFFICE_COUNTY, RD_OFFICE2_COUNTY, RD_WORK_HISTORY, RD_EDUCATION, RD_SUMMARY, RD_DESCRIPTION, RD_AWARDS, RD_ADA_REGISTRATION, RD_LICENSE_STATE, RD_LICENSE_NUMBER, RD_CERTIFICATION_STATE, RD_FOCUS_AGE, RD_MEMBERSHIPS, RD_NEARBY_CITIES, RD_NEARBY_COUNTIES, RD_NEARBY_TOWNS, RD_NEARBY_ZIPS, RD_PAYMENT_METHODS, RD_PAYMENT_DESCRIPTION, RD_VERIFIED, ReadyForReview, Active, ActivateDate, ExpirationDate, datascope, rd_image, comments, isTelehealthProvider ,telehealthProviderNotes , isTakesInsurance , takesInsuranceNotes , showEmailMeButton, count(*) over() tot_Records FROM patino_diet.rd R WHERE 1=1 AND ( 1=1 AND ( (len(rtrim(ltrim(rd_office_zip))) = 5 and rd_office_zip in (99999999,90292)) OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,90292)) OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,90292)) ) ) AND R.RD_Verified = '1' AND R.Active = 'true' AND datascope <> 'PT' AND (R.expirationdate > 07/18/24 OR (R.UID in (SELECT UID FROM users WHERE unlimitedRDListing = 'true'))) ) AS A WHERE rownum >=1 and rownum<=50 ORDER BY RD_LAST_NAME, RD_FIRST_NAME
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string16.00.4095
DriverName
stringMicrosoft JDBC Driver 12.4 for SQL Server
DriverVersion
string12.4.2.0
Datasource
stringpatino_diet
DataSource
stringpatino_diet
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringAn error occurred during the current command (Done status 0). Conversion failed when converting the nvarchar value '-----' to data type int.
NativeErrorCode
number245
queryError
stringselect * from( SELECT ROW_NUMBER() OVER(ORDER BY r.rd_uid desc) AS rownum, UID,SubscriptionID,RD_FIRST_NAME,r.RD_UID,RD_LAST_NAME, RD_PREFIX, RD_CREDENTIALS, RD_OFFICE_ADDRESS, RD_OFFICE_ADDRESS2, RD_OFFICE_CITY, RD_OFFICE_STATE, RD_OFFICE_ZIP, RD_OFFICE2_ADDRESS, RD_OFFICE2_ADDRESS2, RD_OFFICE2_CITY, RD_OFFICE2_STATE, RD_OFFICE2_ZIP, RD_OFFICE3_ADDRESS, RD_OFFICE3_CITY, RD_OFFICE3_STATE, RD_OFFICE3_ZIP, RD_COMPANY_NAME, RD_CONTACT_PHONE, RD_CONTACT_EMAIL, RD_DIRECTORY_URL, RD_OFFICE_TOWN, RD_OFFICE_COUNTY, RD_OFFICE2_COUNTY, RD_WORK_HISTORY, RD_EDUCATION, RD_SUMMARY, RD_DESCRIPTION, RD_AWARDS, RD_ADA_REGISTRATION, RD_LICENSE_STATE, RD_LICENSE_NUMBER, RD_CERTIFICATION_STATE, RD_FOCUS_AGE, RD_MEMBERSHIPS, RD_NEARBY_CITIES, RD_NEARBY_COUNTIES, RD_NEARBY_TOWNS, RD_NEARBY_ZIPS, RD_PAYMENT_METHODS, RD_PAYMENT_DESCRIPTION, RD_VERIFIED, ReadyForReview, Active, ActivateDate, ExpirationDate, datascope, rd_image, comments, isTelehealthProvider ,telehealthProviderNotes , isTakesInsurance , takesInsuranceNotes , showEmailMeButton, count(*) over() tot_Records FROM patino_diet.rd R WHERE 1=1 AND ( 1=1 AND ( (len(rtrim(ltrim(rd_office_zip))) = 5 and rd_office_zip in (99999999,90292)) OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,90292)) OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,90292)) ) ) AND R.RD_Verified = '1' AND R.Active = 'true' AND datascope <> 'PT' AND (R.expirationdate > 07/18/24 OR (R.UID in (SELECT UID FROM users WHERE unlimitedRDListing = 'true'))) ) AS A WHERE rownum >=1 and rownum<=50 ORDER BY RD_LAST_NAME, RD_FIRST_NAME
Sql
stringselect * from( SELECT ROW_NUMBER() OVER(ORDER BY r.rd_uid desc) AS rownum, UID,SubscriptionID,RD_FIRST_NAME,r.RD_UID,RD_LAST_NAME, RD_PREFIX, RD_CREDENTIALS, RD_OFFICE_ADDRESS, RD_OFFICE_ADDRESS2, RD_OFFICE_CITY, RD_OFFICE_STATE, RD_OFFICE_ZIP, RD_OFFICE2_ADDRESS, RD_OFFICE2_ADDRESS2, RD_OFFICE2_CITY, RD_OFFICE2_STATE, RD_OFFICE2_ZIP, RD_OFFICE3_ADDRESS, RD_OFFICE3_CITY, RD_OFFICE3_STATE, RD_OFFICE3_ZIP, RD_COMPANY_NAME, RD_CONTACT_PHONE, RD_CONTACT_EMAIL, RD_DIRECTORY_URL, RD_OFFICE_TOWN, RD_OFFICE_COUNTY, RD_OFFICE2_COUNTY, RD_WORK_HISTORY, RD_EDUCATION, RD_SUMMARY, RD_DESCRIPTION, RD_AWARDS, RD_ADA_REGISTRATION, RD_LICENSE_STATE, RD_LICENSE_NUMBER, RD_CERTIFICATION_STATE, RD_FOCUS_AGE, RD_MEMBERSHIPS, RD_NEARBY_CITIES, RD_NEARBY_COUNTIES, RD_NEARBY_TOWNS, RD_NEARBY_ZIPS, RD_PAYMENT_METHODS, RD_PAYMENT_DESCRIPTION, RD_VERIFIED, ReadyForReview, Active, ActivateDate, ExpirationDate, datascope, rd_image, comments, isTelehealthProvider ,telehealthProviderNotes , isTakesInsurance , takesInsuranceNotes , showEmailMeButton, count(*) over() tot_Records FROM patino_diet.rd R WHERE 1=1 AND ( 1=1 AND ( (len(rtrim(ltrim(rd_office_zip))) = 5 and rd_office_zip in (99999999,90292)) OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,90292)) OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,90292)) ) ) AND R.RD_Verified = '1' AND R.Active = 'true' AND datascope <> 'PT' AND (R.expirationdate > 07/18/24 OR (R.UID in (SELECT UID FROM users WHERE unlimitedRDListing = 'true'))) ) AS A WHERE rownum >=1 and rownum<=50 ORDER BY RD_LAST_NAME, RD_FIRST_NAME
SQLState
stringS0001
StackTrace
stringlucee.runtime.exp.DatabaseException: An error occurred during the current command (Done status 0). Conversion failed when converting the nvarchar value '-----' to data type int. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259) at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer$FetchBufferTokenHandler.onDone(SQLServerResultSet.java:5456) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:103) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:42) at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:5559) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1821) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1079) at lucee.runtime.type.QueryImpl.fillResult(QueryImpl.java:712) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:314) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:243) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1134) at lucee.runtime.tag.Query._doEndTag(Query.java:701) at lucee.runtime.tag.Query.doEndTag(Query.java:566) at cfc.search_cfc$cf.udfCall(/cfc/Search.cfc:206) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:356) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:667) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:589) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1993) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1777) at rd.rd_search_results_cfm$cf$125.call(/rd/rd_search_results.cfm:320) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1027) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:950) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:931) at application_cfc$cf.udfCall(/Application.cfc:483) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:356) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:667) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:589) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1993) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:446) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:220) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2494) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2480) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2451) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1219) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1165) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:765) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1790) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:829)
TagContext
Array
1
Struct
codePrintHTML
string204: WHERE rownum &gt;=#arguments.startRow# and rownum&lt;=#arguments.endRow#<br> 205: ORDER BY RD_LAST_NAME, RD_FIRST_NAME <br> <b>206: &lt;/cfquery&gt;</b><br> 207: <br> 208: &lt;cfif cgi.remote_addr contains '42.111.'&gt;<br>
codePrintPlain
string204: WHERE rownum >=#arguments.startRow# and rownum<=#arguments.endRow# 205: ORDER BY RD_LAST_NAME, RD_FIRST_NAME 206: </cfquery> 207: 208: <cfif cgi.remote_addr contains '42.111.'>
column
number0
id
string??
line
number206
Raw_Trace
stringcfc.search_cfc$cf.udfCall(/cfc/Search.cfc:206)
template
string/opt/lucee/tomcat/webapps/ROOT/dietitian-central/cfc/Search.cfc
type
stringcfml
2
Struct
codePrintHTML
string318: &lt;!---&lt;cfdump var=&quot;#form#&quot;&gt;&lt;cfdump var=&quot;#url#&quot;&gt;&lt;cfabort&gt;---&gt;<br> 319: <br> <b>320: &lt;cfset Variables.qResults = application.searchObject.getResults(form.Country,form.Tele,form.Insurance,form.specialty&lt;!---,url.Country---&gt;,url.city,form.state,usezipflag,ziplist,todaydate,numresults,form.name,form.startRow,form.endRow)&gt;</b><br> 321: <br> 322: &lt;!---TODO:cfdump---&gt; &lt;!---&lt;cfdump var = &quot;#Variables.qResults#&quot;&gt;&lt;!---&lt;cfdump var = &quot;#form.name#&quot;&gt;---&gt;&lt;cfexit&gt;---&gt;<br>
codePrintPlain
string318: <!---<cfdump var="#form#"><cfdump var="#url#"><cfabort>---> 319: 320: <cfset Variables.qResults = application.searchObject.getResults(form.Country,form.Tele,form.Insurance,form.specialty<!---,url.Country--->,url.city,form.state,usezipflag,ziplist,todaydate,numresults,form.name,form.startRow,form.endRow)> 321: 322: <!---TODO:cfdump---> <!---<cfdump var = "#Variables.qResults#"><!---<cfdump var = "#form.name#">---><cfexit>--->
column
number0
id
string??
line
number320
Raw_Trace
stringrd.rd_search_results_cfm$cf$125.call(/rd/rd_search_results.cfm:320)
template
string/opt/lucee/tomcat/webapps/ROOT/dietitian-central/rd/rd_search_results.cfm
type
stringcfml
3
Struct
codePrintHTML
string481: &lt;cfinclude template=&quot;#ARGUMENTS.targetPage#&quot;&gt;<br> 482: &lt;cfelse&gt;<br> <b>483: &lt;cfinclude template=&quot;#ARGUMENTS.targetPage#&quot;&gt;</b><br> 484: &lt;/cfif&gt;<br> 485: &lt;/cffunction&gt;<br>
codePrintPlain
string481: <cfinclude template="#ARGUMENTS.targetPage#"> 482: <cfelse> 483: <cfinclude template="#ARGUMENTS.targetPage#"> 484: </cfif> 485: </cffunction>
column
number0
id
string??
line
number483
Raw_Trace
stringapplication_cfc$cf.udfCall(/Application.cfc:483)
template
string/opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc
type
stringcfml
type
stringdatabase
where
string
Sql
stringselect * from( SELECT ROW_NUMBER() OVER(ORDER BY r.rd_uid desc) AS rownum, UID,SubscriptionID,RD_FIRST_NAME,r.RD_UID,RD_LAST_NAME, RD_PREFIX, RD_CREDENTIALS, RD_OFFICE_ADDRESS, RD_OFFICE_ADDRESS2, RD_OFFICE_CITY, RD_OFFICE_STATE, RD_OFFICE_ZIP, RD_OFFICE2_ADDRESS, RD_OFFICE2_ADDRESS2, RD_OFFICE2_CITY, RD_OFFICE2_STATE, RD_OFFICE2_ZIP, RD_OFFICE3_ADDRESS, RD_OFFICE3_CITY, RD_OFFICE3_STATE, RD_OFFICE3_ZIP, RD_COMPANY_NAME, RD_CONTACT_PHONE, RD_CONTACT_EMAIL, RD_DIRECTORY_URL, RD_OFFICE_TOWN, RD_OFFICE_COUNTY, RD_OFFICE2_COUNTY, RD_WORK_HISTORY, RD_EDUCATION, RD_SUMMARY, RD_DESCRIPTION, RD_AWARDS, RD_ADA_REGISTRATION, RD_LICENSE_STATE, RD_LICENSE_NUMBER, RD_CERTIFICATION_STATE, RD_FOCUS_AGE, RD_MEMBERSHIPS, RD_NEARBY_CITIES, RD_NEARBY_COUNTIES, RD_NEARBY_TOWNS, RD_NEARBY_ZIPS, RD_PAYMENT_METHODS, RD_PAYMENT_DESCRIPTION, RD_VERIFIED, ReadyForReview, Active, ActivateDate, ExpirationDate, datascope, rd_image, comments, isTelehealthProvider ,telehealthProviderNotes , isTakesInsurance , takesInsuranceNotes , showEmailMeButton, count(*) over() tot_Records FROM patino_diet.rd R WHERE 1=1 AND ( 1=1 AND ( (len(rtrim(ltrim(rd_office_zip))) = 5 and rd_office_zip in (99999999,90292)) OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,90292)) OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,90292)) ) ) AND R.RD_Verified = '1' AND R.Active = 'true' AND datascope <> 'PT' AND (R.expirationdate > 07/18/24 OR (R.UID in (SELECT UID FROM users WHERE unlimitedRDListing = 'true'))) ) AS A WHERE rownum >=1 and rownum<=50 ORDER BY RD_LAST_NAME, RD_FIRST_NAME
SQLState
stringS0001
StackTrace
stringlucee.runtime.exp.DatabaseException: An error occurred during the current command (Done status 0). Conversion failed when converting the nvarchar value '-----' to data type int. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259) at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer$FetchBufferTokenHandler.onDone(SQLServerResultSet.java:5456) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:103) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:42) at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:5559) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1821) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1079) at lucee.runtime.type.QueryImpl.fillResult(QueryImpl.java:712) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:314) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:243) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1134) at lucee.runtime.tag.Query._doEndTag(Query.java:701) at lucee.runtime.tag.Query.doEndTag(Query.java:566) at cfc.search_cfc$cf.udfCall(/cfc/Search.cfc:206) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:356) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:667) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:589) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1993) at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:787) at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1777) at rd.rd_search_results_cfm$cf$125.call(/rd/rd_search_results.cfm:320) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1027) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:950) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:931) at application_cfc$cf.udfCall(/Application.cfc:483) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:356) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:667) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:589) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1993) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:446) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:220) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2494) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2480) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2451) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1219) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1165) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:765) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:390) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1790) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:829)
TagContext
Array
1
Struct
codePrintHTML
string204: WHERE rownum &gt;=#arguments.startRow# and rownum&lt;=#arguments.endRow#<br> 205: ORDER BY RD_LAST_NAME, RD_FIRST_NAME <br> <b>206: &lt;/cfquery&gt;</b><br> 207: <br> 208: &lt;cfif cgi.remote_addr contains '42.111.'&gt;<br>
codePrintPlain
string204: WHERE rownum >=#arguments.startRow# and rownum<=#arguments.endRow# 205: ORDER BY RD_LAST_NAME, RD_FIRST_NAME 206: </cfquery> 207: 208: <cfif cgi.remote_addr contains '42.111.'>
column
number0
id
string??
line
number206
Raw_Trace
stringcfc.search_cfc$cf.udfCall(/cfc/Search.cfc:206)
template
string/opt/lucee/tomcat/webapps/ROOT/dietitian-central/cfc/Search.cfc
type
stringcfml
2
Struct
codePrintHTML
string318: &lt;!---&lt;cfdump var=&quot;#form#&quot;&gt;&lt;cfdump var=&quot;#url#&quot;&gt;&lt;cfabort&gt;---&gt;<br> 319: <br> <b>320: &lt;cfset Variables.qResults = application.searchObject.getResults(form.Country,form.Tele,form.Insurance,form.specialty&lt;!---,url.Country---&gt;,url.city,form.state,usezipflag,ziplist,todaydate,numresults,form.name,form.startRow,form.endRow)&gt;</b><br> 321: <br> 322: &lt;!---TODO:cfdump---&gt; &lt;!---&lt;cfdump var = &quot;#Variables.qResults#&quot;&gt;&lt;!---&lt;cfdump var = &quot;#form.name#&quot;&gt;---&gt;&lt;cfexit&gt;---&gt;<br>
codePrintPlain
string318: <!---<cfdump var="#form#"><cfdump var="#url#"><cfabort>---> 319: 320: <cfset Variables.qResults = application.searchObject.getResults(form.Country,form.Tele,form.Insurance,form.specialty<!---,url.Country--->,url.city,form.state,usezipflag,ziplist,todaydate,numresults,form.name,form.startRow,form.endRow)> 321: 322: <!---TODO:cfdump---> <!---<cfdump var = "#Variables.qResults#"><!---<cfdump var = "#form.name#">---><cfexit>--->
column
number0
id
string??
line
number320
Raw_Trace
stringrd.rd_search_results_cfm$cf$125.call(/rd/rd_search_results.cfm:320)
template
string/opt/lucee/tomcat/webapps/ROOT/dietitian-central/rd/rd_search_results.cfm
type
stringcfml
3
Struct
codePrintHTML
string481: &lt;cfinclude template=&quot;#ARGUMENTS.targetPage#&quot;&gt;<br> 482: &lt;cfelse&gt;<br> <b>483: &lt;cfinclude template=&quot;#ARGUMENTS.targetPage#&quot;&gt;</b><br> 484: &lt;/cfif&gt;<br> 485: &lt;/cffunction&gt;<br>
codePrintPlain
string481: <cfinclude template="#ARGUMENTS.targetPage#"> 482: <cfelse> 483: <cfinclude template="#ARGUMENTS.targetPage#"> 484: </cfif> 485: </cffunction>
column
number0
id
string??
line
number483
Raw_Trace
stringapplication_cfc$cf.udfCall(/Application.cfc:483)
template
string/opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc
type
stringcfml
type
stringdatabase
where
string