Re: ConnectionPooling and the new parameter_collection.cs
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
Subject
Written By
Posted
November 22, 2006 01:19AM
November 22, 2006 12:10PM
December 01, 2006 04:32AM
December 01, 2006 08:33AM
December 01, 2006 09:25AM
December 01, 2006 10:11AM
December 05, 2006 09:56AM
December 05, 2006 10:02AM
December 16, 2006 12:28PM
December 17, 2006 12:57PM
December 05, 2006 03:01PM
Re: ConnectionPooling and the new parameter_collection.cs
December 06, 2006 02:52AM
December 06, 2006 07:33AM
December 06, 2006 09:45AM
December 06, 2006 11:21AM
December 07, 2006 02:47AM
December 07, 2006 08:21AM
December 07, 2006 07:08PM