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 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
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
#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
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
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
]>
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