above separately without the Create Trigger DDL, the query runs
successfully and populates my zWeeks table with values 1 through 10.
Do triggers not support this behavior, or is my syntax incorrect?
Thanks,
BEN
___
sqlite-users mailing list
sqlite-users
Thanks Simon.
The 10 is just an arbitrary value I chose for this example. The user
actually determines the value at run-time, so this value could be any
integer. I have a way to settle that, if only I could figure out how I can
get this trigger working.
BEN
On Tue, Nov 11, 2014 at 5:41 PM
Thanks everyone. I will have the programming language do the work on this
one instead of going the trigger route.
On Nov 11, 2014 7:39 PM, Richard Hipp d...@sqlite.org wrote:
On Tue, Nov 11, 2014 at 8:22 PM, Igor Tandetnik i...@tandetnik.org
wrote:
On 11/11/2014 6:15 PM, Ben Newberg wrote
Hi,
Really appreciate any help. I get the exception 'The specified store provider
cannot be found in the configuration, or is not valid.' on this line in the
code:
using (var handheldEntities = new HandheldDatabaseOnDesktopEntities())
My environment: VS2010 SP1, WIN 8.1 PRO
Snippet from
Hi,
Really appreciate any help, spent a day and a half trying to figure this out
without success. I can't get 'System.Data.SQLite Database File' to show up as
an option I the 'choose data source' window.
My environment: VS2010 SP1, WIN 8.1 PRO
1. Installed
FROM items, collections
WHERE collections.collection_date = date(items.creation_date, '+50 days')
GROUP BY items.id
ORDER BY prod_code ASC,
last_collection_date ASC
Thanks again,
Ben
On 13 Aug 2014, at 02:43, Keith Medcalf kmedc...@dessus.com wrote:
I don't think you want max
,
Ben
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 6 Apr 2014, at 21:28, Richard Hipp d...@sqlite.org wrote:
On Sun, Apr 6, 2014 at 4:18 PM, Ben sqlite_l...@menial.co.uk wrote:
Hi all,
Is there any advantage to using the encoding specific functions from the C
api?
For example, given a database with its encoding set to UTF-16, should
Dear sqlite experts,
I have an application where data stored in columns can be lists of integers
(e.g. 158;42;76). I cannot really split such record into multiple records
(one for 158, one for 42 etc) and I am currently storing them as VARCHAR
because they represent a complete piece of
the columns directly and save us from the
trouble of translating user input, so it might be a better solution in this
case.
Thanks,
Bo
On Fri, Mar 21, 2014 at 10:05 AM, Tristan Van Berkom
tris...@upstairslabs.com wrote:
On Fri, 2014-03-21 at 09:35 -0500, Ben Peng wrote:
Dear sqlite experts
danielk1...@gmail.com wrote:
On 03/21/2014 10:33 PM, Ben Peng wrote:
Hi, Tristan,
Your solution definitely works (we have defined a few custom functions)
but
our application hides databases from users but allows users to use simple
conditions to retrieve results. To use this function, we would
and still has some bugs,
but works.
- Ben
On 7 Nov 2013, at 17:42, L. Wood lwoo...@live.com wrote:
What directories can SQLite possibly write files to?
Modern Mac OS X programs run in sandbox mode. This is a requirement to
publish apps on Apple's Mac App Store. Sandboxing means
that the option SQLITE_ENABLE_FTS3 enables FTS3 support (without
mentioning FTS4).
It also lists the option SQLITE_ENABLE_FTS4 with a description stating that
this enables FTS3 and 4.
For myself at least, adding SQLITE_ENABLE_FTS3 seems to enable both just fine.
Regards,
Ben Barnett
That first link is *well* out of date and the second only compares three
editors. I don't believe there is a comprehensive comparison anywhere right now.
- Ben
On 26 Jun 2013, at 17:46, Rose, John B jbr...@utk.edu wrote:
fyi
http://www.barefeetware.com/sqlite/compare/?ml/
http
Simulator/6.0/Applications
There's a load of UUID-named folders in there, one for each simulator app. Poke
around in there and you'll likely find it.
- Ben
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman
Hello all,
I've recently joined an organization that is attempting to use SQLite in a
multi-user environment (C#, using System.Data.SQLite, layered under the
DevExpress XPO ORM). Due to the high-latency nature of the networks on
which our application is deployed, we're seeing a very high number
, and presented this to our
management team, however this seems to have been to no avail, so this post
was something of an appeal to authority.
On Fri, Oct 19, 2012 at 4:21 PM, Nick Shaw nick.s...@citysync.co.uk wrote:
Richard Hipp wrote:
Ben Morris magospiet...@gmail.com wrote:
If anyone could share
on the destructor defined by %token_destructor{}. Or for
that matter whether I should be declaring a more specific symbol destructor.
Can anyone shed some light on how this should be done?
Thanks,
Ben
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
On 18 Oct 2012, at 20:07, Richard Hipp d...@sqlite.org wrote:
On Thu, Oct 18, 2012 at 3:03 PM, Ben sqlite_l...@menial.co.uk wrote:
Hi list,
I'm having a little trouble getting my head around memory management
within a Lemon-generated parser. Specifically the part of the docs stating
Hi,
If we compile sqlite3.c (version 3.7.14) using Microsoft Visual C++ 2010 with
maximum optimization, /Ox, then we experience this problem:
The code in sqlite3VXPrintf is sensitive to numerical optimization. With
optimizations turned on, a number like:
99.943
*sometimes* is
Upon reading Programmers are cautioned not to use the two exceptions described
in the previous bullets at http://www.sqlite.org/lang_keywords.html, the goody
two-shoes in me thought, I would like a pragma that disables those exceptions,
i.e. a strict quoting pragma. Then I could use that pragma
SQLite, in its 'default' code configuration, contains enough functionality to
be a replacement for a shapefile.
However, there is one very significant feature that is wasteful to ignore:
spatial indexes.
In order for the SQLite RTree to be used, it needs accompanying code that
understands the
of the virtual table mechanism?
Regards,
Ben
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
the virtual table the ability to recognized case-insensitive
LIKE queries, which is also not currently possible.
I basically just copied the single line from bestBtreeIndex into
bestVirtualIndex.
Is there any chance something like this could get merged into the main line?
Regards,
Ben
and SQLITE_INDEX_CONSTRAINT_ codes are identical. The
** following asserts verify this fact. */
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Ben Harper
Sent: 09 September 2011 03:18 PM
To: sqlite-users@sqlite.org
Subject: [sqlite
Hi,
We make use of a number of queries which we also run against other databases.
Consider this simplified example:
SELECT psim_objects.ObjectName, property.AttributeTextValue, data.Attribute,
data.AttributeUOM FROM psim_objects INNER JOIN (psim_objectdata data INNER
JOIN psim_objectdata
class of
functions,
that breakpoint does not get hit, but the RTree is nevertheless updated.
One symptom of the corruption is:
SELECT * from idx_table_field_geometry,
and you'll end up with a bunch of 0,0,0,0 MBRs.
Ben
___
sqlite-users mailing list
Apologies!
My mistake. The UPDATE trigger can be catch-all-fields (ie no fields specified),
and it is still correct.
To answer your question Dan, I am not creating a trigger on an RTree.
I am creating a trigger on a regular table, which keeps the RTree up to date.
Thanks,
Ben
like so:
SELECT my_function();
Thanks,
Ben
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
OK.
I'm assuming this is not a regular pattern that has an idiomatic workaround?
Ben
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Pavel Ivanov
Sent: 07 July 2011 05:18 PM
To: General Discussion of SQLite Database
Subject
discern anything strange about the data, or my methods.
I'm curious to know whether anybody has seen this kind of thing before?
Thanks,
Ben
ps. This message is cross-posted to the Spatialite mailing list.
___
sqlite-users mailing list
sqlite-users@sqlite.org
...@sqlite.org]
On Behalf Of Richard Hipp
Sent: 05 July 2011 03:20 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] False negatives from RTree
On Tue, Jul 5, 2011 at 8:55 AM, Ben Harper b...@imqs.co.za wrote:
Hi,
Has anybody ever seen anomalous behaviour on an R*Tree. Specifically
To: General Discussion of SQLite Database
Subject: Re: [sqlite] False negatives from RTree
On Tue, Jul 5, 2011 at 8:55 AM, Ben Harper b...@imqs.co.za wrote:
Hi,
Has anybody ever seen anomalous behaviour on an R*Tree. Specifically, false
negatives?
I'm using Spatialite 2.4.0 RC.
What I end up
You don't mention which platform you're on, but for OS X there's a good
comparison table of SQLite editors here:
http://www.barefeetware.com/sqlite/compare/?ml
- Ben
On 22 Mar 2011, at 18:46, Sam Carleton wrote:
I am looking for a good SQLite IDE, SQLite Maestro looks like a good
candidate
announcement (with a link to release notes) here:
http://menial.co.uk/2011/02/18/base-2-0/
I hope this is something of interest to list subscribers.
Ben Barnett
Menial
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin
discussions here. If anyone has any
comments or problems, you can contact me off-list on i...@menial.co.uk, or
using the from address in this message.
- Ben
On 20 Feb 2011, at 06:19, BareFeetWare wrote:
Hi Ben,
In reply to your announcement of Base 2:
Just a short message to announce
This is low probability, but maybe the Fault Tolerant Heap is turned on for
sqlite.exe?
I believe you'll see the exe mentioned in here if that is the case:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\FTH\State
FTH was introduced in Windows 7.
Ben
___
sqlite
bring this up anyway.
Regards,
Ben
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I'm using rollback - and no it's nothing like trying to commit inside a
user-defined function. Very simple usage pattern.
I'll isolate the code so that it's small enough to post here.
I just noticed that I do sqlite3_busy_timeout(DB,0) - if that's relevant.
Ben
-Original Message-
From
the
responsiveness that you require. I have no contact with the SQLite
authors, but I wouldn't place my bets on rolling logs being available
any time soon.
Ben
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Yoni
Sent: 25 November 2010
system of mine, where blocking is an issue, I
buffer up the write messages, and flush them on a background thread.
Of course this may not be practical for you...
Ben
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Yoni
Sent
, but
the manner in which I cater for long transactions makes it necessary for me to
strap Sqlite onto,
for instance, a modified Postgres table that has not yet been committed to the
DB.
Ben
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org
= 'val' COLLATE NOCASE;
... send identical data to xBestIndex.
Am I right if I conclude that the xBestIndex interface would need to be extended
in order to make it possible to distinguish between these three different
queries?
Thanks,
Ben
___
sqlite
In wal.c, it reads 8 or 10 comparisons (on average) suffice to either locate a
frame in the WAL or to establish that the frame does not exist in the WAL.
I'm wondering -- how often does it occur that only a small subset of pages is
written to again and again, in sequence, such that the WAL
Are you sure that double precision in the RTree is necessary for your purposes?
Here is a table of floating point precision at various values:
The 'flip' values are the 'org' values with the lowest bit flipped.
org flip (delta)
0.01 0.01 (
, or is it made to
run pretty much ignorant of the file that it is WAL'ing against?
Thanks,
Ben
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Using sqlite's WAL with a hash table store
On 3 Nov 2010, at 8:30am, Ben Harper wrote:
I know the answer to this question is really Just try it and see, but I
want to gauge whether the idea is sane or not before I spend/waste time
] Using sqlite's WAL with a hash table store
FTS3 extension is very fast and scalable hash engine. I did test FTS3 up to
400+ millions of record and it's nice.
2010/11/3 Ben Harper b...@imqs.co.za
Hi,
I know the answer to this question is really Just try it and see, but I
want to gauge whether
On Wed, Nov 03, 2010 at 12:31:35PM +0200, Ben Harper scratched on the wall:
I guess I could actually dump the hash table into a blob.
I'm also doing something like a bloom filter, and I guess that can just
as well go into a blob too.. Basically the system is a big cache,
and it must quickly
. I want the default LIKE behaviour, which
is NOCASE, but I can't figure out where to glean this information from inside
xBestIndex.
Am I missing something?
Thanks,
Ben
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi
I just discovered the MSVC compiler generates bad debug info for source files
larger than 64k lines, which is the case with the Sqlite amalgamation.
Does anyone know of a workaround?
Thanks,
Ben
___
sqlite-users mailing list
sqlite-users@sqlite.org
OK.
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Teg
Sent: 23 September 2010 03:20 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Breakpoints uncorrelated on MSVC amalgamation build
Hello Ben
'? If so, I don't
understand
how this comes to be. The docs clearly state that the default is BINARY, and
I've tried explicitly creating my vtable with (field COLLATE BINARY)... so that
seems unlikely
to me. But I'll have to dig further.
Ben
-Original Message-
From: sqlite-users-boun
September 2010 03:24 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Breakpoints uncorrelated on MSVC amalgamation build
Which MSVC compiler has this bug? There's a link to information on that ?
On Thu, Sep 23, 2010 at 10:17, Ben Harper b...@imqs.co.za wrote:
I just discovered
Mike,
If you are using iOS, then presumably you are using the NSDate class. If you
are, then the easiest thing to do is store the result of
- (NSTimeInterval)timeIntervalSinceReferenceDate . This stored value can be
turned back into an NSDate using [NSDate
On Wed, Sep 1, 2010 at 12:46 PM, Jay A. Kreibich j...@... wrote:
There is no reason to assume the filesystem
will over-write the existing allocations, rather than just create new
ones, especially if the pages are shuffled in groups...
Actually there's no reason to do the opposite, as it would
if the xUpdate function could inform one that only the
field 'age' is being altered. As it is now, every field is fed to xUpdate,
causing a circumventable read/verify/write burden on the VT implementation.
This must be a frequent question?
Thanks,
Ben
___
sqlite
: Re: [sqlite] Any way to make xUpdate only alter the columns that are
changed?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/28/2010 07:37 AM, Ben Harper wrote:
then it would be great if the xUpdate function could inform one that only the
field 'age' is being altered. As it is now
As of 3.6.23.1 the pragmas foreign_keys and recursive_triggers default to OFF,
but the documentation mentions they might get enabled in the future. It would
seem natural for these features to be enabled by default; as I understand the
only reason they are disabled is to avoid affecting
When the database format is 2 or higher (explicitly via PRAGMA
legacy_file_format = false; or implicitly via ALTER TABLE ... ADD COLUMN
...), sqlite doesn't currently take advantage of the fact that NULL columns at
the end don't have to be stored.
For example:
PRAGMA legacy_file_format =
in sqlite3Insert() at the line:
sqlite3ExprCodeAndCache(pParse, pList-a[j].pExpr, regCols+i+1);
Is this something I'm doing wrong?
If more information is needed, just let me know what to get.
- Ben
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
Thanks very much for pointing me to the ticket. I'm still not very familiar at
locating stuff in the fossil repo.
The error message you show is what I was expecting as my app will notice that
and handle the error.
Thanks again,
Ben
On 15 May 2010, at 14:53, Black, Michael (IS) wrote:
I
for me so far.
On my simple views I always see homogenous column types.
Ben
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Stefan Keller
Sent: 08 May 2010 04:29 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite
On 3 May 2010, at 15:47, D. Richard Hipp wrote:
Community feedback is requested for the following proposed new SQLite
C API:
int sqlite3_open_v3(const char*, sqlite3**, int, const char*);
...
(3) The default database file format would be format 4 (meaning that
new databases
* FROM one;
CREATE VIEW v2 AS SELECT rowid,* FROM one; -- My current best guess
SELECT rowid,i32 FROM v1;
|100
|200
--- vs ---
SELECT rowid,i32 FROM v2;
1|100
2|200
Thanks,
Ben
___
sqlite-users mailing list
sqlite
I only have this problem when I'm using a view on virtual tables, and since I
have complete control over them, I guess I could just explicitly declare a
rowid INTEGER PRIMARY KEY column for my virtual tables, and that should solve
the problem.
Thanks,
Ben
-Original Message-
From
Minor typo: section 2.0 Type Affinity of
http://www.sqlite.org/datatype3.html
says, in the third paragraph after the bullet list,
Hence, the string '3.0e+5' is stored in a column with NUMERIC
affinity as the integer 3, not as the floating point value
30.0.
I think this
How about (for a start):
for i in *.txt; do sqlite3 dir.db insert into texts values('$i', '`cat
$i`');; done
Probably there shouldn't be any single quotes in the contents.
Ben G
Given table texts(filename text, contents blob) and a directory of plain
text files, is it possible (using
Can I add a column name containing a dash - and if yes, how would I do that?
I am asking because I fail to add a column name that contains a dash - and I
don't know if I cause the problem (easy solution) or if its something else
causing this to fail.
Here's what I try:
sqlite create table
the
column name every time you (or somone other) uses ist.
Thanks. Unfortunately I don't have a choice. An application I don't have
control over expects such strange table names.
p...@rick
Martin
Patrick Ben Koetter wrote:
Can I add a column name containing a dash - and if yes, how would I do
Tim Romano wrote:
Thanks, Simon. I've tried PRAGMA encoding too but Adobe complains
whenever it sees PRAGMA.
Tim Romano
According to the Adobe documentation, PRAGMA statements are not
supported by their actionscript/flash database engine.
it, but wondered if this
would produce different symptoms than a file 'properly' corrupted
through accidental damage.
Thanks,
Ben Barnett
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite
On Sun, 29 Nov 2009 10:31:29 +, Ben
sqlite_l...@menial.co.uk wrote:
Hi all,
I write an SQLite browser for macs, and someone recently brought to
my
attention that it doesn't handle corrupt database files very well.
I've read the pages on pragmas for integrity checking and how locking
,
Ben Barnett
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
, Igor. That tells me what I need.
Regards,
Ben
Ben Atkinson wrote:
Sorry for the newbie SQL question. I'm trying to use the INSERT INTO
statement with a hexadecimal literal. I want to accomplish something
like this:
INSERT INTO TruckDefaultsTable VALUES ( 'AirPressureTime', 0
: 0xB4
I could express the value in decimal as 11796480, but that's pretty awkward
since the actual value I'm putting into the table is a Linux timeval structure.
It just makes more sense as hex.
Does SQL have a hex literal sequence that serves the same role as 0x in C?
Thanks for any help.
Ben
make install put the
installation bin, include, and lib directories in a directory on my Ubuntu host
where I could zip them up, and transfer them to /usr/local on my embedded
target.
Regards,
Ben
On Thu, Jun 25, 2009 at 4:23 PM, Ben Atkinsonwrote:
I have an embedded Linux ARM target and wish
through this and perhaps has a howto? Is
there already a recipe in the Makefile for this?
Regards,
Ben
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Jun 25, 2009, at 4:23 PM, Ben Atkinson wrote:
I have an embedded Linux ARM target and wish to run sqlite on it. I
successfully cross-compiled sqlite-3.6.15 on my Ubuntu x86 host, and
now I'm ready to install sqlite3, its libraries, and headers on my
target system.
I originally
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
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
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
)
which is incremented during every change operation.
Thanks,
Ben
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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
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
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.com/
Signature
Email: b
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: (864) 284.9918
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
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 PROTECTED
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.com http://www.magazooms.com
To the best of my findings, it seems to me that one needs to write a
mini SQL parser in order to read the 'sql' field from sqlite_master,
in order to discover the fields in an Sqlite table. Is this really a
necessary design? Would it not be better if
sqlite3_table_column_metadata had a mode that
Thanks, that's perfect!
On Mon, Dec 1, 2008 at 3:06 PM, Igor Tandetnik [EMAIL PROTECTED] wrote:
Ben Harper [EMAIL PROTECTED] wrote in
message
news:[EMAIL PROTECTED]
To the best of my findings, it seems to me that one needs to write a
mini SQL parser in order to read the 'sql' field from
();
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 PROTECTED]
Phone: (864) 284.9918
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 3.4.2 database
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: (864) 284.9918
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 hammer -
I just delete
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/
Signature
Email: [EMAIL PROTECTED
?
*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/listinfo/sqlite-users
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-users mailing list
sqlite-users@sqlite.org
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.magazooms.com http://www.magazooms.com/
Signature
Email
1 - 100 of 205 matches
Mail list logo