MySQL query oddity between 2 OS's
Please allow me to preface this post with an apology. I'm not sure where the below issue is derived from, (the difference in operating systems, a MySQL problem, a C problem, etc...), so if this post is in the wrong topic, again, my apologies.
System Setup 1:
Microsoft Windows XP Professional, SP3, 32 bit.
System Setup 2:
Microsoft Windows Server 2008 Web Edition, SP3, 32 bit.
Everything on System Setup 2 is identical to System Setup 1 except for the operating system.
On the System Setup 1, the following C code has been working flawlessly. In other words, "bot", "top", "ls", and "rm" all populate with the correct data.
MYSQL_RES *My_result = NULL;
int bot, top, ls, rm;
snprintf(szQueryText, sizeof(szQueryText), "SELECT roomRangeFrom, roomRangeTo, lifespan, resetMode FROM zData WHERE zone= 10");
My_result = MySQL__query(szQueryText);
if (my.Query(szQueryText) > 0)
bot = atoi(my.GetData("roomRangeFrom"));
top = atoi(my.GetData("roomRangeTo"));
ls = atoi(my.GetData("lifespan"));
rm = atoi(my.GetData("resetMode"));
However, on System Setup 2, ONLY "bot" populates with the correct data.
Let's assume that the database holds the following values for each of the above mentioned variables:
On System Setup 1, the code would produce:
However, on System Setup 2, the code would produce:
Conclusion: I'm completely baffled as to what's going on here. Is it an operating system issue? A MySQL issue? Something else? Any insight to this hair-pulling circumstance would be greatly appreciated.