[sqlite] [C] Problem getting int results

[Severin Müller]

Hello Folks

I have some problem retrieving a result from a sqlite database in C. 

I have the following statement: 

int func(void)
{
        // database is open and the select statement is executed
        // this is the query: char *sql = "SELECT 'protect' FROM 'test_db');";
        struct sqlite3_stmt *oStmt;
        int rc;
        int result = 0;
        
                
if((rc=sqlite3_prepare_v2(db,sql,strlen(sql),&oStmt,NULL))==SQLITE_OK)
                {
                        if((rc=sqlite3_bind_int(oStmt,0,result))==SQLITE_OK)
                        {
                                if((rc=sqlite3_step(oStmt))==SQLITE_ROW)
                                {
                                        printf("result: %i\n",result);
                                        return result;
                                }
                        }
                }
                else
                {
                        printf("SQL Error: %s\n",sqlite3_errmsg());
                        return -1;
                }
        }
}


But i always get the following error message: 

"Bind or column index out of range"

What did i do wrong?

Thanks for your help
-- 
Freundliche Grüsse // Kind regards

Severin A. Mueller
Mythenquai 2
CH-8022 Zurich
Office: +41 44 278 85 03
Mobile: +41 76 249 85 38


GMX startet ShortView.de. Hier findest Du Leute mit Deinen Interessen!
Jetzt dabei sein: http://www.shortview.de/[EMAIL PROTECTED]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users