SQL Question

[SmileeTiger]

I am trying to update a time field in my access db using PHP but for some reason it doesn't like the formatting (I assume). Any ideas?

The error message I am getting looks like this:

UPDATE CourseTimeTable SET MondayTime = '08:30:00 AM', TuesdayTime = '10:00:00 AM', WednesdayTime = ' ', ThursdayTime = ' ', FridayTime = ' ' WHERE CourseTimeTable.CourseID = 'CS0433'
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression., SQL state 22005 in SQLExecDirect in c:\inetpub\

http://wwwroot\DAN\ChangeCH3.php

on line 508


Cory

 

[goatstudio]

Your sql statement look ok...do you set the field type to datetime? ------------------
Freedom is a Right

 

[SmileeTiger]

Yeah they are of the form date/time with the format Medium Time so an example would be 9:00 am I donno what's up with it.

Cory

 

[Kindon]

Can you run that exact SQL update in Access?