MySQL Forums
Forum List  »  Stored Procedures

Re: My error or bug ?
Posted by: Federico Giampietro
Date: June 23, 2005 07:47AM

Hello Andrew,

modified this line because your code was wrong (syntax error):

SET @stmt_expr = CONCAT('select valore from ', ptabella ,' where broker = ', pbroker, ' and nome =', pnome);

but I get a strange result:

1054-Unknown column CARGILL in 'where clause'.

Maybe MySQL dont see "where broker =" ?

Many thanks, Fede

Options: ReplyQuote


Subject
Views
Written By
Posted
2828
June 23, 2005 06:11AM
2008
June 23, 2005 07:15AM
Re: My error or bug ?
1895
June 23, 2005 07:47AM
1914
June 23, 2005 08:26AM


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.