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 'order by lpos desc' at line 3
|
|
The error occurred in D:/inetpub/wwwroot/mondotoys.com/products_info.cfm: line 46
Called from D:/inetpub/wwwroot/mondotoys.com/products_info.cfm: line 2
Called from D:/inetpub/wwwroot/mondotoys.com/products_info.cfm: line 1
Called from D:/inetpub/wwwroot/mondotoys.com/application.cfc: line 184
Called from D:/inetpub/wwwroot/mondotoys.com/application.cfc: line 353
Called from D:/inetpub/wwwroot/mondotoys.com/products_info.cfm: line 46
Called from D:/inetpub/wwwroot/mondotoys.com/products_info.cfm: line 2
Called from D:/inetpub/wwwroot/mondotoys.com/products_info.cfm: line 1
Called from D:/inetpub/wwwroot/mondotoys.com/application.cfc: line 184
Called from D:/inetpub/wwwroot/mondotoys.com/application.cfc: line 353
|
44 : <cfquery name="q_root" datasource="webmondo">
45 : select * from v_struttura_albero
46 : where depth = 3 and lpos < #q_canali.lpos#
47 : order by lpos desc
48 : </cfquery>
|
|
SQLSTATE |
42000 |
DATASOURCE |
webmondo |
VENDORERRORCODE |
1064 |
SQL |
select * from v_struttura_albero
where depth = 3 and lpos <
order by lpos desc
|
|
Resources:
|
Browser |
CCBot/2.0 (https://commoncrawl.org/faq/) |
Remote Address |
35.172.223.251 |
Referrer |
|
Date/Time |
12-Aug-22 08:21 PM |
|