That's what we're here for. :) > 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=2181 >> >>6 >> >> >> >> >> >> >> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> > ~~~ >> > ~~~~~~~~~~~| >> > 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 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
