Error Executing Database Query.
|
Table 'idx.id' doesn't exist
|
|
The error occurred in C:\inetpub\wwwroot\MapRealty\view.cfm: line 3
Called from C:\inetpub\wwwroot\MapRealty\view.cfm: line 1
Called from C:\inetpub\wwwroot\MapRealty\query_redirect.cfm: line 12
Called from C:\inetpub\wwwroot\MapRealty\view.cfm: line 3
Called from C:\inetpub\wwwroot\MapRealty\view.cfm: line 1
Called from C:\inetpub\wwwroot\MapRealty\query_redirect.cfm: line 12
|
1 : <CFQUERY NAME="GetHomes" DATASOURCE="IDX">
2 : SELECT *,If(#MLS_FieldName# LIKE '#MLS_Office_Identifier#%',1,99) AS Broker_Order
3 : FROM #mls_id#homes WHERE MLS = '#MLS#'
4 : </CFQUERY>
5 :
|
|
SQL |
SELECT *,If(officeID LIKE 'F0710%',1,99) AS Broker_Order
FROM id=ECARhomes WHERE MLS = 'tell'
|
DATASOURCE |
IDX |
VENDORERRORCODE |
1146 |
SQLSTATE |
42S02 |
|
Resources:
|
Browser |
claudebot |
Remote Address |
3.81.144.39 |
Referrer |
|
Date/Time |
29-Mar-24 01:46 AM |
|