Previous Issue Current Issue Main page Next Issue
Fusion Authority Fusion Authority
The House of Fusion Technical Magazine
Issue: 36

August 14, 2000
August 20, 2000
This is an opt-in magazine. To join, leave or change subscription mode, please visit the signup page. All content of this magazine is copyright Fusion Authority, Inc. It may not be reproduced without permission.

Community
Allaire Announces Birds-of-a- Feather Program (BOFs) at Allaire Conference
Special CFUG Event: Back to Basics ColdFusion Seminar
Registration Closes Today for ECommerce Seminar in Memphis
 
News
AbleCommerce Releases Linux Version of AuctionBuilder 1.0
Fast Track to AbleCommerce Course Open for Registration
ZDNet/eWeek Labs Assess AuctionBuilder
Allaire President/CEO Joins MarketSoft Board
Allaire Powers Relaunch of FAO Schwarz Site
ColdFusion Powers Pottery barn.com's eCommerce Solutions
ColdFusion Powers PiranhaNet's New Merchant System
WebPerfect Solutions Announces Cooperative Sales and Marketing Agreement with Excalibur Technologies
Vertical Sky Launches Vertical Sky Evolution Management Solution
AbleCommerce Announces New Premium Level of Support
 
Tech and Tags
What's new in the Tag Gallery
Dispelling the Confusion: ColdFusion Enterprise vs. ColdFusion Professional
User Interface Resources
Collapse Your Code
Migrating Allaire Spectra Applications
Variable Speed Animation
 
Views
A Whole New Can of Worms
 
Techniques
QuickTip: Installing CF Custom Tags Remotely
JRun 3.0 Connection Pooling
Case Study: Active Research
Case Study: Bridge Information Systems
Test Your Knowledge
 
Security
Microsoft IIS 5.0 Translate: f Source Disclosure Vulnerability
 
Knowledge Base
Authentication Fails When Logging Into the Allaire Spectra Webtop
 
Stock
Allaire Corp Files 10-Q for Quarter Ending 0630
Looking at Hypothecating
Weekly Numbers
 

Community

Allaire Announces Birds-of-a- Feather Program (BOFs) at Allaire Conference

Allaire has announced more informal "BOF" meetings for developers. Birds-of-a-Feather (BOF) meetings are purely forums for technical discussion, moderated by conference attendees with the help of an Allaire representative. Allaire is now accepting topic submissions. If selected, your session will be assigned an Allaire monitor, a 75- to 100-person meeting room during a designated one-hour period, and the forum will be listed in the daily newsletter to increase the visibility of your topic. BOFs will take place after 4:00 p.m. on Sunday, November 5 and after 5:30 p.m. on Monday, November 6, and Tuesday, November 7.

The deadline for submission of topics is August 29, 2000.

Please note: "BOF meetings are purely for technical discussion and are not a venue for formal structured presentations. No audio-visual support will be provided for these meetings, and formal presentations will not be allowed."

Birds-of-a-Feather Program (BOFs)

[Top]

Special CFUG Event: Back to Basics ColdFusion Seminar

You are invited to Free MDCFUG "Back to Basics ColdFusion" seminar on Saturday, September 9, 2000. For more information and registration, visit http://www.cfconf.org/cf101/

This special meeting is a direct result of the success of the Maryland CFUG, CPCUG and TeraTech's recently hosted CFUN-2K ColdFusion event. The surveys indicated that there was a group of people that attended to check out the excitement about ColdFusion but were interested in hearing more basic information. If you are new to ColdFusion or are just plain curious, this MDCFUG seminar is for you!

The agenda for Just the Basics includes:

10:00-10:30Why I like CFUGs - Michael Smith
10:30-11:30Introduction to ColdFusion - Charlie Arehart
What ColdFusion is used for with samples
Why you would Use ColdFusion
11:30-11:45Break
11:45-12:45Basic coding samples
How ColdFusion interacts with databases
12:45Q &A

Location:
NIH Lipsett Auditorium (same place as CFUN-2K)
9000 Wisconsin Ave (MD Route 355)
Bethesda MD 20814
10:00 AM
FREE! FREE! FREE!

Seating is limited. You must register for this seminar at http://www.cfconf.org/cf101/. One free Fast Track to ColdFusion class ($1200 value) and some other goodies will be raffled off to registered attendees. You must be present to win.

[Top]

Registration Closes Today for ECommerce Seminar in Memphis

*** REGISTRATION CLOSES TODAY!

*** Advance Registration Only -- No On-Site Registration
*** Fusion Authority Subscribers Get In For Less Than Half-Price! (see below)
*** All Attendees Get Free CommerceBlocks Software
*** Memphis AirTran Flights and Hotel Rooms Are Cheap

ECOMMERCE DEVELOPMENT WITH COLDFUSION SEMINAR

Three full days (August 29-31) of "exactly what you need to know to not only build killer eCommerce apps, but killer ColdFusion apps in general. There's a database design course built right in, too." When you're done, you get all the example code and free CommerceBlocks software.

Remember:

-- $195.00* for a three day, chef catered, materials heavy seminar with free software you can really use is incredibly cheap (it's below their cost).

-- AirTran and other airlines' ticket prices are dirt cheap, as are hotel rooms in Memphis (see the Memphis travel and lodging links on www.coldfusionseminar.com)

-- This seminar series is already booked through June 2001, so don't wait for it to come to your area.

-- As of this writing we have only 18 seats left.

For complete details and to register, go to www.ColdFusionSeminar.com. Remember to email first and ask for your discount passcode, or you won't get your discount! Then you can register.

[Top]


News

AbleCommerce Releases Linux Version of AuctionBuilder 1.0

AbleCommerce has just announced the release of their AuctionBuilder product for Linux, making their software compatible over two major operating systems. AuctionBuilder, which came out earlier this year, is AbleCommerce's ColdFusion-based full-featured online auction package.

AuctionBuilder Product Description

[Top]

Fast Track to AbleCommerce Course Open for Registration

Seats are now available for AbleCommerce's new training course, "Fast Track to AbleCommerce," a step-by-step tutorial to opening a retail store using AbleCommerce. The $895 investment will get you a space in the two-day seminar taking place September 22nd and 23rd at a training facility just outside of Los Angeles, California.

"Fast Track to AbleCommerce"

[Top]

ZDNet/eWeek Labs Assess AuctionBuilder

Able Commerce's ColdFusion-based AuctionBuilder recently went under the ZDNet/eWeek Lab microscope. Jim Rapoza reports that "This powerful yet simple-to- deploy online auction application lowers the complex and costly barriers to entry that typically accompany auctioning solutions. ... [The Lab] was able to quickly build and manage several auction sites and provide sellers and buyers with the same variety of auctioning capabilities found in costlier products."

AuctionBuilder Capable, Economical (ZDNet eWeek)

[Top]

Allaire President/CEO Joins MarketSoft Board

LEXINGTON, Mass., Aug. 21 /PRNewswire/ -- MarketSoft Corporation, a provider of B2B eMarketing solutions, has announced that David Orfao, President and CEO of Allaire Corporation, has joined MarketSoft's board of directors."The appointment of David Orfao to our board reinforces MarketSoft's leadership position in the highly competitive B2B eMarketing space," said Greg Erman, president and CEO of MarketSoft. "David brings more than 15 years of senior management experience to the company. His fundamental knowledge of the software industry, together with the success he has driven at Allaire, will help direct MarketSoft's success and growth."

President and CEO of Allaire Joins MarketSoft's Board of Directors (Company Sleuth Report)

President and CEO of Allaire Joins MarketSoft's Board of Directors; David Orfao to Share His Insight and Expertise with MarketSoft Corporation (Powerize Alert)

President and CEO of Allaire Joins MarketSoft's Board of Directors; David Orfao to Share His Insight and Expertise with MarketSoft Corporation (Northern Light News Alert)

President and CEO of Allaire Joins MarketSoft's Board of Directors (Datek NewsAlert)

President and CEO of Allaire Joins MarketSoft's Board of Directors (ZDNet Inter@ctive Investor Alert)

President and CEO of Allaire Joins MarketSoft's Board of (C|Net Investor Alert)

President and CEO of Allaire Joins MarketSoft's Board of Directors (ZDNet Tech InfoBase Alert)

[Top]

Allaire Powers Relaunch of FAO Schwarz Site

NEWTON, Mass., Aug. 22 /PRNewswire/ -- Allaire Corporation has announced that FAO Schwarz, recognized as a leading toy retailer and authority in the toy industry, has implemented the Allaire Business Platform to relaunch its online toy store, FAO.com. The Allaire Business Platform provides the features and functionality to ensure that FAO.com offers the same whimsical experience associated with FAO Schwarz' retail stores, while rapidly developing and deploying a scalable, world-class site, establishing the 138-year-old brand as a premier click-and-mortar toy company on the Web.

FAO Schwarz Leverages Allaire Business Platform to Relaunch FAO.com (Company Sleuth)

FAO Schwarz Relaunches FAO.com to Bring "E-Magic" Buying Experience to Online Shopping Community (Powerize Alert)

FAO Schwarz Revamps Online Store (Northern Light Alert)

FAO Schwarz Relaunches FAO.com to Bring "E-Magic" Buying Experience to Online Shopping Community (Northern Light Alert)

FAO Schwarz Relaunches FAO.com to Bring "E-Magic" Buying Experience to Online Shopping Community (Wall Street Research Net Alert)

[Top]

ColdFusion Powers Pottery barn.com's eCommerce Solutions

NEWTON, Mass., Aug. 22 /PRNewswire/ -- Allaire Corporation has announced that Pottery Barn, Williams- Sonoma's popular home furnishings division, has implemented Allaire ColdFusion to extend its brick-and- mortar presence to the Web with http://www.potterybarn.com. Leveraging Allaire's industry leading web application server, Pottery Barn can now reach the global community of online shoppers and enthusiasts while deploying a site that is secure and able to handle the large volume of site traffic anticipated this holiday season.

Allaire Furnishes Potterybarn.com With Powerful Internet Technology Solutions (Company Sleuth)

[Top]

ColdFusion Powers PiranhaNet's New Merchant System

SEATTLE, Aug 22, 2000 /PRNewswire via COMTEX/ -- Implementing and maintaining eCommerce on the Web just got easier, thanks to PiranhaNet's new Merchant System. The PiranhaNet Merchant System is a fully secure "E-tail" system, programmed in ColdFusion, that can act as a stand-alone eCommerce solution or integrated seamlessly into a pre-existing Web site. With a user-friendly Administration Utility and special features, such as a "Floating Shopping Cart" and fast, automatic image resizing during uploads, the PiranhaNet Merchant System offers a 100% turn-key eCommerce solution for growing companies.

PiranhaNet Offers the Ultimate E-Commerce Solution With New Merchant System" (Northern Light News Alert)

[Top]

WebPerfect Solutions Announces Cooperative Sales and Marketing Agreement with Excalibur Technologies

WebPerfect Solutions, a leading provider of Internet business services which uses ColdFusion for its application layer, has announced a cooperative sales and marketing agreement with Excalibur Technologies, a leading provider of content management solutions for indexing and retrieving text, video and images on the Internet and intranets. The firms will engage in a variety of joint sales and marketing activities, including events/seminars, direct marketing, advertising, communications and public relations projects.

Northern Light Alert: "WebPerfect Solutions Announces Cooperative Sales and Marketing Agreement with Excalibur Technologies"

WebPerfect Solutions Announces Cooperative Sales and Marketing Agreement with Excalibur Technologies (Yahoo! News Alert)

[Top]

Vertical Sky Launches Vertical Sky Evolution Management Solution

CHICAGO, IL, Aug. 21 /CNW-PRN/ - Vertical Sky, Inc., has introduced its new Vertical Sky Evolution Management solution, bringing a new generation of management capabilities to the eBusiness marketplace. The product integrates with ColdFusion Studio.

Vertical Sky Launches the Vertical Sky Evolution Management(TM) Solution (Yahoo! News Alert)

[Top]

AbleCommerce Announces New Premium Level of Support

AbleCommerce has put the word out that it has increased its technical staff and support hours. In addition to the free 30-day installation support following a purchase, free non-code related email support, online FAQ's and online support forums, premium support allows customers to address specific issues unique to individual applications on a one to one basis via telephone.

Effective September 1, 2000, Premium technical support will be offered for an hourly rate of $120 per hour. "AbleCommerce developers anticipating any unique needs should consider purchasing a block of support time now, while it is still at a discounted rate of $80 per hour. The support time will remain credited to your account until used, and can be applied to any AbleCommerce product."

Contact your AbleCommerce representative to boost your account time, or to get further details on additionally discounted 5 and 10 hour premium support packs.

For more information, contact info@ablecommerce.com.

http://www.ablecommerce.com

[Top]


Tech and Tags

What's new in the Tag Gallery

cf_img
This custom tag presents a clean impression of any page comprising many graphical images by illuminating unsightly placeholders.
ServiceMinder
ServiceMinder allows you to view active services as well as start or stop any service.
CF_PathIndex version 2.0
CF_Pathindex version 2.0 is an update of the original cf_pathindex tag that I wrote a couple of years ago. Many people have expressed an interest in particular functionality that was not included in the original code, so here it is. The tag allows you to create a Verity index of a tree of documents on your server, but to exclude subdirectories in the tree by name. This function can be very useful if you use FrontPage extensions, for instance. Documentation is included in the tag itself.
XMLvar
XML Variable Identification Tag - For those who want simple XML interpretation. This tag can be used to interpret an XML string received by passing the variable name you are looking for. The tag will return the variable value as well as other valuable information.
cf_generateobjectmodel
cf_generateobjectmodel grabs property and method information from user-defined types and outputs them to a page in table-format. This is useful when you need to produce a report on your object model.
Aversion.com E-Mail List Manager
The Aversion.com E-Mail List Manager helps to automate your email distribution lists. It can be used to set up mailing lists for news or anything else on your site. The program comes with a fully functional administration screen that allows you to add, delete and modify addresses. You can also send emails directly from the administrator, and view archived emails. The system also comes with an Automated Email Tool, which will automatically process the email in your email list address inbox. This tool allows users to automatically subscribe and unsubscribe, and it will also remove any emails addresses that bounce.
CF_Authenticate
This ColdFusion custom tag protects directories and/or individual templates from public access.
CF_RECYCLE_FORM
This tag allows you to pull data out of any database table, and will let you populate a form if there are results. Perfect for Fusebox applications.
MachineState
CF_MachineState determines the current state of the machine that the code is running on. The valid replies to retState are "On" and "Off". If the state of the machine is "On" then retTimeToChange is blank, as the time when the machine will be on may not be determined by the OS. If the state of the machine is "Off" then retTimeToChange is equal to the time determined by the GetTickCount that tells when the server will turn on, or the state of the machine will change. This may be used to determine when the machine is available.
CF_SourceBrowser
A versatile utility for viewing and analyzing ColdFusion source files/directories. Integrates a source viewer with a 'FusionDocs' standard documentation parser/viewer, and eight separate software 'metrics'. An invaluable tool during all phases of the software development cycle.
CF_SoftwareMetrics
Returns eight separate "metrics" of a given ColdFusion template. These measure different aspects of logic and style, to give valuable information regarding reliability and maintainability. High 'risk' values may be a sign that the code needs to broken into smaller units, or at least that more extensive comments/indentation are needed. Based on Tom McCabe and Arthur Watson's "Structured Testing: A Testing Methodology Using the Cyclomatic Complexity Metric," 1996. Interpreted for CF by Lee Borkman.
cf_multiplelistintersection
cf_multiplelistintersection takes in an array of lists, and returns the intersection of all the lists.
InflationCalculator
This tag will take an initial year and dollar amount and give you a corresponding value, adjusted for inflation, in a second year. Data allows for dates from 1913 to 1999.
Email Made Simple 2.0
This new version of Email Made Simple handles all basic mail functions (send, receive, reply, delete), along with some new functions (send AND receive attachments, custom addressbook). Easy-to-use interface helps add to its functionality. Low price for what it offers!
CF_MailMonger
Calculates US Postal Service Priority Mail shipping rates. Since the rate tables are on your own website, there is no reliance on anyone else to produce your rates. Includes an admin utility so you can modify rates online.
FreeData_USTrademarks
This ColdFusion 4+ CFML custom tag uses CFHTTP to perform a keyword search on the Trademark Text and Image database of the US Patent and Trademark Office and return the results as a ColdFusion data structure.
FreeData_EDGAR
This ColdFusion CFML custom tag uses CFHTTP to retrieve a list of SEC filings from the EDGAR database. This tag can be used to create a custom EDGAR query for a corporate relations site, or to offer a free form search on a financial services site.
FreeData_NWS
This ColdFusion 4.1+ CFML custom tag uses CFHTTP to retrieve hourly weather reports from the National Weather Service's Interactive Weather Information Network.
DP_PCQuote
This ColdFusion 3.1+ CFML custom tag uses CFHTTP to retrieve price and fundamental packages from the PC Quote CGI service.
DP_AlphaWords
This ColdFusion 4.x CFML custom tag provides a simple way to ensure proper interpertation of such data as random passwords. It helps to eliminate confusion between "1" (One) and "l" (Lowercase L) and "0" (Zero) and "O" (Uppercase O). The tag takes a string and presents one of five standard "alpha word" encoding sequences. For example the tag might take the string "ABC" and return the standard NATO encoding of "Alpha Bravo Charlie". It can also present more detailed information to enforce case.
CF_FormValidate
CF_FormValidate is a simple validation tool that captures invalid characters submitted through forms. This tag is one line of defense against "Cross-Site Scripting" hacks.
PlasmaFusion
PlasmaFusion is a structured development environment and secure web application hosting platform for Allaire ColdFusion. The techniques employed by PlasmaFusion improve application flow and encourage reutilization, segregation and the maintainability of source code.
Lotto Number Generator
Lottery number generator. You specify the highest number that can be drawn and the game type. You can specify Pick 3, Pick 4, Pick 5, Pick 6 (Lotto) or PowerBall games.
_Text to URL
Turns plain text into URLs, or removes URLs from text and leaves as plain text.
CF_UPSRateMonger
Calculates UPS® rates using the 2000 rates downloaded from ups.com. Since all rate tables are on your site, no reliance on the UPS® web site or CFHTTP calls are necessary. The present version supports shipping (weights up to 150 lbs) in all 50 U.S. states and Canada (At present only Canada Standard shipping service is supported to Canadian destinations), and includes the fuel surcharge effective 8/7/2000. Future revisions may include UPS® ''accessorial'' options given sufficient interest, but this system provides enough functionality for most common needs.
CF_DHTMLQUERY
CF_DHTMLQUERY generates a table (like CF_DUMPQUERY) but each column is client-side resortable (using dhtml) if they are using IE4+. Otherwise, a normal table is generated.
_EMail Pager
This file checks remote emails, then forwards the messages to any other address (like a cellphone or pager). Handy for being notified of new messages to dumb servers (like at my work) that cannot notify you when new messages arrive, effectively freeing you up from having to check your emails all day long just to discover you have none.

[Top]

Dispelling the Confusion: ColdFusion Enterprise vs. ColdFusion Professional

Luke Kearney (kearneyl@tky.ewc.co.jp) posed the following question on CF Community: What is the difference between ColdFusion Professional Server and ColdFusion Enterprise Server? Here are some of the responses:

[Top]

User Interface Resources

Andy Edmonds of Figleaf has forwarded the following useful list of User Interface resource sites and recommendations, recently submitted to the Atlanta CFUG:

"HCI is a occupational hobby of mine and I add HCI laden info to my search engine on a regular basis (1100 pages after 3 years of collecting). You can find it at http://psyberspace.net with commentary at /blogger/.

"Other good general resources are http://www.webword.com, http://www.useit.com (check the archives of the website spotlight), http://www.uidesign.net, http://www.asktog.com, and for look and feel analysis http://www.coolhomepages.com

"The general recommendation, unfortunately, is look at MS Word and http://www.aol.com, and do as they do. Consistency is priority number 1.

Regarding HTH and AE for application standards:

"For button naming (Save or Submit? Edit or Modify?), try http://psyberspace.net/web/searchresult.cfm?criteria=button+and+names

"For button placement (Save before Cancel or Cancel before Save?) and current trends (tabbed, explorer-like menus, etc.), try http://www.psyberspace.net/web/searchresult.cfm?criteri a=interface+and+trends

"For UI critique of current software (MacOS, Windows) and websites: http://psyberspace.net/web/searchresult.cfm?criteria=CF%5FCUSTOM1%20%3CCONTAINS%3E%20Critique."

Thanks, Andy!

[Top]

Collapse Your Code

Freelance writer Amy Cowen explores how the Collapsed Text feature, which allows you to "collapse" selected text or code, can help you streamline your Web development. The feature was first introduced in HomeSite 4.5 and ColdFusion Studio 4.5.

Collapse Your Code

[Top]

Migrating Allaire Spectra Applications

Syntegra's Rich Regan discusses how best practices development for ColdFusion and Allaire Spectra sites employs the use of separate servers for development, staging, and production, allowing the development team to work without disturbing the actual production site, the content editors, or the site testers.

Migrating Allaire Spectra Applications

[Top]

Variable Speed Animation

Al DiMarzio of HB Graphics shows us how to create multiple single-cell images and use JavaScript to control the speed at which they are seen, varying the animation effect.

Variable Speed Animation

[Top]


Views

A Whole New Can of Worms

by James Moll

(Taken from the ACFUG mailing list, with permission of the author. This was a response to Sean Harrison's challenge to clean up the formatting on our CF code):

<CFSOAPBOX action="step_on_up">

I would like to extend your challenge to include the regular 'ole html code, as well as CF code. I've been a "corporate", enterprise-oriented developer now since the mid '80s, coding in COBOL, REXX, C, VB, etc., and over the last couple years, HTML, Cold Fusion, and some ASP. In any programming language/IDE, you expect to run into different formatting preferences, as well as some expected laziness...but until I started doing web-related stuff, never in my varied development career have I ever witnessed such utter and total lack of any type of attempted code formatting discipline whatsoever! I don't mean to be a developer snob here, but I've just shrugged it off as being a by-product of the original nature and intent of html, and therefore its use and adoption by "designer" and "content supplier" types (read "non-programmers").

But enough already! By the very fact that we are using the ColdFusion application server, and that this is a ColdFusion users group list, we all here are now officially "application developers," not simply web page "designers". As a result of your newly christened title, there is, like many titles in the world, some implied responsibilities that are now expected of you as a "developer"....to wit,

  1. THOU SHALT FORMAT THY CODE TO FACILITATE READABILITY AND MAINTENANCE.
  2. THOU SHALT FORMAT AND INDENTETH NOT ONLY THY CF CODE, BUT ALSO THY HTML, AND THY JAVASCRIPT.

(ok, I don't really have time to parody a full set of 10 commandments, but I think you get the drift...)

<CFSOAPBOX action="ok_get_off_now">

[Top]


Techniques

QuickTip: Installing CF Custom Tags Remotely

What if you wanted to install your CFX tags remotely and didn't have access to the CF Administrator?

This question, posed by Sean Harrison on the ACFUG list, brought to light the following operation:

[Top]

JRun 3.0 Connection Pooling

Karl Moss, JRun Engineer, Allaire Corp., explores the built-in JDBC connection pooling mechanism found in Allaire's JRun 3.0. This article "examines not only why you should use connection pooling in your servlets and JSPs, but also demonstrates how to use it through several code samples."

JRun 3.0 Connection Pooling

[Top]

Case Study: Active Research

This article is a case study/feature on ActiveBuyersGuide.com by Active Research, Inc., the dominant comparison shopping service on the Internet. The site, a free service to shoppers, spans over 130 different product categories and draws close to 1 million unique visitors each. It is built on Allaire ColdFusion.

Active Research

[Top]

Case Study: Bridge Information Systems

Bridge Information Systems calls itself the "Financial Web Site To The World," leveraging the Allaire business platform to manage huge databases. Bridge is the largest provider of its kind in North America and the second largest provider in the world.

Bridge Information Systems

[Top]

Test Your Knowledge

As part of the relaunch of their site, the folks at depressedpress.com (http://www.depressedpress.com) are presenting a series of CFML challenges. The first is converting a Query to an Array using only CFML as fast as you can.

Full details (including the site's own proposed solution) can be found at: http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Challenge/Index.cfm. The site will be taking solutions and posting the best ones. There is no set deadline on this contest, so think long and hard, folks!

Last Weeks Questions

Name all the CFLOOP types and what they do.
Index loop - Takes 2 numbers and loops from the first (FROM) to the second (TO). The steps and direction of the count between these two numbers can also be controled.
Conditional Loops - Takes a conditional statment and as loon as it is true will run a loop. This look has no Index or counter so you must write in code to stop the loop. When an infinate loop occurs, this loop type is usually the culprit.
Looping over a Query - Loops over a query in the same way a CFOUTPUT does, looping over every row in the query record set. During each iteration of the loop, the columns of the current row will be available for output. CFLOOP allows you to loop over tags that can not be used inside CFOUTPUT. A CFOUTPUT must still be used for the evaluation of variables.
Looping over a List - Takes a list (with a default or defined delimiter) and loops over each item in the list. The Index attribute is loaded with the current list item on each loop iteration.
Looping over a COM Collection or Structure - Loops over each item in a structure (ColdFusion) or a collection (returned from COM).
 
Name all the Loop types in CFSCRIPT and what they do.
for loop - Takes a number and loops until the conditional part of the loop is fales. The number can be added to in order to make it like an index CFLOOP. It cal also run as an infinate loop where there is no stop condition. This loop has many ways of being used.
while loop - Loops while a condition is true. Same as conditional CFLOOP
do-while loop - Same as a while loop, but the test to see if the loop stops is done at the end of the loop rather than the beginning.
for-in loop - Loops over a structure.
 
Can you loop over a query in CFSCRIPT and if so, how do you do it?
Yes
Assume a query named "queryone". We will loop over each row of the query and then loop over each column in the row.

<CFSCRIPT>
   // write the column headers in bold
   for(loop0=1; loop0 LTE Listlen(queryone.columnlist); loop0=loop0+1)
      WriteOutput(' <b>'&listgetat(queryone.columnlist, loop0)&'</b> ');
   //Add a new line after the headers
   WriteOutPut('<br>');
   //Loop over each record in the query
   for(Loop1=1; Loop1 LTE queryone.recordcount; Loop1 = Loop1 + 1)
   {	
      //Write out each column of the record
      for(loop2=1; loop2 LTE Listlen(queryone.columnlist); loop2=loop2+1)
         WriteOutput(Evaluate('queryone.'&listgetat(queryone.columnlist,loop2)&'[loop1]'));
      // Add a new line after the record
      WriteOutPut(' <br>');
   }
</cfscript>

[Top]


Security

Microsoft IIS 5.0 Translate: f Source Disclosure Vulnerability

According to Security Focus, Microsoft IIS 5.0 has a dedicated scripting engine for advanced file types which handles requests for these file types, processes them accordingly, and then executes them on the server. It is possible to force the server to send back the source of known scriptable files to the client. The scripting engine will be able to locate the requested file, but will not recognize it as a file that needs to be processed and thus will send the file source to the client. Microsoft has issued a patch.

Microsoft IIS 5.0 "Translate: f" Source Disclosure Vulnerability (Security Focus Alert)

[Top]


Knowledge Base

Authentication Fails When Logging Into the Allaire Spectra Webtop

If you have more than two LDAP user directories in a Security Context, authentication to the Spectra desktop will fail if one of those user directories is unavailable or unresponsive. Here's what to do.

Authentication Fails When Logging Into the Allaire Spectra Webtop

[Top]


Stock

Allaire Corp Files 10-Q for Quarter Ending 0630

Allaire has filed the required Form 10-Q with the SEC for the quarter ending June 30, 2000. The corporation reported total revenue increases of 155% for the three-month period ending on June 30, 2000, in comparison to the three-month period ending June 30, 1999.

ALLAIRE CORP files 0630 qtr 10-Q. Reports $59.9 mil tot rev (NewsAlert)

[Top]

Looking at Hypothecating

James J. Cramer tells us all about stock hypothecating and how brokers can legally loan YOUR stock to short-sellers.

TheStreet.com - Wrong! (Yahoo! News Alert)

[Top]

Weekly Numbers

Date Open High Low Close Volume
18-Aug-00 34.4375 34.75 31.9375 33.625 345,100
17-Aug-00 31.9375 34.75 31.875 33.4375 584,600
16-Aug-00 31.125 33.75 31.125 31.875 544,900
15-Aug-00 30.125 32.1875 29.75 31 1,036,900
14-Aug-00 28.375 30 27.625 30 1,262,500

[Top]

All articles are for informational purposes only and do not constitute a suggestion to buy, sell, or in any way trade in any stock or securities.


This is an opt-in magazine. To join, leave or change subscription mode, please visit the signup page. All content of this magazine is copyright Fusion Authority, Inc. It may not be reproduced without permission.