unsuscribe
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
btw Im using
PECL Module version 2.0-dev $Id: sqlite.c,v 1.166.2.13 2006/04/18 14:30:15
iliaa Exp $
SQLite Library 2.8.17
SQLite Encoding iso8859
--
View this message in context:
http://www.nabble.com/Cant+find+sqlite+db+from+cron-t1708143.html#a4637538
Sent from the SQLite forum at Na
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...
Warning: sqlite_query(): no such table: *** in /
"Sleigher, William H." <[EMAIL PROTECTED]> wrote:
> I am using tcl8.4.6 and have upgraded my sqlite from sqlite-2.8-13 to
> sqlite-3.3.5. I originally tried to update my tcl8.4.6 to tcl8.4.11 and
> could not get my application to run. I can get my application to come
> up with tcl8.4.6 and the sq
The database version does not impact performance much.
You can verify this yourself by converting your database files to
the 3.3.5 format.
I'm guessing that you are seeing a difference in query performance
between 3.2.1 and 3.3.5. Much code has changed between these two
versions, including the a
For a single-threaded application, is there some performance benefit to
compiling SQLite3 with the THREADSAFE=0 option? The only thing I do in a
multi-threaded situation is inserts, and I'm wondering if I'm not better off
just multiplexing them myself so that I only have to worry about one
transac
Sorry, sqlite3_bind also.
For the benefit of the original poster the API call which implements a
callback is implemented with sqlite3_prepare etc.
[EMAIL PROTECTED] wrote:
Have not you forgot the bind ?
Mario Hebert
Legerity
John Stanton <[EMAIL PROTECTED]>
05/30/2006 04:55 PM
Please res
Have not you forgot the bind ?
Mario Hebert
Legerity
John Stanton <[EMAIL PROTECTED]>
05/30/2006 04:55 PM
Please respond to
sqlite-users@sqlite.org
To
sqlite-users@sqlite.org
cc
Subject
Re: [sqlite] SQLite without callback function
Use sqlite3_prepare, sqlite3_step, sqlite3_reset and s
Use sqlite3_prepare, sqlite3_step, sqlite3_reset and sqlite3_finalize.
[EMAIL PROTECTED] wrote:
I think I know the answer to this but I figured it would be better to ask
than to do a major design flaws. :)
What is the most efficient way in SQLite (using the C/C++ interface layer)
to retrieve
I am using tcl8.4.6 and have upgraded my sqlite from sqlite-2.8-13 to
sqlite-3.3.5. I originally tried to update my tcl8.4.6 to tcl8.4.11 and
could not get my application to run. I can get my application to come
up with tcl8.4.6 and the sqlite-3.3.5 with some problems. After
changing application
On 5/30/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I think I know the answer to this but I figured it would be better to ask
than to do a major design flaws. :)
What is the most efficient way in SQLite (using the C/C++ interface layer)
to retrieve the result of a query without using the ca
I think I know the answer to this but I figured it would be better to ask
than to do a major design flaws. :)
What is the most efficient way in SQLite (using the C/C++ interface layer)
to retrieve the result of a query without using the callback function
(setting it to NULL) ?
Thanks,
Mario H
>+1 for moderated posting status after days, -10 for all of the
>other suggestions that will cause me to jump through hoops to stay
subscribed.
I would imagine 95% of the content of this list is done by 20 or so
posters. I'm not one of them.
For similar reasons for staying subscribed, I do
I have to agree as well - Quite frequently I am just too busy to read
the list, other times I get a wealth of information from the list. I
would hate to get unsubscribed because I was too busy to reply to a
message. Plus, I archive all of my messages in the list so I can search
for previous infor
Jay Sprenkle wrote:
On 5/30/06, Eric Scouten <[EMAIL PROTECTED]> wrote:
I agree with Jay. I'd hate to have to respond to an e-mail ping every
so often just to continue reading the list.
On the other hand, I wouldn't mind terribly if I got placed on
"moderated" status (i.e. had to go through a v
On 5/30/06, Eric Scouten <[EMAIL PROTECTED]> wrote:
I agree with Jay. I'd hate to have to respond to an e-mail ping every
so often just to continue reading the list.
On the other hand, I wouldn't mind terribly if I got placed on
"moderated" status (i.e. had to go through a verification step in
o
I agree with Jay. I'd hate to have to respond to an e-mail ping every
so often just to continue reading the list.
On the other hand, I wouldn't mind terribly if I got placed on
"moderated" status (i.e. had to go through a verification step in
order to *post* to the list) if I were either (a
Unsubscribe
* Jay Sprenkle <[EMAIL PROTECTED]> [2006-05-30 17:00]:
> You could sign up an autoresponder email account (like paypal)
> and it would stay signed up forever. It would always respond to
> the query email with a reply including the original text of the
> message. You'd need to set it up so they had
On 5/30/06, Eugene Wee <[EMAIL PROTECTED]> wrote:
Hi,
Basically, what I imagined from DRH's original proposal was that accounts that
have not sent out mails after some period of time would receive an email
informing them that they will be unsubscribed unless they send a mail to the
mailing list,
BUT, the spammers ARE posting...
> -Original Message-
> From: Jay Sprenkle [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 30, 2006 8:46 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Purging the mailing list roles. Was: Please
> Restore Your Account Access
>
>
> On 5/29/06, [EMAI
Hi,
Basically, what I imagined from DRH's original proposal was that accounts that
have not sent out mails after some period of time would receive an email
informing them that they will be unsubscribed unless they send a mail to the
mailing list, or they reply to this notification email, withi
>
> I wonder if I need to implement some kind of mechanism that requires
> you to either send a message to the mailing list or else renew your
> subscription every 3 months. Does anybody have any experience with
> other mailing lists that require such measures?
>
As most people, they are either
On 5/29/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I wonder if I need to implement some kind of mechanism that requires
you to either send a message to the mailing list or else renew your
subscription every 3 months. Does anybody have any experience with
other mailing lists that require s
On 5/29/06, Mikey C <[EMAIL PROTECTED]> wrote:
I am using a web front end to display paged results. I need to tell the
user how many records there are in total, how many pages and which page they
are viewing.
I would like to use the LIMIT keyword to restrict the result using the two
parameters
On May 30, 2006, at 3:05 AM, Noel Frankinet wrote:
Hello Rusty,
Exactly what I was looking for
I've seen the PRAGMA TEMP_STORE to create a memory table.
Do you think I can join a memory table and a disk based one ?
Anyway, thank a lot
Best wishes
Of course you can do that.
Rusty
--
Rusty C
[EMAIL PROTECTED] wrote:
> Hello Paul Bohme,
>
> Could u please send me across the patch for cross compiling configure
> script sqlite for ARM + Linux, which u might hav given to ben.
>
> it would be a great help.
> thanks and awaiting for the reply.
>
For cross-compiling, your best bet is to
Rusty Conover wrote:
Using a temporary table seems to be the best way when you have lots
of keys. Of course there is a tradeoff point, such as for 1 or 2
rows a temporary table is overkill. Also it depends on if you're
temporary table is being stored in memory or on the disk, check the
On May 30, 2006, at 1:36 AM, Noel Frankinet wrote:
Hello All,
since nobody has answered my last question, I'll try to rephrase it :
How do you select record you have the keys (and I mean a lot of keys)
I know
SELECT .. WHERE rowid=
SELECT .. WHERE rowid IN (something like that)
SELECT ... WHAR
Hello All,
since nobody has answered my last question, I'll try to rephrase it :
How do you select record you have the keys (and I mean a lot of keys)
I know
SELECT .. WHERE rowid=
SELECT .. WHERE rowid IN (something like that)
SELECT ... WHARE rowid BETWEEN ...
Is there another way, does a temp
We have recompiled several applications with new sqlite 3.3.5 library.
We have observed that one of these application, which access intensively
(read-only) a large number (around 180) of old sqlite 3.2.1 db-files (4
million records, 2GB, each) runs now much slower.
These files are updated sporadic
31 matches
Mail list logo
