Small Business Web Design Solutions in Thailand
(This web site has been moved to www.kapilakan.com)
Intermediate Tutorials - Coldfusion Web development Thailand
Learn how to create database connection, by skipping the old ODBC connections with ColdFusion.
Written by: Pablo Varando
This tutorial will demonstrate how you can create a "member's only" area. It will show you how to log them in and how to check that they are logged in.
Written by: Pablo Varando
This tutorial will show you how to create a fully automated system to allow visitors to subscribe and unsubscribe to your newsletter, and for administrators to send out a newsletter to all the registered users.
Written by: Pablo Varando
This is a brief demonstration on how to use Fusebox 2.0 Methodology.
Written by: Pablo Varando
This tutorial will demonstrate how to use query string values instead of form values.
Written by: Pablo Varando
This tutorial demonstrate how to implement "Previous" & "Next" into your existing results page.
Written by: Pablo Varando
This tutorial will demonstrate how to clear your applications sessions variables with just three lines of code!
Written by: Pablo Varando
This tutorial will demonstrate how to use .INI files with ColdFusion. Perfect for users wishing to create administration areas for existing software titles that are INI file driven (i.e. FTP Servers).
Written by: Pablo Varando
More and more developers are becoming aware of creating dynamic applications with Flash and Cold Fusion. Now the question is, "How do I get external data into my Flash movie and what are my options?". There is not one simple answer to this question since there are a few ways to accomplish this.
Written by: Dennis Baldwin
This tutorial will show you how to create, modify and delete database tables easily with ColdFusion.
Written by: Pablo Varando
This tutorial will show you two two ways you can implement error checking, to ensure that your users are actually entering the required fields on your forms!
Written by: Pablo Varando
This tutorial will show you how to use arrays to display data properly in ColdFusion.
Written by: Pablo Varando
This tutorial places the submitted form values into a session, than error checks them. If there is an error it will show the form again with the previous values the user entered pre-entered in the form. It will also tell the user which form fields had errors in them.
Written by: Redmanz
Make your email messages stick out in the users inbox with barely any effort
Written by: Andy Jarrett
You will be shown how to display the images in the desired number ofcolumns and desired number of records per page with minimal coding. When the thumbnail image is clicked on it will open another window with the large image and image description under it.
Written by: D Evans
This tutorial uses a opt-in mailing list as an example. After the end-user enters their information the information goes to an action page which checks to see if the users email address already exists in the database. If it exists it lets them know and will not enter the duplicate data, if it does not exist it enters them into the mailing list.
Written by: Redmanz
This deals with database dates:(1)inserting a properly formatted date into the database, and then(2)pulling a query from the database between a date range defined by 2 text boxes.
Written by: Jim Summer
Many developers I have talked to are not aware of the ability to create an "alias" in an SQL statement, concatenate, and even add strings into your SQL statements. A little work up front in the SQL can cut out a lot of tedious coding in the tag.
Written by: Jim Summer
This tutorial shows how you create Relationships between tables to speed up queries and decrease the overall size of the database
Written by: Alex Allen-Turl
This Guestbook is part one of a two part tutorial. This part deals with the guest book itself the second part will build a administration area for this guestbook. The guest book submits to two tables in a mySql database the first table being for the actual guest book display template and the second table to be used for an opt-in mailing list.
Written by: Redmanz
This code will process any form submitted and email the submitted form fields excluding the submit, the redirect, the hidden, and the required fields; to the designated recipient.
Written by: D Evans
Simple and effective code to output an endlessly dynamic calendar using just basic ColdFusion functions
Written by: David Siles
This is a very quick tutorial on how to create a voting system for page relavances and other such things from a scale of 1 to 5!
Written by: Alex Allen-Turl
This is part two of my guestbook tutorial, in part one we created the actual guestbook. In this part we will now look at creating an administration area for our guestbook. In this admin area we will be able to edit and delete guestbook entries as well as add or delete administrators.
Written by: Redmanz
This will help you understand what a CFC and a web service is, and get you started on writing your own
Written by: Robert Bailey
This will help you get started on writing stored procedures. A good place to start and understand how they are written.
Written by: Robert Bailey
Get the search engines to really dig deep into your site by replacing the ? and & in your dynamic URL's with /. Tricks the SE bot into thinking it's a regular folder and eats up your content!
Written by: Phil Williams
A quick look at how fast and easy Flash Remoting is to use.
Written by: Marcus J. Dickinson
A handy timesaver - Automatically determine the URL and file path to the root of any application, this allows you to easily transfer sites from development to production servers without having to modify settings.
Written by: Peter Coppinger
This tutorial will demonstrate how to create a query from two different queries based from two separate datasources. This is the easiest way to combine your data.
Written by: Pablo Varando
this is just a customer complaint tracking system i put together with coldfusion. i got alot of help from easycfm.com so i figured i would get back with an app. its using an access database to store usernames and passwords. did all of the login authentication code myself because my damn server behaviors were not taking.copy the dbase somewhere and use the HCCTS datasource nameenjoy
Written by: chris mcintosh
Ever wanetd to know the size of an uploaded image so that you can store in the database, or check if it falls into allowed sizes etc.
Written by: Russ Michaels
This tutorial will allow you to enable sitewide error handling with CFERROR. Look like a real professional and display your own custom error page when an error has occurred, instead of the default Cold Fusion page. Not only that, once the error page has been displayed, the details of the error will be automatically emailed to you.
Written by: Jason Rockenbach
You might have already noticed that even database servers like Microsoft's SQL Server 2000 have no method of hiding even password fields from prying eyes. Instead passwords are stored as plain text. Not good. Even Microsoft Access provides a way to mask fileds you would prefer not to be easily read. Not so SQL Server - and probably quite a few other database servers suffer the same issue.This is easily rectified however using two handy functions built-in to ColdFusion, from at at least version 5.0 and above (I think they were in 4.x also). I've developed the following code using CFMX updated 3.
Written by: Peter Tilbrook
This will show you how to make a simple WHOIS search that can be easily added to any site.
Written by: Drew Tempelmeyer
This tutorial shows you how to serve banner ads directly into Rich Internet Applications. With the evolution of Macromedia Central, now is the time for companies to receive Return on Investment on Rich Internet Applications
Written by: Grover Fields
When you allow file uploading... Set a File Max Size and reject the file if it is too large.Others will check it after it is uploaded.. then deletes it if too large.. but not this... it won't let them even upload a single bit... if it is too large!
Written by: David McIntosh
Have you ever wanted to have your own chat room? This tutorial will help you have one, but the best thing about this tutorial is that you will not need to use any type of database!
Written by: Chris A.
This tutorial will show you how to you can provide your members with the ability to save their username and password into memory, so they dont have to type it in everytime the want to log in to your web site.
Written by: Pablo Varando
Well, we have covered the basics. Let's continue the series and explore many of the options available to us in SQL. Then, in future tutorials, we can cover error handling and more advanced functionality.
Written by: Marcus J. Dickinson
Going back to the beginning. Our first tutorial "Flash Remoting in under Ten Minutes" isn't as efficient as it could be. This time round, we cut out 60% of the code, including the database!!!
Written by: Marcus J. Dickinson
This will retrieve the 9 day weather forecast for the specified ZIP code.
Written by: Drew Tempelmeyer
Use SQL server's system tables to automatically create a form to insert data into your database.
Written by: Nathan Miller
Manage text-based files on your server from any Web browser. Create a new file, edit a file, or delete a file. Can be a life saver if you're on the road, and find an error in some of your code that needs a quick fix.
Written by: Charlie Griefer (CJ)
How to restart the ColdFusion service automatically when certain errors occur.
Written by: Anthony Moore
A small tutorial on how to send data securely from Flash to verify a user login using Remoting.
Written by: Marcus J. Dickinson
A nifty little custom tag that will allow you to save a visitor's clickstream through your site, as well as display it back to them (with links).Did I really just say 'nifty'?
Written by: Charlie Griefer (CJ)
This is an expansion of Pablo Varando's Email client, I heard a few folks say that they had problems viewing the attachments in the way that Pablo's tutorial outlined it, so I came up with a new way.
Written by: Robert Jones
This tutorial explains how to use nested custom tags in ColdFusion. It also presents one 'basic quiz' in CF MX where nested custom tags show an interesting behavior
Written by: Claudio Dias
Ever wondered how sites are able to return stores that are within a certain radius of your own zip code?
Written by: kaigler
Sometimes, you want to be able to change the color of something on your page. Be it one item, or every item on the page. Using this simple color picker, you can create admin areas that can allow you or your visitors to pick their own colors and the value is automatically inserted into a text field.
Written by: Mark Aplet
This tutorial will show you how to make a file content crawler with ColdFusion to find specified documents in a folder and its children folders. (Similar to find files or folder in Windows(c) Operating Systems 'find' feature).
Written by: Pablo Varando
Boolean values are excellent ways to save on precious coding time when you are using a boatload of IF statements in an application.Having only 2 possible states allows you to kind of cheat on creating your IF statements and minimize redundancy.
Written by: David Patricola
Here is a random image display. You can even upload it to the server. Uses a database.
Written by: Chris
This tutorial will demonstrate how you can get the ID of the record you have just inserted without having to connect to the database again!
Written by: Pablo Varando
I have seen a couple random image scripts here and there.Most require you to have a list of the images stored in a database somewhere or actually a switch statement with all the images listed there...This code will read a directory, pull all jpg's and choose a random one everytime to be displayed.Alot of my clients have wanted random images. THis is the easiest way I came up with to do it. This way when they want another image in the rotation... all you have to do is upload it to the image directory and its ready to go.
Written by: Bobby Hartsfield
Yes, I know we're a ColdFusion site...but ColdFusion does not live in a vacuum. We have to know SQL, HTML, CSS...and sometimes...JavaScript! This tutorial focuses on using JavaScript (in lieu of cfform) to create client side form validation (and explains why writing your own is better than using ).
Written by: Charlie Griefer (CJ)
Describes a solution to a connection problem from CF to MS Access.
Written by: Steve Moore
A technique for displaying, validating and processing forms.
Written by: Steve Sommers
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.
Written by: ANANG PHATAK
Want to know how to parse XML with ColdFusion with ease and very basic concepts? Then this is the tutorial for you.
Written by: Drew Tempelmeyer
Many tutorials give information on relating select boxes, but this one actual gives information on not only relating multiple selects, but also how to duplicate those related selects multiple times in the same form.
Written by: Steven Durette
This tutorial teach you how to integrate ups tools into your site. The code allows user to enter the destination's zipcode and get the shipping rate instantly.
Written by: chhchung
Not all queries can be saved as an application variable. For Queries that do not meet the checkpoints in my previous tutorial there is another way to improve performance. Query Caching is another way to save data and eliminate unnecessary queries. This is for queries that are more dynamic in nature.
Written by: Mark Aplet
One thing I am always trying to do is speed up my applications. As my site grows in size and complexity I find that I spend a fair amount of time re-coding pages because of a new technique I just learned. I wish I had learned about these techniques long before, and thereby allowing me to create more effective code. In this tutorial I'll try to explain some problem areas that I have identified, and some of the things you can do to improve performance.
Written by: Mark Aplet
DSNless hit counter/visitor logger with images as the numbers
Written by: Jeff Sheppard
Set up a single form to add multiple records to parent/child database tables. This example uses a parent table for a home, with child records for each resident.
Written by: Matt Robertson
This is a custom tag to translate the regular english output of a date into spanish like (20 de Enero de 2004) and as you want it to be.
Written by: Diego Benitez
Select multiple records for deletion just by checking a box next to the record listing.
Written by: Marlene Murphy
hi,I saw some tutorials on may sites which show how to develop related select boxes using cold fusion and javascript. Many of them were titles "Multiple Select Boxes" which was a bit un-appropriate as they did not really show how many levels of heirarchy they would cover. So, I finally decided to develop a custom tag that would help developers to simply implement a "n" level of select boxes using hierarchial data.thanks,Saurabh
Written by: Saurabh Gulati
Ever wanted your data to be output in a column view such as mailing labels are?Use this code and change only a few lines and your data will be output in a table with 3 columns and as many rows as you have data.A great alternative to the standard row based view. Very easy to modify.
Written by: Rhino
This tutorial is already posted but needed some additional comments/corrections added. I didn't see anyway to upload the changed tutorial.
Written by: Marlene Murphy
Do you have a website that you'd like to monitor but would rather not pay outrageous fees to some company? This simple script will monitor uptime for you website. It is the barebones version and can be easily modified into something highly useful.
Written by: Rhino
This script provides a simple admin area for the login script written by Pablon on this site. You can list, add, change pass, and delete users.
Written by: Rhino
I came up with this solution after building an email marketing application with content management built in. I found that if I had CF code in my html pieces that were stored in the database, it would not get processed by the server after the contents of the field holding the HTML and CF were used as the body of an email.
Written by: Derrick Anderson
This tutorial shows how to process a form and generate a random string that is put on the end of a link. When the user clicks the link it goes to their personal page.
Written by: Rhino
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.
Written by: Anang A Phatak
This code allows the user to dynamically populate the contents of a select box based on a selection from a previous select box.
Written by: Mike Corbridge
Example of how to dynamically populate a drop-down list from database tables based on a selection in another drop-down list.
Written by: Megan Garrison
Freelance Web Designer Thailand