0

Greetings,

I'm using Flash MX connecting to an MS Access database via JET.

I've stored dates using Flash/Jet into my database as 'dd/mm/yyyy hh:mm:ss' into a DATE/TIME field.

However I can't update because of the WHERE clause as I am not specifying the date correctly. I believe syntax wise I need to use # and specify it in american format mm/dd/yyyy hh:mm:ss.

I have the code below working :-

mdm.Database.MSAccess.runQuery("UPDATE UserOverallResults SET Results = 10 WHERE UserName = 'Rob' AND quizDate > #02/19/2008#");

When I add the time it complains and using the "=" clause it complains :-

mdm.Database.MSAccess.runQuery("UPDATE UserOverallResults SET Results = 10 WHERE UserName = 'Rob' AND quizDate = #02/19/2008 12:03:32# ");

Can anyone please assist, ive spent hours messing around with date/time formats, very confused.

Thanks
Rob W

2
Contributors
2
Replies
3
Views
9 Years
Discussion Span
Last Post by peter_budo
0

After further testing it appears not to like the time format as the code below works

mdm.Database.MSAccess.runQuery("UPDATE UserOverallResults SET Results = 10 
WHERE UserName = 'Rob' AND quizDate = #19/02/2008#");

As soon as I add time (hh:mm:ss) it errors.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.