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
Also interesting is how the argument is set:
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:
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
