ColdFusion Simple access to database examples

Usage Environment:

windows 7,coldfusion 9,coldfusion builder,ms SQL Server 2008 R2 Development version

1. set up a data source

2. Query and display

<cfquery name = "Getweixiu" datasource = "MSSQL2008R2" >

SELECT [ID]

, [numbering]

, [device name]

, [Equipment Brand]

, [Equipment Model]

, [Number of devices]

, [units]

, [manufacturer name] from Weixiu

Order by ID

</cfquery>

<i>currently available courses</i>

<!---Cfgrid must be inside a cfform tag. --->

<cfform>

<cfgrid name = "Firstgrid" format= "Flash"

height= "width=" "580"

"Tahoma" fontsize= "12"

query = "Getweixiu" >

</cfgrid>

</cfform>

Or

<cfoutput query= "Getweixiu" >

#GetWeixiu. id#, #GetWeixiu. Number #, #GetWeixiu. Device name #, #GetWeixiu. Equipment Brand #<br>

</cfoutput>