Actually..I mean the collection returns 0 results on every search. I suspect that the collection isn't being populated correctly from the database, and was wondering if there was a way to output the entire collection to see what was indexed etc.
I'm trying to troubleshoot why the collection isn't being indexed correctly, and aside from switching my fields and syntax and clicking refresh refresh in mad trial and error I can't see a clear way to do that. Anyone have much experience with Verity? -Gel -----Original Message----- From: Angel Stewart [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 1:42 PM To: CF-Talk Subject: Verity: What is in a collection? 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 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
