Re: searching for key words using cf

[AustralianAccommodation.com Pty. Ltd.]

thanks for your advice and warning regarding the use of the like command

as it turns out the database is at present in ms access however I intend to
migrate it up to sql in the very near future

so if the like facility has problems as you suggested what do you suggest to
be the alternative conditional code for the query.

for your interest the website I have personally developed is
www.australianaccommodation..com I intend for the site to become of
Australia's main accommodation portals in the internet and therefore I
expect there to be, in time, 10,000's of records in the public members table
and therefore potentially 1,000's of simultaneous access to the database.
There are over 15,000 accommodation houses in australia of which I have over
5,000 listed at the moment each with their own record so I really do
appreciate your comments and I will act on them accordingly once I know what
the alternative more efficient code to use is.

I welcome you if you have the time to take a look at the website and for
your own use if applicable re travelling to australia and also for any
comments / suggestions you may wish to provide.

Please keep in mind I am relatively new to database and cf programming not
knowing what cf was prior to December 1999

I look forward to your reply


Kind Regards

Claude Raiola (Director)
AustralianAccommodation.com Pty. Ltd.
Website: www.AustralianAccommodation.com
Email: [EMAIL PROTECTED]

----- Original Message -----
From: Brett Schlank <[EMAIL PROTECTED]>
To: 'Bill Killillay ' <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: '[EMAIL PROTECTED] '
<[EMAIL PROTECTED]>
Sent: Monday, July 17, 2000 6:52 AM
Subject: RE: searching for key words using cf


> 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/cf-talk@houseoffusion.com/
> > 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/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
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.