Quotes missing around dates.
WHERE "2003-03-14" ...
Ignatius
- Original Message -
From: "Cory Hicks" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 9:05 PM
Subject: Finding an ID between two dates
> Hey folks!
>
> I a
In addition I would suggest to verify that your text file does not end with
a CR or LF character. This happens very often on Windows systems when for
instance saving an Excel sheet as a text file.
If you do not remove this last character(s), you risk inserting a blank row
in the DB.
Ignatius
It would be nice to have the possibility to exclude CREATE TEMPORARY TABLE
statements from the log bin.
Because such statements are really used not for updating a DB, but for
constructing intermediary statements that eventually derive in a final
INSERT/ UPDATE. I believe only this final statement
Syntax errors. Try:
SELECT studenti.*
FROM studenti LEFT JOIN valutazioni ON studenti.sid=valutazioni.sid
WHERE ISNULL( valutazioni.sid )
Ignatius
- Original Message -
From: "Francesco" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROT
