Updating database before submitting form

takabyte · July 9th, 2003, 12:14 PM

I have a form that must be submitted by POST method to a CGI page, but I first need to post some of the form content to an ASP database. Is it possible to invoke ASP code with an "onsubmit=" within a FORM?

abbylee26 · July 10th, 2003, 08:38 AM

Would not the easiest way be to send your data to the next page and do your insert command in your <head> area so it happens before the new page is processed? At least this is the way I would handle it.

tyson · July 17th, 2003, 06:58 AM

I am new to all of this but i thought i would ask I made this form that starts off with collecting information from someone like an email then it send s the info to a asp page and it says thank you with the name of the person emailing then how do i get the information to come to me in a a email i am lost please help

lanctotd · July 17th, 2003, 12:43 PM

Hey Tyson, This what worked for me.
in my main page
<FORM ACTION="submitform.asp" Method="Post" >
<INPUT TYPE="hidden" NAME="FormName" VALUE="NameofMainPage.asp">
<INPUT TYPE="hidden" NAME="subject" VALUE="Subject">
<INPUT TYPE="hidden" NAME="SendTo" VALUE="[email protected]">
.
.
.
<INPUT TYPE="SUBMIT" NAME="Submit" VALUE="Send Now!">
</FORM>

then you make a submitform.asp page:

<%
Const strHTTP = "http://folder location"

strDate = Now()

    'get form info
    strFormName = Request("FormName")
    strSubject = Request("subject")
    strSendTo = Request("SendTo")

strHTML = "<HTML> <HEAD> <TITLE></TITLE> </HEAD>"
strHTML = strHTML & "<BODY>"
strHTML = strHTML & "<TABLE WIDTH=600 CELLPADDING=""0"" CELLSPACING=""0"">"
strHTML = strHTML & "<TR><TD COLSPAN=3 ALIGN=CENTER></TD>"
strHTML = strHTML & "</TR>"

'time to send the email
    Dim objCDO
    Set objCDO = Server.CreateObject("CDONTS.NewMail")

    objCDO.To = strSendTo
    objCDO.From = strNumber
    objCDO.Subject = strSubject
    objCDO.BodyFormat = 0
    objCDO.MailFormat = 0
    objCDO.Body = strHTML
    objCDO.Send

    set objCDO = nothing

    'redirect to the "Thanks" page
    Response.Redirect strHTTP & "submitdone.htm"
%>

in the strHTML you can specify the format on how you want it emaild works great...

hope this helps, email me directly if you need more help