CFINDEX / CFCOLECTION / CFSEARCH
Posted on 2002-07-25
I wanted to use the CFSEARCH ... i have created a collection ... but I dont have a clear picture on how to go ahead ...
I have a member table - with lot of details abt the member ... say around 100 fields having diff sets of data abt the member.
so i create a collection first:
then a index:
<CFQUERY NAME="Member" DATASOURCE="#IWD_DSN#" DBTYPE="ODBC" username="#IWD_USERNAME#" PASSWORD="#IWD_PASSWORD#">
SELECT * FROM Tbl_member_m
Now what i want to do here is
1. to be able to display all the data abt the user present in the collection [ie all 100 fields].
2. define criteria for searching thru the collection [like if i wanna search for all members above the age of 24 & who are all males - then how do i do this ]
if ne-of u can help me out on this - it would be really great !!!
thanx for putting in ur time & effort