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
