email parsing + dagsdato opdatering

Hvordan sender jeg en email+dagsdato (som tastes i et andet field) med når en record skal opdateres? email + dags dato skal benyttes til at opdatere en record som brugeren ikke ser!

Jeg har en database med feltet \"programID\" og jeg vil gerne sende den email som brugeren taster ind i formen til datafeltet \"programID\" i databasen. Emailen skal PARSES så mailen er uden (.) og (@) (punkttum og snabel A). Herefter skal dato tilføjes i \'short\' form!

Den som kan rette følgende asp så det virker modtager points!

<%@LANGUAGE=\"VBSCRIPT\"%>
<!--#include file=\"Connections/bo.asp\" -->
<%
\' *** Edit Operations: declare variables

MM_editAction = CStr(Request(\"URL\"))
If (Request.QueryString <> \"\") Then
  MM_editAction = MM_editAction & \"?\" & Request.QueryString
End If

\' boolean to abort record edit
MM_abortEdit = false

\' query string to execute
MM_editQuery = \"\"
%>
<%
\' *** Insert Record: set variables

If (CStr(Request(\"MM_insert\")) <> \"\") Then

  MM_editConnection = MM_bo_STRING
  MM_editTable = \"tblUser\"
  MM_editRedirectUrl = \"office_reg.asp\"
  MM_fieldsStr  = \"name|value|email|value|username|value|password|value|hostname|value\"
  MM_columnsStr = \"name|\',none,\'\'|email|\',none,\'\'|username|\',none,\'\'|password|\',none,\'\'|hostname|\',none,\'\'\"

  \' create the MM_fields and MM_columns arrays
  MM_fields = Split(MM_fieldsStr, \"|\")
  MM_columns = Split(MM_columnsStr, \"|\")
 
  \' set the form values
  For i = LBound(MM_fields) To UBound(MM_fields) Step 2
    MM_fields(i+1) = CStr(Request.Form(MM_fields(i)))
  Next

  \' append the query string to the redirect URL
  If (MM_editRedirectUrl <> \"\" And Request.QueryString <> \"\") Then
    If (InStr(1, MM_editRedirectUrl, \"?\", vbTextCompare) = 0 And Request.QueryString <> \"\") Then
      MM_editRedirectUrl = MM_editRedirectUrl & \"?\" & Request.QueryString
    Else
      MM_editRedirectUrl = MM_editRedirectUrl & \"&\" & Request.QueryString
    End If
  End If

End If
%>
<%
\' *** Insert Record: construct a sql insert statement and execute it

If (CStr(Request(\"MM_insert\")) <> \"\") Then

  \' create the sql insert statement
  MM_tableValues = \"\"
  MM_dbValues = \"\"
  For i = LBound(MM_fields) To UBound(MM_fields) Step 2
    FormVal = MM_fields(i+1)
    MM_typeArray = Split(MM_columns(i+1),\",\")
    Delim = MM_typeArray(0)
    If (Delim = \"none\") Then Delim = \"\"
    AltVal = MM_typeArray(1)
    If (AltVal = \"none\") Then AltVal = \"\"
    EmptyVal = MM_typeArray(2)
    If (EmptyVal = \"none\") Then EmptyVal = \"\"
    If (FormVal = \"\") Then
      FormVal = EmptyVal
    Else
      If (AltVal <> \"\") Then
        FormVal = AltVal
      ElseIf (Delim = \"\'\") Then  \' escape quotes
        FormVal = \"\'\" & Replace(FormVal,\"\'\",\"\'\'\") & \"\'\"
      Else
        FormVal = Delim + FormVal + Delim
      End If
    End If
    If (i <> LBound(MM_fields)) Then
      MM_tableValues = MM_tableValues & \",\"
      MM_dbValues = MM_dbValues & \",\"
    End if
    MM_tableValues = MM_tableValues & MM_columns(i)
    MM_dbValues = MM_dbValues & FormVal
  Next
  MM_editQuery = \"insert into \" & MM_editTable & \" (\" & MM_tableValues & \") values (\" & MM_dbValues & \")\"

  If (Not MM_abortEdit) Then
    \' execute the insert
    Set MM_editCmd = Server.CreateObject(\"ADODB.Command\")
    MM_editCmd.ActiveConnection = MM_editConnection
    MM_editCmd.CommandText = MM_editQuery
    MM_editCmd.Execute
    MM_editCmd.ActiveConnection.Close

    If (MM_editRedirectUrl <> \"\") Then
      Response.Redirect(MM_editRedirectUrl)
    End If
  End If

End If
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">
</head>
<body bgcolor=\"#FFFFFF\" text=\"#000000\">
<form method=\"post\" action=\"<%=MM_editAction%>\" name=\"form1\">
  <table align=\"center\">
    <tr valign=\"baseline\">
      <td nowrap align=\"right\">Name:</td>
      <td>
        <input type=\"text\" name=\"name\" value=\"\" size=\"32\">
      </td>
    </tr>
    <tr valign=\"baseline\">
      <td nowrap align=\"right\">Email:</td>
      <td>
        <input type=\"text\" name=\"email\" value=\"\" size=\"32\">
      </td>
    </tr>
    <tr valign=\"baseline\">
      <td nowrap align=\"right\">Username:</td>
      <td>
        <input type=\"text\" name=\"username\" value=\"\" size=\"32\">
      </td>
    </tr>
    <tr valign=\"baseline\">
      <td nowrap align=\"right\">Password:</td>
      <td>
        <input type=\"text\" name=\"password\" value=\"\" size=\"32\">
      </td>
    </tr>
    <tr valign=\"baseline\">
      <td nowrap align=\"right\">Hostname:</td>
      <td>
        <input type=\"text\" name=\"hostname\" value=\"\" size=\"32\">
      </td>
    </tr>
    <tr valign=\"baseline\">
      <td nowrap align=\"right\">&nbsp;</td>
      <td>
        <input type=\"submit\" value=\"Insert Record\">
      </td>
    </tr>
  </table>
  <input type=\"hidden\" name=\"MM_insert\" value=\"true\">
  <input type=\"hidden\" name=\"programID\" value=\"<%=now()%>\">
</form>
<p>&nbsp;</p>
<p>&nbsp;</p>
</body>
</html>