Re: [sqlite] Let us make SQLite more powerful

2003-12-12 Thread Mrs. Brisby
On Fri, 2003-12-12 at 08:09, Yogesh Vachhani wrote: > For example, if the Phones column is a collection, one can find all > rows that contain the phone number 206-481-4442 by specifying the > following SELECT statement: > > SELECT LastName > FROM Contacts >

[sqlite] ITIS example : Error404

2003-12-12 Thread Pierre-Yves Delens
Bonjour, I'm looking for the PySqLite example ITIS, which should be on http://pysqlite.sourceforge.net/examples. But this page is missing. Can someone help ? Thanks on forward (NB : for Calflora example, it is OK : I do have it) ___ P-Y Delens,

[sqlite] Let us make SQLite more powerful

2003-12-12 Thread Yogesh Vachhani
Hello everyone, This is espcially for Dr. Hipp. First I will try to highlite the reasons as to why I am raising this topic just to establish proper grounds for what I am going to Say and Suggest. I am a software developer using VB as my main development tool and an trying to learn Delphi but

[sqlite] RE: special chars in sql query

2003-12-12 Thread Fitzharris, Jason
Add an additional quote, so instead of 'Tom's', use 'Tom''s' Regards, Jason. -Original Message- From: Gianmaria [mailto:[EMAIL PROTECTED] Sent: 12 December 2003 12:41 To: [EMAIL PROTECTED] Subject: special chars in sql query hi, i've a little issue to ask, how can i set a text field or

[sqlite] RE: select on 2 tables

2003-12-12 Thread Fitzharris, Jason
You are doing a cross-join which returns one row for each possible pairing of rows from the two tables. To correct use an inner join alike select t1.a,t1.b,t2.n,t1.c,t1.d,t1.e from t1,t2 where t1.a = t2.a limit 3 or like select t1.a,t1.b,t2.n,t1.c,t1.d,t1.e from t1 inner join t2 on t1.a = t2.a

RE: [sqlite] special chars in sql query

2003-12-12 Thread Dewang Shah
escape the ' as '' - thats two 's for the ' you want in your data. INSERT INTO albums VALUES (1, 'Tom''s Diner'); Regards, Dewang Shah Directi Quidquid latine dictum sit, altum sonatur. Whatever is said in Latin sounds profound. -Original

[sqlite] special chars in sql query

2003-12-12 Thread Gianmaria
hi, i've a little issue to ask, how can i set a text field or a record via sql query when in the string there's the ' char? i'd like not to substitute this symbol with another one. for example when i have in the sql 'Tom's' he thinks that the string is 'Tom' Excuse me for the stupid question!