Re: [sqlite] PHP mods was: Changing table and security

2004-12-23 Thread Mrs. Brisby
On Thu, 2004-12-23 at 04:27 -0500, Randall Randall wrote: > >> > >> Arg! Just invites people to crash your web site. > >> > > *their* web site... think about phpbb or similar phorums > > The unsaid part here, though quite off-topic, is that PHP bulletin > boards are often changed with "mods"

Re: [sqlite] Questions about binding

2004-12-23 Thread D. Richard Hipp
James Berry wrote: (3) Binding of blob data: If I bind some arbitary bind data, I assume I shouldn't (and wouldn't want to) do any escaping or quoting of null values, etc. Is that correct? Correct. The answers to your other questions should be easy to discover by examining the code. You are

[sqlite] Questions about binding

2004-12-23 Thread James Berry
I'm somewhat confused by binding in the C++ interface. The documentation seems not to be entirely consistent. My questions fall into several areas: (1) Form of wildcards: ? ?N :N: $N At various places in the documentation, all of these seem to be mentioned, though not all consistently. At

Re: [sqlite] Pragma default_synchronous?

2004-12-23 Thread James Berry
On Dec 23, 2004, at 4:41 PM, D. Richard Hipp wrote: PRAGME default_sychronous went away with version 3. Thanks. Ah, a documentation bug. -jdb

Re: [sqlite] Pragma default_synchronous?

2004-12-23 Thread D. Richard Hipp
James Berry wrote: PRAGMA default_synchronous doesn't seem to have any effect on my sqlite 3.0.8 installation. PRAGMA default_synchronous; doesn't return a result in the sqlite3 shell, and PRAGMA default_synchronous=OFF doesn't seem to have any effect, either. In contrast, PRAGMA synchronous

Re: [sqlite] How to retrieve ROWID without explicite request

2004-12-23 Thread Will Leshner
On Thu, 23 Dec 2004 19:08:05 -0500, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > (3) This would be a huge change that would require > a lot of code. Isn't it easier just to add > "rowid," in from of the "*" in your query? > How hard is it really to write a routine

[sqlite] Pragma default_synchronous?

2004-12-23 Thread James Berry
PRAGMA default_synchronous doesn't seem to have any effect on my sqlite 3.0.8 installation. PRAGMA default_synchronous; doesn't return a result in the sqlite3 shell, and PRAGMA default_synchronous=OFF doesn't seem to have any effect, either. In contrast, PRAGMA synchronous does seem to be

Re: [sqlite] How to retrieve ROWID without explicite request

2004-12-23 Thread D. Richard Hipp
pascalive wrote: [pseudocode] sql=select * from tablename sqlite_compile loop sqlite_step [function to get _rowid_ from returned row] endloop (1) This would slow down queries that do not use the get_last_rowid() function. It seems like a bad idea to slow down queries

Re: [sqlite] How to retrieve ROWID without explicite request

2004-12-23 Thread Will Leshner
On Thu, 23 Dec 2004 14:47:28 -0800, Will Leshner <[EMAIL PROTECTED]> wrote: > What would be neat, I think, is if there were a > PRAGMA we could add to a query that would tell SQLite to add the > 'rowid' column to any result set for which 'rowid' wasn't already a > column. Would it make sense to

Re: [sqlite] How to retrieve ROWID without explicite request

2004-12-23 Thread Will Leshner
On Thu, 23 Dec 2004 20:33:01 -0200, pascalive <[EMAIL PROTECTED]> wrote: > I'd like to know if there's a way to retrieve the _rowid_ of each returned > row without asking for it. Actually, this is something I've been meaning to feature-request, and for exactly the same reason. What I do, and it

[sqlite] How to retrieve ROWID without explicite request

2004-12-23 Thread pascalive
I'm doing a wrapper of sqlite to freepascal compiler which caches the requested data and uses _ROWID_ to identify the row, so i can properly update the changes made in cached data to the database. The problem with this approach is that the user must explicitely put the _ROWID_ in the field list

Re: [sqlite] malformed disk image

2004-12-23 Thread Michael Hunley
At 05:33 AM 12/23/2004, you wrote: Inserting binary data without encoding it should *not* corrupt the database. It might make it difficult to get your data back, but other records in the database should be uneffected and the kinds of errors you were seeing from PRAGMA INTEGRITY_CHECK should not

Re: [sqlite] malformed disk image

2004-12-23 Thread D. Richard Hipp
Michael Hunley wrote: At 03:43 PM 12/22/2004, you wrote: See section 6.0 in http://www.sqlite.org/lockingv3.html. That article is on SQLite version 3, but the methods for corrupting a database apply equally well to version 2. Thanks. Unfortunately, none of these seem terribly likely. The user

Re: [sqlite] PHP mods was: Changing table and security

2004-12-23 Thread Randall Randall
On Dec 23, 2004, at 3:22 AM, Paolo Vernazza wrote: Jay wrote: You're altering tables you don't understand the structure of? Think about a php forum... someone could choose to make a mod and add a column for the birthday in the users table... you can't know if someone did it or not... Arg! Just

Re: [sqlite] ODBC Driver

2004-12-23 Thread Dan Keeley
The page that gives the (very impressive) list of drivers and wrappers for SQLite is: http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers The specific one you want is: http://www.ch-werner.de/sqliteodbc/ Excellent thanks! Rgds, Dan

Re: [sqlite] ODBC Driver

2004-12-23 Thread Dan Keeley
Ah, I should have made it clear _why_ i need an odbc driver. I'm using some commercial reporting and application generation tools to connect to it - They dont support sqlite natively, so I must use odbc. So which one should I use? Thanks! Dan From: Oliver Bienert <[EMAIL PROTECTED]> Reply-To:

Re: [sqlite] Changing table and security

2004-12-23 Thread Paolo Vernazza
Jay wrote: You're altering tables you don't understand the structure of? Think about a php forum... someone could choose to make a mod and add a column for the birthday in the users table... you can't know if someone did it or not... Arg! Just invites people to crash your web site.