Solved

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

Posted on 2003-11-26
3
220 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

Save the day with this special offer from ATEN!

Save 30% on the CV211 using promo code EXPERTS30 now through April 30th. The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

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

This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month (considering normal rate of Big Data Cetnters like …
A web service (http://en.wikipedia.org/wiki/Web_service) is a software related technology that facilitates machine-to-machine interaction over a network. This article helps beginners in creating and consuming a web service using the ColdFusion Ma…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

717 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