. . . . . ..... Cold Fusion
TAG Syntax
<CFquery ............NAME="queryName" ...................DATASOURCE="odbc datasource name" ...................MAXROWS=n ...................USERNAME="username" ...................PASSWORD="password" > ...................TIMEOUT=n ........not supported by all ODBC database drivers ...................DEBUG ................if used it turns ON ...................SQL statement ..........................SELECT * FROM dbTABLEname </CFquery> <CFoutPut......Query="queryName"............optional ...................MAXROWS=n ..>................. danger from 0 to n ...................literal-test, HTML tags, ...................dynamic field ref (e.g. #fullname#)......................###### </CFoutPut> <CFtable........if to many rows add these attributes ...................QUERY...................required
....QueryName <CFcol.............sub tag of CFtable ...................HEADER..........the text Example: Tip...Displaying result sets using HTML 3.0 tables does not require the use of CFtable tag with HTMLtable attribute. You can also use CFoutput tag. For maximum control over the appearance of your tables the CFoutput is superior. Use the CFtable tag if you need to convert existing preformatted CFtables..or..you want the increased readability and maintainability gained by using the CFtable tag. |