Error Executing Database Query.
|
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'price'.
|
| |
The error occurred in G:\data\devonhillbmw\clearance\index.cfm: line 37
Called from G:\data\devonhillbmw\clearance\index.cfm: line 1
Called from G:\data\devonhillbmw\clearance\index.cfm: line 37
Called from G:\data\devonhillbmw\clearance\index.cfm: line 1
|
35 : <cfif SpecialList is not "">AND Vin IN (#PreserveSingleQuotes(SpecialList)#)</cfif>
36 : <cfif SpecialList is "">and datefirstseen < '#dateset2#'</cfif>
37 : order by price #GetSitePreferences.clearanceSpecialsOrderby#, year, make, model
38 : </CFQUERY>
39 :
|
|
| SQL |
SELECT *
FROM tbl_preowned
WHERE vin <> ''
and dealer IN ('devonhill')
and datefirstseen < '05/04/08'
order by price asc, year, make, model
|
| DATASOURCE |
devonhill |
| VENDORERRORCODE |
207 |
| SQLSTATE |
42S22 |
|
|
Please try the following:
|