CF%205%20Review

1
CF 5 Review

• Steve Drucker
• CEO
• Fig Leaf Software

2

• Introduction
• Industry/CF News
• Job Announcements
• Sign up for the listserv! http//chattyfig.figlea
  f.com
• Todays Schedule

3
Session Overview

• New Language Features
• New 3rd party integration
• Database Support
• CF Administrator enhancements

4
New Language Features

• Query of Queries
• User Defined Functions using ltCFSCRIPTgt
• ltCFSaveContentgt
• ltCFFLUSHgt
• ltCFLOGgt
• Enhancements to ltCFFORMgt objects
• GetHTTPRequestData

5
Running queries of queries

• CF5 allows you to run queries against recordsets
  stored in memory from a ltCFQUERYgt tag
• Join the results of two queries together in
  memory (simulating sql stored procedure temp
  table functionality)
• CF5 supports a minimal subset of the ANSI
  standard
• Group By
• Order By
• Aggregate Functions (Count, Sum, Avg, Max, Min)
• As
• Boolean (Not, Like, IN, Between, AND, OR
• DML (Outer Join syntax)

6
Running a query against a recordset
ltCFQUERY NAMEgetemp datasourcefoogt select
lastname,firstname from person order by
lastname lt/CFQUERYgt ltCFQUERY NAMEgetempbyfirstna
me dbtypequerygt select from
getemp order by firstnamelt/CFQUERYgt
7
User-Defined Functions using ltCFSCRIPTgt

• ltCFSCRIPTgt (introduced in CF 3.x) now gets
  javascript-like function support
• ltCFSCRIPTgt functions will perform better than
  calling CFML custom tags
• UDFs can be recursive

8
User Defined Functions using ltCFSCRIPTgt
ltCFSCRIPTgt function addit(x,y) var
totalxy return total lt/CFSCRIPTgt ltCFSET
myval addit(2,2)gt ltCFOUTPUTgtmyvallt/CFOUTPUTgt
9
ltCFSAVECONTENTgt

• ltCFSAVECONTENTgt caches the HTML output of all
  CFML constructs within the tags
• Enables the caching of specified sections of a
  page for later recall
• Similar to ltCFA_GeneratedContentCachegt in Allaire
  Spectra and other tags currently available on the
  Allaire Tag Gallery
• Operates faster than the tags on the Gallery
• NOTE All output is suppressed within the tags

10
ltCFSAVECONTENTgt
ltCFIF not isDefined("session.mycontent")gt ltCFSAVE
CONTENT variable"session.mycontent"gt ltCFQUERY
NAME"getemp" DATASOURCE"uikitdevsample"gt sele
ct from empemployees lt/CFQUERYgt ltCFOUTPUT
QUERY"getemp"gt firstname lastname
ltBRgt lt/CFOUTPUTgt lt/CFSAVECONTENTgt lt/CFIFgt ltCFO
UTPUTgtsession.mycontentlt/CFOUTPUTgt
11
ltCFFLUSHgt

• Flushes the current ColdFusion output buffer
• Use it to start sending output to the web client
  before the page has fully completed processing
• After a ltCFFLUSHgt has executed, the following
  tags will generate an exception
• CFCONTENT
• CFCOOKIE
• CFFORM
• CFHEADER
• CFHTMLHEAD
• CFLOCATION

12
ltCFFLUSHgt
ltCFQUERY NAME"getperson" DATASOURCE"careernotesd
ev"gt select personfname,personlname from
person lt/CFQUERYgt ltCFFLUSH interval"100"gt ltCFOU
TPUT QUERY"Getperson"gt personfname
personlnameltBRgt lt/CFOUTPUTgt
13
ltCFLOGgt

• Programmatically create a log entry in any of the
  standard log files (or create your own!)
• Generate application-specific, scheduled task,
  and custom logs
• Limit logs by size and entries by age
• Utilize the new CFADMIN log viewers to view logs
• Writes out information comma-delimited
• Type
• Thread
• Date
• Time
• Application

14
ltCFLOGgt
ltCFLOG textCompleted Process Successfully log
Application TypeInformation ThreadYes D
ateYes TimeYes ApplicationYesgt
15
Enhancements to ltCFFORMgt

• The CFTextInput, CFSLIDER, CFTREE, and CFGRID
  tags were completely rewritten
• The controls run more consistently in JVMs
• The ltCFFORMgt tag now has a preservedata attribute
  that will autoload information into a control if
  the page submits to itself.
• Users are prompted to install the Java 1.3
  runtime from the web

16
GetHTTPRequestData

• Makes HTTP Request Headers available for
  potentially capturing SOAP request data
• Information is returned in a structure

17
ltCFDUMP?gt

• Graphically dumps the contents of ANY CF variable
• Available in Beta 3?

18
New 3rd Party Integration

• Verity has been upgraded from Search 97 to
  Verity VDK 2.6.1
• Graphing will be available in Beta 3 using a
  subset of Macromedia Generator, Developer Edition
  (ltCFGRAPHgt tag)
• A new version of Netegrity Siteminder is being
  integrated (CF Advanced Security)
• Crystal Reports 8 reports are now supported

19
Database Support

• Allaire has licensed a new set of MERANT database
  drivers
• Some datasources will now be able to be set up
  clientless
• Sybase
• Informix 9
• Oracle?
• CF now supports DSNless Connections

20
DSNless Connections

• You can specify a connection string for odbc
  datasources

ltCFQUERY NAME"getpeople" DATASOURCE"__DYNAMIC_
_" DBTYPE"dynamic" blockfactor"100" connectst
ring"DRIVERSQL SERVER SERVER(local) UID
sa PWD DATABASEuikitdevsample"gt select
firstname,lastname from empemployees
lt/CFQUERYgt
21
Administration Enhancements

• Revamped CF Administrator
• SNMP Support
• Application/Server Backup and Restore (Harvest)