hi,
in sqlite3 u r having a function named callback whose third argument is used
to save the
value of a column. u can store that value in an array or in char vairiable
also.
try this
regards
Nishit
On 9/5/07, "Severin Müller" <[EMAIL PROTECTED]> wrote:
>
> Hi
>
> I'm new to sqlite3, and i' have some Problems with my code. I'm trying to
> select data from a table and to save the result in a string. but i have no
> clue how to accomplish this.
>
> Here is a part of my code:
>
> std::string get_user_info(const char* nick,int mode)
> {
> #ifdef _WIN32
> const char *filename = "db\\users.db";
> #else
> const char *filename = "db/users.db";
> #endif
> services serv;
> Config conf;
> sqlite3 *db;
> char *zErrMsg = 0;
> int rc;
> char *sql = (char*) malloc(sizeof(char)*64);
> rc = sqlite3_open(filename,&db);
> if(rc)
> {
> std::cout << "S_ERR_USERDATABASE" << std::endl;
> globops(conf.get_s_name(),S_MSG_SRVGOINGDOWN);
> sqlite3_close(db);
> return NULL;
> }
> sprintf(sql,"SELECT * FROM '%s';",nick);
> if(rc!=SQLITE_OK)
> {
> fprintf(stderr,"SQL error: %s\n",zErrMsg);
> sqlite3_free(zErrMsg);
> }
> user = ...// i'd like to store the db data in a string here...
> return user;
> }
>
> Can anybody help me here? Thanks
>
>
> Regards
>
> Sevi
>
>
> --
> GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
> Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail
>
>
> -----------------------------------------------------------------------------
> To unsubscribe, send email to [EMAIL PROTECTED]
>
> -----------------------------------------------------------------------------
>
>
