Multiple-step operation generated errors. Check each status value

error messsage

[txbakers]

again, this works fine on production, crashes on development.

There are two fields it crashes on in the select statement, both are decimals.

When I cast them to CHAR it works.

Both dev and prod are same OS same version of DB (mysql 5.x).

Any ideas on this one? I'm stumped.

[aspdaddy]

Have you looked at the settings in Regional Options->Numbers?

Whats the actual value when converted to char, anywhere near any upper bounds?