Thanks Ted that would work also. But of course as people pointed out
( and as I had started to do anyway but never tested) it works fine as
a one column many row array in the search action. Witango handles it
correctly. as @@request$search_ids
Dan Stein
[EMAIL PROTECTED]
On Mar 19, 2008, at 10:58 AM, Ted Wolfley wrote:
Hi,
Here is what I do, I put the array into an variable using the
csuffix and add a ) after the array variable tag. Then I use the
replace function looking for the ",)" that is a the end of the comma
delimited list.
Example:
<@ASSIGN NAME='vcommalist' VALUE='<@VAR varray[*,1] SCOPE="Request"
type="text" aprefix="" asuffix="" rprefix="" rsuffix="" cprefix=""
csuffix=",">)' SCOPE='request'>
<@ASSIGN NAME="vcommalist" VALUE="<@REPLACE STR='@@request
$vcommalist' FINDSTR=',)' REPLACESTR=')'>" SCOPE="request">
Ted
-----Original Message-----
From: Dan Stein [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2008 8:16 PM
To: [email protected]
Subject: Re: Witango-Talk: Using an array for In Search
Thanks guess I was over thinking it I had that but didn't try it. As
usually
witango does the hard work.
--
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
"I destroy my enemies when I make them my friends."
Abraham Lincoln
From: Alan Wolfe <[EMAIL PROTECTED]>
Reply-To: "[email protected]" <[email protected]>
Date: Tue, 18 Mar 2008 16:41:07 -0700
To: "[email protected]" <[email protected]>
Subject: Re: Witango-Talk: Using an array for In Search
Ive tried this before by building an sql query as a string then
putting it in a direct DBMS.
We hit problems though when the string got too long, our DB didn't
accept the query anymore.
So, if you go this way you might want to check the maximum length
query your DB supports and make sure that's enough space for your
worst case scenario, but yeah you can deffinately do this (:
On 3/18/08, Walker, Buddy <[EMAIL PROTECTED]> wrote:
Dan
Not sure if this what you are talking about but this is what I've
done in
a search action
Column Oper. Value
MasterVisitID.CourseID Is in <@VAR uDeptCourses
SCOPE="USER" [*,1]>
UDeptCourses is a one column array.
Buddy
________________________________
From: Dan Stein [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2008 7:28 PM
To: [email protected]
Subject: Witango-Talk: Using an array for In Search
I want to use an array of ID's to do an in search.
I am trying to figure out how to take the array and return it as a
comma
delimited string without the trailing comma that shows up with
csuffix=","
Is there a simple way way assign this to a variable and lose that
comma?
Seems there should be
--
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
"The love of one's country is a splendid thing. But why should
love stop at
the border? "
Pablo Casals
________________________________________________________________________
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
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
