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 
 
SQLGetData() problem

 
Post new topic   Reply to topic    nwnx.org Forum Index -> Database related
View previous topic :: View next topic  
Author Message
Epitaffio



Joined: 13 Jul 2010
Posts: 29
Location: Italy

PostPosted: Fri May 27, 2011 15:56    Post subject: SQLGetData() problem Reply with quote

Hi all, i have a problem/question with the SQLGetData function.

First of all, my server is an ubuntu 9.04 32bit (need to upgrade) and i use MySQL as database engine. For the odbc connect, i use the .so downloaded here: http://nwn.virusman.ru/trac/nwnx2-linux/downloader
The script included for the database functions is the aps_include (in the script there is a comment: "Modified : February 16, 2003")


I have a table named "personaggi" with 11 columns, the last one is a column named "login". I do this:

Code:

    string sSQL = "SELECT Login FROM personaggi WHERE ID = "+sPcID;
    SQLExecDirect(sSQL);
    sPcLogin = SQLGetData(1);


sPcLogin will return as result the first column of the table personaggi, if i use SQLGetData(11), it will result the right column value .-.


I think it's an issue with the aps_include, what do you think about it?
Back to top
View user's profile Send private message
Epitaffio



Joined: 13 Jul 2010
Posts: 29
Location: Italy

PostPosted: Sat May 28, 2011 13:15    Post subject: Reply with quote

nevermind, fixed by myself Embarassed
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> Database related 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