When you have a long list to display, it often makes sense to break the list
up into columns. If you display your list using tables, a simple CFIF tag is
all it takes.
SELECT listitem FROM list
The code above creates a three-column table. You can set the numcols variable
to any desired integer, or calculate it based on the number of items in the
list.
This technique displays items in horizontal sequence. To list items
vertically, use a slightly different technique:
#listitem# more)
Tips for Migrating from Access to SQL
If you develop ColdFusion applications using Microsoft Access, and plan to
upgrade later to SQL Server, here are two tips that will make the migration
easier.
1. Access allows you to configure fields to accept zero-length strings. It is
tempting to use this option because it simplifies the coding of dynamic ODBC
statements in CF. However, SQL Server does not permit zero-length strings.
You may as well get into the habit of dealing with this in Access.
2. SQLServer has no yes/no datatype, although it does support a bit datatype
that can be zer... (more)
Those static pages we were so glad to leave behind--they're back.
At least, they are for Joe Copley. Joe's figured out how to use CF to combine
static pages with dynamic templates, reaping the benefits of both. In our
long and detailed feature article, he tells you how.
O T H E R A R T I C L E S
Using Dynamic Variables
Robert O'Donnell
How-to, illustrated with sample code.
Mountain Resorts Online
Steve Momorella
Site Study: Dynamic duplication of data
SMIL: You're on the Web!
Ronald West
Tag-based multimedia
The Ultimate Searching Utility
David Medinets
OK, so you have to learn som... (more)
|
|
Joe Copley is president of Copley Internet Systems.
Scott Sellers
Anthony Franco
Daniel Morris
Wayne Walls
Niki Acosta
Jereme Hancock
Oren Michels
Marvin Wheeler
Douglas Kim
