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= 'Neighborhood'' at line 1
|
|
The error occurred in C:\inetpub\wwwroot\AmericanAssociates\neighborhoods.cfm: line 7
Called from C:\inetpub\wwwroot\AmericanAssociates\query_redirect.cfm: line 36
Called from C:\inetpub\wwwroot\AmericanAssociates\neighborhoods.cfm: line 7
Called from C:\inetpub\wwwroot\AmericanAssociates\query_redirect.cfm: line 36
|
5 : </CFQUERY>
6 : <cfquery name="Getfiles" datasource="REOL_files">
7 : select FileName,FileTitle from CommunityFiles where memberID = 1000#BrokersSiteID# AND pageid = #pageinfo.pageid# AND pagetype= 'Neighborhood'
8 : </cfquery>
9 : <cfquery name="Getphotos" datasource="REOL_files">
|
|
SQL |
select FileName,FileTitle from CommunityFiles where memberID = 10001 AND pageid = AND pagetype= 'Neighborhood'
|
DATASOURCE |
REOL_files |
VENDORERRORCODE |
1064 |
SQLSTATE |
42000 |
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
3.147.54.6 |
Referrer |
|
Date/Time |
28-Apr-24 08:19 AM |
|