reading data from sqlite database

Question

I have stored my images in sqlite database.. i am reading the datas from db using the following query...but the "select"query not working ...if anyone knows,pls help me to resolve..

const char *phssqlStatement="select fld_image ,fld_path from tbl_image where fld_path like ?";
        sqlite3_stmt *phscompiledStatement;

        sqlite3_prepare_v2(database, phssqlStatement, -1, &phscompiledStatement, NULL);
        printf( "could not prepare statemnt: %s\n", sqlite3_errmsg(database));
        //sqlite3_bind_text(compiledStatement,1,[str_imgname1_site UTF8String],250, SQLITE_TRANSIENT);
        //sqlite3_bind_text(phscompiledStatement,1,[zoomedImageURL UTF8String],350,SQLITE_STATIC);
         sqlite3_bind_text(phscompiledStatement, 1, [zoomedImageURL UTF8String],350, SQLITE_TRANSIENT);

Oleg Danu · Accepted Answer · 2011-03-04 07:17:38Z

1

You forgot to number your input var like this:

const char *phssqlStatement="select fld_image ,fld_path from tbl_image where fld_path like ?1";

answered Mar 4, 2011 at 7:17

Oleg Danu

4,1585 gold badges32 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Oleg Danu Over a year ago

Try like this: const char *phssqlStatement="select fld_image ,fld_path from tbl_image where fld_path like '?1'";

Prabh · Accepted Answer · 2011-03-04 07:41:09Z

0

Your SQLite query should be more like:

const char *phssqlStatement="select fld_image ,fld_path from tbl_image where fld_path like '%?%'";

Hope this works for you.

answered Mar 4, 2011 at 7:41

Prabh

2,4742 gold badges24 silver badges27 bronze badges

Collectives™ on Stack Overflow

reading data from sqlite database

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related