This is a discussion on Irregular stored proc results giving me headaches, please help within the MySQL forums, part of the Database Server Software category; --> Hey folks, I'm having a really weird problem -- I've written a stored procedure to give me aggregated results ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hey folks, I'm having a really weird problem -- I've written a stored procedure to give me aggregated results from a table and pair that with data from another table -- what's weird is that when I execute the proc in Toad or MySQL Query Browser, the results come out fine, but when I execute the proc in SQLyog, or from a PHP script, the results come out with some weird numbers. Here is the proc - http://pastebin.com/d5e3d24ab Here are the *expected* results (come back fine in Toad and MySQL Query Browser) - http://pastebin.com/d4babe393 Here is what I'm getting in SQLYog and my PHP script - http://pastebin.com/d4847f26a Notice the 544 values -- that's what's throwing me off. Any insight would be MOST welcome! |