Error Executing Database Query.
|
|
[Macromedia][SQLServer JDBC Driver][SQLServer]The radians function requires 1 argument(s).
|
| |
The error occurred in C:/home/ilovecomm.com/wwwroot/_search_products.cfm: line 45
Called from C:/home/ilovecomm.com/wwwroot/_search_products.cfm: line 4
Called from C:/home/ilovecomm.com/wwwroot/_search_products.cfm: line 1
Called from C:/home/ilovecomm.com/wwwroot/index.cfm: line 600
Called from C:/home/ilovecomm.com/wwwroot/index.cfm: line 1
Called from C:/home/ilovecomm.com/wwwroot/_search_products.cfm: line 45
Called from C:/home/ilovecomm.com/wwwroot/_search_products.cfm: line 4
Called from C:/home/ilovecomm.com/wwwroot/_search_products.cfm: line 1
Called from C:/home/ilovecomm.com/wwwroot/index.cfm: line 600
Called from C:/home/ilovecomm.com/wwwroot/index.cfm: line 1
|
43 : select idshop
44 : from shops
45 : where ROUND(6363 * sqrt(POWER(RADIANS(#session.box.Lat#) - RADIANS(shops.lat) , 2) + POWER(RADIANS(#session.box.Lng#) - RADIANS(shops.lng) , 2)),2) < #zoneonedist#
46 : </cfquery>
47 : <!---recupero setting fascia 1 search_shops_max_radius--->
|
|
| SQLSTATE |
HY000 |
| DATASOURCE |
ilovecomm |
| VENDORERRORCODE |
174 |
| SQL |
select idshop
from shops
where ROUND(6363 * sqrt(POWER(RADIANS() - RADIANS(shops.lat) , 2) + POWER(RADIANS() - RADIANS(shops.lng) , 2)),2) <2 |
|
|
Resources:
|
| Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
| Remote Address |
216.73.216.223 |
| Referrer |
|
| Date/Time |
15-Dec-25 11:18 PM |
|