two columns (currently just displaying in one).
<cfquery name="search" datasource="#DSN#" username="#db_username#"
password="#db_password#">
SELECT *
FROM users
WHERE dealership = #form.dealership#
ORDER BY
department
</cfquery>
<cfoutput query="search" group="department">
#department#
<br /><br />
<cfoutput>
#first_name#<br />
</cfoutput>
<br />
</cfoutput>
Thanks!
--
Jillian
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

