Heh heh..
This is cool..I did this..and...the collection is completely EMPTY!
The query though returns 4 records..but...umm...obviously the problem is
my CFINDEX tag...
Hmmm.
I created the collection through the CF Administrator then used the
CFINDEX tag to populate it..or so I thought
I did not use K2,though. This is all on CF5.
<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
FROM tblCompany
</cfquery>
<CFINDEX
COLLECTION = "eguide"
ACTION = "REFRESH"
TYPE = "CUSTOM"
QUERY = "listeguide"
TITLE = "listeguide.CName"
KEY = "entryid"
BODY = "listeguide.CName"
EXTERNAL = NO>
<cfsearch collection="eguide"
name="myResults"
criteria="">
<cfdump var="#myResults#">
To me..that CFINDEX statement should more than do the job. The query
returns the results I want to search..can't get much simpler than
that.I've cut the Body field down to just the company name too, although
I want to search on all the fields in the database(MS Access).
What the heck is wrong? I'm not even getting an error message.
-Gel
-----Original Message-----
From: Sean McCarthy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 17, 2002 4:15 PM
To: CF-Talk
Subject: RE: Verity: What is in a collection?
Sure you can use the cfdump tag and spit out all the goods.
I highly recommend u use K2 all you have to do is set up the alias info
in the .ini file.
<cfsearch collection="ur_collection"
name="myResults"
criteria="#form.keywords#">
<cfdump var="#myResults#">
leave your form field blank and get all results
other helpful goodies
<cfset k2collections = GETK2SERVERCOLLECTIONS()>
<cfset k2doccount = GETK2SERVERDOCCOUNT()>
<cfset k2doclimit = GETK2SERVERDOCCOUNTLIMIT()>
hth
sean
______________________________________________________________________
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
