Server Error in '/' Application.

Syntax error (missing operator) in query expression 'ZoomName = '/pics/GMEATGRANDPAHOUGHTALING'S1942lg.jpg''.

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.OleDb.OleDbException: Syntax error (missing operator) in query expression 'ZoomName = '/pics/GMEATGRANDPAHOUGHTALING'S1942lg.jpg''.

Source Error:


Line 59: 
Line 60: sqlDataSource1.SelectCommand = "Select * from cmtQuery where ZoomName = '" & Pic & "'"
Line 61: 	dvIndiv = SqlDataSource1.Select(DataSourceSelectArguments.Empty)
Line 62:  if dvindiv.count = 0 then
Line 63:  ' *** if objrs.eof then

Source File: G:\PleskVhosts\townscrapbook.com\httpdocs\Level3OneOne.aspx    Line: 61

Stack Trace:


[OleDbException (0x80040e14): Syntax error (missing operator) in query expression 'ZoomName = '/pics/GMEATGRANDPAHOUGHTALING'S1942lg.jpg''.]
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +1007188
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +255
   System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +188
   System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +58
   System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +161
   System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +116
   System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +4
   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, String srcTable) +92
   System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1297
   System.Web.UI.WebControls.SqlDataSource.Select(DataSourceSelectArguments arguments) +19
   ASP.level3oneone_aspx.Page_Load(Object Sender, EventArgs E) in G:\PleskVhosts\townscrapbook.com\httpdocs\Level3OneOne.aspx:61
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627


Version Information: Microsoft .NET Framework Version:2.0.50727.9061; ASP.NET Version:2.0.50727.9062