You might want to try the following:
<cfquery datasource="#application.datasource#" name="update_record2"> UPDATE Tour_dates
SET Tour_dates.departuredates = #createODBCDate(form.DepartureDateTxt)#, Tour_dates.returndates = #createODBCDate(form.ReturnDateTxt)#, Tour_dates.fares = '#form.FaresTxt#'
WHERE (Tour_dates.Date_ID=#url.Tour_ID#) AND Tour_dates.Tour_ID=#url.ID#) </cfquery>
Hope this helps.
Cheers
Dave
On Thu, 22 Jan 2004 14:02:06 -0000 James Buckingham <[EMAIL PROTECTED]> wrote:
Afternoon guys,
I'm a bit stuck with some dates functions I'm working with and wondered if
anyone can help. I've got a form which is used to Amend information in an
Access DB. When the user clicks the 'Amend' button the information in sent
to a query to update the appropriate field. I can get it update everything
though apart from the Departure and Return Date fields. These are set to
Date/Time in Access.
I sent a question in earlier and got this reply from Stephen Moretti:
"DateTime fields in Access need to be fed ODBC formatted date/times either
using CreateODBCDate/CreateODBCDateTime or <cfqueryparam> You don't need to
wrap odbc datetimes in quotes."
I've messed around with these ideas but no matter what I try I get an error
message coming back. Here's what I've got at the moment:
<cfquery datasource="#application.datasource#" name="update_record2"> <cfset Departure_Date = createODBCDate(#form.DepartureDateTxt#)>
<cfset Return_Date = createODBCDate(#form.ReturnDateTxt#)>
UPDATE Tour_dates
SET Tour_dates.departuredates = '#Departure_Date#'
, Tour_dates.returndates = '#Return_Date#'
, Tour_dates.fares = '#form.FaresTxt#'
WHERE (Tour_dates.Date_ID=#url.Tour_ID#) AND (Tour_dates.Tour_ID=#url.ID#) </cfquery>
I've done a CFOUTPUT of the SET Departure_Date and it comes out as {d
'2004-11-09'}
I've also tried converting it using DateFormat first and then inserting it
but nothing is working.
Can anyone give me some pointers?
Cheers, James
-- ** 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]
