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,30359))
OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,30359))
OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,30359))
)
)
AND R.RD_Verified = '1'
AND R.Active = 'true'
AND datascope <> 'PT'
AND (R.expirationdate > 03/28/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
string
Microsoft SQL Server
DatabaseVersion
string
16.00.4095
DriverName
string
Microsoft JDBC Driver 12.4 for SQL Server
DriverVersion
string
12.4.2.0
Datasource
string
patino_diet
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,30359))
OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,30359))
OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,30359))
)
)
AND R.RD_Verified = '1'
AND R.Active = 'true'
AND datascope <> 'PT'
AND (R.expirationdate > 03/28/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
string
Microsoft SQL Server
DatabaseVersion
string
16.00.4095
DriverName
string
Microsoft JDBC Driver 12.4 for SQL Server
DriverVersion
string
12.4.2.0
Datasource
string
patino_diet
DataSource
string
patino_diet
Detail
string
ErrorCode
string
0
Extended_Info
string
ExtendedInfo
string
Message
string
An error occurred during the current command (Done status 0). Conversion failed when converting the nvarchar value '-----' to data type int.
NativeErrorCode
number
245
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,30359))
OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,30359))
OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,30359))
)
)
AND R.RD_Verified = '1'
AND R.Active = 'true'
AND datascope <> 'PT'
AND (R.expirationdate > 03/28/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
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,30359))
OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,30359))
OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,30359))
)
)
AND R.RD_Verified = '1'
AND R.Active = 'true'
AND datascope <> 'PT'
AND (R.expirationdate > 03/28/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
string
S0001
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: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.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:482)
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
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.'>
An error occurred during the current command (Done status 0). Conversion failed when converting the nvarchar value '-----' to data type int.
name
string
onRequest
NativeErrorCode
number
245
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,30359))
OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,30359))
OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,30359))
)
)
AND R.RD_Verified = '1'
AND R.Active = 'true'
AND datascope <> 'PT'
AND (R.expirationdate > 03/28/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
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,30359))
OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,30359))
OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,30359))
)
)
AND R.RD_Verified = '1'
AND R.Active = 'true'
AND datascope <> 'PT'
AND (R.expirationdate > 03/28/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
string
Microsoft SQL Server
DatabaseVersion
string
16.00.4095
DriverName
string
Microsoft JDBC Driver 12.4 for SQL Server
DriverVersion
string
12.4.2.0
Datasource
string
patino_diet
DataSource
string
patino_diet
Detail
string
ErrorCode
string
0
Extended_Info
string
ExtendedInfo
string
Message
string
An error occurred during the current command (Done status 0). Conversion failed when converting the nvarchar value '-----' to data type int.
NativeErrorCode
number
245
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,30359))
OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,30359))
OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,30359))
)
)
AND R.RD_Verified = '1'
AND R.Active = 'true'
AND datascope <> 'PT'
AND (R.expirationdate > 03/28/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
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,30359))
OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,30359))
OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,30359))
)
)
AND R.RD_Verified = '1'
AND R.Active = 'true'
AND datascope <> 'PT'
AND (R.expirationdate > 03/28/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
string
S0001
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: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.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:482)
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
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.'>
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,30359))
OR (len(rtrim(ltrim(rd_office2_zip))) = 5 and rd_office2_zip in (99999999,30359))
OR (len(rtrim(ltrim(rd_office3_zip))) = 5 and rd_office3_zip in (99999999,30359))
)
)
AND R.RD_Verified = '1'
AND R.Active = 'true'
AND datascope <> 'PT'
AND (R.expirationdate > 03/28/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
string
S0001
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: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.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:482)
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
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.'>