Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]The data types float and int are incompatible in the modulo operator.
|
|
The error occurred in C:/Websites/nnnsales.com/newusers/properties.cfm: line 476
Called from C:/Websites/nnnsales.com/newusers/properties.cfm: line 1
Called from C:/Websites/nnnsales.com/newusers/properties.cfm: line 476
Called from C:/Websites/nnnsales.com/newusers/properties.cfm: line 1
|
474 : </CFIF>
475 :
476 : ORDER BY #session.so#
477 : </CFQUERY>
478 :
|
|
SQLSTATE |
HY000 |
DATASOURCE |
IP01 |
VENDORERRORCODE |
402 |
SQL |
SELECT *
FROM properties p, propfiles f WHERE
p.id=f.id AND
(
propertystatus='Available' OR
propertystatus='Under L.O.I.' OR
propertystatus='Under Contract' OR
propertystatus='Back-Up Offers Accepted'
)
AND
(tenantname<>'Blank' and tenantname<>'No Tenant' and tenantname is not null AND tenantname<>' ')
AND
displayonsites LIKE '%100003%'
ORDER BY saleprice%20desc |
|
Resources:
|
Browser |
claudebot |
Remote Address |
44.202.128.177 |
Referrer |
http://www.nnnsales.com/newusers/properties.cfm?so=saleprice%2520desc |
Date/Time |
28-Mar-24 03:49 AM |
|