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
> >
> >
> > "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/> 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/>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
> >
> > =====================================================
> > 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
