Unix Technical Forum

Irregular stored proc results giving me headaches, please help

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 ...


Go Back   Unix Technical Forum > Database Server Software > MySQL

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 10:27 AM
darkroastbeans
 
Posts: n/a
Default Irregular stored proc results giving me headaches, please help

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!

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-28-2008, 10:27 AM
darkroastbeans
 
Posts: n/a
Default Re: Irregular stored proc results giving me headaches, please help

What makes this even more puzzling is that if I execute the query
outside of the proc, with hard-coded values, it works fine.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 06:26 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com