Hi all,
I am creating a verity collection from a CFQuery, and I would like to
know what is listed in the collection.
How do I do that?
-------------------------
<cfquery name="listeguide" datasource="eguide" dbtype="ODBC">
SELECT tblCompany.entryid,tblCompany.CName, tblCompany.CAddr,
tblCompany.CAddr2, tblCompany.CState, tblCompany.CZip,
tblCompany.CCountry, tblCompany.Ctel1, tblCompany.Ctel2,
tblCompany.cemail, tblCompany.curl,
tblCompanyContacts.ContactName, tblCompanyContacts.ContactTel1
FROM tblCompany, tblCompanyContacts
WHERE tblCompany.entryid = tblCompanyContacts.companyid
</cfquery>
<cfindex action="UPDATE"
collection="eguide"
key="entryid"
type="CUSTOM"
title="cname"
query="listeguide"
body="cname,caddr1,caddr2,cstate,czip,ccountry,ctel1,ctel2,cemail,curl">
-------------------------
-Gel
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
