Error Executing Database Query.
|
|
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY menu_order,type_name' at line 4
|
| |
The error occurred in C:/HostingSpaces/antiques/antiquesandfineart.com/wwwroot/search/indexform8.cfm: line 33
Called from C:/HostingSpaces/antiques/antiquesandfineart.com/wwwroot/search/index.cfm: line 439
Called from C:/HostingSpaces/antiques/antiquesandfineart.com/wwwroot/search/indexform8.cfm: line 33
Called from C:/HostingSpaces/antiques/antiquesandfineart.com/wwwroot/search/index.cfm: line 439
|
31 : SELECT *
32 : FROM inventory_type
33 : WHERE category_id = 0 and date_deleted IS NULL AND date_disabled IS NULL AND parent_id = <cfqueryparam value = "#url.id#" cfsqltype = "cf_sql_integer">;
34 : ORDER BY menu_order,type_name
35 : </cfquery>
|
|
| SQLSTATE |
42000 |
| EXCEPTIONS |
<small><i>not set</i></small> |
| DATASOURCE |
c150026-h221640_cafadb |
| VENDORERRORCODE |
1064 |
| SQL |
SELECT *
FROM inventory_type
WHERE category_id = 0 and date_deleted IS NULL AND date_disabled IS NULL AND parent_id = (param 1) ;
ORDER BY menu_order,type_name |
|
|
Resources:
|
| Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
| Remote Address |
18.216.69.239 |
| Referrer |
|
| Date/Time |
12-May-25 08:19 PM |
|
