Problem: Insert Time into Access DB

blackcorvidae

I'm running PHP5 on XP, and I want to write to an Access database.

I'm using the COM object.

I try to do this:

$insert = "INSERT INTO Fourth_Sixth_Floor (Today, Hour, Fourth, Sixth, LHC, LHD) VALUES (#".$_POST['today']."#,

#".$POST['hour']."#,".$POST['fourth'].",".$POST['sixth'].",".$POST['lectureC'].",".$_POST['lectureD'].")";

printing out $insert returns:

INSERT INTO Fourth_Sixth_Floor (Today, Hour, Fourth, Sixth, LHC, LHD) VALUES (#01/04/05#, #4:01:15 PM#,0,0,0,0)

Welp, it doesn't work.

If I extract just the Hour attribute, it works fine, posts my data and I can look at it.

The problem is with the time.
I always thought Access took time like this:
#9:30:00 PM#

If I hardcode the time instead of using my POST variable I get the same problem. Did it everyway I can think of short of making the attribute a string and storing it that way.

I'm a bit confused.
If the attribute Today works, which i derived with the PHP date() function, then why doesn't the time work.

Any help...
This is a work project and I'm kinda stuck working with Access and PHP on windows, not my first choice.

ciao
thanks

Roger_Ramjet

Yes, good old Access. First thing would be to check what the Regional Settings specifies for the Date/time delimiters etc. This is the Regional Settings for the Windows machine the db is running on.

But! If what you are after it to capture current date and time, then configure the Access table with a default value of Now() and make it a Required field. Access will then generate and store the current date and time whenever you insert a record if you ommit any value for the field. No need for 2 fields since you can specify what to display when you output the data.

blackcorvidae

Turns out I was doing it totally right. I even got the default to run as you suggested with Now, but I needed to specify and change the time as needed, not just record the current.

Anyways, stupid Access crapped out on that particular column.
I deleted it and started over and it was fine.
I changed the names of the columns to make sure too to "xtime."

Could have been corrupted to some extent even, and luckily I'm using a copy of the existing database so no harm done.

Thanks.
:p

Roger_Ramjet

Not an external event, just Access doing it's usual thing a f*****g up. No rational reason will be found.