Error Executing Database Query.
|
Unknown column '20desc' in 'order clause'
|
|
The error occurred in D:/home/fordor.com/wwwroot/category.cfm: line 16
|
14 : ON i.category = c.category
15 : WHERE i.category = '#url.cat#' AND i.visible = 1 <cfif isdefined('url.dept')>AND i.department = '#url.dept#'</cfif>
16 : ORDER BY #sort#
17 : </cfquery>
18 :
|
|
SQLSTATE |
42S22 |
EXCEPTIONS |
<small><i>not set</i></small> |
DATASOURCE |
Hh334235Ti |
VENDORERRORCODE |
1054 |
SQL |
SELECT i.*, c.*
FROM items i INNER JOIN categories c
ON i.category = c.category
WHERE i.category = '1926%201927%20Ford%20Model%20T%20Roadster%20and%20Roadster%20Pickup' AND i.visible = 1 AND i.department = '0927modelt'
ORDER BY price%20desc |
|
Resources:
|
Browser |
claudebot |
Remote Address |
23.20.220.59 |
Referrer |
http://fordor.com/category.cfm?dept=0927modelt&cat=1926%25201927%2520Ford%2520Model%2520T%2520Roadster%2520and%2520Roadster%2520Pickup&sort=price%2520desc |
Date/Time |
19-Mar-24 01:04 AM |
|