Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 Insert Date of Registration into DB		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Brachole
Starting Member

USA
33 Posts
Posted - 20 April 2005 :  14:38:57  Show Profile  Visit Brachole's Homepage
I am using my own registration form to insert the data into the FORUM_MEMBERS.

However, how do I insert the current date of registration into the M_DATE, using the format they use...

I'm using ASP with JAVASCRIPT and Access. If I change the properties of M_DATE in Access to Date/Time and use Now() for current date, it won't display correctly on Memebrs.asp

Any suggestions?

HuwR
Forum Admin

United Kingdom
20593 Posts
Posted - 20 April 2005 :  17:24:19  Show Profile  Visit HuwR's Homepage
the forum useses a string representation of the date for which there are conversion functions included strToDate(string) and DateToStr(date). it does this because database date formats are different depending which you use so it makes more sence to store it in a generic format.
Go to Top of Page

Brachole
Starting Member

USA
33 Posts
Posted - 21 April 2005 :  11:57:41  Show Profile  Visit Brachole's Homepage
How can I insert the date function into my own html form (I'm using ASP with Javascript as server model). Here's my form:

<form action="<%=MM_editAction%>" method="POST" name="NovaForm" id="NovaForm">

Full Name: <input name="name" type="text" id="name" size="40">
<div align="right">E-Mail Address:</div>
<input name="email" type="text" id="email3" size="40">
<input type="submit" name="Submit22" value="Continue >">
<input type="hidden" name="MM_insert" value="NovaForm">
</form>
Go to Top of Page

Brachole
Starting Member

USA
33 Posts
Posted - 21 April 2005 :  12:25:18  Show Profile  Visit Brachole's Homepage
...or, I can always change the properties of the M_DATE in Access to display a Default Value of NOW() when a new member is inserted.

But obviously, the date won't display right in the Forum because of the string fucntion.

How can I disable the string everytime the date should appear?

Thanks.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.28 seconds. Powered By: Snitz Forums 2000 Version 3.4.07