as
follows:
You have an error in your SQL syntax near '(Date as varchar(11)) Date,
Artist, Country, RecordCompany, CatalogueNumber, Com' at line 1
Can anyone help me with the cast() function. I have gotten this to work on
an internal MSSQL server but not on the MySQL server.
thanks
Morgan Bardon
Thanks for that, but I get a NULL entry in the field then for all the dates.
- Original Message -
From: Moreno Riccardi [EMAIL PROTECTED]
To: Morgan Bardon [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, July 25, 2003 4:34 PM
Subject: R: [PHP-DB] MYSQL and PHP cast() function
have also renamed the column to ReleaseDate in case there was a problem
using a reserved word and there was still no fix.
- Original Message -
From: CPT John W. Holmes [EMAIL PROTECTED]
To: Morgan Bardon [EMAIL PROTECTED]; Moreno Riccardi
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday