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

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.

Options: ReplyQuote


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


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.