Using SQL to update database

[NHorley]

Hi I am trying to update a table in my database using the WHERE clause in SQL. This is successful for all fields apart from date and time. It seems to ignore these or create an error on my web page. I need this as sort of timestamp logged in the database everytime an update is made. Any suggestions? all will be gratefully received.

 

[grega]

What DB are you using?

What doesn't work properly? Can you post an example?

Greg.

 

[NHorley]

Hi
I'm using Access 2000 DB. It's when I try use date or/and time fields as paramaters it ignores them!

This is the statment I'm using:

UPDATE OOH_Rota
SET
Update_OnCallName='::Update_OnCallName::',
Your_Name='::Your_Name::',
Date_Time=':ate_Time::'
WHERE Number_Me='::Number_Me::'

This works for updating the on call name and your name, being the person who's posting the change, but the date and time of the posting does not pull through. (By the way this is for on-line rota changes - if it helps)

 

[NHorley]

Sorry scrap that last one it is working now and updating the database just not pulling through all the results onto the web page.

thanks anyway