timestamp

[Guest]

I am writing a program in Cold Fusion and want to submit a form to Access to
update data. I want to include a timestamp so that there is a record of the
last update.

I am using

submission_date=#CreateODBCDateTime(Now())#

for that part of the update. I am getting an error message stating:

Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in query expression ''{ts '2004-10-14 20:09:51'}''.

The problem seems to be getting both a date and a time. I can get one or the
other but not both.

Any suggestions are appreciated.

LF

 

[Guest]

I should have actually said that I can get the date only if I use

submission_date=#DateFormat(Now())#

or I can get the time only if I use

submission_time=#TimeFormat(Now())#

I want to capture both the date and time in one field

 

[G. Vaught]

If you are using Now(), it should automatically show the date and time in
Access. Try just setting submission_date=Now()
I'm not sure you need the # at the beginning and end when using Now().

I should have actually said that I can get the date only if I use

submission_date=#DateFormat(Now())#

or I can get the time only if I use

submission_time=#TimeFormat(Now())#

I want to capture both the date and time in one field

I am writing a program in Cold Fusion and want to submit a form to Access
to
update data. I want to include a timestamp so that there is a record of
the
last update.

I am using

submission_date=#CreateODBCDateTime(Now())#

for that part of the update. I am getting an error message stating:

Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in query expression ''{ts '2004-10-14 20:09:51'}''.

The problem seems to be getting both a date and a time. I can get one or
the
other but not both.

Any suggestions are appreciated.

LF

 

[Guest]

That did the trick! Thanks so much. I thought I had tried that already but I
obviously did something wrong before.

Again - thanks for your help!

If you are using Now(), it should automatically show the date and time in
Access. Try just setting submission_date=Now()
I'm not sure you need the # at the beginning and end when using Now().

I should have actually said that I can get the date only if I use

submission_date=#DateFormat(Now())#

or I can get the time only if I use

submission_time=#TimeFormat(Now())#

I want to capture both the date and time in one field

I am writing a program in Cold Fusion and want to submit a form to Access
to
update data. I want to include a timestamp so that there is a record of
the
last update.

I am using

submission_date=#CreateODBCDateTime(Now())#

for that part of the update. I am getting an error message stating:

Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing
operator) in query expression ''{ts '2004-10-14 20:09:51'}''.

The problem seems to be getting both a date and a time. I can get one or
the
other but not both.

Any suggestions are appreciated.

LF