Error Executing Database Query.
|
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '24861-our-agents.html WHERE MLS = 'p'' at line 1
|
|
The error occurred in D:/inetpub/wwwroot/Websites/Brokers/BayAreaRealEstate/view.cfm: line 35
Called from D:/inetpub/wwwroot/Websites/Brokers/BayAreaRealEstate/view.cfm: line 1
Called from D:/inetpub/wwwroot/Websites/Brokers/BayAreaRealEstate/view.cfm: line 1
Called from D:/inetpub/wwwroot/Websites/Brokers/BayAreaRealEstate/query_redirect.cfm: line 11
Called from D:/inetpub/wwwroot/Websites/Brokers/BayAreaRealEstate/view.cfm: line 35
Called from D:/inetpub/wwwroot/Websites/Brokers/BayAreaRealEstate/view.cfm: line 1
Called from D:/inetpub/wwwroot/Websites/Brokers/BayAreaRealEstate/view.cfm: line 1
Called from D:/inetpub/wwwroot/Websites/Brokers/BayAreaRealEstate/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">
|
|
SQLSTATE |
42000 |
DATASOURCE |
IDX_MULTIPLE |
VENDORERRORCODE |
1064 |
SQL |
SELECT *,If(officeID LIKE '30028%',1,99) AS Broker_Order FROM 24861-our-agents.html WHERE MLS = 'p'
|
|
Resources:
|
Browser |
claudebot |
Remote Address |
44.210.120.182 |
Referrer |
|
Date/Time |
29-Mar-24 12:01 PM |
|