Almost everybody who uses a data-driven website has a database containing some information about the users.
I had a database table called "contact" in which user's first name, last name, address, zip, email, phone, fax.... everything was listed.
If you do have something like that and wish to draw and group your contacts by say last names, maybe you will find this tutorial useful.
___________________________
CREATE FIRST FILE : "dir.cfm"
___________________________
Create the first file "dir.cfm"
Then create a cold fusion form. Within the form create 26 buttons with
NAME= "same for all buttons" and VALUE="alphabets from A-Z" as shown in the example
<html>
<head>
<title>DIRECTORY</title>
</head>
<body>
<cfform action="list.cfm"
method="POST"
enablecab="Yes">
<input type="hidden"
name="option"
value="0">
<input type="SUBMIT"
name="a"
value="A">
<input type="SUBMIT"
name="a"
value="B">
<input type="SUBMIT"
name="a" value="C">
<input type="SUBMIT"
name="a"
value="D">
<input type="SUBMIT"
name="a"
value="E">
<input type="SUBMIT"
name="a"
value="F">
<input type="SUBMIT"
name="a"
value="G">
<input type="SUBMIT"
name="a"
value="H">
<input type="SUBMIT"
name="a" value="I">
<input type="SUBMIT"
name="a"
value="J">
<input type="SUBMIT"
name="a"
value="K">
<input type="SUBMIT"
name="a"
value="L">
<input type="SUBMIT" name="a"
value="M">
<input type="SUBMIT"
name="a"
value="N">
<input type="SUBMIT"
name="a"
value="O">
<input type="SUBMIT"
name="a"
value="P">
<input type="SUBMIT"
name="a"
value="Q">
<input type="SUBMIT"
name="a"
value="R">
<input type="SUBMIT"
name="a"
value="S">
<input type="SUBMIT"
name="a"
value="T">
<input type="SUBMIT"
name="a"
value="U">
<input type="SUBMIT"
name="a"
value="V">
<input type="SUBMIT"
name="a"
value="W">
<input type="SUBMIT"
name="a"
value="X">
<input type="SUBMIT" name="a"
value="Y">
<input type="SUBMIT"
name="a" value="Z">
</cfform>
</body>
</html>
______________________________
CREATE SECOND FILE : "list.cfm"
______________________________
Then create a second file "list.cfm" with the query and and listing values in it, as follows;
<!--- this was my query to the directory dsn --->
<cfquery name="dir"
datasource="YOUR DSN"
dbtype="ODBC">
Select *
from
contact
where contact.l_name like '#form.a#%'
</cfquery>
<!--- if you know some basic SQL a% will give you the values starting from "A"
b% will give those starting from "B" and so on.
You can even tweak the "dir.cfm" page to search by last name or first name. For our purpose here I have only searched by Last Names --->
<html>
<head>
<title>LISTINGS</title>
</head>
<body>
<div align="center">
<cfinclude template="dir.cfm">
<hr>
<!--- the rest of it is simple use of cfoutput tags and aligning the query results to you liking. I have done it in a single row of a
table. But you may set it to look differently. --->
Found records: <cfoutput>#dir.recordcount#</cfoutput><br>
<!--- counts number of records found --->
<table width="100%">
<tr align="center"
valign="middle"
bgcolor="eeeeff">
<td>COUNT</td>
<td>NAME</td>
<td>URL</td>
<td>EMAIL</td>
<td>ADDRESS</td>
<td>PHONE</td>
</tr>
<cfoutput query="dir">
<cfform action="directory.cfm"
method="POST"
enablecab="Yes">
<tr bgcolor="###iif(currentrow MOD
2,DE('ffffff'),DE('efefef'))#">
<td>#currentrow#</td>
<td>#f_name# #l_name#</td>
<td>#web_page#</td>
<td>#email#</td>
<td>#address_1#
#address_2#<br>
#city#,#state#-#zip#
</td>
<td>#phone#</td>
</tr>
</cfform>
</cfoutput>
</table>
</div>
</body>
</html>
-
Basic Calculator
This is a tutorial to build a simple calculator for your web pages. You should get it pretty easily as you browse through the code.
Author: Anang A Phatak
Views: 16,304
Posted Date: Tuesday, October 14, 2003 -
An E - Rolodex System
Quick and easy way to sort and list your contacts by last names, in two really really simple steps. Almost everybody who uses a data-driven website has a database containing some information about the users. I had a database table called "contact" in which user's first name, last name, address, zip, email, phone, fax.... everything was listed. If you do have something like that and wish to draw and group your contacts by say last names, maybe you will find this tutorial useful.
Author: Anang A Phatak
Views: 16,497
Posted Date: Friday, November 7, 2003 -
A plot to plot a line
I had no work one day due to a worm attack on our servers, thus a plot to plot a line on a graph was hatched in my empty mind. These files show you, how to plot a line using no database, no java, no long wait times for aplet loading, just 3 tools, Loop, table and text.
Author: Anang A Phatak
Views: 15,256
Posted Date: Thursday, May 6, 2004 -
Automatic Form Generator
This is not a tutorial as such, more like an application that you can put in a directory. It could boring if you use the CF editor, to pick "cfform" fill its attributes, then pick "cfinputs" one by one. fill out those attributes... one by one, then change tabs and pick the "submit" button... so on and so forth. Even if you code in a note pad, it might get lengthy to code individual element. Wouldn't it be nicer to code all these elements at once, then just copy the code and paste it in your editor?
Author: Anang A Phatak
Views: 16,913
Posted Date: Thursday, May 20, 2004 -
A random password generator
RANDOM PASSWORD GENERATOR SCRIPT ! I know there is a random password tutorial here already. This is just another way to do the same. I think this is a little easier to understand. Refresh it to generate a new password string everytime !
Author: Anang A Phatak
Views: 18,213
Posted Date: Monday, May 24, 2004 -
Advanced Calculator
I have posted a "Basic Calculator" tutorial here. That was more like a representation of how you would calculate with a paper and a pencil. You provide INPUT A then a MATHEMATICAL OPERATION like a "+" or a "-" and then an INPUT B. This is more a represntation of how you would use a regular hand-held calculator complete with buttons for NUMBERS, OPERATIONS and CLEAR TEXT.
Author: Anang A Phatak
Views: 15,515
Posted Date: Friday, June 18, 2004 -
Automatically Query To CFM
This is a custom tag application. The cf_QueryRender custom tag takes your query arguments and gives you a final page table and all...
Author: Anang A Phatak
Views: 20,650
Posted Date: Friday, October 29, 2004 -
A Mp3 Streaming Server
This is a small application that shows you how to create an MP3 streaming server.
Author: Anang A Phatak
Views: 21,514
Posted Date: Monday, November 8, 2004 -
Breaking down your query results into pages (Paging Tutorial)
I havent come across a "paging" tutorial on this site. I know there are JavaScripts available that help you achieve this, and the DataSet object in VB.Net comes with paging. All you do is "enable paging". But how do you do it in ColdFusion ?
Author: Anang A Phatak
Views: 25,234
Posted Date: Tuesday, November 16, 2004 -
A DataSet just like VB.Net
This tutorial shows you how to create a "dataset" just like the one in VB.Net In VB.Net you would create a dataset with "edit" button in an extra column. Once you click "edit", you get an option to "update", "delete" or "cancel edit mode" This is just like a cfgrid tag. Although a cfgrid tag lets you bulk insert, bulk update or bulk delete, the dataset object does it one by one. But cfgrid is slower, and may give users Java errors, depending on their browser settings.
Author: Anang A Phatak
Views: 27,351
Posted Date: Wednesday, November 17, 2004 -
Dynamic time and date for your pages
Have you seen the "www.EasyCFM" page closely? On the main page, top right, there is a place for time, and top left a place for day-date. Ever wonder how Pablo does it ? This is not a ColdFusion tutorial. Its JavaScript.
Author: Anang A Phatak
Views: 17,211
Posted Date: Wednesday, January 5, 2005 -
ColdFusion MX 6.1 Installation on Linux (Ubuntu -- Hoary Hedgehog)
I have tried hoards of websites on how to install coldfusion on Fedora Core 3 with apache webserver. For some reason the connectors always failed. I had "Ubuntu" on my laptop, basically because "acpi" suspend/hibernate actually works. I decided I might try to install CF there to find out what was going wrong. Surprisingly everything worked like a charm. Make sure you use "apt-get install apache2" before you try this. BEST OF LUCK ....
Author: Anang A Phatak
Views: 19,333
Posted Date: Tuesday, May 10, 2005 -
Dynamic textbox and progress bar for your pages
The principle of this tutorial is similar to "Dynamic time and date for your pages" tutorial. Except that this one generates messages, and that one updated time. Read on, you will get the hang of it....
Author: Anang A Phatak
Views: 20,835
Posted Date: Thursday, May 19, 2005 -
Getting ColdFusion Studio for Linux
I like using HomeSite+ for windows, and I am getting used to Dreamweaver Mx. But I still need something just as good for Linux. For some reason, I couldnt get "wine and Dreamweaver Mx" to work. So I "Googled" a bit and stumbled upon Eclipse and cfEclipse. Here is how to set it up.
Author: Anang A Phatak
Views: 17,910
Posted Date: Wednesday, May 25, 2005 -
Breaking down your query results into pages (Paging Tutorial) Part-II
This is an extension to my last tutorial "Breaking down your query results into pages (Paging Tutorial)" which is posted here on www.easycfm.com In the last tutorial, you could retrieve a dataset with a, then use a technique to seperate the results over several pages. It simply ; - took the total "recordCount" - divided that with the "number of records per page" - then displayed the number of pages at the bottom of the table. This is a little more sophisticated than that. Read on...
Author: Anang A Phatak
Views: 15,143
Posted Date: Wednesday, January 11, 2006
