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 '://www.jacksonmihomes.com/view.cfm?qt=c,JAAR WHERE MLS = 'jarmi201900272,jarmi20' at line 1
|
|
The error occurred in D:/inetpub/wwwroot/REALTORAssociations/Jackson/view.cfm: line 53
Called from D:/inetpub/wwwroot/REALTORAssociations/Jackson/view.cfm: line 1
Called from D:/inetpub/wwwroot/REALTORAssociations/Jackson/view.cfm: line 1
Called from D:/inetpub/wwwroot/REALTORAssociations/Jackson/view.cfm: line 53
Called from D:/inetpub/wwwroot/REALTORAssociations/Jackson/view.cfm: line 1
Called from D:/inetpub/wwwroot/REALTORAssociations/Jackson/view.cfm: line 1
|
51 : <cfelseif qt is 'c'>
52 : <CFQUERY NAME="GetHomes" DATASOURCE="IDX_COM">
53 : SELECT *,If(#MLS_FieldName# LIKE '#MLS_Office_Identifier#%',1,99) AS Broker_Order FROM #mls_id# WHERE MLS = '#MLS#'
54 : </CFQUERY>
55 : <cfset qttitle = "Commercial property">
|
|
SQLSTATE |
42000 |
DATASOURCE |
IDX_COM |
VENDORERRORCODE |
1064 |
SQL |
SELECT *,If(OfficeName LIKE 'xxxx%',1,99) AS Broker_Order FROM JAAR,https://www.jacksonmihomes.com/view.cfm?qt=c,JAAR WHERE MLS = 'jarmi201900272,jarmi201900272'
|
|
Resources:
|
Browser |
claudebot |
Remote Address |
3.227.229.194 |
Referrer |
http://jacksonmihomes.com/view.cfm?qt=c&mls=jarmi201900272&mls_id=JAAR |
Date/Time |
29-Mar-24 10:44 AM |
|