As a purely academic question I'd be interested in knowing your reasons to use verity (or whatever cf uses now) instead of the database directly.
On Tue, Feb 8, 2011 at 6:17 PM, N kips <nich...@gmail.com> wrote: > > Below is the code that does the index, and the cfsearch code that reads > > The index: > > <cfquery name="Qryname" datasource="dsnnane"> > SELECT id, eid, title > FROM tbl1 > </cfquery> > > <cfindex > query="Qryname" > collection="events" > action="Update" > type="Custom" > title="title" > key="id" > body="eid,title"> > > Search Results > > <cfsearch > collection="events" > name="Qryname" > criteria="#Form.Criteria#"> > > <!--- Output the record set. ---> > <cfoutput> > Your search returned #Qryname.RecordCount# result(s). > </cfoutput> > > <cfoutput query="Qryname"> > <a href="page.cfm?eid=#eid#">#title#</a> > > </cfoutput> > > I get an error saying that eid is not defined. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342020 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm