I think this is what you have. A field in your db that has the expertise in
a list. If this is the case then utimately you want to design your DB
differently. I would create another table with something like a UserID and
category, and then use a JOIN in your query. But...
This might work in your case, or some variation...
<cfquery name="getResults" datasource="expertise">
SELECT * FROM projects
WHERE 1=1
<CFLOOP LIST="#Form.SelectExpertise#" INDEX="tmpVar" DELIMETERS=",">
OR category LIKE #PreserveSingleQuotes(tmpVar)#
</CFLOOP>
</cfquery>
-----Original Message-----
From: Michael Blair [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 13, 2000 11:05 PM
To: [EMAIL PROTECTED]
Subject: searching a database list
Need some help on this one. I have a select field ("expertise") that
folks can select multiple items from and then upon submittance are
submitted into the databaseThen there is a search form to search on these
database fields
This is my search:
<cfquery name="getResults" datasource="expertise">
SELECT * FROM projects
WHERE category IN (#PreserveSingleQuotes(FORM.SelectExpertise)#)
</cfquery>
This does not find an entry within the database such as ('internet', 'html',
'coldfusion')
I give the option for the users to select numerous options but unless
they select the exact same expertise entered into the database it
returns nothing. If they are an expert in internet and that is within
their list I want that returned. Is there a way to do this if the
database already has these fields are do you have to enter them each
individually into their own row?
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
