Solved

Sorting Columns, Add Items to a Cart, Send HTML Email

Posted on 2003-11-26
3
216 Views
Last Modified: 2013-12-24
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.
0
Comment
Question by:zakirdavis
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 17

Accepted Solution

by:
anandkp earned 250 total points
ID: 9831235
I guess - ur trying to have a project done here ...

U shld have ur requirements answered in small small queries ...

Sorting COlumns : have a look at
http://oldlook.experts-exchange.com/Web/WebDevSoftware/ColdFusion/Q_20799971.html

to display teh items & show view cart or delete selections .. u need to well versed with SQL
i hope u have a good knowledge of insert / update & delete queries

email :
<CFMAIL TO="anand@ee.com" FROM="yourname@yourdomain.com" SUBJECT="hi - html mail" TYPE="HTML">
      <!--- I hope u have configured teh IP address for ur mails erver in CFADMIN --->
      <TABLE>
            <TR>
                  <TD>name</TD>
                  <TD>Age</TD>
                  <TD>country</TD>
            </TR>
            <TR>
                  <TD>:</TD>
                  <TD>:</TD>
                  <TD>:</TD>
            </TR>
            <TR>
                  <TD><B>anand</B></TD>
                  <TD><B>19</B></TD>
                  <TD><B>india</B></TD>
            </TR>
      </TABLE>
</CFMAIL>

the same email can be generated for the selections done by the user & have them emailed in their inbox. all u need to do is run a CFQUERY & change ur email tag to

<CFQUERY NAME="Qry_eMailcart" DATASOURCE="Dsn">
    Select * from tbl_shoppingcart where userid = 'anandkp'
</CFQUERY>

<CFMAIL QUERY="Qry_eMailcart" TO="#useremailid#" FROM="yourname@yourdomain.com" SUBJECT="cart-details" TYPE="HTML">
      <!--- I hope u have configured teh IP address for ur mails erver in CFADMIN --->
      <TABLE>
            <TR>
                  <TD>name</TD>
                  <TD>Age</TD>
                  <TD>country</TD>
            </TR>
            <TR>
                  <TD>:</TD>
                  <TD>:</TD>
                  <TD>:</TD>
            </TR>
            <TR>
                  <TD><B>#name#</B></TD>
                  <TD><B>#age#</B></TD>
                  <TD><B>#country#</B></TD>
            </TR>
      </TABLE>
</CFMAIL>
0
 
LVL 17

Expert Comment

by:anandkp
ID: 9841460
HELLO ???
0
 

Author Comment

by:zakirdavis
ID: 9841754
should i store things in a structure?
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SCCM vs Windows server 5 89
Run a Radio Station (Streaming media) with web interface 10 84
How to use 2 separate DNS names. 5 54
SonicWall port forward 4 24
In our day to day coding, how many times have we come across a necessity to check whether a URL is a broken link or not? For those of you that answered countless and are using ColdFusion like myself, then this article is for you.  It will show yo…
Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question