Solved

adding an identifier for a row

Posted on 2004-04-18
17
160 Views
Last Modified: 2013-12-24
http://www.englishtrunkshowco.com/antiques/china/china.cfm

i would like to add feature where people can add an item to a shopping cart, what is the best way to do that on this page and how can i do that??

thanks
0
Comment
Question by:finnstone
[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
  • 6
  • 6
  • 5
17 Comments
 
LVL 17

Expert Comment

by:Tacobell777
ID: 10855169
If you are retrieving the items from a database then I assume they already have a Identifier, if not, first assign an identifier to the table.

Easiest way (for you) is to probably use CLIENT variables, if they click an item you just add the item to a list stored in the CLIENT. scope.

You could do something like, and this is the best I could do, if I need to write anymore I might as well write you a whole shopping cart ;-))

<cfif NOT isDefined("client.order")>
      <!--- initialize list --->
      <cfset client.order = "">
</cfif>

<!--- if we need to add the item to our order and it does not already exist --->
<cfif isDefined("url.addToOrder") AND NOT listFindNoCase(client.order, url.addToOrder)>
      <cfset client.order = listAppend(client.order, url.addToOrder)>
</cfif>

<!--- if we need to remove the item from the order --->
<cfif isDefined("url.removeFromOrder")>
      <cfset client.order = listDeleteAt(client.order, listFindNoCase(client.order, url.removeFromOrder))>
</cfif>

<!--- if we need to display the order --->
<cfif isDefined("url.showOrder")>
      <cfoutput>
      #listLen(client.order)# Item(s) ordered:<br>
      </cfoutput>
      <cfloop index="item" list="#client.order#">
            <!--- retrieve the item details here if need be --->
            Item number: #listGetAt(client.order, variables.item)#<br>
      </cfloop>
</cfif>

Don't forget to enable client variables in your cfapplication.

0
 
LVL 17

Expert Comment

by:Tacobell777
ID: 10855174
Another way would be to use one of the many free shopping carts offered on developers exchange on Macromedia.om
0
 

Author Comment

by:finnstone
ID: 10855529
sorry i am asking from a more simpler approach.

 i have a coldfusion cfc that can process adding something to a cart, i am using this for my flash web site. now i am just looking for a way to call this cfc for adding an item from the html version.. for instance, how can i identify the product that is clicked to be added to cart.
0
Turn your laptop into a mobile console!

The CV211 Laptop USB Console Adapter provides a direct Laptop-to-Computer connection for fast and easy remote desktop access with no software to install.

 
LVL 18

Accepted Solution

by:
Plucka earned 200 total points
ID: 10855935
<input type="button" value="Add to Cart" onclick="actionpage.cfm?productId=#productId#">

actionpage.cfm would do the necessary bits and call the cfc function. Let me know.
0
 
LVL 17

Expert Comment

by:Tacobell777
ID: 10855962
<a href="actionpage.cfm?productID=#yourProductID#"><img src="yourimage here"></a>
Better than using javascript, as that might be turned of and won't work for screen readers etc.

Or even use a button <input type="submit" name="product_45" value="Add">

And on the action page you loop through the form scope and see if the field start with "product_" if so do a listlast with delimeter "_" to get the product ID..

You might want to ask your question a bit clearer next time so people don't waste time ;-))
0
 

Author Comment

by:finnstone
ID: 10856040
how could i send the product to a javascript function and how can i call a cfc from that javascript function? then how can i reload the current page from the cfc

thanks for the continual support.
0
 
LVL 18

Expert Comment

by:Plucka
ID: 10856098
That's a totally different question again.

Why do you want to go via a javascript function exactly?

CFC's are normally not called from javascript functions, although it's possible, I think if we understood why you want to do this we could recommend a better solution.
0
 

Author Comment

by:finnstone
ID: 10856256
i want to update the cart using the cfc but i want to refresh the page so that the cart table shows that an item has been added.

i suppose i do not need javascript, all i have to do is call the cfc which will then reload the page.
0
 
LVL 18

Expert Comment

by:Plucka
ID: 10856265
Ok,

So lets say your first page has the add to order button. Which runs an ActionPage.

The actionpage would

1. Invoke the cfc using <CFINVOKE or similar
2. Use <CFLOCATION or a javascript redirect to return to the main page.

The main page would probably also call the cfc to determine the quantities ordered for each product.
0
 
LVL 17

Assisted Solution

by:Tacobell777
Tacobell777 earned 300 total points
ID: 10856283
If you post the page to itself and then at the top of the page call the CFC you do not need to do a refresh or relocation.

All you do at the top of the page is <cfif isDefined("url.productid")> call the cfc </cfif>
0
 

Author Comment

by:finnstone
ID: 10856330
taco, thats an awesome idea, thanks
0
 
LVL 18

Expert Comment

by:Plucka
ID: 10856342
You can also do it without the page refreshing at all, but taco's answer is the simplest.
0
 

Author Comment

by:finnstone
ID: 10864744
wait if i call the cfc, then wont i then go to the cfc, and then i will have to do a cflocation just to get back to the main page??

can you show me how this would e done
0
 
LVL 17

Expert Comment

by:Tacobell777
ID: 10866541
Page-----------

<cfif isDefined("url.productid")>
call your cfc here
</cfif>

<a href="thissamepage.cfm?productid=44">add me</a>
0
 
LVL 18

Expert Comment

by:Plucka
ID: 10866562
Calling a method in a CFC doesn't actually run the page like <CFLOCATION. It just calls the function and returns to the calling page, passing back paramaters if they exist.

Taco's example is correct.

I assume the cfc will return an array or structure of ordered items. So you will need to check this when redisplaying the page to display the current qty in the order.
0
 

Author Comment

by:finnstone
ID: 10924109
i am getting an error message from this line of code - it says expression required

 <td width="24%"><div align="center"><input type="button" value="Add to Cart" onclick="antique_lamps.cfm?addprodId=#PRODUCT.productoid#"></div></td>
0
 
LVL 18

Expert Comment

by:Plucka
ID: 10924149
Sorry, must have abreviated this.

 <td width="24%"><div align="center"><input type="button" value="Add to Cart" onclick="window.location.assign('antique_lamps.cfm?addprodId=#PRODUCT.productoid#');"></div></td>
0

Featured Post

Portable, direct connect server access

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

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…
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…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

690 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