Re: [sqlite] [C] Problem getting int results

2008-03-12 Thread Severin Müller
12 Mar 2008 08:27:47 -0400 > Von: "Igor Tandetnik" <[EMAIL PROTECTED]> > An: sqlite-users@sqlite.org > Betreff: Re: [sqlite] [C] Problem getting int results > ""Severin Müller"" <[EMAIL PROTECTED]> wrote > in message news:[EMAIL PROTE

Re: [sqlite] [C] Problem getting int results

2008-03-12 Thread Igor Tandetnik
""Severin Müller"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] >> ""Severin Müller"" <[EMAIL PROTECTED]> >> wrote in message >> news:[EMAIL PROTECTED] >>> int func(void) >>> { >>> // database is open and the select statement is executed >>> // this is the query:

Re: [sqlite] [C] Problem getting int results

2008-03-12 Thread Severin Müller
> ""Severin Müller"" <[EMAIL PROTECTED]> wrote > in message news:[EMAIL PROTECTED] > > int func(void) > > { > > // database is open and the select statement is executed > > // this is the query: char *sql = "SELECT 'protect' FROM > > 'test_db');"; > > This is not valid SQL.

Re: [sqlite] [C] Problem getting int results

2008-03-12 Thread Igor Tandetnik
""Severin Müller"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > int func(void) > { > // database is open and the select statement is executed > // this is the query: char *sql = "SELECT 'protect' FROM > 'test_db');"; This is not valid SQL. FROM clause expects a

[sqlite] [C] Problem getting int results

2008-03-12 Thread 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