Re: ConnectionPooling and the new parameter_collection.cs
Posted by: James Pearson
Date: December 06, 2006 02:52AM

Hi Matt, nice work finding that!

My SQL SELECT doesn't have any duplicate fields, so I'm not sure where my problem lies.

Here's the SQL:

SELECT cust.company_id AS SiteID, company.parent_company_id AS CustomerID, company.descr AS SiteName, address.fax_phone_id AS CustomerSiteID, address.address_1 AS Address, address.city AS City, address.zip AS PostCode, address.phone_id AS PhoneNumber
FROM cust
INNER JOIN company ON cust.company_id = company.company_id
INNER JOIN address ON company.address_id = address.address_id
WHERE company.parent_company_id is not Null
ORDER BY SiteID

Options: ReplyQuote


Subject
Written By
Posted
Re: ConnectionPooling and the new parameter_collection.cs
December 06, 2006 02:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.