Solved

adding an identifier for a row

Posted on 2004-04-18
17
154 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
  • 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
 
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
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…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video discusses moving either the default database or any database to a new volume.

706 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now