Oops, I thought you were talking about column name ambiguity. I wonder of this has to do with the underscore "_", don't remember what was the deal with the _ like in _function. For some strange reason it looks like it is not recognizing the _ in the table name and the search and replace is just replacing all instances of "Product"
Ben -----Original Message----- From: John McGowan [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 20, 2005 2:24 PM To: [email protected] Subject: Re: Witango-Talk: Bad Table Name Replacing 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 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
