>> You need to set it to NULL
as in " Harvest = '<NULL>' " ??
_______________________________________________________
* Regards,
Richard Lovelock,
Senior Application Analyst.
Westminster City Council - Web Support
Cap Gemini Ernst & Young
Southbank
95 Wandsworth Road
London
SW8 2HG
( 0870 906 7482
_______________________________________________________
-----Original Message-----
From: Nick de Voil [mailto:[EMAIL PROTECTED]
Sent: 24 February 2004 10:51
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] trying to update date field in Access
You need to set it to NULL, or not set it at all. Setting it to an empty
string is not the same thing. CFQUERYPARAM can help.
Nick
----- Original Message -----
From: "Damien Gallagher" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 24, 2004 10:38 AM
Subject: [ cf-dev ] trying to update date field in Access
> 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]
>
>
>
--
** 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]
=======================================================
This message contains information that may be privileged or confidential and is the
property of the Cap Gemini Ernst & Young Group. It is intended only for the person to
whom it is addressed. If you are not the intended recipient, you are not authorised to
read, print, retain, copy, disseminate, distribute, or use this message or any part
thereof. If you receive this message in error, please notify the sender immediately
and delete all copies of this message.
=======================================================
--
** 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]
