Creat a ColdFusion collection with the cfcollection tag

-

On occasion a developer may not have access to ColdFusion Administrator, for example, if you use a virtual hosting company. If you want your ColdFusion application to be able to create, delete, and maintain a collection you will need to use the cfcollection tag. The following will show you how to create a collection index it then index it to include a MS Access database this code works great for use with a serch function for your shopping cart site. You will need to create an Access database with a table named Products and you will need the following fields ItemID, ProductID, ProductName, BriefDescription, Details.

 

To create a simple collection form page:

Create a ColdFusion page with the following content:

[html]

[head]

[title]Collection Creation Input Form[/title]

[/head]

[body]

[h2]Specify a collection[/h2]

[form action="collection_action.cfm" method="POST"]

[!--- The following can be changed to your needs ---]

 

[p]Collection name:mycart

[/p]

 

[p]What do you want to do with the collection?[/p]

[input type="radio"

name="CollectionAction"

value="Create" checked]Create[br]

[input type="radio"

name="CollectionAction"

value="Repair"]Repair[br]

[input type="radio"

name="CollectionAction"

value="Optimize"]Optimize[br]

[input type="radio"

name="CollectionAction"

value="Delete"]Delete[br]

[input type="submit"

name="submit"

value="Submit"]

[/form]

 

[/body]

[/html]

 

Save the file as collection_form.cfm in the web root directory.

 

 

To create a simple collection form action page:

Create a ColdFusion page with the following content:

[html]

[head]

[title]cfcollection[/title]

[/head]

[body]

[h2]Collection creation[/h2]

 

[cfoutput]

 

[cfswitch expression=#Form.collectionaction#]

[cfcase value="Create"]

[cfcollection action="Create"

collection="mycart"

[!--- Replace with the path to your web root directory ---]

path="D:\Inetpub\www\"]

[p]The collection mycart is created.

[/cfcase]

 

[cfcase value="Repair"]

[cfcollection action="Repair"

collection="mycart"]

[p]The collection mycart is repaired.

[/cfcase]

 

[cfcase value="Optimize"]

[cfcollection action="Optimize"

collection="mycart"]

[p]The collection mycart is optimized.

[/cfcase]

 

[cfcase value="Delete"]

[cfcollection action="Delete"

collection="mycart"]

[p]Collection mycart deleted.

[/cfcase]

[/cfswitch]

[/cfoutput]

[/body]

[/html]

Save the file as collection_action.cfm in the web root directory.

In the web browser, enter the following URL to display the form page:

http://www.yourserver.com/collection_form.cfm

Verify that Create is selected and submit the form.

You successfully created a collection, named mycart. Now we have to index it.

 

 

Indexing a collection using the cfindex tag

You can index a collection using the cfindex tag, which eliminates the need to use the ColdFusion MX Administrator.

Create a ColdFusion page with the following content:

[html]

[head]

[title]Creating Index[/title]

[/head]

[body]

[h2]Indexing Complete[/h2]

 

[cfindex collection="mycart"

action="refresh"

extensions=" .mdb, .htm, .html, .xls, .txt, .mif, .doc"

[!--- Replace with the path to your web root directory ---]

key="D:\Inetpub\www\"

type="path"

urlpath="D:\Inetpub\www\"

recurse="Yes"

language="English"]

 

[cfoutput]

The collection mycart has been indexed.

[/cfoutput]

[/body]

[/html]

Save the file as collection_index_action.cfm in web_root.

In the web browser, enter the following URL to display the form page:

http://www.yourserver.com/ collection_index_action.cfm

A confirmation message appears upon successful completion.

 

Adding database information to a CF collection

To add your database information to your collection:

Create a ColdFusion page with the following content:

[html]

[head]

[title]Adding Query Data to an Index[/title]

[/head]

[body]

 

[!--- retrieve data from the table ---]

[cfquery name="mydata" datasource="mycart"]

SELECT * FROM Products

[/cfquery]

 

[!--- update the collection with the above query results ---]

[cfindex

query="mydata"

collection="mycart"

action="Update"

type="Custom"

key="ItemID"

title="ProductName"

Custom1="ProductName"

custom2="BriefDescription"

body="ItemID,ProductID,ProductName,BriefDescription,Details"]

[h2]Indexing Complete[/h2]

[!--- output the record set ---]

[p]Your collection now includes the following items:[/p]

[cfoutput query="mydata"]

[p]#ItemID# #ProductID# #ProductName# #BriefDescription# #Details#[/p]

[/cfoutput]

[/body]

[/html]

 

To create a simple collection form action page:

Create a ColdFusion page with the following content:

[html]

[head]

[title]Verity Search Results[/title]

[meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"]

[/head]

[body]

[cfsearch name="mydata"

collection="mycart"

criteria="#form.criteria#"]

[strong]Your Results[/strong]

[cfoutput query="mydata"]

[cfif URL IS ""]

[p][a href="http://www.yourserver.com/index.cfm?action=ViewDetails&ItemID=#key#"]#title#[/a][br]

[/p]

[cfelse]

[p][a href="http://www.yourserver.com/index.cfm?Action=ViewCategory&Category=9"][/a][br]

[/p]

[/cfif]

[/cfoutput]

[/body]

[/html]

Comments

Post a Comment

Popular posts from this blog

Protopage a great iGoogle Alternative

-
Well if you haven't heard iGoogle will be shut down by Google in November of 2013, so it may be time to look at some alternatives. I recently came across Protopage you can find them here http://www.protopage.com/ Protopage launched in 2005 and is still going despite nearly every other start page shutting down or becoming derelict. Due to popular demand, they have released better support for tablets and larger smartphones, so that you have the choice between viewing the mobile version or the normal version of Protopage on your device. There isn't much to dislike about Protopage. It has a very nice Web 2.0-oriented design, and it is very solid in every area that you expect from a personalized start page. The ability to view multiple RSS feeds in a single module and the integrated podcasts puts this start page right up there among the best. What’s the business model? No idea. It’s totally free and sans-ads, at least for now. No registration at all is requir
Read more

A simple Flex Builder contact form

-
Ok here is my simple flex builder contact form. It will validate fields then post form data to a backend page for processing. This Flex Builder Form does not use the httpservice to retrieve information its just a simple post form that keeps the bots from filling out the form on a standard web site   <?xml version="1.0" encoding="utf-8"?> <mx:Application xmlns:validators="validators.*" applicationComplete="validator()" xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute" width="480" height="500" backgroundGradientColors="[#ffffff, #ffffff]"> <mx:Script>                 <![CDATA[                                 private function validator():void {         submitButton.enabled = Validator.validateAll(             [requireName, requirePhone, validateEmail]).length == 0;     }                 private function submit():void {         var args:URLVariabl
Read more

Designing a Better Contact Page

-
Image
A good contact page is essential for maintaining relationships with your visitors. Whether we’re talking eCommerce, magazines, personal websites, online services, users will usually seek out a contact page as their first means of communication with you. Oddly enough, many web designers neglect the humble contact page, even considering it one of the least important aspects of a website. Let’s put that right. The Importance of a Good Contact Page A contact page is often overlooked. How many times have you visited a website, wanting to get in touch to complain about a product or service, or ask a question? And how often have you struggled with a contact form? A good contact page can benefit any type of business. It can improve customer satisfaction by helping users with their problems. It can also help a business improve its products and services by providing an avenue for valuable feedback. Other channels can be limited when it comes to user feedback. Television, radio, magazines, news
Read more