Re: [sqlite] Loss of Binary Data in Dump File

2010-10-28 Thread Art Age Software
With Roger's help I have gotten to the bottom of this issue, and I wanted to post the resolution to the list in case anyone else bumps into it. There is a bug in PHP versions prior to PHP 5.3 that makes it impossible to reliably create/store BLOB columns. My code ends up creating TEXT data when

[sqlite] Loss of Binary Data in Dump File

2010-10-27 Thread Art Age Software
Hi All, New to this list and hoping someone can help. I have a sqlite3 database that contains a couple of tables that have binary data in BLOB columns. I know the data is in there and stored correctly because the application accessing the database can retrieve the column data just fine. The

Re: [sqlite] Loss of Binary Data in Dump File

2010-10-27 Thread Art Age Software
MESSAGE- Hash: SHA1 On 10/27/2010 11:48 AM, Art Age Software wrote: New to this list and hoping someone can help. I have a sqlite3 database that contains a couple of tables that have binary data in BLOB columns. Note that there is column affinity, but the data stored for a particular column

Re: [sqlite] network access problem

2010-05-27 Thread Art
the folder's permission in the vb settings were set to r/w for the shared folder, it worked. When set to read only it fails. Thank you, Art, == From: Black, Michael (IS) michael.bla...@ngc.com One thing to be clear on. What OS are you running in your Virtualbox? I hope

Re: [sqlite] network access problem

2010-05-26 Thread Art
with read_only specified should fail under these circumstances, If this was a problem with virtualbox then you see their message board light up with complaints. Its not, no other apps have problems accessing files through vb shared folders! Art. Running

Re: [sqlite] sqlite-users Digest, Vol 29, Issue 25

2010-05-25 Thread Art
, unless sqlite is not setting its permissions correctly when it does the file open. If the folder is tagged as full access then sql open works. Art. Running in sqlite application in Virtual Box, attempt to open a database with sqlite from a shared network folder

[sqlite] network access problem

2010-05-24 Thread Art
this seems to be a bug in the open code of sqlite when accessing a file across a network. Thank you, Art Zerger azer...@yahoo.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

[sqlite] active critical section

2007-01-24 Thread Art
tell the sqlite3.dll to exit cleanly. Thank you, Art [EMAIL PROTECTED] using 3.3.11 of the sqlite3.dll === VERIFIER STOP 0201 : pid 0x738: Unloading DLL containing an active critical section. 60949020 : Critical section address.

Re: [sqlite] mbcs vs char

2006-05-01 Thread Art
I'll give that a try, thanks art List: sqlite-users Subject:Re: [sqlite] mbcs vs char From: Dennis Cote dennis.cote () gmail ! com Date: 2006-05-01 14:52:06 Message-ID: 44562096.2000300 () gmail ! com [Download message RAW] Art wrote: since there is no sqlite_exec16

[sqlite] mbcs vs char

2006-04-29 Thread Art
you, art Thank you, Art Zerger [EMAIL PROTECTED] - Get amazing travel prices for air and hotel in one click on Yahoo! FareChase