Re: [sqlite] [OT] Digest Attachments: why use them?

2003-10-25 Thread M. Fioretti
On Fri, Oct 24, 2003 20:45:11 at 08:45:11PM -0400, Mrs. Brisby ([EMAIL PROTECTED]) wrote: > Many users want to keep up with list-traffic but do not ordinarily need > to post to individual messages. > > Some users filter messages by hand- to make sure they don't miss > anything. > MMhh. The two

Re: [sqlite] Making sqlite support unicode?

2003-10-25 Thread M. Fioretti
On Fri, Oct 24, 2003 21:24:44 at 09:24:44PM -0400, Mrs. Brisby ([EMAIL PROTECTED]) wrote: > > FYI, nobody said internal use of "unicode" - just "UCS16". Plan9 > doesn't. Linux doesn't. Not correct, unless I misunderstood the original question. At least Red Hat started to use unicode (UTF-8?) as

Re: [sqlite] Alter Table?!

2003-10-25 Thread andr3a
I've implemented this sintax with few options on my PHP Class, if you're interested in syntax like this: ALTER TABLE tbl_name ADD column_name alter_specification [FIRST | AFTER column_name] or this: ALTER TABLE tbl_name DROP [COLUMN] col_name tell me. andr3a - Original Message - From:

Re: [sqlite] Alter Table?!

2003-10-25 Thread Bertrand Mansion
<[EMAIL PROTECTED]> wrote : > I've implemented this sintax with few options on my PHP Class, if you're > interested in syntax like this: > ALTER TABLE tbl_name ADD column_name alter_specification [FIRST | AFTER > column_name] > or this: > ALTER TABLE tbl_name DROP [COLUMN] col_name > tell me. Hi

Re: [sqlite] Alter Table?!

2003-10-25 Thread andr3a
I hope this's not spam, this is the url dedicated to my_sql.class.php , i wait for your feedback :-) ... or bugs report on dedicated session http://www.3site.it/DOCUMENTATION/index.php [ look at documentation for more info ] P.S. this class is on phpclasses.org too http://www.phpclasses.org/browse

[sqlite] Select as a column

2003-10-25 Thread Mitch Vincent
Again I find myself spoiled by PostgreSQL and it's nifty rewriting.. I'm trying to do this in SQLite : SELECT *,(SELECT count(*) FROM invoice_master WHERE invoice_master.customer_id = customers.customer_id) FROM customers as; It's giving me "no such column: customers.customer_id" and I underst

Re: [sqlite] Select as a column

2003-10-25 Thread Kurt Welgehausen
>> SELECT *,(SELECT count(*) FROM invoice_master WHERE >> invoice_master.customer_id = customers.customer_id) >> FROM customers as; You can't do correlated subqueries in SQLite, for the reasons given in the 'Features not supported' document. Try something like select customers.*, Icount from