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
