I believe the only thing supported, is what appears in the drop down
in that operator field, NOT IN is not supported. Witango must take
the xml built from this, and build SQL, and they must not have built
in support for this, so you wouild need to use directDBMS. If you did
find a string that provided support for is NOT in, then by all means,
share it.
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/
On Nov 2, 2006, at 11:28 AM, Quinn Mclaughlin wrote:
Hi all,
Here's an interesting one for a serious Witango head... I noticed
the search builder allows an <@arg> to set the Operator used in the
search query. (see pic which should appear inline, but may be
attached)
______________________________________________________________________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
<pastedGraphic.png>
Also interesting is how the argument is set:
<pastedGraphic.png>
seems like we have some secret code words working as operators as
SQL queries are built.
Anyway, what I was trying to do is avoid building custom DBMS
actions for queries with a "NOT IN" operator. What I want to run
is a NOT IN operator:
<pastedGraphic.png>
It seems the "NOT IN" is translated to a simple "=" sign in the
generated SQL. I also tried setting a variable with that value in
that space, just in case the item had to be evaluated for some
reason - doesn't work either.
Anyone know if there is a way to get that operator over into the
SQL statement? Seems like there would be, or should be a way...
Quinn McLaughlin
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
