Time Stamp

[Houston]

I am pretty new at this so please bare with me.

I have a page working perfectly but I just want to ad a column that will
show the time it was entered into the database. I think all I need is the
syntax for writing the server time to the TimeStamp field in the record. I
have hidden field in the form that I alocated. So how do I get it to write
the current time to the database. Here is the current code:
<form name="form1" method="POST" action="<%=MM_editAction%>">
<table width="500" cellpadding="2" cellspacing="0">
<tr>
<td width="242" class="tdtl">Are you coming to the lake this weekend?
</td>
<td width="244" class="tdtr"><input name="Answer" type="radio"
value="Yes" checked>
Yes&nbsp;&nbsp;&nbsp; <input name="Answer" type="radio"
value="No">
No</td>
</tr>
<tr>
<td class="tdleft">Your Name Please </td>
<td class="tdright"><input name="Name" type="text" id="Name"
size="40"></td>
</tr>
<tr>
<td class="tdleft">I will be arriving on . . . </td>
<td class="tdright"><select name="Arriving" size="1" id="Arriving">
<option value="Cant make it">Cant make it</option>
<option value="Friday">Friday</option>
<option value="Saturday">Saturday</option>
<option value="Sunday">Sunday</option>
<option value="Monday">Monday</option>
<option value="Tuesday">Tuesday</option>
<option value="Wednesday">Wednesday</option>
<option value="Thursday">Thursday</option>
</select></td>
</tr>
<tr>
<td class="tdleft">Boathouse</td>
<td class="tdright"><input name="BoatHouse" type="text" id="BoatHouse"
size="6" maxlength="6">&nbsp;&nbsp; </td>
</tr>
<tr align="center">
<td colspan="2" class="tdleft"><input name="Submit" type="submit"
onClick="MM_validateForm('Name','','R');return document.MM_returnValue"
value="Submit"></td>
</tr>
</table>

<input type="hidden" name="MM_insert" value="form1">
<span class="tdright">
<input name="TimeStamp" type="hidden" id="TimeStamp"
value="<%=(rsList.Fields.Item("TimeStamp").value)% >">
</span>
</form>

Is it this last "Input" statement that I need to change to get this to work
right?

Thanks

Houston

[Tobias Marquart]

Hi Houston,

wouldn't it be a lot easier to set the timestamp right in the sql-query?
You could even set up a datetime-column with default-value getdate().
Sample (suggestion, not that I say that I'd do it that way, but accoring
to your html):

CREATE TABLE lakeweekend
(
lw_id int identity(1,1) primary key,
Answer varchar(10),
Arriving varchar(20),
[Name] varchar(100) not null,
lw_inserted datetime default getdate()
)

(some columns left out for the sample)

You could then enter the data like this (just leaving the
timestamp-column away):

insert into lakeweekend ([Name]) values ('Test')

if you do a
select * from lakeweekend
you can see that the current date has been inserted into lw_inserted

I'm not an ASP-programmer so I just gave you some sql-snipplets (they
should work on SQLServer 2000).

hth,

Tobias

Houston wrote:

I am pretty new at this so please bare with me.

I have a page working perfectly but I just want to ad a column that will
show the time it was entered into the database. I think all I need is the
syntax for writing the server time to the TimeStamp field in the record. I
have hidden field in the form that I alocated. So how do I get it to write
the current time to the database. Here is the current code:
<form name="form1" method="POST" action="<%=MM_editAction%>">
<table width="500" cellpadding="2" cellspacing="0">
<tr>
<td width="242" class="tdtl">Are you coming to the lake this weekend?
</td>
<td width="244" class="tdtr"><input name="Answer" type="radio"
value="Yes" checked>
Yes&nbsp;&nbsp;&nbsp; <input name="Answer" type="radio"
value="No">
No</td>
</tr>
<tr>
<td class="tdleft">Your Name Please </td>
<td class="tdright"><input name="Name" type="text" id="Name"
size="40"></td>
</tr>
<tr>
<td class="tdleft">I will be arriving on . . . </td>
<td class="tdright"><select name="Arriving" size="1" id="Arriving">
<option value="Cant make it">Cant make it</option>
<option value="Friday">Friday</option>
<option value="Saturday">Saturday</option>
<option value="Sunday">Sunday</option>
<option value="Monday">Monday</option>
<option value="Tuesday">Tuesday</option>
<option value="Wednesday">Wednesday</option>
<option value="Thursday">Thursday</option>
</select></td>
</tr>
<tr>
<td class="tdleft">Boathouse</td>
<td class="tdright"><input name="BoatHouse" type="text" id="BoatHouse"
size="6" maxlength="6">&nbsp;&nbsp; </td>
</tr>
<tr align="center">
<td colspan="2" class="tdleft"><input name="Submit" type="submit"
onClick="MM_validateForm('Name','','R');return document.MM_returnValue"
value="Submit"></td>
</tr>
</table>

<input type="hidden" name="MM_insert" value="form1">
<span class="tdright">
<input name="TimeStamp" type="hidden" id="TimeStamp"
value="<%=(rsList.Fields.Item("TimeStamp").value)% >">
</span>
</form>

Is it this last "Input" statement that I need to change to get this to work
right?

Thanks

Houston

[Houston]

I appreciate your help, I ended up just putting in a Hidden field and had it
write the current time into the "TimeLog" column of an access database using
"Value = <% NOW() %>" Works great

Thanks again.
"Tobias Marquart" <to******@gmx.de> wrote in message
news:41********@maser.urz.unibas.ch...

Hi Houston,

wouldn't it be a lot easier to set the timestamp right in the sql-query?
You could even set up a datetime-column with default-value getdate().
Sample (suggestion, not that I say that I'd do it that way, but accoring
to your html):

CREATE TABLE lakeweekend
(
lw_id int identity(1,1) primary key,
Answer varchar(10),
Arriving varchar(20),
[Name] varchar(100) not null,
lw_inserted datetime default getdate()
)

(some columns left out for the sample)

You could then enter the data like this (just leaving the
timestamp-column away):

insert into lakeweekend ([Name]) values ('Test')

if you do a
select * from lakeweekend
you can see that the current date has been inserted into lw_inserted

I'm not an ASP-programmer so I just gave you some sql-snipplets (they
should work on SQLServer 2000).

hth,

Tobias

Houston wrote:

I am pretty new at this so please bare with me.

I have a page working perfectly but I just want to ad a column that will
show the time it was entered into the database. I think all I need is the syntax for writing the server time to the TimeStamp field in the record. I have hidden field in the form that I alocated. So how do I get it to write the current time to the database. Here is the current code:
<form name="form1" method="POST" action="<%=MM_editAction%>">
<table width="500" cellpadding="2" cellspacing="0">
<tr>
<td width="242" class="tdtl">Are you coming to the lake this weekend? </td>
<td width="244" class="tdtr"><input name="Answer" type="radio"
value="Yes" checked>
Yes&nbsp;&nbsp;&nbsp; <input name="Answer" type="radio"
value="No">
No</td>
</tr>
<tr>
<td class="tdleft">Your Name Please </td>
<td class="tdright"><input name="Name" type="text" id="Name"
size="40"></td>
</tr>
<tr>
<td class="tdleft">I will be arriving on . . . </td>
<td class="tdright"><select name="Arriving" size="1" id="Arriving"> <option value="Cant make it">Cant make it</option>
<option value="Friday">Friday</option>
<option value="Saturday">Saturday</option>
<option value="Sunday">Sunday</option>
<option value="Monday">Monday</option>
<option value="Tuesday">Tuesday</option>
<option value="Wednesday">Wednesday</option>
<option value="Thursday">Thursday</option>
</select></td>
</tr>
<tr>
<td class="tdleft">Boathouse</td>
<td class="tdright"><input name="BoatHouse" type="text" id="BoatHouse" size="6" maxlength="6">&nbsp;&nbsp; </td>
</tr>
<tr align="center">
<td colspan="2" class="tdleft"><input name="Submit" type="submit"
onClick="MM_validateForm('Name','','R');return document.MM_returnValue"
value="Submit"></td>
</tr>
</table>

<input type="hidden" name="MM_insert" value="form1">
<span class="tdright">
<input name="TimeStamp" type="hidden" id="TimeStamp"
value="<%=(rsList.Fields.Item("TimeStamp").value)% >">
</span>
</form>

Is it this last "Input" statement that I need to change to get this to work right?

Thanks

Houston