Writing a Date & Time function 
Author Message
 Writing a Date & Time function

How would I go about writing to an Access db....the date & time from a
clients machine, when doing a search through my helpdesk?

I can display the date and time using the following code...

<% = date %>
<% = time %>

But it displays on the actual page. How can I get the date and time to be
hidden from view, and then using SQL....write it to a db.

I am able to write the queries they're searching on, and I am able to write
the customer id, when they logged in.....I am able to do this by using
Request.QueryString....and by using this SQL statement...
SQL = "INSERT INTO {*filter*}log (CustID, Searched_On) VALUES ('" & custid & "',
'" & search & "')"

TIA!

David Stackis
Communications Administrator
Comtronic Systems
http://www.*-*-*.com/



Tue, 17 Dec 2002 03:00:00 GMT  
 Writing a Date & Time function
You can load the values for the date and time from script into input values
for a form and then submit the form to the ASP page.

steve


Quote:
> How would I go about writing to an Access db....the date & time from a
> clients machine, when doing a search through my helpdesk?

> I can display the date and time using the following code...

> <% = date %>
> <% = time %>

> But it displays on the actual page. How can I get the date and time to be
> hidden from view, and then using SQL....write it to a db.

> I am able to write the queries they're searching on, and I am able to
write
> the customer id, when they logged in.....I am able to do this by using
> Request.QueryString....and by using this SQL statement...
> SQL = "INSERT INTO {*filter*}log (CustID, Searched_On) VALUES ('" & custid &
"',
> '" & search & "')"

> TIA!

> David Stackis
> Communications Administrator
> Comtronic Systems
> http://www.*-*-*.com/



Tue, 17 Dec 2002 03:00:00 GMT  
 Writing a Date & Time function
Would the input values be hidden?


Quote:
> You can load the values for the date and time from script into input
values
> for a form and then submit the form to the ASP page.

> steve



> > How would I go about writing to an Access db....the date & time from a
> > clients machine, when doing a search through my helpdesk?

> > I can display the date and time using the following code...

> > <% = date %>
> > <% = time %>

> > But it displays on the actual page. How can I get the date and time to
be
> > hidden from view, and then using SQL....write it to a db.

> > I am able to write the queries they're searching on, and I am able to
> write
> > the customer id, when they logged in.....I am able to do this by using
> > Request.QueryString....and by using this SQL statement...
> > SQL = "INSERT INTO {*filter*}log (CustID, Searched_On) VALUES ('" & custid &
> "',
> > '" & search & "')"

> > TIA!

> > David Stackis
> > Communications Administrator
> > Comtronic Systems
> > http://www.*-*-*.com/



Tue, 17 Dec 2002 03:00:00 GMT  
 Writing a Date & Time function
If you want them to be.

Doesn't matter.

steve


Quote:
> Would the input values be hidden?



> > You can load the values for the date and time from script into input
> values
> > for a form and then submit the form to the ASP page.

> > steve



> > > How would I go about writing to an Access db....the date & time from a
> > > clients machine, when doing a search through my helpdesk?

> > > I can display the date and time using the following code...

> > > <% = date %>
> > > <% = time %>

> > > But it displays on the actual page. How can I get the date and time to
> be
> > > hidden from view, and then using SQL....write it to a db.

> > > I am able to write the queries they're searching on, and I am able to
> > write
> > > the customer id, when they logged in.....I am able to do this by using
> > > Request.QueryString....and by using this SQL statement...
> > > SQL = "INSERT INTO {*filter*}log (CustID, Searched_On) VALUES ('" & custid
&
> > "',
> > > '" & search & "')"

> > > TIA!

> > > David Stackis
> > > Communications Administrator
> > > Comtronic Systems
> > > http://www.*-*-*.com/



Tue, 17 Dec 2002 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Writing a Date & Time function

2. time & date functions

3. Compare date in form with date/time in form with date/time in database

4. VB Date/Time datatype and VB date functions

5. VB Date/Time datatypes and VB date functions

6. Need function to increase time in date/time field by one hour

7. Date Time Picker & Null dates

8. Crystal Reports, Date/Time, and the Time() function

9. start date/time, end date/time problem

10. Response.Write and Date/Time 'Stamp'

11. *&*&*&* Date math question *&*&*&*

12. Format Date & Time Validation

 

 
Powered by phpBB® Forum Software