Flash, asp, and access database

programming flash
1

http://www.kirupa.com/developer/actionscript/forms_database.htm

I got partial success with the tutorial above, but couldn’t figure out a few things.

  1. How to save the date and time to the database? Based on web search result on how to find date or time in APS, I thought I could do
    [COLOR=#ff0000]theDate = <%=date()%>
    theTime = <%=time()%>
    [/COLOR]add the fields in MDB and modify the line

SQL = “INSERT INTO contacts (FirstName, LastName, Email, Message, Date, Time) VALUES (’”&strFirst&"’,’"&strLast&"’,’"&strEmail&"’,’"&strMessage&"’,’"&theDate&"’,’"&theTime&"’)"
conn.Execute(SQL)

but the ASP generated errors on the 2 lines.

  1. When executing the file (getURL(“http://yourSite.com/processForm.asp",0,"post”);
    }), it always opens the processForm.asp file in a new window. Can it be executed in the same window or just being hidden?

The tutorial is old, and I wonder if there are new ways to do the things with CS4 or CS5?

Thanks for the help,