Hi all,
I'm having a problem with updating a simple date field in MS Access.
The problem lies where I try to pass an empty string and it comes up with an
ODBC error even though the field is NOT required.
The code is:
<cfquery datasource="#dsn#">
UPDATE VintageReport
SET Yields = #Form.Yields#,
Rainfall = #Form.Rainfall#,
Sunshine = #Form.Sunshine#,
Flowering = '#Form.Flowering#',
Veraison = '#Form.Veraison#',
Harvest = '#Form.Harvest#',
VintageReportOther = '#Form.VintageReportOther#'
WHERE Wine_ID = #Cookie.wineid#
</cfquery>
The error output contains:
Error Code: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver]
[ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE
statement
SQL UPDATE VintageReport SET Yields = 60, Rainfall = 2 , Sunshine = 100 ,
Flowering = '', Veraison = '', Harvest = '', VintageReportOther = 'none' WHERE
Wine_ID = 244
DATASOURCE IWIN02 VENDORERRORCODE -3503 SQLSTATE 42000
- where Flowering, Veraison, and Harvest are the date fields
Any ideas?
Thanks,
Damien
----------------------------------------------
This mail sent through http://www.ukonline.net
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
