Dennis mentioned before that it was not necessary to do a bind on something that was defined as an integer primary key.
when i do: select * from Images; 1| 2| thats pretty much it. there are two entries because i tried to pure void cast as the previous message suggest vs the char * way..and it "seems" to make no difference. if i am supposed to bind the imageID what would that bind look like? which bind statement am i looking for? thanks!! --- "Matthew L. Creech" <[EMAIL PROTECTED]> wrote: > On Wed, Mar 12, 2008 at 9:37 AM, C S > <[EMAIL PROTECTED]> wrote: > > > > myString = "insert into Images(imageID, > imageData) > > values(?, ?); > > > > > > status = sqlite3_prepare_v2(db, myString.c_str(), > -1, > > &statement, NULL); > > > > void *blob = reinterpretcast<char *>(imageArray); > > > > > > status = sqlite3_bind_blob(statement, 2, blob, 10 > * > > sizeof(unsigned short), SQLITE_STATIC); > > > > statusu = sqlite3_finalize(statement); > > > > return sqlite3_last_insert_row(db); > > > > **************************** > > > > however when i do: > > > > select * from Images; > > > > i get no results returned to me. i just get > returned > > to the prompt. is there anything that i missed? > thanks > > again!!! > > > > You're missing a bind for the first column (the > imageID), and more > importantly, a call to sqlite3_step() - you do need > one, otherwise the > insert never executes. :) > > -- > Matthew L. Creech > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
