This does it. A real pain ot build but I can re use > it. > <@exclude> > <@assign request$Search_Parts <@tokenize <@ARG keyword> > " ,">> > > > > > P1.clip_width,P1.clip_height > FROM witango.Products P1,witango.product_pricing_levels > p2,witango.product_description_css > p3,witango.product_description p4 > WHERE ((p2.quanity_min=1 AND p2.pricing_level=@@domain$level > AND P1.site_eng=<@SQ>@@domain$lang<@SQ> > AND P1.is_web=1) > '> > > > > AND (P1.title like '%<@var request$Term > encoding=SQL>%') "> > </@for> > > </@exclude> > > The key is the for loop and then of course there > > <@var request$Search_SQL> > > > > > AND ((p4.aa_product_id=P1.a_product_id) > AND (p2.aa_product_id=P1.a_product_id) > AND (p3.aa_product_id=P1.a_product_id)) > > > > > > > > > P1.clip_width,P1.clip_height > FROM witango.Products P1,witango.product_pricing_levels > p2,witango.product_description_css > p3,witango.product_description p4 > WHERE ((p2.quanity_min=1 AND p2.pricing_level=1 AND > P1.site_eng='eng' > AND P1.is_web=1) > AND (P1.title like '%who%') > And(P1.title like '%men%') > and(P1.title like '%say%') > AND (P1.site_served=1 OR P1.site_served=0)) > AND ((p4.aa_product_id=P1.a_product_id) > AND (p2.aa_product_id=P1.a_product_id) > AND (p3.aa_product_id=P1.a_product_id)) > > > > > > > <[email protected]> wrote: > oh ok, maybe this would work then > > column like '%<word1>%<word2>%<word3>%' > > where you could make it longer if there were more > than 3 words or shorter if there were less > > > > On 9/3/07, Dan Stein <[EMAIL PROTECTED]> wrote: > > This will not work as > an or search like that since > I don't want where title has just the 1st word but > > > > We are looking for a title that has Who and Men and > Say they have to have all 3 words to qualify. > > > > -- > > > Dan Stein > FileMaker 7 Certified Developer > Digital Software Solutions > 799 Evergreen Circle > Telford PA 18969 > Land: 215-799-0192 > Cell: 610-256-2843 > Fax 413-410-9682 > FMP, WiTango, EDI,SQL 2000, MySQL, CWP > [EMAIL PROTECTED] > > > "There is more to life than increasing its speed." > Gandhi > > > > > > > On Sep 3, 2007, at 1:24 AM, Alan Wolfe wrote: > > in sql you'd want something more like this: > > select columns > from table > where column like '%<first word here>%" or column > like '%<second word here>%' > > etc. > > > > is equivalent in english to "column contains <word1> > or <word2>" which is what you want but > > column in ('word1','word2') > > is equivalent to "column is word1 or word2" > > > I'm not sure how "the big guys" like google and yahoo > do their queries but this is as close as i've been > able to get in my experiences. > > On 9/2/07, Dan Stein <[EMAIL PROTECTED]> wrote: > Just to try and be clear. > This is not a search on > a keyword database. > > > I need to bring back any title that has all the words > they typed in the title > Jesus: Who Do Men Say That I Am? > I can search by typing in Who Men Say and get the > title > > > When you use the FileMaker aPI for PHP this works > fine > > > I imagine we can do this with some sort of SQL search > > > > I though by doing an in search it would work but it > does not see to > > > where title in {'Who','Men'.'Say') does not return > the expected results > > > -- > > > Dan Stein > FileMaker 7 Certified Developer > Digital Software Solutions > 799 Evergreen Circle > Telford PA 18969 > Land: 215-799-0192 > Cell: 610-256-2843 > Fax 413-410-9682 > FMP, WiTango, EDI,MSSQL, MySQL, CWP > [EMAIL PROTECTED] > "The butterfly counts not months but moments. > And has enough time." Rabindranath Tagore > > > On Sep 2, 2007, at 9:09 PM, Dan Stein wrote: > > Thanks that did help. I modified the code in my case > you need to transpose the array since the string is just > one row > > <@EXCLUDE> > > <@assign request$value_Array <@tokenize '<@arg > keyword>' ", ">> > <@assign request$value_Array <@TRANSPOSE ARRAY="value_Array" > SCOPE="request">> > <@assign request$String ""> > > <@ASSIGN request$String_Delim ","> > <@assign request$Quote "<@sq>"> > > > <@ROWS array=request$Value_Array> > <@IFEMPTY @@request$String> > <@assign request$String "@@request$Quote<@COL > 1>@@request$Quote"> > <@ELSE> > <@assign request$String "<@var request$String><@VAR > > </@IF> > </@ROWS> > > </@EXCLUDE> > > > The only problem is I am still not getting waht I > want so maybe even this search is not right. > > In Searching Filemaker with PHP if I search a title > called > > > Jesus: Who Do Men Say That I Am? I can search by typing in Who Men Say and get the > title > > That is what I want from SQL I want to get the title > if any of the words are in the title. > > But that is not working any thoughts? > > <[email protected]> wrote: Hi Dan, > > Look at the method "array2string_With_Quote" in the > attached TCF. > That will do it for you. > > Stefan > > At 06:24 PM 9/2/2007, you wrote: > Thanks > > I sort of figured that much out but that just gives > me a 1x1 array so what am I looping through? > > I would have to figure out some way to count the > words and then loop through somehow getting each word > and wrapping it in <@SQ> tags and then a comma? > > I guess I could 1st add a <@SQ to the left and right > of the string and then replace the spaces with a <@SQ> > > > There must be an easier way to do this. > > I just want > Who I am has to become > 'who','I','am' > > It might even be if I can do that I can use a witango > search action > -- > Dan Stein > FileMaker 7 Certified Developer > Digital Software Solutions > 799 Evergreen Circle > Telford PA 18969 > Land: 215-799-0192 > Cell: 610-256-2843 > Fax 215-799-0192 ( Call 1st) > FMP, WiTango, EDI,SQL 2000, MySQL, CWP > [EMAIL PROTECTED] > www.dss-db.com > > > "When you are born, you cry and those who love > you rejoice. And if you > live your life as you should, when you die, you rejoice > and those who > love you cry." > > > > From: Stefan Gonick < [EMAIL PROTECTED]> > Reply-To: "[email protected]" < [email protected]> > Date: Sun, 02 Sep 2007 17:38:16 -0400 > To: "[email protected] " <[email protected]> > Subject: Re: SPAM-MED: Witango-Talk: Keyword Search > > Use @tokenize and loop through the array to create > your string. > > <@assign request$Search_Array <@tokenize > <@ARG Search_String> ", "> > > I'll leave the looping part to you. > > Stefan > > At 05:20 PM 9/2/2007, you wrote: > I want to have a keyword search search the title for > any of the words > entered in the search box. > > So I figure I have to do an is in search and I have > to use a direct DBMS > because Studio will not quote the words and SQL throws > an error. > > No problem I have the DBMS written. > > But what is the best way to get the words into a comma > separated string. > > Who I am has to become 'who','I','am' > -- > Dan Stein > FileMaker 7 Certified Developer > Digital Software Solutions > 799 Evergreen Circle > Telford PA 18969 > Land: 215-799-0192 > Cell: 610-256-2843 > Fax 215-799-0192 ( Call 1st) > FMP, WiTango, EDI,SQL 2000, MySQL, CWP > [EMAIL PROTECTED] > www.dss-db.com < http://www.dss-db.com/ > > > > "When you are born, you cry and those who love > you rejoice. And if you > live your life as you should, when you die, you rejoice > and those who > love you cry." > > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > > Database WebWorks: Dynamic web sites through database > integration > http://www.DatabaseWebWorks.com > > < http://www.databasewebworks.com/ > > http < http://www.cvcommunity.com/?af=69474 > :// > www.cvcommunity.com?af=69474 > < http://www.cvcommunity.com/?af=69474 > > > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
> > Database WebWorks: Dynamic web sites through database > integration > http://www.DatabaseWebWorks.com > > > http :// www.cvcommunity.com?af=69474 > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > -- Dan Stein MSN Certified FileMaker 7 Developer > Digital Software Solution, LLC 799 Evergreen Circle > 215-799-0192 610-256-2843 ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf -- Dan Stein MSN Certified FileMaker 7 Developer Digital Software Solution, LLC 799 Evergreen Circle 215-799-0192 610-256-2843 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
