Hi Roland,
I just read your post reagrding the variables with & without @.
http://forums.mysql.com/read.php?98,62373,62512#msg-62512
Then I tried to change the user variables to local variables, but got one error from the line: PREPARE STMT FROM Sql;
From:
http://dev.mysql.com/doc/refman/5.0/en/sqlps.html
> preparable_stmt is either a string literal or a user variable that contains the text of the statement
I just read that it has to be either a String 'SELECT XXX' Or a user variable. I think I shouldn't use user variables, because many concurrent connections(same user) are excuting the same SP from my web application. How do I handle this issue?
Any problem with synchronization when many connections(the same user) accessing the same @variable?
Thanks,
Ming
Edited 2 time(s). Last edit at 01/10/2006 12:37AM by Ming Yeung.