Re: ConnectionPooling and the new parameter_collection.cs
Matt, sorry I made a mistake - I'm not using that SQL with the command builder. I'm simply using:
SELECT * FROM sites ORDER BY SiteID
and the UPDATE command generated by the MySqlCommandBuilder is:
UPDATE `sitedb_test`.`sites` SET `SiteID` = ?p1, `CustomerID` = ?p2, `SiteName` = ?p3, `CustomerSiteID` = ?p4, `Address` = ?p5, `City` = ?p6, `PostCode` = ?p7, `PhoneNumber` = ?p8 WHERE ((`SiteID` = ?p9) AND (`CustomerID` = ?p10) AND (`SiteName` = ?p11) AND ((?p12 = 1 AND `CustomerSiteID` IS NULL) OR (`CustomerSiteID` = ?p13)) AND ((?p14 = 1 AND `Address` IS NULL) OR (`Address` = ?p15)) AND ((?p16 = 1 AND `City` IS NULL) OR (`City` = ?p17)) AND ((?p18 = 1 AND `PostCode` IS NULL) OR (`PostCode` = ?p19)) AND ((?p20 = 1 AND `PhoneNumber` IS NULL) OR (`PhoneNumber` = ?p21)))
The UPDATE command is the same for both 5.0.1 and 5.0.2, but in 5.0.2 I receive the previously mentioned error.
Sorry for the red herring.
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
December 06, 2006 02:52AM
December 06, 2006 07:33AM
Re: ConnectionPooling and the new parameter_collection.cs
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