Is it a single outer join? With multiple, witango will NEST them, and
the db will sometimes not like that.
Try the outer join in a direct DBMS action. Try the new SQL 92
syntax, and the old ANSI syntax (*=) and see if that makes a difference.
What db are you using? ODBC or JDBC?
I definitely found issues with joins before, in specific
circumstances. One issue needed an update from my db vendor, the
other requires I use DBMS, cuz I don't want them nested, and no way
to tell witango how to build the joins.
--
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 18, 2005, at 9:23 AM, Roland Dumas wrote:
The _function has six actions. I've isolated to the single action
that is the culprit. A relatively simple search action with a left
outer join. Microscope to the XML reveals nothing out of the
ordinary. No funny business at all.
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
