Afficher un message
Vieux 16/09/2007, 16h06   #1
darkroastbeans
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Irregular stored proc results giving me headaches, please

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!

  Réponse avec citation
 
Page generated in 0,05517 seconds with 9 queries