You should have your own table for this data. Storing data comma delimted is not a
good idea.
You should create a referenece table to store your drop down lists. Then insert the
value for the element in its own table along with the persons user id for example.
The will make you select run that much faster. And you can also easily report on the
data now. If is was comma seperated you would have to select the data and basiclly do
an outer loop and inner loop to get back how mnay people choose internet.
In its own table you can just say Select count(user_id) where category = 3 .... 3
being Internet.
So in the end from your one table you now have 3.
Original Table minus Expertise
Expertise Table
Ref_experstise table
---------- Original Message ----------------------------------
From: "Michael Blair" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Thu, 13 Apr 2000 20:04:34 -0700
>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.
