The processing page must be a .asp page (ASP does not run on .htm pages) and running on a server that supports .asp
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________
| the server supports cdonts and asp/access, thats not the issue, I had
| to modify the script b/c the field names in my table were different
| from that script, here is the info:
|
| The form page (form.htm, should it be .asp? Neither worked):
| <form method="POST" action="form2.asp">
| <table border="1" width="100%">
| <tr>
| <td width="50%">From</td>
| <td width="50%"><input type="text" name="from" size="20"></td>
| </tr>
| <tr>
| <td width="50%">Subject</td>
| <td width="50%"><input type="text" name="subject" size="20"></td>
| </tr>
| <tr>
| <td width="50%">Body</td>
| <td width="50%"><textarea rows="2" name="body"
| cols="20"></textarea></td>
| </tr>
| <tr>
| <td width="50%">Password</td>
| <td width="50%"><input type="text" name="password" size="20"
| value="dummy"></td>
| </tr>
| </table>
| <p><input type="submit" value="Submit" name="B1"><input type="reset"
| value="Reset" name="B2"></p>
| </form>
|
|
| ---
|
| The results page:
|
| <!--webbot bot="DatabaseRegionStart" startspan
| s-columnnames="emailID,emailNAME,name1" s-columntypes="3,202,202"
| s-dataconnection="naameccDATA" b-tableformat="FALSE"
| b-menuformat="FALSE"
| s-menuchoice="emailNAME" s-menuvalue="emailNAME" b-tableborder="TRUE"
| b-tableexpand="TRUE"
| b-tableheader="TRUE" b-listlabels="FALSE" b-listseparator="FALSE"
| i-ListFormat="0" b-makeform="TRUE" s-recordsource="emailTBL"
| s-displaycolumns="emailNAME" s-criteria s-order s-sql="SELECT * FROM
| emailTBL"
| b-procedure="FALSE" clientside SuggestedExt="asp" s-DefaultFields
| s-NoRecordsFound="No records returned." i-MaxRecords="0"
| i-GroupSize="0"
| BOTID="0" u-dblib="_fpclass/fpdblib.inc"
| u-dbrgn1="_fpclass/fpdbrgn1.inc"
| u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="BODY"
| local_preview="<table border=0
| width="100%"><tr><td bgcolor="#FFFF00"
| align="left"><font
| color="#000000">Database Results regions will not preview
| unless this page is fetched from a Web server using a web browser. The
| section of the page from here to the end of the Database Results region
| will repeat once for each record returned by the
| query.</font></td></tr></table>"
| preview="<table border=0 width="100%"><tr><td
| bgcolor="#FFFF00" align="left"><font
| color="#000000">This is the start of a Database Results
| region.</font></td></tr></table>"
| b-WasTableFormat="FALSE" --><!--#include file="_fpclass/fpdblib.inc"-->
| <%
| fp_sQry="SELECT * FROM emailTBL"
| fp_sDefault=""
| fp_sNoRecords="No records returned."
| fp_sDataConn="naameccDATA"
| fp_iMaxRecords=0
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=False
| fp_fMenuFormat=False
| fp_sMenuChoice="emailNAME"
| fp_sMenuValue="emailNAME"
| fp_iDisplayCols=1
| fp_fCustomQuery=False
| BOTID=0
| fp_iRegion=BOTID
| %>
| <!--#include file="_fpclass/fpdbrgn1.inc"-->
| <!--webbot bot="DatabaseRegionStart" endspan i-CheckSum="43973" -->
| <p><!--webbot bot="DatabaseResultColumn" startspan
| s-columnnames="emailID,emailNAME,name1" s-column="emailNAME"
| b-tableformat="FALSE" b-hasHTML="FALSE" clientside
| local_preview="<font
| size="-1">&lt;&lt;</font>emailNAME<font
| size="-1">&gt;&gt;</font>"
| preview="<font
| size="-1">&lt;&lt;</font>emailNAME<font
| size="-1">&gt;&gt;</font>"
| --><%=FP_FieldVal(fp_rs,"emailNAME")%><!--webbot
| bot="DatabaseResultColumn" endspan i-CheckSum="17555" --><%
| If Request.Form("password") = "dummy" Then
| Set objCDOMail = Server.CreateObject("CDONTS.NewMail")
| objCDOMail.To = fp_rs("emailNAME")
| objCDOMail.From = Request.Form("from")
| objCDOMail.Subject = Request.Form("subject")
| objCDOMail.Body = Request.Form("body")
| objCDOMail.Send
| Set objCDOMail = Nothing
| End If
| %>
| <!--webbot bot="HTMLMarkup" startspan --><!--webbot bot="HTMLMarkup"
| endspan -->
| </p>
| <!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="FALSE"
| b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
| clientside
| tag="BODY"
| local_preview="<table border=0
| width="100%"><tr><td bgcolor="#FFFF00"
| align="center"><font color="#000000">End
| of Database Results
| region.</font></td></tr></table>"
| preview="<table border=0 width="100%"><tr><td
| bgcolor="#FFFF00" align="left"><font
| color="#000000">This is the end of a Database Results
| region.</font></td></tr></table>"
| --><!--#include file="_fpclass/fpdbrgn2.inc"-->
| <!--webbot bot="DatabaseRegionEnd" endspan i-CheckSum="62730" -->
|
|
| Mike Mueller wrote:
| > What type of server is the site hosted on? CDONTS is
| > obsolete, and not available on new server OSs
| > NT4: CDONTS
| > 2000: CDONTS or CDOSYS
| > XP: CDOSYS
| > 2003: CDOSYS
| >
| >
| >
| > | > : Does anyone have a good script they can recommend to send
| > email to a
| > : table or query in a database using cdonts? I have only
| > found this
| > :
http://home.att.net/~codeLibrary/FrontPage/cdonts.htm and
| > I cant get it
| > : to work. I'm trying to create an online form that will
| > email the
| > : subject and body to all emails in a database table or
| > query. That
| > : link appears to list the process for doing it but it
| > doesnt seem to
| > : work.
| > :
| > : Thanks,
| > : Robert
|
