Nope bad syntax.
-- 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 "The love of one's country is a splendid thing. But why should love stop at the border? " Pablo Casals From: Alan Wolfe <[EMAIL PROTECTED]> Reply-To: "[email protected]" <[email protected]> Date: Mon, 3 Sep 2007 11:00:12 -0700 To: "[email protected]" <[email protected]> Subject: Re: Witango-Talk: Keyword Search 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 where title has all of the three words in any order. > > > 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. >> >> column like '%<word1>%' or column like '%<word2>%' >> >> 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 but I am not clear how >>> to form the query I guess. >>> >>> >>> 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$Num_Elements <@numrows array=request$Value_Array>> >>>> <@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 >>>> request$String_Delim>@@request$Quote<@COL 1>@@request$Quote"> >>>> </@IF> >>>> </@ROWS> >>>> <@assign request$keyword_String @@request$String> >>>> </@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> and comma but that is still not >>>>>> going to be right. >>>>>> >>>>>> 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 <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." >>>>>> >>>>>> >>>>>> >>>>>> From: Stefan Gonick < [EMAIL PROTECTED] >>>>>> <mailto:[EMAIL PROTECTED]> > >>>>>> Reply-To: "[email protected]" < [email protected] >>>>>> <mailto:[email protected]> > >>>>>> Date: Sun, 02 Sep 2007 17:38:16 -0400 >>>>>> To: "[email protected] <mailto:[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/> < <http://www.dss-db.com/> >>>>>> http://www.dss-db.com <http://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://www.databasewebworks.com/> http://www.databasewebworks.com >>>>>> <http://www.databasewebworks.com/> / > <http://www.databasewebworks.com/> >>>>>> CoachVille: For coaches and people taking teleclasses >>>>>> http < <http://www.cvcommunity.com/?af=69474> >>>>>> http://www.cvcommunity.com/?af=69474 > >>>>>> <http://www.cvcommunity.com/?af=69474> :// www.cvcommunity.com?af=69474 >>>>>> <http://www.cvcommunity.com/?af=69474> >>>>>> < <http://www.cvcommunity.com/?af=69474> >>>>>> http://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 >>>>>> <http://www.witango.com/developer/maillist.taf> >>>>> ===================================================== >>>>> Database WebWorks: Dynamic web sites through database integration >>>>> http://www.DatabaseWebWorks.com >>>>> >>>>> <http://www.databasewebworks.com/> CoachVille: For coaches and people >>>>> taking teleclasses >>>>> 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 >>>> >>>> -- 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 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
