Dracos
Joined: 16 Oct 2006 Posts: 21
|
Posted: Wed Dec 06, 2006 12:40 Post subject: SQLEncodeSpecialChars: what am I missing? |
|
|
! Execute / mysql_query: Data too long for column 'gamespy' at row 1.
I get that error (100 or so rows repeated) in the 1.06 nwnx4 version when I call this query:
SQL="SELECT id_account, nomepg, cognomepg, location, puntiferita, statoaccount, primavolta, server, oro, goto FROM account WHERE nomepg='"+SQLEncodeSpecialChars(GetFirstName(oPC))+"' AND cognomepg = '"+SQLEncodeSpecialChars(GetLastName(oPC))+"' AND gamespy= '"+SQLEncodeSpecialChars(GetPCPlayerName(oPC))+"'";
SQLExecDirect(SQL);
if (SQLFetch() == SQL_ERROR)
{
SQL ="INSERT INTO account (gamespy, nomepg, cognomepg, background, iscritto) VALUES ('"+SQLEncodeSpecialChars(GetPCPlayerName(oPC))+"', '"+SQLEncodeSpecialChars(GetFirstName(oPC))+"', '"+SQLEncodeSpecialChars(GetLastName(oPC))+"', 'no bg', NOW())";
SQLExecDirect(SQL);
}
what happened????? |
|