i have my data already in database, i want to perform some algorithms on it
and put it within the database onto the same row, because this is binary
data i must use blob
functions for processing the data are registered by
$pdo->sqliteCreateFunction
interestingly, when I operate on strings by putting data as an ascii hex
into database it works, the problem is only with this type of blob...
anyway it is not as necessary as i thought it will be, the amount of data
will not be so big as I originally thought:
this is my code:
foreach ($pdo->query("SELECT id,blobdata FROM table WHERE blobdata not
null") as $r) {
$pdo->query("UPDATE table SET
blobdata=X'".dosomemagic($r['blobdata'])."'
WHERE id=$r[id]");
}
should work fine
--
View this message in context:
http://www.nabble.com/how-to-pass-function-result-to-a-blob---tp25389627p25390639.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
