MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Re: Stored Procedure with a "ORDER BY" parameter
Posted by: Roland Bouman
Date: November 09, 2005 04:20PM

Whooops! I made a very annoying mistake there. Ironic how you try to explain something and run into the same trap. Sorry for the confusion.

The snippet should be like this :

set @stmt_text := concat('select tabletype from audit order by ',sorder);

get it? No parameters, just build the statement text dynamically. (And beware for sql injection)

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Stored Procedure with a "ORDER BY" parameter
3675
Martin Beaudet
November 08, 2005 07:59PM
Re: Stored Procedure with a "ORDER BY" parameter
2867
Per-Erik Martin
November 09, 2005 02:37AM
Re: Stored Procedure with a "ORDER BY" parameter
3215
Roland Bouman
November 09, 2005 02:49AM
Re: Stored Procedure with a "ORDER BY" parameter
2674
Martin Beaudet
November 09, 2005 09:40AM
Re: Stored Procedure with a "ORDER BY" parameter
3122
peter.hamilton-scott
November 09, 2005 04:07PM
Re: Stored Procedure with a "ORDER BY" parameter
2723
Roland Bouman
November 09, 2005 04:20PM
Re: Stored Procedure with a "ORDER BY" parameter
2886
peter.hamilton-scott
November 09, 2005 04:33PM
Re: Stored Procedure with a "ORDER BY" parameter
8007
Roland Bouman
November 09, 2005 05:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.