dava133
|
| Posted: 03/03/2002, 6:50 AM |
|
Heres my problem :
I have 2 records on a page and one of them has all fields hidden and an update button. The other record is the users profile but that is irrelevant! When the update button is clicked i need to upate to fields : s_l and date_activated
s_l is the security level and I use this code in before update :
if getparam("s_l") = "1" then
flds_l = 2
end if
the second needs to add the current date and I thought I could do it like this:
if getparam("date_activated") = "" then
flddate_activated = date
end if
Where ive written date im not sure what to put i need it to be like whe u enter =date() in the default box but that doesnt seem to work, im guessing because its updating not submitting, because I have a registration form which does exactly the same and inserts a date registered but the only difference is its a submit button, cheers for ne help
|
|
|
 |
dava133
|
| Posted: 03/03/2002, 11:30 AM |
|
sorted
|
|
|
|
Nicole
|
| Posted: 03/04/2002, 2:33 AM |
|
Hello,
Try to put the code to Before Update event.
As for current date I propose to use:
flddate_activated = date()
|
|
|
|
|
