Catch
Entries: 18 |
| additional | | Struct (ordered) | | SQL | | string | select * 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,90311))
OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,90311))
OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,90311))
)
)
AND R.RD_Verified = '1'
AND R.Active = 'true'
AND datascope <> 'PT'
AND (R.expirationdate > 01/20/25 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 | | string | Microsoft SQL Server |
| | DatabaseVersion | | | DriverName | | string | Microsoft JDBC Driver 12.6 for SQL Server |
| | DriverVersion | | | Datasource | |
|
| Cause | Struct
Entries: 15 | | additional | | Struct (ordered) | | SQL | | string | select * 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,90311))
OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,90311))
OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,90311))
)
)
AND R.RD_Verified = '1'
AND R.Active = 'true'
AND datascope <> 'PT'
AND (R.expirationdate > 01/20/25 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 | | string | Microsoft SQL Server |
| | DatabaseVersion | | | DriverName | | string | Microsoft JDBC Driver 12.6 for SQL Server |
| | DriverVersion | | | Datasource | |
| | DataSource | | | Detail | | | ErrorCode | | | Extended_Info | | | ExtendedInfo | | | Message | | string | An error occurred during the current command (Done status 0). Conversion failed when converting the nvarchar value '-----' to data type int. |
| | NativeErrorCode | | | queryError | | string | select * 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,90311))
OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,90311))
OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,90311))
)
)
AND R.RD_Verified = '1'
AND R.Active = 'true'
AND datascope <> 'PT'
AND (R.expirationdate > 01/20/25 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 | | string | select * 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,90311))
OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,90311))
OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,90311))
)
)
AND R.RD_Verified = '1'
AND R.Active = 'true'
AND datascope <> 'PT'
AND (R.expirationdate > 01/20/25 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 | | | StackTrace | | string | lucee.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:261)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer$FetchBufferTokenHandler.onDone(SQLServerResultSet.java:5455)
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:5558)
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:711)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:313)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:242)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:1128)
at lucee.runtime.tag.Query._doEndTag(Query.java:695)
at lucee.runtime.tag.Query.doEndTag(Query.java:560)
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:357)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:671)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2033)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1984)
at rd.rd_search_results_cfm$cf.call(/rd/rd_search_results.cfm:320)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1016)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:921)
at application_cfc$cf.udfCall_000002(/Application.cfc:486)
at application_cfc$cf.udfCall(/Application.cfc:449)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:671)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2033)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:476)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2725)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2712)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2683)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1159)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1116)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:42)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
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:482)
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.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:396)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:937)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Unknown Source)
|
| | TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 204: WHERE rownum >=#arguments.startRow# and rownum<=#arguments.endRow#<br>
205: ORDER BY RD_LAST_NAME, RD_FIRST_NAME <br>
<b>206: </cfquery></b><br>
207: <br>
208: <cfif cgi.remote_addr contains '42.111.'><br>
|
| | codePrintPlain | | string | 204: 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 | | | id | | | line | | | Raw_Trace | | string | cfc.search_cfc$cf.udfCall(/cfc/Search.cfc:206) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/cfc/Search.cfc |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 318: <!---<cfdump var="#form#"><cfdump var="#url#"><cfabort>---><br>
319: <br>
<b>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)></b><br>
321: <br>
322: <!---TODO:cfdump---> <!---<cfdump var = "#Variables.qResults#"><!---<cfdump var = "#form.name#">---><cfexit>---><br>
|
| | codePrintPlain | | string | 318: <!---<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 | | | id | | | line | | | Raw_Trace | | string | rd.rd_search_results_cfm$cf.call(/rd/rd_search_results.cfm:320) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/rd/rd_search_results.cfm |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 484: <cfinclude template="#ARGUMENTS.targetPage#"><br>
485: <cfelse><br>
<b>486: <cfinclude template="#ARGUMENTS.targetPage#"></b><br>
487: </cfif><br>
488: </cffunction><br>
|
| | codePrintPlain | | string | 484: <cfinclude template="#ARGUMENTS.targetPage#">
485: <cfelse>
486: <cfinclude template="#ARGUMENTS.targetPage#">
487: </cfif>
488: </cffunction>
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall_000002(/Application.cfc:486) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | 447: <br>
448: <cffunction name="onRequest"><br>
<b>449: <cfargument name="targetPage" type="String" required=true/></b><br>
450: <br>
451: <cfif cgi.remote_addr NEQ '127.0.0.1'><br>
|
| | codePrintPlain | | string | 447:
448: <cffunction name="onRequest">
449: <cfargument name="targetPage" type="String" required=true/>
450:
451: <cfif cgi.remote_addr NEQ '127.0.0.1'>
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall(/Application.cfc:449) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc |
| | type | |
|
| | type | | | where | |
|
| DataSource | |
| Detail | |
| ErrorCode | |
| Extended_Info | |
| ExtendedInfo | |
| Message | | string | An error occurred during the current command (Done status 0). Conversion failed when converting the nvarchar value '-----' to data type int. |
|
| name | |
| NativeErrorCode | |
| queryError | | string | select * 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,90311))
OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,90311))
OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,90311))
)
)
AND R.RD_Verified = '1'
AND R.Active = 'true'
AND datascope <> 'PT'
AND (R.expirationdate > 01/20/25 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 | | string | select * 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,90311))
OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,90311))
OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,90311))
)
)
AND R.RD_Verified = '1'
AND R.Active = 'true'
AND datascope <> 'PT'
AND (R.expirationdate > 01/20/25 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 | | string | Microsoft SQL Server |
| | DatabaseVersion | | | DriverName | | string | Microsoft JDBC Driver 12.6 for SQL Server |
| | DriverVersion | | | Datasource | |
| | DataSource | | | Detail | | | ErrorCode | | | Extended_Info | | | ExtendedInfo | | | Message | | string | An error occurred during the current command (Done status 0). Conversion failed when converting the nvarchar value '-----' to data type int. |
| | NativeErrorCode | | | queryError | | string | select * 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,90311))
OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,90311))
OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,90311))
)
)
AND R.RD_Verified = '1'
AND R.Active = 'true'
AND datascope <> 'PT'
AND (R.expirationdate > 01/20/25 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 | | string | select * 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,90311))
OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,90311))
OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,90311))
)
)
AND R.RD_Verified = '1'
AND R.Active = 'true'
AND datascope <> 'PT'
AND (R.expirationdate > 01/20/25 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 | | | StackTrace | | string | lucee.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:261)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer$FetchBufferTokenHandler.onDone(SQLServerResultSet.java:5455)
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:5558)
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:711)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:313)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:242)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:1128)
at lucee.runtime.tag.Query._doEndTag(Query.java:695)
at lucee.runtime.tag.Query.doEndTag(Query.java:560)
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:357)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:671)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2033)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1984)
at rd.rd_search_results_cfm$cf.call(/rd/rd_search_results.cfm:320)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1016)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:921)
at application_cfc$cf.udfCall_000002(/Application.cfc:486)
at application_cfc$cf.udfCall(/Application.cfc:449)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:671)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2033)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:476)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2725)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2712)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2683)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1159)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1116)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:42)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
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:482)
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.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:396)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:937)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Unknown Source)
|
| | TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 204: WHERE rownum >=#arguments.startRow# and rownum<=#arguments.endRow#<br>
205: ORDER BY RD_LAST_NAME, RD_FIRST_NAME <br>
<b>206: </cfquery></b><br>
207: <br>
208: <cfif cgi.remote_addr contains '42.111.'><br>
|
| | codePrintPlain | | string | 204: 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 | | | id | | | line | | | Raw_Trace | | string | cfc.search_cfc$cf.udfCall(/cfc/Search.cfc:206) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/cfc/Search.cfc |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 318: <!---<cfdump var="#form#"><cfdump var="#url#"><cfabort>---><br>
319: <br>
<b>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)></b><br>
321: <br>
322: <!---TODO:cfdump---> <!---<cfdump var = "#Variables.qResults#"><!---<cfdump var = "#form.name#">---><cfexit>---><br>
|
| | codePrintPlain | | string | 318: <!---<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 | | | id | | | line | | | Raw_Trace | | string | rd.rd_search_results_cfm$cf.call(/rd/rd_search_results.cfm:320) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/rd/rd_search_results.cfm |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 484: <cfinclude template="#ARGUMENTS.targetPage#"><br>
485: <cfelse><br>
<b>486: <cfinclude template="#ARGUMENTS.targetPage#"></b><br>
487: </cfif><br>
488: </cffunction><br>
|
| | codePrintPlain | | string | 484: <cfinclude template="#ARGUMENTS.targetPage#">
485: <cfelse>
486: <cfinclude template="#ARGUMENTS.targetPage#">
487: </cfif>
488: </cffunction>
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall_000002(/Application.cfc:486) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | 447: <br>
448: <cffunction name="onRequest"><br>
<b>449: <cfargument name="targetPage" type="String" required=true/></b><br>
450: <br>
451: <cfif cgi.remote_addr NEQ '127.0.0.1'><br>
|
| | codePrintPlain | | string | 447:
448: <cffunction name="onRequest">
449: <cfargument name="targetPage" type="String" required=true/>
450:
451: <cfif cgi.remote_addr NEQ '127.0.0.1'>
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall(/Application.cfc:449) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc |
| | type | |
|
| | type | | | where | |
|
| Sql | | string | select * 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,90311))
OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,90311))
OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,90311))
)
)
AND R.RD_Verified = '1'
AND R.Active = 'true'
AND datascope <> 'PT'
AND (R.expirationdate > 01/20/25 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 | |
| StackTrace | | string | lucee.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:261)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer$FetchBufferTokenHandler.onDone(SQLServerResultSet.java:5455)
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:5558)
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:711)
at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:313)
at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:242)
at lucee.runtime.tag.Query.executeDatasoure(Query.java:1128)
at lucee.runtime.tag.Query._doEndTag(Query.java:695)
at lucee.runtime.tag.Query.doEndTag(Query.java:560)
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:357)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:671)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2033)
at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:796)
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1984)
at rd.rd_search_results_cfm$cf.call(/rd/rd_search_results.cfm:320)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1016)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:921)
at application_cfc$cf.udfCall_000002(/Application.cfc:486)
at application_cfc$cf.udfCall(/Application.cfc:449)
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112)
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:671)
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:588)
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2033)
at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:476)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:212)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:41)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2725)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2712)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2683)
at lucee.runtime.engine.Request.exe(Request.java:45)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1159)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1116)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:42)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:623)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
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:482)
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.connector.CoyoteAdapter.service(CoyoteAdapter.java:346)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:396)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:937)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Unknown Source)
|
|
| TagContext | | Array | | 1 | | Struct | | codePrintHTML | | string | 204: WHERE rownum >=#arguments.startRow# and rownum<=#arguments.endRow#<br>
205: ORDER BY RD_LAST_NAME, RD_FIRST_NAME <br>
<b>206: </cfquery></b><br>
207: <br>
208: <cfif cgi.remote_addr contains '42.111.'><br>
|
| | codePrintPlain | | string | 204: 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 | | | id | | | line | | | Raw_Trace | | string | cfc.search_cfc$cf.udfCall(/cfc/Search.cfc:206) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/cfc/Search.cfc |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 318: <!---<cfdump var="#form#"><cfdump var="#url#"><cfabort>---><br>
319: <br>
<b>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)></b><br>
321: <br>
322: <!---TODO:cfdump---> <!---<cfdump var = "#Variables.qResults#"><!---<cfdump var = "#form.name#">---><cfexit>---><br>
|
| | codePrintPlain | | string | 318: <!---<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 | | | id | | | line | | | Raw_Trace | | string | rd.rd_search_results_cfm$cf.call(/rd/rd_search_results.cfm:320) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/rd/rd_search_results.cfm |
| | type | |
| | 3 | | Struct | | codePrintHTML | | string | 484: <cfinclude template="#ARGUMENTS.targetPage#"><br>
485: <cfelse><br>
<b>486: <cfinclude template="#ARGUMENTS.targetPage#"></b><br>
487: </cfif><br>
488: </cffunction><br>
|
| | codePrintPlain | | string | 484: <cfinclude template="#ARGUMENTS.targetPage#">
485: <cfelse>
486: <cfinclude template="#ARGUMENTS.targetPage#">
487: </cfif>
488: </cffunction>
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall_000002(/Application.cfc:486) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc |
| | type | |
| | 4 | | Struct | | codePrintHTML | | string | 447: <br>
448: <cffunction name="onRequest"><br>
<b>449: <cfargument name="targetPage" type="String" required=true/></b><br>
450: <br>
451: <cfif cgi.remote_addr NEQ '127.0.0.1'><br>
|
| | codePrintPlain | | string | 447:
448: <cffunction name="onRequest">
449: <cfargument name="targetPage" type="String" required=true/>
450:
451: <cfif cgi.remote_addr NEQ '127.0.0.1'>
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf.udfCall(/Application.cfc:449) |
| | template | | string | /opt/lucee/tomcat/webapps/ROOT/dietitian-central/Application.cfc |
| | type | |
|
|
| type | |
| where | |