Editing the fpdbform.inc in frontpage2000 (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

momof4boys -> Editing the fpdbform.inc in frontpage2000 (3/19/2001 20:06:00)

I have edited this and it works but the form info comes into the email as a link with & and + symbols and it is all in one line.
What do I need to do to get this info into the email body in a way that is more presentable?

sFrom = Request.Form("EMailAddress")
sTo = "midwestdreams@yahoo.com"
sSubject = "My Ad"
sBody = Request.Form
----------------
Set myCDONTSMail= CreateObject("CDONTS.NewMail")
myCDONTSMail.BodyFormat= 1
MyCDONTSMail.MailFormat= 0
myCDONTSMail.Importance= 2
myCDONTSMail.Send sFrom, sTo, sSubject, sBody
Set myCdontsMail= Nothing
-------------------

This is how it shows up in Email
-------------------
VTI-GROUP=0&MemberID=1321564869&City=Wichita&State=Kansas&EmailAddress=mom_of_4boys@yahoo.com&Category=Antiques%2FCollectables&ItemName=Testing21&Description=this+is+just+a+test&Pr ice=00&B1=Submit
--------------------
I sure hope somebody can help me.

Thanks in advance!!!!!
Christina



Vince from Spain -> RE: Editing the fpdbform.inc in frontpage2000 (3/20/2001 23:10:00)

Hi Christina,
the bit that is getting you into the pickle is the line . . .

sBody = Request.Form

which will just make the body of the message all the variables that have been posted to the page, formatting and all.

To format it a bit more nicely, try for instance replacing it with . . .

sBody = "MemberID = " & Request.Form("MemberID") & vbcrlf & _
"City = " & Request.Form("City") & vbcrlf & _
"State = " & Request.Form("State") & vbcrlf & _
"Email = " & Request.Form("EmailAddress") & vbcrlf & _
. . . . . . (and so on until) . . . .
"Price = " & Request.Form("Price") & vbcrlf


All the best

Vince

------------------
Internet Business Solutions S.L.(Spain)




momof4boys -> RE: Editing the fpdbform.inc in frontpage2000 (3/20/2001 23:44:00)

Ok
Lookin over my message it looks like I left a bunch out....anyway this is what I have now......Function FP_FormConfirmation(szCharset, szTitle, szmsg1, szUrl, szMsg2)

sFrom = Request.Form("EMailAddress")
sTo = "midwestdreams@yahoo.com"
sSubject = "My Ad"

sBody = "MemberID = " & Request.Form("MemberID") & vbcrlf & _
"City = " & Request.Form("City") & vbcrlf & _
"State = " & Request.Form("State") & vbcrlf & _
"Email = " & Request.Form("EmailAddress") & vbcrlf & _
"Category = " & Request.Form("Category") & vbcrlf & _
"ItemName = " & Request.Form("ItemName") & vbcrlf & _
"Description = " & Request.Form("Description") & vbcrlf & _
"Price = " & Request.Form("Price") & vbcrlf & _

Set myCDONTSMail= CreateObject("CDONTS.NewMail")
myCDONTSMail.BodyFormat= 1
MyCDONTSMail.MailFormat= 0
myCDONTSMail.Importance= 2
myCDONTSMail.Send sFrom, sTo, sSubject, sBody
Set myCdontsMail= Nothing

And I'm not even getting my form to display...
What did I do wrong????



momof4boys -> RE: Editing the fpdbform.inc in frontpage2000 (3/20/2001 22:00:00)

Ok....
Vince
I don't know what I did wrong when I tried your suggestion the first time but I tried it again and it works perfectly.

Thank You Very Much!!!!!




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.0625