--- John Stanton <[EMAIL PROTECTED]> wrote:
> I think you miss the point about Sqlite. It is just
> a part of your CGI
> program - you don't need any help from the ISP, just
> a directory with
> enough disk space for the Sqlite file. For a
> modestly sized web
> application it is a great
On Oct 7, 2005, at 10:21 PM, Joe Noon wrote:
I need to find all records where login has an underscore in them. I
know it has something to do with ESCAPE, since _ matches a single
character, but I cant seem to get the syntax correct. Here is what im
intending to do, even though this obviously
I need to find all records where login has an underscore in them. I
know it has something to do with ESCAPE, since _ matches a single
character, but I cant seem to get the syntax correct. Here is what im
intending to do, even though this obviously doesnt do it:
SELECT * from users where login
Jay Sprenkle wrote:
You might also consider NOT saving the image data in the database.
I've always found it better to save a path or URL in the database and store
the image in the file system. (Unless you're searching for things
in the image data itself and not just searching for an image using
Thanks very much for your help, Peter. Here is a variation that seems to
be working for me:
select sa.lg_abbr, sa.dbsource, sa.signid, sa.recid, sa.majorlvl,
sa.lvl6, j.imgfn from sampsign as sa left outer join sgnphoto as j on
sa.recid = j.recid where sa.dbsource = 'Smith' and sa.majorlvl =
Hi,
Is there a SQL query that returns the size in bytes a table occupies?
Thanks
Eno
I think you miss the point about Sqlite. It is just a part of your CGI
program - you don't need any help from the ISP, just a directory with
enough disk space for the Sqlite file. For a modestly sized web
application it is a great way of handling your data.
If you are using PHP you just
Hi,
IBM : powerpc-ibm-aix5.1.0.0
I did a lot of cleanup in environnemnts variables.
then
1 ) export OBJECT_MODE=64
2) I stick with a simple configure
./../sqlite-3.2.7/configure --disable--shared --disable-tcl
--disable-threadsafe --prefix=$PREFIX
3) in the Makefile put
-q64 -qlonglong for the
Jim McNamara wrote:
thanks john and clay-
it is good to know i have an option that works if i
need it. i think people can actually save a little
money that way. some hosts will offer php at a lower
price per month without the mysql db . when you
upgrade to get a mysql db included it costs
On 2005-10-07 at 11:11, http://tick/%7Egeocar/netmail/ws.cgi?action=v2;[EMAIL PROTECTED]">[EMAIL
PROTECTED] wrote:
"Mrs. Brisby" http://tick/%7Egeocar/netmail/ws.cgi?action=v2;[EMAIL PROTECTED]">[EMAIL
PROTECTED] wrote:
I had some MacOSX systems suffer a power failure, when they came
In epistula a Robert L Cochran, die horaque Thu, Oct 06, 2005 at 10:56:03PM
-0400:
> Hi --
>
> I'm inexperienced with joining tables and need help.
>
> I'm using SQLite v3.2.7 and the tables discussed below are part of an
> SQLite database.
>
> There are 2 tables: A contains some text columns
Thanks to all who replied. I really appreciate the great feedback!
I will probably end-up using something like the scheme offered below :-)
-Clark
- Original Message
From: Dan Kennedy <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Thursday, October 06, 2005 09:42:32
"Mrs. Brisby" <[EMAIL PROTECTED]> wrote:
> I had some MacOSX systems suffer a power failure, when they came back
> I made some copies of the database and: [integrity_check failed]
This suggests that you copied only the database file itself and
not its rollback journal. That can lead to
I have used Sqlite in a web application. It is called from C language
CGI programs running under Apache and performs very well. Its
simplicity and the fact that it only involves one file and is linked
with the CGI process makes it very appropriate for the short sessions
inherent with CGI.
I had some MacOSX systems suffer a power failure, when they came back I made
some copies of the database and:
sqlite PRAGMA integrity_check;
*** in database main ***
On tree page 39134 cell 65: 2nd reference to page 33247
On tree page 39134 cell 65: Child page depth differs
On tree page 39134
On 10/6/05, Robert L Cochran <[EMAIL PROTECTED]> wrote:
>
> I want to craft an SQL query that will return every row in A having a
> primary key that does not match the keys in the rows in B. Then display
> these rows on a web page form. I eventually tried doing a left outer
> join of A and B:
I've just built SQLite 3.2.7 on HP-UX 11 in 64-bit mode.
Loading 1000 000 records into a simple table (using .read
from SQL script with inserts, 1 in a single transaction)
took 5 min 40 s (the same in 32-bit - 06:29) and creating
index 56 s (01:14 for 32-bit). Unfortunately, this is
heavily
Jim McNamara said:
> i dont see many webhosts that advertise sqlite
> availability. are webhosts excluding support for
> sqlite for any reason
> i.e. is it a security concern?
> it is suppose to be an internal extension. i am not
> sure what that means yet.
Because SQLite doesn't have a
On Thu, 6 Oct 2005, Will Leshner wrote:
>
>On Oct 6, 2005, at 10:57 AM, [EMAIL PROTECTED] wrote:
>
>> Figure 10 to 20 microseconds per opcode. I'd say around 100.
>>
>
>Thanks. That makes sense.
>
>> Please note that the counter resets with each call to sqlite3_step().
>
>That is very good to
I have an AMD 64 machine myself. Do I need to pass any special to
compile in 64 bit mode?
Bob
[EMAIL PROTECTED] wrote:
Hamid Benhocine <[EMAIL PROTECTED]> wrote:
I want just to know if the Engine is 64
bits ready
SQLite is designed to work on 64-bit machines. There
have been a
Hamid Benhocine <[EMAIL PROTECTED]> wrote:
> I want just to know if the Engine is 64
> bits ready
SQLite is designed to work on 64-bit machines. There
have been a few alignment problems in the past but those
have all been worked out now, I believe. I do not have
a 64-bit machine to test on,
On Thu, 6 Oct 2005, Brett Wilson wrote:
> I believe saying "GROUP BY a.primarykey" clause at the end of your
> query will do what you want. It's explained in
I would try something like:
select sa.dbsource, sa.signid, sa.recid, sa.majorlvl, sa.lvl6
from sampsign sa
where sa.dbsource = 'Smith'
22 matches
Mail list logo