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"
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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:
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.
17 matches
Mail list logo