Thanks that did help. I madified the code in my case you need to transpose the
array since the string is jsut 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/ >
"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/ > 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
________________________________________________________________________ TO
UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
=====================================================
Database WebWorks: Dynamic web sites through database integration
http://www.DatabaseWebWorks.com
CoachVille: For coaches and people taking teleclasses
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
