Actually, that is much easier than you'd think. To accomplish this, simply place a hidden (or visable if you'd like) field into your form... then insert the ASP variable for showing the date and time, which is considered "Now".
Sounds like you are brand new to web development, as that is a much broader question than is usual for a forum like this. Have you bought any Dreamweaver web development books? I would suggest doing that to give you a basic understanding of dynamic web development. There are some great books listed on this site for that subject: http://www.dmxzone.com/index.asp?TypeId=5&CatId=716
Not sure, but someone may have taken the time to write out some free tutorials on this, either on this site or elsewhere on the web.
Also, I have found some free tutorials from the Macromedia website to get you started:
Do one thing. Make your database in such a way that the column you want to to enter the date into, is the date field.
For example you have an access database and a date field in in.In the default value for date field, enter now(). This will put the date and time into this field automativcally when you enter a new record into database.
I am sure you can do this.
Then go to the application pannel in dreamweaver mx and make a connection through connection string. Now using the same pannel make a recordset object. After this make a form with respect to the table in database which you want to update and then use the sever behgaviour named Insert record. It will open up a dialog box. That will be simple and easy to do what you want there.Ask for more if you want.
Comments
Date & Time
To accomplish this, simply place a hidden (or visable if you'd like) field into your form... then insert the ASP variable for showing the date and time, which is considered "Now".
<form>
<input name="EditDate" type="hidden" value="<%=Now%>">
</form>
The result is in this format: 2/23/2005 11:18:03 AM
Hope this helps...
RE: Date & Time
and how insert into database?
give me an example.. please...
Date & Time
Sounds like you are brand new to web development, as that is a much broader question than is usual for a forum like this.
Have you bought any Dreamweaver web development books? I would suggest doing that to give you a basic understanding of dynamic web development. There are some great books listed on this site for that subject: http://www.dmxzone.com/index.asp?TypeId=5&CatId=716
Not sure, but someone may have taken the time to write out some free tutorials on this, either on this site or elsewhere on the web.
Also, I have found some free tutorials from the Macromedia website to get you started:
Going Dynamic with Dreamweaver MX
http://www.macromedia.com/devnet/mx/dreamweaver/articles/going_dynamic.html
Understanding DW Connections
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_16566
Setting Up The Database
http://www.macromedia.com/devnet/mx/dreamweaver/articles/webservice_07.html
This is simple
Do one thing. Make your database in such a way that the column you want to to enter the date into, is the date field.
For example you have an access database and a date field in in.In the default value for date field, enter now(). This will put the date and time into this field automativcally when you enter a new record into database.
I am sure you can do this.
Then go to the application pannel in dreamweaver mx and make a connection through connection string. Now using the same pannel make a recordset object. After this make a form with respect to the table in database which you want to update and then use the sever behgaviour named Insert record. It will open up a dialog box. That will be simple and easy to do what you want there.Ask for more if you want.
Regards,
Fahd Murtaza
You must me logged in to write a comment.