HI, JC
I use php_do_sqlite with PHP 5.1.4 and Sqlite 3.2.8 on Windows XP. The
following is my coding:
setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$myPre = $myConn->prepare('update test_item set balqty = 100');
$myPre->execute();
}catch (PDOException $e){
die('execute err: '.$e->g
* Clay Dowling:
> [EMAIL PROTECTED] at least does have an auto-responder. The message
> contains the text of any message sent to it, appended to the bottom of
> the email. That would serve to automatically validate the check
> email.
In my experience, the real problem with ezmlm's subscription
yuyen wrote:
> Hi, all
>
> I try to use php_pdo_sqlite in php which is a sqlite of version 3.2.8. With
> php_pdo, it provides PREPARE and EXECUTE functions to prepare an sql at first
> then which can execute later. But it seems that the php_pdo_sqlite.dll
> doesn't support it. Or I may do somth
unsubscribe
Now here's a "class" of messages it would be nice to "trash." It ain't
spam, but it looks like it, smells like it, and is as useful. Even if it
is unintentional.
> -Original Message-
> From: Sankara Narayanan [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, May 31, 2006 6:33 PM
> To: sqlite-u
Dennis Cote <[EMAIL PROTECTED]> wrote:
> So far Richard has been quite benevolent.
>
It is easy to be benevolent when you have no real power.
Nevertheless, your ruler thanks you for your kind
remarks.
;-)
--
D. Richard Hipp <[EMAIL PROTECTED]>
"Preston & Chrystie" <[EMAIL PROTECTED]> wrote:
> If I have never set the user_version will the value always be 0?
It will unless somebody else sets it ;-)
>
> I plan to start using user_version in my app, I will need to set this
> value to a approprate value if it has not yet been set, and i a
Hi, all
I try to use php_pdo_sqlite in php which is a sqlite of version 3.2.8. With
php_pdo, it provides PREPARE and EXECUTE functions to prepare an sql at first
then which can execute later. But it seems that the php_pdo_sqlite.dll doesn't
support it. Or I may do somthing wrong. If there is a
On 5/31/06, René Tegel <[EMAIL PROTECTED]> wrote:
Eugene Wee schreef:
>
> Oh, and if one's email address is [EMAIL PROTECTED], according to
> one of the first few emails I received from the mail manager, another
> way to unsubscribe is to send an email to:
> [EMAIL PROTECTED]
Interesting.. thi
If I have never set the user_version will the value always be 0?
I plan to start using user_version in my app, I will need to set this
value to a approprate value if it has not yet been set, and i am just
double checking that it is always 0 untill i set it.
Anybody have a better way to hold onto
Eugene Wee schreef:
Oh, and if one's email address is [EMAIL PROTECTED], according to
one of the first few emails I received from the mail manager, another
way to unsubscribe is to send an email to:
[EMAIL PROTECTED]
Interesting.. this suggest that anyone could easily unsubscribe any
other l
I will be out of the office starting 2006-05-31 and will not return until
2006-06-02.
I am on leave for two days (31st May and 1st June). I will not be having
access to the mails in this time. I will respond to your mails when I
return on Friday 2nd June. You could reach me on my mobile +91-994
Dennis Cote wrote:
Dennis Jenkins wrote:
There are probably many pre-existing web sites where anyone can create
an poll they want, so it might take less than 10 minutes to construct
a poll and post a url. Then again, I could be delusional ;)
Dennis,
Then you should go ahead and give it a go
Dennis Jenkins wrote:
There are probably many pre-existing web sites where anyone can create
an poll they want, so it might take less than 10 minutes to construct
a poll and post a url. Then again, I could be delusional ;)
Dennis,
Then you should go ahead and give it a go. If it will only tak
On 5/31/06, Dennis Jenkins <[EMAIL PROTECTED]> wrote:
There are probably many pre-existing web sites where anyone can create
an poll they want, so it might take less than 10 minutes to construct a
poll and post a url. Then again, I could be delusional ;)
yahoo groups will do it quickly but you
you should change this:
rc = sqlite3_exec(memdb, "insert into dummy values (\"dummy\", \"user\")",
to this:
rc = sqlite3_exec(memdb, "insert into dummy values ('dummy', 'user')",
You need single quotes for strings
On 5/31/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I am pretty sure it i
[EMAIL PROTECTED] wrote:
I am pretty sure it is something trivial but it does not work for me, can
someone please help me figure out what I may be missing.
strcpy( query, "select count(*) from dummy");
rc = sqlite3_prepare( memdb, query, strlen(query), &pStmt, NULL);
if (rc) {
return;
Mario.Hebert-/9DqrJztSFFWk0Htik3J/[EMAIL PROTECTED] wrote:
Ok it makes sense, but how can I get the number of rows in my query
then ?
sqlite3_column_int
Igor Tandetnik
Ok it makes sense, but how can I get the number of rows in my query then ?
Thanks,
Mario Hebert
Legerity
> strcpy( query, "select count(*) from dummy");
> rc = sqlite3_prepare( memdb, query, strlen(query), &pStmt, NULL);
> rc = sqlite3_bind_text( pStmt, 1, query, strlen(query),
> SQLITE_STAT
Dennis Cote wrote:
> Dennis Jenkins wrote:
>> Maybe someone could create a simple web site that lets us vote on the
>> suggestions?
>>
> Unfortunately (or perhaps not) Richard runs SQLite and its related
> community more like a benevolent dictatorship than a democracy. :-)
>
> I believe he liste
Mario.Hebert-/9DqrJztSFFWk0Htik3J/[EMAIL PROTECTED] wrote:
I am pretty sure it is something trivial but it does not work for me,
can someone please help me figure out what I may be missing.
What happens is that the call to sqlite3_bind_text returns error 25
(SQLITE_RANGE).
strcpy( query, "selec
I am pretty sure it is something trivial but it does not work for me, can
someone please help me figure out what I may be missing.
What happens is that the call to sqlite3_bind_text returns error 25
(SQLITE_RANGE). This is caused because p->nVar is set to 0 and I am
passing 1.
How can I know ho
As with all benevolent dictatorships, everything goes relatively
smoothly as long as the dictator remains benevolent. So far Richard has
been quite benevolent.
Definitely! One of the most pleasant individuals I've worked with.
Thanks DRH! For all your hard work and tolerance!
Especially the tole
Dennis Jenkins wrote:
Maybe someone could create a simple web site that lets us vote on the
suggestions?
Unfortunately (or perhaps not) Richard runs SQLite and its related
community more like a benevolent dictatorship than a democracy. :-)
I believe he listens to the responses (especially
Dennis Cote wrote:
>
> I think an opt in mechanism with a CAPTCHA to allow an account to
> continue to post to the list that is triggered every couple of months
> wouldn't be a burden to those actively posting. First time or
> occasional poster would receive an email when they try to post that
> wo
Clark Christensen wrote:
>> And yet somehow, the spammer still managed to get signed up
>> using a "paypal.com" address. How did they do that?
>> --
>>
>
> As others have pointed-out, there's probably a simple autoresponder on many
> [EMAIL PROTECTED] mailboxes. It replied, and that was goo
The real [EMAIL PROTECTED] wrote:
>And yet somehow, the spammer still managed to get signed up
>using a "paypal.com" address. How did they do that?
Perhaps the spoofed an address that *is* subscribed to the list?
-jonathan
On Wed, May 31, 2006 at 01:42:48PM -0500, Bob Dankert wrote:
> Especially considering they are all spelling the word wrong with the
> same mis-spelling.
Wild guess: the list actually receives a lot more of these messages
than you see, but mailman has the ability to filter out messages that
were ob
Taking a quick look at the page on the SQLite website that tells about the
mailing list:
http://www.sqlite.org/support.html
It seems that nothing is said about how to unsubscribe. The 'List-Unsubscribe'
mail header has the email address:
[EMAIL PROTECTED]
I think that that webpage should be u
Yet another mailing list weakness: One must be able to spell to
unsubscribe! :-)
> -Original Message-
> From: Bob Dankert [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, May 31, 2006 1:43 PM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] unsuscribe
>
>
> Especially considering they ar
Brandon, Nicholas (UK) wrote:
So +1 for moderated posting status *only* if its done without additional
effort of the poster (human moderator?).
Brandon,
Are you volunteering for the human moderator job?
I'm sure that Dr. Richard Hipp's time is worth much more doing something
(perhaps any
yeah didnt even notice that, glad i got it right, thank god for the spell
checker!! lol.
On 31/05/06, Bob Dankert <[EMAIL PROTECTED]> wrote:
Especially considering they are all spelling the word wrong with the
same mis-spelling.
-Original Message-
From: John Newby [mailto:[EMAIL PROTEC
Especially considering they are all spelling the word wrong with the
same mis-spelling.
-Original Message-
From: John Newby [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 31, 2006 1:25 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] unsuscribe
whats with all these unsubscribe messag
whats with all these unsubscribe messages, they're beginning to do my head
in now!!!
On 31/05/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]>
wrote:
unsuscribe
unsuscribe
unsuscribe
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.7.1/348 - Release Date: 25/05/2006
Anyone know where SQLite is going?
Is there a roadmap for features?
--
View this message in context:
http://www.nabble.com/What%27s+planned+in+the+next+major+release+of+SQLite--t1711756.html#a4647686
Sent from the SQLite forum at Nabble.com.
Unit 5 wrote:
What happens when your SQL query includes any of these:
select 'abc' as my_literal;
The original poster specifically wanted to, quote, "get the fields of a
table", unquote. Not of an arbitrary select statement.
Igor Tandetnik
How about asking a new subscriber to copy some magic number
from the body to the subject of his reply? AFAIK autoresponders
can't do that.
Kind regards
Ulrich
On Wednesday 31 May 2006 17:17, Clark Christensen wrote:
> > And yet somehow, the spammer still managed to get signed up
> > using a "pa
Igor Tandetnik <[EMAIL PROTECTED]> wrote: Michele Simionato
wrote:
> I forgot to say that I would like a solution working from sqlite3, the
> console, not from the
> programming interface.
PRAGMA table_info(tableName);
Igor Tandetnik
What happens when your SQL query includes any of
Michele Simionato said:
> I forgot to say that I would like a solution working from sqlite3, the
> console, not from the
> programming interface. For instance, I may want to pipe the SQL code to
> sqlite3 from a CGI script, or just make some interactive exploration.
You don't want this. You ma
Michele Simionato
<[EMAIL PROTECTED]> wrote:
I forgot to say that I would like a solution working from sqlite3, the
console, not from the
programming interface. For instance, I may want to pipe the SQL code
to sqlite3 from a CGI script, or just make some interactive
exploration.
PRAGMA table_i
On 5/31/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
Michele Simionato
<[EMAIL PROTECTED]> wrote:
> Just a quick question, how do I get the fields of a table, i.e. the
> equivalent of
> PostgreSQL "select column_name from information_schema.columns where
> table_name = '%s' "?
Use sqlite3_colu
> And yet somehow, the spammer still managed to get signed up
> using a "paypal.com" address. How did they do that?
> --
As others have pointed-out, there's probably a simple autoresponder on many
[EMAIL PROTECTED] mailboxes. It replied, and that was good enough :-)
I think if the list confirm
Michele Simionato
<[EMAIL PROTECTED]> wrote:
Just a quick question, how do I get the fields of a table, i.e. the
equivalent of
PostgreSQL "select column_name from information_schema.columns where
table_name = '%s' "?
Use sqlite3_column_table_name[16]. Prepare a query of the form "select *
fro
Just a quick question, how do I get the fields of a table, i.e. the
equivalent of
PostgreSQL "select column_name from information_schema.columns where
table_name = '%s' "?
Thanks,
Michele Simionato
Just a note for anyone interested, I originally took the Windows DLL 3.3.5
and benchmarked a particular query. Takes 2.4 seconds on a reasonable
dataset.
Took the src, compiled up in VS.NET 2003, with lots of speed optimisations,
Pentium 4 and above, SSE on etc.
Same query takes 1.6 seconds, so
I use the Finisar src (taken from CVS so it has all the latest bug fixes),
.NET 1.1 SP1 and SQLite 3.3.5 (compiled up myself from source with compiler
speed and pentium 4 optimisations on) and have no issues at all.
But your mileage may vary.
--
View this message in context:
http://www.nabble.
"Eggert, Henri" <[EMAIL PROTECTED]> wrote:
> How does sqlite recognize a boolean value ?
> Does sqlite know that bool , Bool , boolean ... are booleans ?
>
There is not a separate boolean datatype. SQLite just happens
to have a more efficient storage mechanism for integer values
0 and 1. Prior
Hi Mikey and Jon,
A personal comment: For .NET 1.1. and SQLite 3.3.5 I have recently had
_major_ problems with http://sourceforge.net/projects/adodotnetsqlite
(see previous posts on this list with subject 'Possible bug in
sqlite3_prepare').
I haven't been able to verify that the bug actually orig
How does sqlite recognize a boolean value ?
Does sqlite know that bool , Bool , boolean ... are booleans ?
Thank's
Henri
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 31. Mai 2006 15:04
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Bin
On 5/30/06, womble <[EMAIL PROTECTED]> wrote:
Hi Ive just converted a script from mysql to sqlite using php 5.1.4.
Running the script like..
php script.php
works fine but I need it run from cron, if I do..
10 14 * * * php -q /var/www/html/script.php
It cant find the db file errors like...
For .NET 1.1 this works quite well.
http://sourceforge.net/projects/adodotnetsqlite
I use this on many projects. Works for me using SQLite 3.3.5
I have the full source if you want it, including some bug fixes.
For .NET 2.0 there is this:
http://sqlite.phxsoftware.com/
Never used it but beli
Dennis Jenkins <[EMAIL PROTECTED]> wrote:
>
> I have recently updated my development branch from v 3.2.1 to v 3.3.5
> and noticed the compatibility issue as well. What are the key
> differences between the two file formats? Is there a compelling reason
> to move to the new format (vs using the p
Hi Jon,
I can recommend Mono.data.SqliteClient.
/Michael
-Original Message-
From: Jon García de Salazar Bilbao [mailto:[EMAIL PROTECTED]
Sent: 31. maj 2006 13:40
To: sqlite-users@sqlite.org
Subject: [sqlite] .NET bindings or Csharp wrapper
Hi,
Does anyone know any .NET binding (or Csh
[EMAIL PROTECTED] wrote:
> Nikki Locke <[EMAIL PROTECTED]> wrote:
>
>
> 3.2.2 will refuse to read a database file created by 3.3.5
> unless version 3.3.5 was compiled with -DSQLITE_DEFAULT_FILE_FORMAT=1
> or the "PRAGMA legacy_file_format=ON" pragma is used prior to creating
> the database. But
Hi,
Does anyone know any .NET binding (or Csharp wrapper) for SQLite besides
SQLiteDotNet?
Thanks in advance, Jgdsb.
Nikki Locke <[EMAIL PROTECTED]> wrote:
> I am running sqlite 3.3.5 on Microsoft Windows, and sqlite 3.2.2 on CentOS
> (because that's the version that comes with CentOS).
>
> Should the data files produced by these two versions be binary compatible?
> I.e. can I transfer the db files between the
I am running sqlite 3.3.5 on Microsoft Windows, and sqlite 3.2.2 on CentOS
(because that's the version that comes with CentOS).
Should the data files produced by these two versions be binary compatible?
I.e. can I transfer the db files between the two machines and continue to
use them with the
59 matches
Mail list logo
