I don't think it has anything to do with column names... witango is
replacing the table name with a table name alias... it's just not doing
it correctly. It should only be replacing if it matches a whole word...
instead it is replacing a substring.
/John
Ben Johansen wrote:
This sounds like the same column name is in both tables and Witango is
selecting the first instance. You change the table order or if you flip the
join to flip the table/columns and use a right outer join instead of a left
might do the trick.
Or you need to do DirectDBMS
Ben Johansen
-----Original Message-----
From: John McGowan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 20, 2005 11:46 AM
To: [email protected]
Subject: Witango-Talk: Bad Table Name Replacing
I have a query that joins the following tables.
products as p1
cart_products as c2
however at one point in the query that is created by Witango, a
reference to cart_products is showing up as "cart_p1" not "c2" Seems
like witango is replacing products with p1 even if it is a partial table
name match.
Anybody else ever see anything like this?
I'm forced to write this query as a DirectDBMS action....
________________________________________________________________________
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
