Re: [sqlite] Leaving List?

2005-03-30 Thread Peter Jay Salzman
On Wed 30 Mar 05, 11:20 AM, Richard Thomas <[EMAIL PROTECTED]> said: > Hi; > I've got to leave the list for some time. My system crashed big time and > I've lost all my e-mail list controls for all my lists. How do I turn off my > subscription? > Thanks > Rick of Farmington Mich. U > SA Hi

[sqlite] DB agnostic auto_increment

2005-03-19 Thread Peter Jay Salzman
Hi all, I'd like to write database agnostic SQL. The SQL itself isn't complicated, so I'm hoping it's possible. One thing that I can't seem to get around is auto_increment. According to the SQLite FAQ, auto_increment can be simulated by declaring: CREATE TABLE 'wheatblog_categories' (

Re: [sqlite] Single quotes are causing misery

2005-03-17 Thread Peter Jay Salzman
On Thu 17 Mar 05, 4:10 PM, Reid Thompson <[EMAIL PROTECTED]> said: > > > I read that in a NSP book awhile ago (Linux Cookbook). It's > > faster than "%s/ //g". Very handy. But which problem does this > > address? :) > > > > Pete > > This is some PHP code on Linux. I suspect it was

Re: [sqlite] Single quotes are causing misery

2005-03-17 Thread Peter Jay Salzman
On Thu 17 Mar 05, 2:26 PM, Reid Thompson <[EMAIL PROTECTED]> said: > Peter Jay Salzman wrote: > > Hi Mike, > > > > To be perfectly honest, other than being a Microsoft thing, I > > don't really know what .NET is. Pretty pathetic, huh? :) > > > &g

Re: [sqlite] Single quotes are causing misery

2005-03-17 Thread Peter Jay Salzman
t; > A solution is to use stripslashes() on the incoming variables if > get_magic_quotes_gpc() returns 1, since you cant change magic_quotes_gpc > at runtime. > Alternatively, you can alter php.ini, but that's usually not practical. > > Eugene Wee > > Peter J

Re: [sqlite] Single quotes are causing misery

2005-03-17 Thread Peter Jay Salzman
Hi Mike, To be perfectly honest, other than being a Microsoft thing, I don't really know what .NET is. Pretty pathetic, huh? :) This is some PHP code on Linux. I suspect it was originally written on a Microsoft operating system because when I edit the files, my editor reports the textfiles as

[sqlite] Single quotes are causing misery

2005-03-16 Thread Peter Jay Salzman
I've nearly completed converting Wheatblog to sqlite. It's been quite a learning experience! I've come across a problem I haven't been able to figure out, though. Whenever I made a blog post that had a forward quote character (') in either the title or the body of the post, I'd get an error.

[sqlite] mysql_insert_id()

2005-03-15 Thread Peter Jay Salzman
Sorry to ask this, but I just want to make sure there aren't any surprises. There's a mysql function: mysql_insert_id( $db_handle ); that returns the ID number of an AUTO_INCREMENT column by the previous INSERT query. I've replaced the call with a sqlite call that sounds like it does the

Re: [sqlite] Conversion mysql -> sqlite

2005-03-15 Thread Peter Jay Salzman
On Tue 15 Mar 05, 9:36 PM, Rob Laveaux <[EMAIL PROTECTED]> said: > > On 15-mrt-05, at 21:26, Peter Jay Salzman wrote: > > >It appears that the error is a "syntax error" near where my arrow > >(<--) > >is. Can someone throw some charity my w

[sqlite] Conversion mysql -> sqlite

2005-03-15 Thread Peter Jay Salzman
Hi all, I know very little about mysql and sqlite - I've only played around a little bit with databases, so I'm a newbie in this area. There's a blogger called Wheatblog that I've been trying to convert from mysql to sqlite so I don't have to run a full RDMBS deamon on my underpowered machine

[sqlite] php4/sqlite - sqlite_escape_string doesn't function

2004-12-24 Thread Peter Jay Salzman
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),

[sqlite] sqlite/php - Having trouble getting started

2004-12-24 Thread Peter Jay Salzman
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