Can CrushFTP use stored procedures instead of parameterized queries?
started a topic
over 3 years ago
codewzrd @ Fri May 23 11:14:24 EEST 2014 Hi,
Our company prefers that all queries to databases via applications be done by using stored procedures.
I updated the user queries by wrapping them in stored procedures and making the change to EXEC those stored procs. But I see in the logs that for some of them, an ORDER BY clause is being appended to certain queries like when trying to get web buttons. I have EXEC spCrushGetWebButtonsByUserID '1' which works but the log shows 05/23/2014 11:56:44 AM|SQL:Querying WEB_BUTTONS:EXEC spCrushGetWebButtonsByUserID '1' ORDER BY SORT_ORDER 05/23/2014 11:56:44 AM|crushadmin:(972)-0.0.0.0 (control) 05/23/2014 11:56:44 AM|com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'ORDER'.