This piece of code kept giving error messages that looked like some of my
VALUES were getting parsed by php:
I don't know what the API looks like in php, but usually you want to
use the "bindings" form which should look something like:
sqlite_query($handle, "INSERT INTO course VALUES (?,?,?,?,?)",
Hi all,
This piece of code kept giving error messages that looked like some of my
VALUES were getting parsed by php:
sqlite_query( $handle, "
INSERT INTO course VALUES (
sqlite_escape_string($semester),
On Fri, Dec 24, 2004 at 09:37:10PM -0500, Peter Jay Salzman wrote:
> I taught myself Perl DBI/sqlite yesterday. Very cool. Today I decided to
> play with sqlite using PHP. Unfortuantely, I'm not having much success with
> the PHP implementation.
the code you pasted was for php5, not the php4
Somewhere I can't find again.
There are several pages on how it all works:
http://sqlite.org/faq.html#q7
http://sqlite.org/lockingv3.html
"ALTER TABLE To change a table you have to delete it (saving its
contents to a temporary table) and recreate it from scratch."
This isn't good is it? I'm
Hi all,
I taught myself Perl DBI/sqlite yesterday. Very cool. Today I decided to
play with sqlite using PHP. Unfortuantely, I'm not having much success with
the PHP implementation.
Platform is GNU/Linux, Debian testing. Package is:
php4-sqlite 1.0.2-5 PHP4 bindings to SQLite, a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
D. Richard Hipp wrote:
| John Richard Moser wrote:
|
|>
|> I thought sqlite databases weren't supposed to be opened with two sqlite
|> processes at once. There are unimplemented locking commands due to this
|> right?
|>
|
| Where did you hear that?
|
John Richard Moser wrote:
I thought sqlite databases weren't supposed to be opened with two sqlite
processes at once. There are unimplemented locking commands due to this
right?
Where did you hear that?
Locking works great (and always has) on both unix and windows. If
you are running on
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I thought sqlite databases weren't supposed to be opened with two sqlite
processes at once. There are unimplemented locking commands due to this
right?
I'm bouncing back and forth in my head trying to decide if I should use
mysql or sqlite to write a
John Richard Moser wrote:
Is sqlite3_open() safe?
By safe, I mean does it create the database file with O_EXCL if it
doesn't exist, with permissions either matching umask() or with 0600
permissions? I don't want to encounter random races here.
SQLite databases are designed to be shared by two or
On Dec 24, 2004, at 9:56 AM, Dennis Cote wrote:
James Berry wrote:
I think I was most confused by was the use of the word "index" in the
documentation where associated with the bind calls. Index is a
misnomer. It should really be something like "parameter number" as
I've used it above, since index
James Berry wrote:
I think I was most confused by was the use of the word "index" in the
documentation where associated with the bind calls. Index is a
misnomer. It should really be something like "parameter number" as
I've used it above, since index to me implies the index of the
parameter
Dennis,
Thanks. You nicely clarified what the documentation didn't. I'd
actually been looking through the code when I got your mail, so I can
verify what you say. I'll summarize:
Accepted parameter binding syntax:
? - Positional parameter. This reference is assigned the next unused
Eli Burke wrote:
I can't tell you how all those variations behave, but I think that by
far the clearest/simplest functional form is plain :N. I'm sure there
are reasons for the other forms to exist (legacy style? oracle/mysql
compatability?), but from a programmatic standpoint:
INSERT INTO
LWL wrote:
> I am by no means an expert cryptographer (in fact, I am just learning
> cryptography) so there may be security flaws in the design of the
> encryption layer. Please help me learn by giving me constructive
> criticism and suggestions to improve the code.
>
A quick glance suggests that
(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 times N is only a numeric
integer, while at others it is a fully alphanumeric identifier. The
last ($) form, is hinted at only in the header file,
> ... in version 2 you could only access the ROWID
> if it had been declared in the CREATE TABLE
> statement
No, it's always available. You just have to ask for it:
select *, rowid from ...
Regards
On Friday, December 24, 2004, at 01:29AM, Will Leshner <[EMAIL PROTECTED]>
wrote:
>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
>>
Hi everyone,
This is my first post to this mailing list. I wrote an extension for
SQLite so that it supports encrypted databases. Existing software
based on SQLite with encryption capabilities were either too expensive
for the average non-professional user or did not suit my needs.
18 matches
Mail list logo