Error Executing Database Query.
|
Table 'idx.realcomphomes' doesn't exist
|
|
The error occurred in D:/inetpub/wwwroot/Websites/Brokers/AmericanAssociates/pop_results_action.cfm: line 4
|
2 : <cfif qt is 'h'>
3 : <CFQUERY NAME="GetHomes" DATASOURCE="IDX">
4 : SELECT *,If(#MLS_FieldName# LIKE '#MLS_Office_Identifier#%',1,99) AS Broker_Order FROM #mls_id#homes WHERE MLS = '#MLS#'
5 : </CFQUERY>
6 : <cfelseif qt is 'l'>
|
|
SQLSTATE |
42S02 |
DATASOURCE |
IDX |
VENDORERRORCODE |
1146 |
SQL |
SELECT *,If(officeID LIKE '399499,399501,373446,349839%',1,99) AS Broker_Order FROM realcomphomes WHERE MLS = '5030037826'
|
|
Resources:
|
Browser |
claudebot |
Remote Address |
54.91.19.62 |
Referrer |
|
Date/Time |
29-Mar-24 11:00 AM |
|