Re: [sqlite] Export Blob data from sqlite database to html

2011-11-16 Thread Luuk
On 16-11-2011 10:02, si666 wrote: > I have a sqlite database from a iphone chat app which I would like to present > in a human readable format either csv, html or other. you should ask the author of that iphone app ;) ___ sqlite-users mailing list

Re: [sqlite] Adobe Air - Using SQLite db, cannot "UPDATE" nor "INSERT"

2011-11-16 Thread BertD
Pavel Ivanov-2 wrote: > >> // first we need to set the file class for our database (ICM.db). >>    var db:File = new File ("C:/ICM.db"); > > Depending on your Windows version only users with elevated privileges > could be able to write into root C:\ directory. Adobe Air apparently > won't ask

Re: [sqlite] Adobe Air - Using SQLite db, cannot "UPDATE" nor "INSERT"

2011-11-16 Thread Pavel Ivanov
> // first we need to set the file class for our database (ICM.db). >    var db:File = new File ("C:/ICM.db"); Depending on your Windows version only users with elevated privileges could be able to write into root C:\ directory. Adobe Air apparently won't ask you to elevate its privileges just to

Re: [sqlite] Adobe Air - Using SQLite db, cannot "UPDATE" nor "INSERT"

2011-11-16 Thread BertD
George Eckert wrote: > > It may make little REAL difference, but the SELECT statement you show does > not have a semicolon at the end, but the INSERT statement does. Perhaps > the error returned is misleading? > > -- > George Eckert > > I've not checked if that would be a problem, i'll ch

Re: [sqlite] 200 lines of fun sqlite3 code

2011-11-16 Thread Alexey Pechnikov
Please submit code to pastebin.com or similar. 2011/11/16 Matt Young : > 200 lines of code with embedded c. (headers omitted) > This code comes up and reads triples from a table view called self, reads > triples one at a time.  The triples are either a configure and load sql > statement command, o

[sqlite] 200 lines of fun sqlite3 code

2011-11-16 Thread Matt Young
200 lines of code with embedded c. (headers omitted) This code comes up and reads triples from a table view called self, reads triples one at a time. The triples are either a configure and load sql statement command, or the triple is executed, as a random sql procedure doing whatever, Rinse and re

[sqlite] Export Blob data from sqlite database to html

2011-11-16 Thread si666
I have a sqlite database from a iphone chat app which I would like to present in a human readable format either csv, html or other. The database has over 600 tables with multiple rows of conversation, the fields are: sender (text) - servertime (blob) – localtime (blob) – type (text) – data(blob)

Re: [sqlite] Adobe Air - Using SQLite db, cannot "UPDATE" nor "INSERT"

2011-11-16 Thread George Eckert
It may make little REAL difference, but the SELECT statement you show does not have a semicolon at the end, but the INSERT statement does. Perhaps the error returned is misleading? -- George Eckert On Tuesday, November 15, 2011 at 6:09 PM, BertD wrote: > > Hello all, > > Question : > >