Re: Witango-Talk: Using an array for In Search
Driscoll, Kevin at [EMAIL PROTECTED] wrote: > I am getting bounced from witango-talk saying the address is on a relay > list. > > Anyone else? Yep, I was. Wayne Byte Services Pty Ltd http://www.byteserve.com.au/ [EMAIL PROTECTED] Ph 02 9960 6099 Mob 0409 960 609 Fax 02 9960 6088 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Using an array for In Search
I am getting bounced from witango-talk saying the address is on a relay list. Anyone else? -Original Message- From: Alan Wolfe [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2008 7:41 PM To: witango-talk@witango.com 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: 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 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: Using an array for In Search
Just a quick thank you to all the Witango talk members out there who have contributed to this thread. I had no idea about the 'Is In' operator but it solved one of my current problems. Thanks. I really should look further into some of the other features of Witango that I have seen but never used. Wayne Irvine Byte Services Pty Ltd http://www.byteserve.com.au/ [EMAIL PROTECTED] Ph 02 9960 6099 Mob 0409 960 609 Fax 02 9960 6088 TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: Using an array for In Search
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: witango-talk@witango.com 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: "witango-talk@witango.com" Date: Tue, 18 Mar 2008 16:41:07 -0700 To: "witango-talk@witango.com" 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: 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 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
RE: Witango-Talk: Using an array for In Search
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: witango-talk@witango.com 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: "witango-talk@witango.com" > Date: Tue, 18 Mar 2008 16:41:07 -0700 > To: "witango-talk@witango.com" > 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: 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 > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
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: "witango-talk@witango.com" > Date: Tue, 18 Mar 2008 16:41:07 -0700 > To: "witango-talk@witango.com" > 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: 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 > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
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: 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
RE: Witango-Talk: Using an array for In Search
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