awesome thanks :)))
>From: S. Isaac Dealey <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Re: Is there a Better Way to do this? >Date: Thu, 19 Dec 2002 13:26:40 -0500 > >Yea, there's a couple things you can do ... > >Make sure that every word in the dream is bounded by spaces > >You can do this with a couple regular expressions like this: > ><cfset dreamtext = REReplace(dreamtext,"([[:alpha:]])([^ [:alpha:]])","\1 >\2","ALL")> ><cfset dreamtext = REReplace(dreamtext,"([^ [:alpha:]])([[:alpha:]])","\1 >\2","ALL")> > >To give you a quick run-down ( in case you're unfamiliar with regular >expressions ), this says find an alphabetic character [[:alpha:]] followed >by a character that is not a space and not alphabetical [^ [:alpha:]], and >replace them with the first character \1 a space and the second character >\2 >-- it then reverses the position of the alpha and the non alpha characters >and places spaces in front of words which are prepended with something >other >than a space. > >Then feed your massaged dream text into the stored procedure with an extra >space on either side of the text and add the spaces to the query like so: > >WHERE dreams.dream LIKE '% ' + dictionary.word + ' %' > >Alternatively, you could just change anything that's not a space into a >space before you feed it to the stored procedure like this: > ><cfquery ...> > exec sp_DreamNewLookup > @txt_dream = ' #REReplace(dreamtext,"[^ [:alpha:]]"," ","ALL")# '; ></cfquery> > >This is going to also replace numbers and punctuation, however, so you >probably won't want to store the text after this REReplace() function call. > >If you need / want more help with regular expressions, check out the >cf-regex list also on www.houseoffusion.com > >hth > >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 > > > > 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 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm