|
 |
asp_databases thread: RE: Time/Date
Message #1 by imran.saleem@b... on Tue, 7 May 2002 13:39:44 +0100
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1F5C4.44018530
Content-Type: text/plain;
charset="iso-8859-1"
strSQL = "INSERT INTO <table name> (<field name>,<field name>,<field
name>,Date....) Values (<Field Value>,<Field Value>,<Field Value>, " & NOW()
& ")"
-----Original Message-----
From: Locke, Darrell (FCS/SFC) [mailto:Darrell.Locke@g...]
Sent: Tuesday, May 07, 2002 1:28 PM
To: ASP Databases
Subject: [asp_databases] RE: Time/Date
No, access.
-----Original Message-----
From: Sam Clohesy [mailto:sam@e...]
Sent: May 7, 2002 9:26 AM
To: ASP Databases
Subject: [asp_databases] RE: Time/Date
Default value getdate() in sql server?
Sam Clohesy
Project Manager
Tel: 0208 772 3958
E: samc@e...
W: http://www.etypemedia.co.uk <http://www.etypemedia.co.uk/>
-----Original Message-----
From: Locke, Darrell (FCS/SFC) [mailto:Darrell.Locke@g...]
Sent: 07 May 2002 13:21
To: ASP Databases
Subject: [asp_databases] Time/Date
G'Day,
Can someone tell me how I would write the code for a Date/Time to write to a
database once the user registers, without there knowledge?
I have a few simple fields, Name, Location and drop down menu populated from
a table in a database. But I am not sure how to get the date and time to
write to the database.
Thanks
---
---
---
Message #2 by "CLINTON PARSLEY" <cparsley@m...> on Tue, 07 May 2002 08:30:04 -0700
|
|
strSql="INSERT INTO Users(FirstName,LastName,RegistrationDate)" & _
" VALUES('" & Trim(Request("FirstName")) & "','" & _
"'" & Trim(Request("LastName")) & "',#" & Date & "#")"
If your inserting into a SqlDB you can remove the # delimiters.
hth,
Clint
::Can someone tell me how I would write the code for a Date/Time to
::write to a database once the user registers, without there knowledge?
_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com
Message #3 by "Locke, Darrell (FCS/SFC)" <Darrell.Locke@g...> on Tue, 7 May 2002 09:27:42 -0300
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1F5C2.95BF0930
Content-Type: text/plain
No, access.
-----Original Message-----
From: Sam Clohesy [mailto:sam@e...]
Sent: May 7, 2002 9:26 AM
To: ASP Databases
Subject: [asp_databases] RE: Time/Date
Default value getdate() in sql server?
Sam Clohesy
Project Manager
Tel: 0208 772 3958
E: samc@e...
W: http://www.etypemedia.co.uk <http://www.etypemedia.co.uk/>
-----Original Message-----
From: Locke, Darrell (FCS/SFC) [mailto:Darrell.Locke@g...]
Sent: 07 May 2002 13:21
To: ASP Databases
Subject: [asp_databases] Time/Date
G'Day,
Can someone tell me how I would write the code for a Date/Time to write to a
database once the user registers, without there knowledge?
I have a few simple fields, Name, Location and drop down menu populated from
a table in a database. But I am not sure how to get the date and time to
write to the database.
Thanks
---
---
Message #4 by Colin.Montgomery@C... on Tue, 7 May 2002 13:31:24 +0100
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1F5C3.19F578B0
Content-Type: text/plain; charset="ISO-8859-1"
default value Now() in Access
-----Original Message-----
From: Locke, Darrell (FCS/SFC) [mailto:Darrell.Locke@g...]
Sent: 07 May 2002 13:28
To: ASP Databases
Subject: [asp_databases] RE: Time/Date
No, access.
-----Original Message-----
From: Sam Clohesy [mailto:sam@e...]
Sent: May 7, 2002 9:26 AM
To: ASP Databases
Subject: [asp_databases] RE: Time/Date
Default value getdate() in sql server?
Sam Clohesy
Project Manager
Tel: 0208 772 3958
E: samc@e...
W: http://www.etypemedia.co.uk <http://www.etypemedia.co.uk/>
-----Original Message-----
From: Locke, Darrell (FCS/SFC) [mailto:Darrell.Locke@g...]
Sent: 07 May 2002 13:21
To: ASP Databases
Subject: [asp_databases] Time/Date
G'Day,
Can someone tell me how I would write the code for a Date/Time to write to a
database once the user registers, without there knowledge?
I have a few simple fields, Name, Location and drop down menu populated from
a table in a database. But I am not sure how to get the date and time to
write to the database.
Thanks
---
---
---
*******
This message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the
intended recipient, please telephone or email the sender and delete this message and any attachment from your system. If you are
not the intended recipient you must not copy this message or attachment or disclose the contents to any other person.
For further information about Clifford Chance please see our website at http://www.cliffordchance.com or refer to any Clifford
Chance office.
Message #5 by "Locke, Darrell (FCS/SFC)" <Darrell.Locke@g...> on Tue, 7 May 2002 09:20:47 -0300
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1F5C1.9E609EB0
Content-Type: text/plain
G'Day,
Can someone tell me how I would write the code for a Date/Time to write to a
database once the user registers, without there knowledge?
I have a few simple fields, Name, Location and drop down menu populated from
a table in a database. But I am not sure how to get the date and time to
write to the database.
Thanks
Message #6 by Sam Clohesy <sam@e...> on Tue, 7 May 2002 13:25:45 +0100
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1F5C2.4FA2BB90
Content-Type: text/plain
Default value getdate() in sql server?
Sam Clohesy
Project Manager
Tel: 0208 772 3958
E: samc@e...
W: http://www.etypemedia.co.uk <http://www.etypemedia.co.uk/>
-----Original Message-----
From: Locke, Darrell (FCS/SFC) [mailto:Darrell.Locke@g...]
Sent: 07 May 2002 13:21
To: ASP Databases
Subject: [asp_databases] Time/Date
G'Day,
Can someone tell me how I would write the code for a Date/Time to write to a
database once the user registers, without there knowledge?
I have a few simple fields, Name, Location and drop down menu populated from
a table in a database. But I am not sure how to get the date and time to
write to the database.
Thanks
---
|
|
|
View Cart
