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 equivelent in english to "column contains <word1> or <word2>" which is
what you want but
column in ('word1','word2')
is equivelent 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
