logo logo

 Back to main page

The NWNX Community Forum

 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
SQLEncodeSpecialChars: what am I missing?

 
Post new topic   Reply to topic    nwnx.org Forum Index -> Development
View previous topic :: View next topic  
Author Message
Dracos



Joined: 16 Oct 2006
Posts: 21

PostPosted: Wed Dec 06, 2006 12:40    Post subject: SQLEncodeSpecialChars: what am I missing? Reply with quote

! 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?????
Back to top
View user's profile Send private message MSN Messenger
Dracos



Joined: 16 Oct 2006
Posts: 21

PostPosted: Wed Dec 06, 2006 13:03    Post subject: Reply with quote

False Alarm, I reinstalled nwnx4 and everything's ok!!!! Laughing
Back to top
View user's profile Send private message MSN Messenger
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> Development All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group