I have a script for uploading files to a server with Google Gears. So far i have been able to get the user to pick the files, add them to my files object, send chunks of them to the server and even poll the server for a list of uploaded files and their progress.
The next step i'm trying to tackle is saving the file data to the Gears database before i start the upload so that i can resume it later. I have the table created and can read and write all other data into it except the blob. How do i go about writing the blob to the table row, sending it as is get a unkown type error? I know Sqlite has a sqlite3_bind_blob() method but i don't know how to access it since it needs a pointer to the sql statement which i don't have. While we are at it, i guess i will also need to figure out how to recreate the blob once it comes out. I was thinking of using a blobbuilder and then append the data to it and use getAsBlob() to re- create the blob. Any light that you can shed on this would be greatly appreciated. Thanks Tony
