Error Executing Database Query.
|
Table 'tips.cfm' doesn't exist
|
|
The error occurred in C:\inetpub\wwwroot\BurrellRealEstate\view.cfm: line 35
Called from C:\inetpub\wwwroot\BurrellRealEstate\view.cfm: line 1
Called from C:\inetpub\wwwroot\BurrellRealEstate\view.cfm: line 1
Called from C:\inetpub\wwwroot\BurrellRealEstate\query_redirect.cfm: line 11
Called from C:\inetpub\wwwroot\BurrellRealEstate\view.cfm: line 35
Called from C:\inetpub\wwwroot\BurrellRealEstate\view.cfm: line 1
Called from C:\inetpub\wwwroot\BurrellRealEstate\view.cfm: line 1
Called from C:\inetpub\wwwroot\BurrellRealEstate\query_redirect.cfm: line 11
|
33 : <cfelse>
34 : <CFQUERY NAME="GetHomes" DATASOURCE="IDX_MULTIPLE">
35 : SELECT *,If(#MLS_FieldName# LIKE '#MLS_Office_Identifier#%',1,99) AS Broker_Order FROM #mls_id# WHERE MLS = '#MLS#'
36 : </CFQUERY>
37 : <cfset qttitle = "Multi-family for sale">
|
|
SQL |
SELECT *,If(agentID LIKE 'F234905%',1,99) AS Broker_Order FROM tips.cfm WHERE MLS = 'improvement'
|
DATASOURCE |
IDX_MULTIPLE |
VENDORERRORCODE |
1146 |
SQLSTATE |
42S02 |
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
18.221.18.145 |
Referrer |
|
Date/Time |
31-Oct-24 08:00 PM |
|