<pre>
I'd do this in two steps
<@assign name='request$arguments' value="<@replace str='<@arg
searchstring>' findstr=' ' replacestr=','>">
<@assign name='request$arguments' value="<@replace str='@@request
$arguments' findstr=',,' replacestr=','>">
</pre>
This would prevent your getting things like double commas if someone
included a comma in the search string.
On Sep 2, 2007, at 5:20 PM, Dan Stein 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
"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
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
