Server Error in '/' Application.

Ambiguous column name 'cityName'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Ambiguous column name 'cityName'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException (0x80131904): Ambiguous column name 'cityName'.]
   noreal_dnet.SiteInfo.getSitesBySearch(String where, Int32 idaysnew) +525
   noreal_dnet._propsearch.BindGrid() +74
   noreal_dnet._propsearch.btnSearch_Click(Object sender, EventArgs e) +1375
   noreal_dnet._propsearch.Page_Load(Object sender, EventArgs e) +2614
   System.Web.UI.Control.OnLoad(EventArgs e) +108
   System.Web.UI.Control.LoadRecursive() +90
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1533


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4700.0