View Single Post
  #4 (permalink)  
Old February 2nd, 2010, 08:13 AM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts

Actually, I meant the code that builds up the SQL statement. You posted the SQL statement earlier, but as you posted it, it won't get you a dynamic company at all:

FROM Company
WHERE CompanyID like 'qrycompanyid'

This always finds companies where the CompanyID contains the literal qrycompanyid. So, somewhere it must be made dynamic.

No I am not sure at all, my experince writing querystrings is zip!
Take a look at the query string in the browser's address bar on the page where you're editing. Do you see a variable called ClientCompanyID, and does it change with each company you're editing?

Imar Spaanjaars
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote