Ed Reed wrote:
Thanks for the reply,
So is there anyway to use User Variables with a single connection. All my apps are in VB6 and VBA. They all take a query, open a connection, run query, fill array from query results, close connection and pass back the array. Because of backward compatibility there's no way I can change them to do otherwise.
Thanks again.
If you're limited to a single query per connection, you probably can't make full use of them, but, depending on the query you may be able to do something like:
SELECT @A := 'Test',CONCAT('@A == "',@A,'"')
I'd suggest reading http://dev.mysql.com/doc/mysql/en/variables.html to see what use you can get out of them.
Chris
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]