MySQL returning only 1 row

[Kato]

Greetings,

I'm currently coding a guild system for my NWN PW, storing all persistent data in a custom MySQL database. The guild infos are displayed to players via a dynamic dialog, wich sends many different queries, all working fine, except for this one:

string sSQL = "SELECT DISTINCT tag FROM players WHERE guild='" + IntToString(nGuild) + "'";
SQLExecDirect(sSQL);
while(SQLFetch() == SQL_SUCCESS)
{
AddStringElement(SQLGetData(1), PAGE2C, oPC);
}

The tag field is a VARCHAR64, holding the value returned by GetPCPlayerName(); both the odbc log and the dialog display a single row. So, I have raised the buffer from 8 * 128 to 128 * 128, trying each step on the way(16, 32 etc...). Still, only one row is displayed(!?)

Any help would be greatly appreciated, thanks in advance!!!!!!!!

[MaxRock]

Just for debugging, change AddStringEntry to WriteTimestampedLogEntry; so you can rule out the zdialog scripts.
Put the query into mysql directly (e.g.: mysql query browser) and see if that returns more.
Can you post the odbc log?

[Kato]

Okay. After testing the query in the query browser, it returns the correct answer, just like WriteTimestampedLogEntry, wich appends these lines to nwnx-odbc.txt:

o Got request: SELECT DISTINCT tag FROM players WHERE guild='1'
o Sent response (7 bytes): Rastin1
o Sent response (8 bytes): ZenBlade
o Sent response (7 bytes): Jearld1
o Sent response (8 bytes): Anaknaej
o Sent response (7 bytes): Rashtin
o Sent response (8 bytes): laskoski
o Sent response (14 bytes): Chaos Maverick
o Sent response (0 bytes):

Also, SendMessageToPC(oPC, SQLGetData(1)) returns the correct answer, wich leads me to think that my problem probably comes from my zdialog scripts. I'll be back with the solution when I find it, thank you for your help, MaxRock.

[Kato]

Okay, I have found it. There was another call to SQLFetch() on the call stack. Sorry, I feel dumb...