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:342015
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm