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
>
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,
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
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
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
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
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!
7 matches
Mail list logo