Re: [sqlite] Adding data to the end of a column

2008-01-30 Thread Shawn Milochik

-Original Message-
From: jose isaias cabrera <[EMAIL PROTECTED]>
Subject: [sqlite] Adding data to the end of a column
Date: Wed, 30 Jan 2008 14:34:17 -0500


Is there a way to add data to the end of a field?  I know I select that 
field, import the data into a variable and then add whatever to the end. 
What I am trying to do is exactly NOT that. :-)  So, instead, just add say a 
line or two of text to a field.

Is this possible?




UPDATE tablename SET something = something + " addition";

Not sure of the exact syntax for contacenation -- could be + or . or something 


To unsubscribe, send email to [EMAIL PROTECTED]

[sqlite] (Solution) Using sqlite from PHP on Bluehost (and maybe your Web host)

2008-01-22 Thread Shawn Milochik
I use for Web hosting. Overall they're great, but every
once in a while there's a roadblock like this. Happily, this one was
solved (using their knowledge base, no less), and I thought I'd share it
in case others find it useful.

No matter what method I used to try to connect to a sqlite database in
PHP, I would receive an error, because PHP wasn't grokking sqlite or

The procedure I followed (on Bluehost) is below. Adapt the steps as
necessary to suit yourself. This method requires ssh access (a feature
which is one of the main reasons I use Bluehost).

1. ls /usr/lib/php/extensions/no-debug-non-zts-*
This revealed and files in the
directory /usr/lib/php/extensions/no-debug-non-zts-20060613.

2. Modify my local php.ini:

Add these lines:

Change this line:
extension_dir = ./ 


extension_dir = /usr/lib/php/extensions/no-debug-non-zts-20060613

I hope this spares other people hours of frustration.


To unsubscribe, send email to [EMAIL PROTECTED]

[sqlite] Sqlite in Python on Bluehost Web hosting

2007-12-17 Thread Shawn Milochik
I searched the archives, but couldn't find a way to fix this on my own.

I use for Web hosting. I like Python. I like Sqlite. I'm trying
to use the three together.

Bluehost supports Python, and sqlite is installed. I have ssh access.
However, there is no pysqlite2 or apsw support built in to their Python
installation. I tried installing pysqlite2 myself (my preferred method), and
also apsw, but they error out for dependency reasons that I can't fix.

I have sent a help desk ticket into Bluehost asking for them to install
pysqlite2, but I'm not terribly hopeful. Does anyone know how to get sqlite
support in Python working within a home directory on Linux without having
root access?


[sqlite] ShawnMilo intro

2007-11-28 Thread Shawn Milochik
Hi. I just joined the list. I'm a developer who mainly works on the Linux
command line with Makefiles, Perl one-liners, and some Perl and Python
scripts. Nearly 100% of what I do is processing tab-delimited files.

I live in Reading, PA. My main hobby is magic -- the art of illusion, not
the card game.

I have a couple of questions, but I am going to lurk a bit first. However,
is there an archive? I didn't receive one by e-mailing the automated help
address for this list. I'd like to see if the answers are there first.