Hello.
Very often PREPARED STATEMENTS are helpful in similar situations. For a pity, they are disabled in the current release. See: http://dev.mysql.com/doc/mysql/en/sqlps.html Leonardo Javier Belén wrote: > Hi all, > I am wondering if I can construct a query string inside a stored > procedure and then execute it. I mean, what I want to do is given a set of > IN parameters, be able to construct a huge where statement out of them an > then complete the query string to execute. Is that possible? because if that > is possible I could be able to abstract all the data logic from the program > itself. > > I've been googling and reading books and references without success so > far, but I think the functionality should be there, what I dont know is how > to use it. > > Thanks in advance. > > sql - query - mysql > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
