<div>
&gt; Using &lt;cfqueryparam&gt; &nbsp;<br />
.. &nbsp; &nbsp;_instead_
</div>


> Using <cfqueryparam>  
..    _instead_

<div>
_agx_<br />
<br />
Great thinking with the cfqueryparam, I forgot all about that. It didn't work though, same results.<br />
#PreserveSingleQuotes(sort<wbr />by)# worked though.<br />
<br />
Thank you!<br />

</div>


_agx_

Great thinking with the cfqueryparam, I forgot all about that. It didn't work though, same results.
#PreserveSingleQuotes(sortby)# worked though.

Thank you!


<div>
<div class="content wysiwyg-content">
I am trying to create a sortable query, but get this error message.<br />
ODBC Error Code = 37000 (Syntax error or access violation)<br />
<br />
&lt;cfset sortby =&quot;CASE WHEN (photo1 &lt;&gt;&nbsp;'0' AND Photo1Auth &lt;&gt;&nbsp;1) OR (photo2 &lt;&gt;&nbsp;'0' AND Photo2Auth &lt;&gt;&nbsp;1) OR (photo3 &lt;&gt;&nbsp;'0' AND Photo3Auth &lt;&gt;&nbsp;1) OR (photo4 &lt;&gt;&nbsp;'0' AND Photo4Auth &lt;&gt;&nbsp;1) OR (photo5 &lt;&gt;&nbsp;'0' AND Photo5Auth &lt;&gt;&nbsp;1) THEN 1 ELSE 0 END DESC&quot;&gt;<br />
<br />
SELECT *<br />
FROM table<br />
ORDER BY #sortby#<br />
<br />
If I hardcode it, it works fine<br />
<br />
SELECT *<br />
FROM table<br />
ORDER BY CASE WHEN (photo1 &lt;&gt;&nbsp;'0' AND Photo1Auth &lt;&gt;&nbsp;1) OR (photo2 &lt;&gt;&nbsp;'0' AND Photo2Auth &lt;&gt;&nbsp;1) OR (photo3 &lt;&gt;&nbsp;'0' AND Photo3Auth &lt;&gt;&nbsp;1) OR (photo4 &lt;&gt;&nbsp;'0' AND Photo4Auth &lt;&gt;&nbsp;1) OR (photo5 &lt;&gt;&nbsp;'0' AND Photo5Auth &lt;&gt;&nbsp;1) THEN 1 ELSE 0 END DESC<br />
<br />
Any ideas??
</div>
</div>


I am trying to create a sortable query, but get this error message.
ODBC Error Code = 37000 (Syntax error or access violation)

<cfset sortby ="CASE WHEN (photo1 <> '0' AND Photo1Auth <> 1) OR (photo2 <> '0' AND Photo2Auth <> 1) OR (photo3 <> '0' AND Photo3Auth <> 1) OR (photo4 <> '0' AND Photo4Auth <> 1) OR (photo5 <> '0' AND Photo5Auth <> 1) THEN 1 ELSE 0 END DESC">

SELECT *
FROM table
ORDER BY #sortby#

If I hardcode it, it works fine

SELECT *
FROM table
ORDER BY CASE WHEN (photo1 <> '0' AND Photo1Auth <> 1) OR (photo2 <> '0' AND Photo2Auth <> 1) OR (photo3 <> '0' AND Photo3Auth <> 1) OR (photo4 <> '0' AND Photo4Auth <> 1) OR (photo5 <> '0' AND Photo5Auth <> 1) THEN 1 ELSE 0 END DESC

Any ideas??

Dynamic Sort

A web server refers to the software that helps to deliver web content that can be accessed either through the Internet or through an intranet. The primary function of a web server is to store, process and deliver web pages to clients. The communication between client and server takes place using the Hypertext Transfer Protocol (HTTP). The most common use of web servers is to host websites, but there are other uses such as gaming, data storage, running enterprise applications, handling email, FTP, etc.