navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

Microsoft MVP

 

Autodate

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> Autodate
Page: [1]
 
Oznob

 

Posts: 87
From: Toronto, Ontario, Canada
Status: offline

 
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

 

Posts: 87
From: Toronto, Ontario, Canada
Status: offline

 
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 ?


(in reply to Oznob)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> Autodate
Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts