I'm having problems getting multiple statements that need to be executed as
one thread (for user variables) through via the ODBC interface (Syntax Error
near ";SELECT" on line 1) . This works directly from mysql but not through
other tools (they don't seem to accept the `;' to end one statement as per
the documentation).
Can someone assist ?
Jon Jenkins
Simplistic example:
SELECT @var:=0;
SELECT * FROM inv
WHERE invno = @var
OR (@var = 0 AND stat <2);
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
