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:
ThanksI 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>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/> CoachVille: For coaches and people taking teleclasseshttp <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>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>http://www.cvcommunity.com?af=69474 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Toolbox.tcf
Description: Binary data
