Bill is correct.
I would like to caution that doing "like" queries do not use indexes and
will go through records in a table one by one.
If the table contains several hundreds of thousands of records (or tens of
simultaneous searches), this can produce an incredible amount of CPU
overhead if you are using a transactional database like MSSQL or Sybase
where table/row level locking is used to enforce data integrity.
-- Brett
-----Original Message-----
From: Bill Killillay
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: 7/15/00 6:56 AM
Subject: RE: searching for key words using cf
Claude,
In your sql statement you just need to do it something like so:
Select Hotel, City, Phone
>From YourDatabase
Where Hotel Like '%search_string%'
Order By Hotel
That where statement is the key, it would return anything with the word
Hotel in it. You can set it up to search anything. Let me know if you
need
any more help on this one.
Bill
> -----Original Message-----
> From: AustralianAccommodation.com Pty. Ltd.
> [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 15, 1999 9:53 AM
> To: [EMAIL PROTECTED]
> Subject: searching for key words using cf
>
>
> I need to extract out of the database those records who value in the
> Property Name field contain a certain work
>
> eg Sofitel Hotel
>
> I need to find the record by searching the property name field
> for the word
> "hotel"
>
>
> Kind Regards
>
> Claude Raiola (Director)
> AustralianAccommodation.com Pty. Ltd.
> Website: www.AustralianAccommodation.com
> Email: [EMAIL PROTECTED]
>
> ------------------------------------------------------------------
> ------------
> 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.
------------------------------------------------------------------------------
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.
