I am inserting info to an Access DB through a page with a <CFSELECT> tag with
multiple selected. So, the info in the field is separated by comas. Example-
22,24,6,63,7. I am trying to do searches of the DB and pull up results of parts
of the info. One person in the DB could have different numbers in this
particular field. (Tom could have 22,24 in this field. Jared could have 6,7 in
this field) The field name is 'desig' I am creating a search page that will
search for one of these items. Such as those with a 22 in this field. There
could be 22,24,6,7 in the field, I want it to identify the 22 and then display
the entire contents of the field, but only if the search parameter was met. I
hope this makes sense and I hope this is possible. The search page is just a
regular HTML input text box. Here is the code from the results page. Desig is
the name of the field I am working with. <CFQUERY NAME='partners'
DATASOURCE='#REQUEST.DataSource#'> SELECT * FROM profiles2 p, Contacts c WHERE
p.ContactID = c.ContactID AND 0=0 <!--- Search by Last Name ---> <CFIF
FORM.LastName IS NOT ''> AND LastName LIKE '%#FORM.LastName#%' </CFIF>
<!--- Search by State---> <CFIF FORM.state IS NOT ''> AND state LIKE
'%#FORM.state#%' </CFIF> <!--- Search by designations ---> <cfif FORM.desig IS
NOT ''> AND desig LIKE '%#FORM.desig#%' </cfif> ORDER BY LastName </CFQUERY>
<TABLE> <TR> <CFOUTPUT> <TH colspan='2' bgcolor='##006699'
class='UP_WhiteTitleSM'> <FONT SIZE='+3'>United Planners' Partners'
(<strong>#partners.RecordCount#</strong> Partners')</FONT> </TH>
</CFOUTPUT> </TR> <cfoutput query='partners'> <cfif CurrentRow MOD 2 IS
1> <cfset bgcolor='tan'> <cfelse> <cfset bgcolor='white'>
</cfif> <TR bgcolor='#bgcolor#'> <TD width='562' class='UP_text'>
<FONT SIZE='+2'><B>#CurrentRow#: <A
href='Prtnrs2_Details.cfm?PartnerID=#URLEncodedFor mat(Trim(PartnerID))#'>#LastNa
me#</A>, #FirstName#</B></FONT>&amp;nbsp; #desig#</TD> <TD width='182'
class='UP_text'>#state#</TD> </TR> </CFOUTPUT> </TABLE> If I do a
search for those with 22 in the 'desig' field, I get everyone in the DB
returned. Thanks for any help. Tom