sorry that should have been insert not insert2, sorry for the confusion. what do you mean no parameters in SQL?
again sorry for sounding noobish -- well fact of the matter is i am. ive learned as much as i have in 2 days so thanks for the patience and the string suggestion. --- Igor Tandetnik <[EMAIL PROTECTED]> wrote: > "C S" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > insert << "insert into Images values(NULL, '" << > Hello > > World << "')" > > As predicted, you don't have any parameters in your > SQL, so there's > nothing to bind. It's also not clear why you use a > stream. You probably > want something like > > string insert = > "insert into Images(imageID, messageID) values > (?, 'Hello World');"; > > Question mark '?' is the parameter placeholder. > > > long ID = db.performUpdate(insert2.str(), > blobarray, > > 10); > > What's the relationship between variables named > 'insert' and 'insert2'? > You initialize one, but then use the other. > > Igor Tandetnik > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
