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: witango-talk@witango.com > 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
