Home Tutorials Forums Articles Blogs Movies Library Employment Press
Old 08-11-2004, 10:47 PM   #1
Roger Chinchill
rogerchinchilla
 
Roger Chinchill's Avatar
 
Join Date: Aug 2003
Location: New York City
Posts: 56
Send a message via MSN to Roger Chinchill Send a message via Yahoo to Roger Chinchill
Red face Clock in Clock out ASP - MS Access

This is the master plan.

I made a flash that contains a few frames.

Frame 1 has the user login - Requires username password. I have this all set with ASP - MS ACCESS Database.

Once you are validated - you go to the next frame that has 4 buttons and a text field(id) and I guess 2 more text fields that contain date(dt) and time(tm).

You enter a user id into the text field and click a button.


in(in)
out for lunch(ofl)
in from lunch(ifl)
out(out)

When you press these buttons all variables are sent.

So the information that will be sent is (in)var - (id)var - (dt)var - (tm)var.

In the database that contains these fields.

userid - date - timeIn - timeOut.


Once you press the send button you get a sending page. There is no problem with that. And finally it says you have been. (clocked in),(clocked out for lunch), (clocked in from lunch) or (clocked out) depending on the button.

I think ASP would be the best for this since this is an Access DB.

For the time variable that needs to be sent. I have a PHP script. What would be the proper translation of this php script to Asp?
PHP Code:
<?php 
$date 
urlencode(date("l F jS, Y"time())); 
print 
"&servertime=$date";
?>
This goes out to all people who know anything about this. ASP programmers, people who have heard of ASP and most of all people who KNOW EVERYTHING - Cyanblue - Farafiro - oldewbie - tg - hangalot - Cota and all those who know how to answer every question that all of us here have.

Thanks a lot

Roger
Roger Chinchill is offline   Reply With Quote
Old 08-17-2004, 12:28 PM   #2
hangalot
lala
 
hangalot's Avatar
 
Join Date: Feb 2002
Location: on the road
Posts: 2,858
Default

<%=now%> which will write a full timestamp
<%=date%> for the date
u can urldecode it on the flash side if necesary
also add a unique id (autonumber in access i think)in your table(it will make querying it easier when u start pulling reportts and u require joins)
__________________
oi poloi
http://www.memorphic.com/news/
hangalot is offline   Reply With Quote
Reply


Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT. The time now is 08:41 AM.

///
Follow actionscriptorg on Twitter

 


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Ad Management plugin by RedTyger
Copyright 2000-2013 ActionScript.org. All Rights Reserved.
Your use of this site is subject to our Privacy Policy and Terms of Use.