Re: multiple statements error

[John Costantino]

After you've finished with your query, try this while loop. The variable "conn" is your connection.

my_results = conn.query(statement1)
my_results.each do |rr|
. . .
end

while (conn.next_result && conn.more_results?)
conn.store_result
end

. . .

my_results = conn.query(statement2)