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
