Autodate (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message


Oznob -> Autodate (3/20/2001 20:19:00)

FP2000 | Access2000

I have a hidden field named 'dateadded'
is value is set to <%=Date()%>

This is added to my database and used to work well putting the actual date in the field.

Recently for some unknown reason the dateadded field in my database now is not passed the actual date but instead ends up holding the string '<%=Date()%>'

Any thoughts on why - I seem to be overlooking something somewhere - it was working fine before

Thanks in advance.
Oznob





Oznob -> RE: Autodate (3/20/2001 20:11:00)

more discoveries:

i actually have two forms that use this date field - the first one works fine and is an update page

UPDATE DISTINCTROW
business
SET dateupdated='::dateupdated::'
WHERE ID=::ID::

where dateupdated = a hidden field <%Date()%>

The page that does not see to work looks like this:

INSERT INTO business (dateupdated)
VALUES ('::dateupdated::')

where dateupdated is has the same hidden field value.

btw above i think i talked about the variable dateadded - while here i talk about dateupdated - please overlook this

still conFused ...any ideas ?





Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875