Here's a query I tried and doesn't

[ljCharlie]

Here's a query I tried and doesn't work for me.

UPDATE activities SET ljTime=19:00:00 WHERE actID=05052003

I have also tried this:

UPDATE activities SET ljTime=07:00:00 [PM] WHERE actID=05052003

But I still receive the error:
[txoov] ERROR 1064: You have an error in your SQL syntax near ':00:00 WHERE actID=05052003' at line 1

Please help!

Many thanks in advance!

ljCharlie

 

[swampBoogie]

UPDATE activities 
   SET ljTime='19:00:00'  
 WHERE actID=05052003

 

[ljCharlie]

Thanks! I guess I forgot about the quotes. I treated the Time as number intead of as string.

ljCharlie