Emailing Contents of An Already Processed Form

I've developed a webpage that displays the contents of my database. The user has 4 different views to look at, (View 1, View 2, View 3 and View All). In each of these views the user can select some rows, add the rows to a cart and continue browsing.

I know how to get what the user selected , but i don't know how to get what they selected, store their selection, allow them to continue surfing, store more rows, and then finally email the administrator their selections.

This is what i don't know how to do:

1. I do not know how to allow users to Sort Columns by clicking a Column Header.

2. I do not know how to allow user to select rows (via checkbox) and send the selections to a cart (structure i am assuming), continue browsing and add more items to cart.

3. I do not know how to have all the pages display how many items they have the the cart.

4. I do not know how to have user view cart and delete selections.

5. I do not know how to have user email their selections over to an email address that is stored in the same database (different table).

6. I do not know how to send html email to administrator.
zakirdavisAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MauseCommented:
You can just use cfmail and type=HTML

<cfmail to="#Email#" from="me@this.com" subject="message from me" type="HTML">
<Table>
  <TR BGCOLOR="#bgcolor#">
        <TD><DIV ALIGN="CENTER"><FONT  SIZE="-1">
            <CFIF column1 IS "">
              <B><FONT color=red>n/a</FONT></B>
              <CFELSE>
              #column1#
            </CFIF>
            </FONT></DIV>
       </TD>
  </tr>
</TABLE>
</cfmail>

But make sure you also submit the sellection in a hiiden field or something

Mause
0
hartCommented:
ok thats simple, pass the #FORM.PROPID# from Results.cfm in an hidden field to sendmail.cfm

on that page now u can do the following

----------send mail page
<CFQUERY name="invest" datasource="Investment">
SELECT ID, column1, column2, column3, column4, column5, column6, column7, column8, column9,
column10, column11, column12
FROM Land
WHERE ID IN (#FORM.PROPID#)
ORDER BY column1 ASC
</CFQUERY>

<CFMAIL FROM="Your Name<system@am.com>" TO="#Trim(form.FName)# #Trim(form.LName)#<#Trim(Lcase(form.Email))#>" TYPE="HTML" SUBJECT="what ever u want to write">

    <!--- Include page header --->
<CFINCLUDE TEMPLATE="header.cfm">

<!--- Create HTML Page & Display List --->
<TABLE WIDTH="99%" BORDER="1" ALIGN="CENTER" CELLPADDING="0" CELLSPACING="0" BORDERCOLOR="#CCCCCC">
 <TR>
    <TD BORDERCOLOR="#CCCCCC"><DIV ALIGN="CENTER"><FONT SIZE="-1"><STRONG>Area</STRONG></FONT></DIV></TD>
   <TD BORDERCOLOR="#CCCCCC"><DIV ALIGN="CENTER"><FONT SIZE="-1"><STRONG>Type</STRONG></FONT></DIV></TD>
   <TD BORDERCOLOR="#CCCCCC"><DIV ALIGN="CENTER"><FONT SIZE="-1"><STRONG>Zoned</STRONG></FONT></DIV></TD>
   <TD BORDERCOLOR="#CCCCCC"><DIV ALIGN="CENTER"><FONT SIZE="-1"><STRONG>Dimension</STRONG></FONT></DIV></TD>
   <TD BORDERCOLOR="#CCCCCC"><DIV ALIGN="CENTER"><FONT SIZE="-1"><STRONG>Price</STRONG></FONT></DIV></TD>
   <TD BORDERCOLOR="#CCCCCC"><DIV ALIGN="CENTER"><FONT SIZE="-1"><STRONG>Acres</STRONG></FONT></DIV></TD>
   <TD BORDERCOLOR="#CCCCCC"><DIV ALIGN="CENTER"><FONT SIZE="-1"><STRONG>Per
        Acre</STRONG></FONT></DIV></TD>
   <TD BORDERCOLOR="#CCCCCC"><DIV ALIGN="CENTER"><FONT SIZE="-1"><STRONG>Features</STRONG></FONT></DIV></TD>
   <TD BORDERCOLOR="#CCCCCC"><DIV ALIGN="CENTER"><FONT SIZE="-1"><STRONG>Taxes</STRONG></FONT></DIV></TD>
   <TD BORDERCOLOR="#CCCCCC"><DIV ALIGN="CENTER"><FONT SIZE="-1"><STRONG>Infra</STRONG></FONT></DIV></TD>
   <TD BORDERCOLOR="#CCCCCC"><DIV ALIGN="CENTER"><FONT SIZE="-1"><STRONG>Survey</STRONG></FONT></DIV></TD>
 </TR>
 <TR>
 <TD COLSPAN="11"><BR><CENTER><FONT COLOR="#0000FF"><B><UL>Below Are Your Selections</UL><P></B></FONT></CENTER></TD></TR>

   <cfloop query="invest">
      <!--- What Color Should Row Be? --->
     <CFIF CurrentRow MOD 2 IS 1>
       <CFSET bgcolor="##cccccc">
       <CFELSE>
       <CFSET bgcolor="white">
     </CFIF>
     <TR BGCOLOR="#bgcolor#">
        <TD><DIV ALIGN="CENTER"><FONT  SIZE="-1">
            <CFIF column1 IS "">
             <B><FONT color=red>n/a</FONT></B>
              <CFELSE>
             #column1#
            </CFIF>
           </FONT></DIV></TD>
       <TD><DIV ALIGN="CENTER"><FONT  SIZE="-1">
            <CFIF column2 IS "">
             <B><FONT color=red>n/a</FONT></B>
              <CFELSE>
             #column2#
            </CFIF>
           </FONT></DIV></TD>
       <TD><DIV ALIGN="CENTER"><FONT  SIZE="-1">
            <CFIF column3 IS "">
             <B><FONT color=red>n/a</FONT></B>
              <CFELSE>
             #column3#
            </CFIF>
           </FONT></DIV></TD>
       <TD><DIV ALIGN="CENTER"><FONT  SIZE="-1">
            <CFIF column4 IS "">
             <B><FONT color=red>n/a</FONT></B>
              <CFELSE>
             #column4#
            </CFIF>
           </FONT></DIV></TD>
       <TD><DIV ALIGN="RIGHT"><FONT  SIZE="-1">
            <CFIF column5 IS "">
             <B><FONT color=red>n/a</FONT></B>
              <CFELSE>
             #NumberFormat(column5, "$,")#
            </CFIF>
           </FONT></DIV></TD>
       <TD><DIV ALIGN="CENTER"><FONT  SIZE="-1">
            <CFIF column6 IS "">
             <B><FONT color=red>n/a</FONT></B>
              <CFELSE>
             #column6#
            </CFIF>
           </FONT></DIV></TD>
       <TD><DIV ALIGN="RIGHT"><FONT  SIZE="-1">
            <CFIF column7 IS "">
             <B><FONT color=red>n/a</FONT></B>
              <CFELSE>
             #NumberFormat(column7,"$,.__")#
            </CFIF>
           </FONT></DIV></TD>
       <TD><DIV ALIGN="CENTER"><FONT  SIZE="-1">
            <CFIF Features IS "">
             <B><FONT color=red>n/a</FONT></B>
              <CFELSE>
             #column8#
            </CFIF>
           </FONT></DIV></TD>
       <TD><DIV ALIGN="CENTER"><FONT  SIZE="-1">
            <CFIF column9 IS "">
             <B><FONT color=red>n/a</FONT></B>
              <CFELSE>
             <DIV ALIGN="RIGHT">#NumberFormat(column9,"$,.__")#</DIV>
           </CFIF>
           </FONT></DIV></TD>
       <TD><DIV ALIGN="CENTER"><FONT  SIZE="-1">
            <CFIF column10 IS "">
             <B><FONT color=red>n/a</FONT></B>
              <CFELSE>
             #column10#
            </CFIF>
           </FONT></DIV></TD>
       <TD><DIV ALIGN="CENTER"><FONT  SIZE="-1">
            <CFIF column11 IS "">
             <B><FONT color=red>n/a</FONT></B>
              <CFELSE>
             #column11#
            </CFIF>
           </FONT></DIV></TD>
     </TR>
   </cfloop>
  </table>
</cfmail>


Regards
Hart
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
hartCommented:
oh i am late :-)

Regards
Hart
0
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

hartCommented:
oh i am late :-)

Regards
Hart
0
hartCommented:
Thnx :-)
0
zakirdavisAuthor Commented:
Thank you. it helped quite a bit. Can you check out my new question?
0
hartCommented:
sorry i coudn't reply earlier, i was out of station...

see u have the #FORM.PROPID# defined in your page [before sending the mail]
<TR>
    <TD COLSPAN="2"><DIV ALIGN="CENTER">
        <P>&nbsp;</P><TABLE WIDTH="35%" BORDER="0" CELLSPACING="0" CELLPADDING="0">
          <TR VALIGN="BOTTOM">
            <TD WIDTH="50%"> <DIV ALIGN="CENTER">
                <INPUT NAME="Send" TYPE="submit" ID="Send" VALUE="Send">
              </DIV></TD>
            <TD WIDTH="50%"> <DIV ALIGN="CENTER">
                <INPUT TYPE="RESET" NAME="Submit2" VALUE="Reset">
              </DIV></TD>
          </TR>
        </TABLE>
      </DIV></TD>
  </TR>
</TABLE>
        </DIV>
        <input type="hidden" name="PROPID" value="<cfoutput>#FORM.PROPID#</cfoutput>"> <!--- note this line of code --->
       </TD>
    </TR>
  </CFFORM>
</TABLE>

This is how us pass the propid in an hidden field to send mail page

Regards
Hart
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Servers

From novice to tech pro — start learning today.