Server Error in '/' Application.

---

Line 2:  <%@ Register TagPrefix="Map" TagName="Item" Src="~/Controls/MapItem.ascx" %>
Line 3:  
Line 4:  <asp:Repeater id="mapItemRepeater" runat="server" DataSource="<%# MapItems%>">
Line 5:      <ItemTemplate>
Line 6:          <Map:Item runat="server" Index="<%# Container.ItemIndex%>" ItemRow="<%# ((System.Data.DataRowView)Container.DataItem).Row%>" />

[SqlException (0x80131904): Incorrect syntax near ')'.
Incorrect syntax near ')'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
   System.Data.SqlClient.SqlDataReader.get_MetaData() +83
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +10
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +130
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +287
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +94
   Iteam.Trex.Data.DataQueryHandler.GetDataSetFromQuery(MissingSchemaAction missingSchemaAction, String sqlQuery, String tableName, Object[] parameters) +630

[TrexDataException: An error occured while executing query. (Table 'clinics)
]
   Iteam.Trex.Data.DataQueryHandler.GetDataSetFromQuery(MissingSchemaAction missingSchemaAction, String sqlQuery, String tableName, Object[] parameters) +796
   Iteam.Trex.Data.DataQueryHandler.GetDataSetFromParameterQuery(ParameterQuery pq) +124
   Iteam.Trex.Data.TableProviders.SqlTableDataProvider.LoadDataSet(RelationLoadDepth depth) +396

[Exception: Query:   
                            DECLARE @clinics table (id int PRIMARY KEY) ;
                            INSERT INTO @clinics SELECT /*xxx1*/ TOP 10 [clinics].[cl_id] FROM [clinics] WITH (NOLOCK)
  WHERE (cl_address LIKE '%%' OR cl_city LIKE '%%' OR cl_name LIKE '%%') AND (1=1) ORDER BY abs(cast(replace(cl_zip, ' ','') as int) - ) ; 

 SELECT /*xxx4*/ TOP 10 [clinics].* FROM [clinics] WITH (NOLOCK) INNER JOIN @clinics a ON a.id = [clinics].[cl_id]  ORDER BY abs(cast(replace(cl_zip, ' ','') as int) - ) ; 
]

[TrexDataException: Error when loading dataset. Table: clinics]
   Iteam.Trex.Web.TxSiteObject.Trex_Error(Object sender, ErrorEventArgs e) +1473
   Iteam.Trex.CodeBase.OnErrorRaised(ErrorEventArgs e) +22
   Iteam.Trex.CodeBase.RaiseError(Exception ex) +38
   Iteam.Trex.Data.TableProviders.SqlTableDataProvider.LoadDataSet(RelationLoadDepth depth) +1092
   Iteam.Trex.Data.TrexTable.LoadDataSet() +171
   Iteam.Trex.Data.TrexTable.GetDefaultView(RelationLoadDepth depth) +15
   Iteam.Trex.Data.TrexTable.GetDefaultView() +51
   Iteam.Trex.Web.Site.Controls.MapItemList.get_MapItems() +79
   ASP.controls_mapitemlist_ascx.__DataBindingmapItemRepeater(Object sender, EventArgs e) in d:\Inetpub\wwwroot\dukoral_2.0\Controls\mapItemList.ascx:4
   System.Web.UI.Control.OnDataBinding(EventArgs e) +99
   System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) +12
   System.Web.UI.WebControls.Repeater.DataBind() +75
   System.Web.UI.Control.DataBindChildren() +211
   System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +102
   System.Web.UI.Control.DataBind() +15
   System.Web.UI.Control.DataBindChildren() +211
   System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +102
   System.Web.UI.Control.DataBind() +15
   System.Web.UI.Control.DataBindChildren() +211
   System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +102
   System.Web.UI.Control.DataBind() +15
   System.Web.UI.Control.DataBindChildren() +211
   System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +102
   System.Web.UI.Control.DataBind() +15
   System.Web.UI.Control.DataBindChildren() +211
   System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +102
   System.Web.UI.Control.DataBind() +15
   Iteam.Trex.Web.Site.MapSearch.OnLoad(EventArgs e) +193
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627