]>
To:
Sent: Thursday, April 05, 2007 12:05 PM
Subject: Re: [SQL] Insert only if not found
am Thu, dem 05.04.2007, um 11:47:35 +0200 mailte Shavonne Marietta
Wijesinghe folgendes:
I think i spoke to soon. It works. But if i change a letter from capital
to
simple it inserts my record 2 ti
It's also desirable that you use TRIM along with UPPER or LOWER.
Roger.
Don't pick lemons.
See all the new 2007 cars at Yahoo! Autos.
http://autos.yahoo.com/new_cars.html
---(end of
#x27; AND
TE_DTNASC='01/05/2006');
but this doesn't work. I don't know why. If i try only the part
SELECT upper(TE_COGNOME), upper(TE_NOME), upper(TE_SESSO), TE_DTNASC FROM
MOD48_02
it returns me the fields in UPPERCASE. It's really strange why it doens't
work
Hello everyone..
Here is the result of my Insert. and also the insert works ok.
INSERT INTO MOD48_02 (ID, TE_INDI, TE_COGNOME, TE_NOME, TE_SESSO, TE_ATTNASC,
TE_LUONASC, TE_DTNASC, TE_PROVSTATO, TE_PROV, TE_PATERNITA, TE_RICHIESTA,
USERNAME, DATE_INSERTED, TIME_INSERTED) VALUES ('12700120074510
am Thu, dem 05.04.2007, um 11:47:35 +0200 mailte Shavonne Marietta Wijesinghe
folgendes:
> I think i spoke to soon. It works. But if i change a letter from capital to
> simple it inserts my record 2 times. So i have 2 records for "Shavonne" and
> "shavonne". So i thought i would do the select i
wow thanks. i managed to paste it to fit my code..
yea ^^
Shavonne Wijesinghe
www.studioform.it
- Original Message -
From: "A. Kretschmer" <[EMAIL PROTECTED]>
To:
Sent: Thursday, April 05, 2007 10:53 AM
Subject: Re: [SQL] Insert only if not found
am Thu
am Thu, dem 05.04.2007, um 10:38:21 +0200 mailte Shavonne Marietta Wijesinghe
folgendes:
> Hello everyone..
>
> Here is the result of my Insert. and also the insert works ok.
>
> INSERT INTO MOD48_02 (ID, TE_INDI, TE_COGNOME, TE_NOME, TE_SESSO, TE_ATTNASC,
> TE_LUONASC, TE_DTNASC, TE_PROVSTAT
