RE: Witango-Talk: Using an array for In Search

2008-03-18 Thread Walker, Buddy
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

Re: Witango-Talk: Using an array for In Search

2008-03-18 Thread Alan Wolfe
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 e

Re: Witango-Talk: Using an array for In Search

2008-03-18 Thread Dan Stein
; 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 >

RE: Witango-Talk: Using an array for In Search

2008-03-19 Thread Ted Wolfley
LACE 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: Usi

Re: Witango-Talk: Using an array for In Search

2008-03-20 Thread Dan Stein
="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-ta

Re: Witango-Talk: Using an array for In Search

2008-03-23 Thread Wayne Irvine
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.

RE: Witango-Talk: Using an array for In Search

2008-03-27 Thread Driscoll, Kevin
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

Re: Witango-Talk: Using an array for In Search

2008-03-27 Thread Wayne Irvine
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 99