https://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/70596.aspxMon, 26 Sep 2011 11:55:13 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:70596Mnutty0https://www.infopathdev.com:443/forums/thread/70596.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=70596<p>Hi</p><p>I can read and write to an sql database no problems.</p><p>In my form I pull back an id, name, price, date&nbsp;and type from a db in a repeating section.&nbsp;I want to then update the date and price for that one product, but in my section it puts every item as the same price as it only sees one id (the first one)</p><p>&nbsp;<strong>What I want is:</strong></p><p>Current information</p><p>&nbsp;id = 1</p><p>name = blah</p><p>price = 12</p><p>date = 01/08/2011</p><p>New information</p><p>id = 1</p><p>date = 01/09/2011</p><p>price = 13</p><p>Current information</p><p> id = 2</p><p>name = blah blah</p><p>price = 12</p><p>date = 01/08/2011</p><p>New information</p><p>id = 2</p><p>date = 01/09/2011</p><p>price = 13</p><p><strong>What I&#39;m getting is</strong> </p><p>Current information</p><p> id = 1</p><p>name = blah</p><p>price = 12</p><p>date = 01/08/2011</p><p>New information</p><p>id = 1</p><p>date = 01/09/2011</p><p>price = 13</p><p>Current information</p><p> id = 2</p><p>name = blah blah</p><p>price = 12</p><p>date = 01/08/2011</p><p>New information</p><p>id = 1</p><p>date = 01/09/2011</p><p>price = 13</p><p>&nbsp;How do I get around this?</p><p>Mike</p>