Hi All


My first post, hopefully the first of many.

I have a form with fields "Date Added:" and "Last Modified:", at the moment only the "Last Modified" field works correctly.

Here's the coding for the two:

PHP Code:

if var_dateAdded = "" then
rsUpdate("DateAdded") = now()
end if

rsUpdate("LastUpdated") = now() 


I have to add that I know nothing of ASP coding, only some bash scripting...


Can one of you please help me out with this one? What I need to happen is that the "Date Added" field must only receive a time-stamp upon creation then stay as is.

The "Last Updated" filed works great at the moment, it's just that darn "Date Added"...



Thanks in advance

If it's an Access database (or even an SQL Server database), don't use ASP at all.

In Access, you can find the field in your table and set the default value to =Now() ... you will need the equals sign for this to work.

SQL Server, I think you can do the same thing, but I haven't done anything with it in a while.

Hello,

Can you provide me the code you are working on for details.

I think it easy to do.....

Hey Kinetik,

If you are using SQL you can set the default value for DateAdded to CURRENT_TIMESTAMP. This will place the current date and time that the row is added in the DateAdded field.

If you're going to fix this in the database instead of in ASP ( which is a good idea ), after you set the default for the column, you'll have to go back and run an update query on the ones that are already in the table.

That depends on if he's already got records in the database or not. If he's just messing around with it trying to get it working, there won't be much there.

(Good thought, though.)