can't cfqueryparam order by?

I'm letting users filter by specific columns, including ORDER BY... So I naturally cfqueryparam'd it and got this error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]The SELECT item identified by the ORDER BY number 1 contains a variable as part of the

Re: can't cfqueryparam order by?

Also, here's my form select if that helps. select name=order onChange=this.form.submit() option value=musicprodnamecfif order EQ musicprodname selected/cfifTitle/option option value=musicproddateaddedcfif order EQ musicproddateadded selected/cfifNewly listed/option option

Re: can't cfqueryparam order by?

Will, cfqueryparram is for PARAMETERS, not field names. Thus param in cfqueryparam You'll pretty much just need to manually verify that the value of the variable is appropriate for where you're using it. Rick ~| Macromedia

RE: can't cfqueryparam order by?

] Sent: Sunday, March 04, 2007 10:25 AM To: CF-Talk Subject: can't cfqueryparam order by? I'm letting users filter by specific columns, including ORDER BY... So I naturally cfqueryparam'd it and got this error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer

Re: can't cfqueryparam order by?

10 - 4! Thanks, Will ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIA’s for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: