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 'AND pagetype <> 'photo'' at line 1
|
|
The error occurred in D:/inetpub/wwwroot/Websites/Brokers/TwoDoorsRealty/neighborhoods.cfm: line 7
Called from D:/inetpub/wwwroot/Websites/Brokers/TwoDoorsRealty/query_redirect.cfm: line 40
Called from D:/inetpub/wwwroot/Websites/Brokers/TwoDoorsRealty/neighborhoods.cfm: line 7
Called from D:/inetpub/wwwroot/Websites/Brokers/TwoDoorsRealty/query_redirect.cfm: line 40
|
5 : </cfquery>
6 : <cfquery name="Getfiles" datasource="REOL_files">
7 : select FileName,FileTitle from CommunityFiles where (Memberid = 1000#BrokersSiteID# OR Memberid = #SiteID#) AND pageid = #pageinfo.pageid# AND pagetype <> 'photo'
8 : </cfquery>
9 :
|
|
SQLSTATE |
42000 |
DATASOURCE |
REOL_files |
VENDORERRORCODE |
1064 |
SQL |
select FileName,FileTitle from CommunityFiles where (Memberid = 1000171 OR Memberid = 850) AND pageid = AND pagetype <> 'photo'
|
|
Resources:
|
Browser |
claudebot |
Remote Address |
35.153.170.189 |
Referrer |
http://www.franklinmeadows.com/listing?address=4899-BROOKSIDE-LN-Washington-MI-48094&mlsno=216042181&info=info&idx=1434898619 |
Date/Time |
29-Mar-24 07:22 AM |
|