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/Application.cfm: line 577
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 372
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 298
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 240
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 231
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 169
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 1
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 577
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 372
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 298
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 240
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 231
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 169
Called from C:/home/ilovecomm.com/wwwroot/Application.cfm: line 1
|
575 :
576 :
577 : <cfquery name="test_pagination" datasource="#app_datasource#">
578 : SELECT idoffer,shops.lat, shops.lng, offer
579 : FROM offers
|
|
SQLSTATE |
HY000 |
DATASOURCE |
ilovecomm |
VENDORERRORCODE |
174 |
SQL |
SELECT idoffer,shops.lat, shops.lng, offer
FROM offers
INNER JOIN shops ON offers.shoppnt = shops.idshop
WHERE offers.enable <> 0
AND shops.enable <> 0
AND offers.categorypnt is not null
AND offers.keyword_pnt is not null
AND ROUND(6363 * sqrt(POWER(RADIANS() - RADIANS(shops.lat) , 2) + POWER(RADIANS() - RADIANS(shops.lng) , 2)),2)<40
|
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
3.141.46.110 |
Referrer |
|
Date/Time |
18-Apr-25 01:42 PM |
|