Autodesk 15606-011408-9300 Developer Guide - Page 91
The HTML output, Access database listing employees
UPC - 606121429548
View all Autodesk 15606-011408-9300 manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 91 highlights
Here's a listing of the complete CFM file called parcel_report.cfm: SELECT * FROM Parcel_Data Where Year_Built = '1963' ColdFusion Example Listing File Contents with ColdFusion Parcel Number: #APN# Owner: #Owner_Name# Year Built: #Year_Built# The following shows the page as it appears in a browser. The HTML output In this example, the database happens to be an Autodesk MapGuide resource, but it could be anything: a Microsoft® Access database listing employees and their phone numbers, a Microsoft® Excel spreadsheet showing your checking account balance, or anything else you might store in a table. Creating Report Scripts with ColdFusion | 91
Creating Report Scripts with ColdFusion
|
91
Here
’
s a listing of the complete CFM file called
parcel_report.cfm
:
<HTML>
<HEAD>
<!-- ColdFusion query -->
<CFQUERY NAME="get_parcel_info" DATASOURCE="Assessor">
SELECT * FROM Parcel_Data Where Year_Built = '1963'
</CFQUERY>
<TITLE>ColdFusion Example</TITLE>
</HEAD>
<BODY>
<H1>Listing File Contents with ColdFusion</H1>
<!-- ColdFusion output tags -->
<CFOUTPUT QUERY="get_parcel_info">
<P>Parcel Number: #APN#<BR>
Owner: #Owner_Name#<BR>
Year Built: #Year_Built#</P>
</CFOUTPUT>
</BODY>
</HTML>
The following shows the page as it appears in a browser.
The HTML output
In this example, the database happens to be an Autodesk MapGuide resource,
but it could be anything: a Microsoft
®
Access database listing employees and
their phone numbers, a Microsoft
®
Excel spreadsheet showing your checking
account balance, or anything else you might store in a table.