Re: [sqlite] import / insert 120k records

That makes good sense - if my task were repetitive I would take that route - I opted to write a quick and dirty PHP script just to handle this one-off case and it worked like a charm. I can share the script as a jumping off point for anyone who is interested. *Ben Marchbanks* John Stanton

[sqlite] import / insert 120k records

Whats the best way to import a large number of records ? 120K+ currently stored as an XML file. -- *Ben Marchbanks* ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Import xml into SQLite

I am looking for a nice GUI for admin of SQLite database - on Mac OS. I tried FireFox SQLmanager with no luck - any other suggestions ? I need an easy way to import large XML into a new table. -- *Ben Marchbanks* ___ sqlite-users mailing list sqlite

[sqlite] Feasibility of SQLite as multiuser (readonly)

I realize the SQLite is designed for single client only but is it feasible at all to use a SQLite DB for multiple users in a workgroup as a readonly data source ? -- *Ben Marchbanks* ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] Multiuser Readonly Database

but the project now has a new requirement that enterprise users be able to run the app and access the same documents (and SQLite db) over the network simultaneously. Files ad SQLite DB is for readonly. Is this viable and if so what are some of the caveats ? -- *Ben Marchbanks

[sqlite] Parenthetical LIKE query ??

SELECT * FROM `pagesText` WHERE pageText LIKE ( "%muffler%" , "%clamp%" ) Is there a nice way to write a query using parenthetical LIKE ? Queries like this can get quite long otherwise Any suggestions ? *Ben Marchbanks* www.magazooms.com <http://www.magazooms.c

[sqlite] REGEXP

I am confused. Is REGEXP enabled in SQLite or does there have to be a regexp custom function created ? -- *Ben Marchbanks* www.magazooms.com <http://www.magazooms.com/> Signature Email: b...@magazooms.com <mailto:b...@magazooms.com> Phone: (8

Re: [sqlite] Adobe AIR SQLite - error 3132

I believe I found the problem. I attempted to update a date field 2008.12.07 which was being interpretted as a number - apparently AIR version of SQLite enforces data types more stringently. *Ben Marchbanks* www.magazooms.com <http://www.magazooms.com/> Signature Email: [EMAIL PRO

[sqlite] Adobe AIR SQLite - error 3132

I am getting an exception # 3132 as I try to update a record in my AIR runtime application. This error only occurs on my WinXP test machine and not on my iMac running OS 10.5.5 ( my development machine). Any resource for getting full list of error codes ? -- *Ben Marchbanks

Re: [sqlite] Adobe AIR Version Issue(?)

the db file and start fresh. If you are using AIR besure to "clean project" to move your sqlite database to the bin-debug folder. I had the same issue just today - I realized my updated SQLite table was not being used by the debugger. *Ben Marchbanks* www.magazooms

Re: [sqlite] Adobe AIR sqlite - access to sqlite_master

ignore this post - found the error of my ways ! *Ben Marchbanks* www.magazooms.com <http://www.magazooms.com/> Signature Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Phone: (864) 284.9918 Ben Marchbanks wrote: > I am having trouble getting a table description from a SQLite

[sqlite] Adobe AIR sqlite - access to sqlite_master

Result = _sqlConnection.getSchemaResult(); var mytableSchema = schemaResult.tables trace(mytableSchema) // = "undefined" Any ideas on a workaround ? -- *Ben Marchbanks* www.magazooms.com <http://www.magazooms.com/> Signature Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTE

Re: [sqlite] Adobe AIR Version Issue(?)

on mac OSX. SQLite Admin helps verify schema and test queries etc... *Ben Marchbanks* www.magazooms.com <http://www.magazooms.com/> Signature Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Phone: (864) 284.9918 Ben Marchbanks wrote: > Yes I did resolve it using a large hamm

Re: [sqlite] Adobe AIR Version Issue(?)

is that the file permission were set to -rwx-rwx-r-x instead of drwx-rwx--r-x as I would expect using chmod 0775. I think that PHP-PDO is a clumsy implementation. *Ben Marchbanks* www.magazooms.com <http://www.magazooms.com/> Signature Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Phone: (8

[sqlite] PHP created sqlite permissions

wxrwxr-x 1 apache apache 9411584 2008-11-21 09:23 mzdb.sqlite Could it be that the reason for the "table lock" is due to file permissions? If not what could cause the table to remain locked after being populated ? -- *Ben Marchbanks* www.magazooms.com <http://www.magazooms.com/&g

Re: [sqlite] Escaped values throws error

Hmmm - thanks for straightening me out guys - somehow I thought that SQLite used double quotes *Ben Marchbanks* www.magazooms.com <http://www.magazooms.com/> Signature Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Phone: (864) 284.9918 John Stanton wrote: > An S

Re: [sqlite] Escaped values throws error

Thanks - I did find a solution since I was not successful using sqlite_escape_string. I think that the SQLite implementation in PHP via PDO is the culprit. I wound up using double escape - str_replace("\"","\"\"",$value); *Ben Marchbanks* www.maga

[sqlite] Escaped values throws error

on 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6.2.2 2007/03/23 14:30:00 wez Exp $ SQLite 3.4.2 -- *Ben Marchbanks* www.magazooms.com <http://www.magazooms.com/> Signature Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Phone: (864) 284.9918

[sqlite] Database Locked

? *Ben Marchbanks* www.magazooms.com <http://www.magazooms.com/> Signature Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Phone: (864) 284.9918 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/lis