Quick guess, change
like ('%' + word + '%')
to
like (word)
??/
WG
> -----Original Message-----
> From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
> Sent: 19 December 2002 17:52
> To: CF-Talk
> Subject: Re: Is there a Better Way to do this?
>
>
> No you were correct I only want to pull the dictionary words that
> were found
> in the dream. The code you gave me worked great the only issue i
> see now for
> example let's say the word is FEEL then it pulls EEL out of the
> dictionary.
> IS there a way to avoid that?
>
> > >> I'm not a SQL wizard and am doing this off the top of my
> > >> head, but I'd try
> > >> something along the lines of
> > >>
> > >> select word from dictionary where
> > >> (select dream from dreams where dream_id = #dreamid#)
> > >> like ('%' + word + '%')
> > >>
> > >> But, again, that's off the top of my head.
> > >>
> >
> > > What you mean is :
> >
> > > SELECT dictionary.word, dictionary.definition
> > > FROM dictionary LEFT JOIN dream
> > > ON dreams.dream LIKE '%' + dictionary.word + '%'
> >
> > > Which is what Isaac's got in his stored proc... ;o)
> >
> >Accept that if you left join dream, you'll get every word from the
> >dictionary -- I was under the impression ( possibly mistaken ) he was
> >looking for only words appearing in the dream text ...
> >
> >s. isaac dealey 954-776-0046
> >
> >new epoch http://www.turnkey.to
> >
> >lead architect, tapestry cms http://products.turnkey.to
> >
> >certified advanced coldfusion 5 developer
> >http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
