Sorry, but I still don't quite understand what do you have and what are you trying to achieve. Now I understand it like you have some binary data in php and want to insert it into blob field. Then you should be able to do this:
UPDATE table1 SET stringblob = ? ... And bind you binary data as blob (sorry I'm not familiar with php-sqlite API and can't say what function will do that). If that's still not what you have and what you want then please explain in more details your requirements. Pavel On Thu, Sep 10, 2009 at 4:23 PM, yogibabu <madra...@interia.pl> wrote: > > > > Pavel Ivanov-2 wrote: >> >> So why can't you do like this: >> >> sql = "UPDATE table1 SET stringblob = X'" . bin2hex(...) . "' ..."; >> > > because I want this function to be called within database without looping it > out through every row in php > -- > View this message in context: > http://www.nabble.com/how-to-pass-function-result-to-a-blob---tp25389627p25390345.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
