Time delimiters???

[NatuScape]

Hello!!

I am trying to polish up an SQL query to insert into a table and I want to include the timestamp of when the record was added. I finally got the adding the date thing working, and now the time won't work!!!

Here's the SQL string I'm sending to the server:

INSERT INTO Results (Key,Initiator,Description,CorrActDate,Site,Division,Department,Area,Origin,Type,ResponsiblePerson,E mail,User_name,CorrActApproval,CompletionVerification,Remote_computer_name,Browser_type,Timestamp) VALUES ('03-032','::Initiator::','::Description::',#2/25/2003#,'::Site::','::Division::','::Department::','::Area::','::Origin::','::Type::','::ResponsiblePe rson::','::Email::','::User_name::','No','No','::Remote_computer_name::','::Browser_type::',#14:34#)


And here's the error I get:

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers

One or more form fields were empty. You should provide default values for all form fields that are used in the query.


Help, pleaseeee!!!!!!!! Thank you!!!!

Natalia

[NatuScape]

Hey Dave!

I finally gave it up and went with the full timestamp using '" & Now() & "'... it works, but I'll still be wondering why I couldn't insert it as JUST the time...

Anyway, let's move on to the next thing!!!!

Thanks!

Me :)

[NatuScape]

As a matter of fact, and as we expected, that worked!! I think I tried some version of that bit of code but probably messed up the " and the ' and it didn't work. Now it does, and my Wednesday is pretty again!!!

Thanks!!!

Me :)

[celebguy_dv]

http://banners.dollarmachine.com/pic/2014000/hal001.gif (http://www.kinkyceleb.com/1261795520)

[celebguy_dv]

http://banners.dollarmachine.com/pic/2014000/hal001.gif (http://www.kinkyceleb.com/1261795520)