Here is an example:
<cfquery name="data_export" datasource="#DSN#">
SELECT person.*,
organization.name AS org_name
FROM person
JOIN organization ON organization.organization_id = person.organization_id
</cfquery>
<html>
<cfcontent type="application/vnd.ms-excel">
<head>
<title>Intranet Test Page</title>
</head>
<body>
<table>
<cfoutput>
<tr>
<td><b>First Name</b></td>
<td><b>Last Name</b></td>
<td><b>E-Mail</b></td>
<td><b>Username</b></td>
<td><b>Password</b></td>
<td><b>Organization</b></td>
</tr>
</cfoutput>
<cfoutput query="data_export">
<tr>
<td>#first_name#</td>
<td>#last_name#</td>
<td>#email#</td>
<td>#userid#</td>
<td>#password#</td>
<td>#org_name#</td>
</tr>
</cfoutput>
</table>
</body>
</html>
-----Original Message-----
From: chad [mailto:[EMAIL PROTECTED]
Sent: November 13, 2003 10:09 AM
To: CF-Talk
Subject: Creating Excel Files
I am looking for an easy way to get orders from a query into a MX Excel
file. Is there anything out there that will allow me to do this?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
