I dont see why not but you might want it to say
LIKE '%#url.page#%' that way as long as Peter
is within the keyword list it will find it otherwise
it won't. the % represents a wild card so anything
can come before or after Peter in the key word list
and it will still find Peter.
Stay current with what's happening on AirportNet. Subscribe to our
Announcement list today: http://www.airportnet.org/email.htm
---------------------------------------
Kelly Matthews
Internet Development Coordinator
AAAE
703.578.2509
[EMAIL PROTECTED]
http://www.airportnet.org
---------------------------------------
> -----Original Message-----
> From: Peter Benoit [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, August 23, 2000 4:31 PM
> To: '[EMAIL PROTECTED]'
> Subject: Select Query
>
> I have set a url string to a page, and I want to perform a query from a DB
> using that as a keyword.
>
> Can I set a field in a DB with a bunch of keywords to compare against a
> string?
>
> Lets say I pass the word "Peter" is #url.page#
>
> And the field in the DB named Keyword has - John Mary Peter Bill - in it.
> Is it possible to build a query that will find Peter in that list of
> words,
> and presents the results?
>
> My code so far:
>
> <cfquery name="doclist" datasource="custdoc" dbtype="ODBC">
> SELECT *
> FROM Customerdoclist
> WHERE (Customerdoclist.keywords LIKE '#url.page#')
> </cfquery>
>
>
> Peter
>
> --------------------------------------------------------------------------
> ----
> Archives: http://www.mail-archive.com/[email protected]/
> 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.mail-archive.com/[email protected]/
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.
