Error Executing Database Query.
|
Table 'arrow.gifhomes' 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 arrow.gifhomes WHERE MLS = 'db'
|
DATASOURCE |
IDX |
VENDORERRORCODE |
1146 |
SQLSTATE |
42S02 |
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
3.12.71.146 |
Referrer |
|
Date/Time |
05-May-24 11:18 PM |
|