[fermataintl]

This message has not been recovered.

[Brian Fernandes]

This message has not been recovered.

[fermataintl]

This message has not been recovered.

[Brian Fernandes]

This message has not been recovered.

[fermataintl]

This message has not been recovered.

[Brian Fernandes]

Dean,

tried out the two lines you posted and it received “1” in the SQL results view when I ran the script.

Do you see VarBinary as the first row of your result in the results view or elsewhere?

Brian.

[fermataintl]

Brian,

When I execute the SQL, in the SQL Results/Result 1 tab I see “@ggg” as the heading for the column and “<VarBinary>” as the value underneath it.

Thanks (man, you guys are good!)
Dean

[Brian Fernandes]

Dean,

Thanks!

What I see is @ggg as the column heading and “1” as the value underneath. What version of MySQL 5 (exactly) are you using and are you using the latest driver too? If not can you try using the latest driver?

I have a feeling this may be related to some installation specific defaults. If you are executing this block of code within a procedure for example, maybe you could use a DECLARE statement to explicitly set @ggg to type INT / INTEGER. AFAIK, DECLARE cannot be used in a snippet like yours.

Brian.

[fermataintl]

Brian,

The driver was the issue. Thanks for your patience and rapid response!

Dean

[Brian Fernandes]

Dean,

Great – glad it was as simple as changing the driver.

[Jim Willeke]

This message has not been recovered.

[Brian Fernandes]

This message has not been recovered.

[Author]

Posts