SELECT * FROM(SELECT RowNumber = ROW_NUMBER() OVER (ORDER BY List_Price DESC),TotalRowCount = Count(OfficeID) OVER(),*,'/assets/img/nophoto/nophoto-offices.jpg' AS ImagePath,'/assets/img/nophoto/nophoto-offices-thumb.jpg' AS ThumbPath,'' AS url,'' AS LogoPath,'' AS LogoPathSmall,'/assets/img/nophoto/nophoto-agents.jpg' AS ManagerImagePath,'/assets/img/nophoto/nophoto-agents-thumb.jpg' AS ManagerThumbPath,'' AS ManagerName,'' AS ManagerPhone,'' AS ManagerCell,'/assets/img/nophoto/nophoto-agents.jpg' AS SecondManagerImagePath,'/assets/img/nophoto/nophoto-agents-thumb.jpg' AS SecondManagerThumbPath,'' AS SecondManagerName,'' AS SecondManagerPhone,'' AS SecondManagerCell,(SELECT COUNT(PublicID)FROM AGENTS WITH (NOLOCK)WHERE Website = 'T'AND OfficeID IN ('CBRG18','CBRG25','CBRG23','CBRG03','CBRG05','CBRG02','CBRG09','CBRG04','CBRG12','CBRG13','CBRG08','CBRG07','CBRG24')AND Status = 'A') AS AgentCountFROM Offices WITH (NOLOCK)WHERE Website = 'T'AND OfficeID IN ('CBRG18','CBRG25','CBRG23','CBRG03','CBRG05','CBRG02','CBRG09','CBRG04','CBRG12','CBRG13','CBRG08','CBRG07','CBRG24')) rsDataWHERE rsData.RowNumber BETWEEN 169 AND 192

DatabaseName

string

Microsoft SQL Server

DatabaseVersion

string

12.00.2000

DriverName

string

Microsoft JDBC Driver 4.0 for SQL Server

DriverVersion

string

4.0.2206.100

Datasource

string

iq_cb_select

DataSource

string

iq_cb_select

Detail

string

Invalid column name 'List_Price'.

ErrorCode

string

0

Extended_Info

string

ExtendedInfo

string

Message

string

NativeErrorCode

number

207

queryError

string

SELECT * FROM(SELECT RowNumber = ROW_NUMBER() OVER (ORDER BY List_Price DESC),TotalRowCount = Count(OfficeID) OVER(),*,'/assets/img/nophoto/nophoto-offices.jpg' AS ImagePath,'/assets/img/nophoto/nophoto-offices-thumb.jpg' AS ThumbPath,'' AS url,'' AS LogoPath,'' AS LogoPathSmall,'/assets/img/nophoto/nophoto-agents.jpg' AS ManagerImagePath,'/assets/img/nophoto/nophoto-agents-thumb.jpg' AS ManagerThumbPath,'' AS ManagerName,'' AS ManagerPhone,'' AS ManagerCell,'/assets/img/nophoto/nophoto-agents.jpg' AS SecondManagerImagePath,'/assets/img/nophoto/nophoto-agents-thumb.jpg' AS SecondManagerThumbPath,'' AS SecondManagerName,'' AS SecondManagerPhone,'' AS SecondManagerCell,(SELECT COUNT(PublicID)FROM AGENTS WITH (NOLOCK)WHERE Website = 'T'AND OfficeID IN ('CBRG18','CBRG25','CBRG23','CBRG03','CBRG05','CBRG02','CBRG09','CBRG04','CBRG12','CBRG13','CBRG08','CBRG07','CBRG24')AND Status = 'A') AS AgentCountFROM Offices WITH (NOLOCK)WHERE Website = 'T'AND OfficeID IN ('CBRG18','CBRG25','CBRG23','CBRG03','CBRG05','CBRG02','CBRG09','CBRG04','CBRG12','CBRG13','CBRG08','CBRG07','CBRG24')) rsDataWHERE rsData.RowNumber BETWEEN 169 AND 192

Sql

string

SELECT * FROM(SELECT RowNumber = ROW_NUMBER() OVER (ORDER BY List_Price DESC),TotalRowCount = Count(OfficeID) OVER(),*,'/assets/img/nophoto/nophoto-offices.jpg' AS ImagePath,'/assets/img/nophoto/nophoto-offices-thumb.jpg' AS ThumbPath,'' AS url,'' AS LogoPath,'' AS LogoPathSmall,'/assets/img/nophoto/nophoto-agents.jpg' AS ManagerImagePath,'/assets/img/nophoto/nophoto-agents-thumb.jpg' AS ManagerThumbPath,'' AS ManagerName,'' AS ManagerPhone,'' AS ManagerCell,'/assets/img/nophoto/nophoto-agents.jpg' AS SecondManagerImagePath,'/assets/img/nophoto/nophoto-agents-thumb.jpg' AS SecondManagerThumbPath,'' AS SecondManagerName,'' AS SecondManagerPhone,'' AS SecondManagerCell,(SELECT COUNT(PublicID)FROM AGENTS WITH (NOLOCK)WHERE Website = 'T'AND OfficeID IN ('CBRG18','CBRG25','CBRG23','CBRG03','CBRG05','CBRG02','CBRG09','CBRG04','CBRG12','CBRG13','CBRG08','CBRG07','CBRG24')AND Status = 'A') AS AgentCountFROM Offices WITH (NOLOCK)WHERE Website = 'T'AND OfficeID IN ('CBRG18','CBRG25','CBRG23','CBRG03','CBRG05','CBRG02','CBRG09','CBRG04','CBRG12','CBRG13','CBRG08','CBRG07','CBRG24')) rsDataWHERE rsData.RowNumber BETWEEN 169 AND 192