Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 07001 (Wrong number of parameters)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 5.
Hint: The cause of this error is usually that your query contains a reference to a field which does not exist. You should verify that the fields included in your query exist and that you have specified their names correctly.
SQL = "select window.ID, window.UFactor, window.SHGC, window.VT, window.frame, window.pic, glass.descr, glass.id as glassid FROM glass, window INNER JOIN city_window ON window.ID = city_window.window_id where glass.ID = window.glass and prodtype = 'WN' and city_window.city_id = 30 and city_window.new = 'E' order by heat+cool, window.ID"
Data Source = "EFFICIENT-WINDOWSORG_DEMO"
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (65:1) to (65:43) in the template file C:\INETPUB\WWWROOT\EFFICIENTWINDOWS\HTML\LIST_WINDOWS2.CFM.
Date/Time: 03/08/14 00:03:06