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.
