Discussions

http://www.ebrandon.ca/photo.aspx?picture_id=10363  
or  
Server Error in '/' Application.  
----------------------------------------  
 
ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.0.51b-community-nt]You have an error in your SQL syntax: check the manual that corresponds to your MySQL server version for the right syntax to use near 's photography,%') ORDER BY picture_id DESC LIMIT 8' at line 1  
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.Odbc.OdbcException: ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.0.51b-community-nt]You have an error in your SQL syntax: check the manual that corresponds to your MySQL server version for the right syntax to use near 's photography,%') ORDER BY picture_id DESC LIMIT 8' at line 1  
 
Source Error:  
 
 
Line 177: ''' show related pictures  
Line 178: objCmd2 = new OdbcCommand("SELECT picture_id,picture_filename FROM tbl_pictures_galleries WHERE (" & related_orstmt & ") ORDER BY picture_id DESC LIMIT 8",conn)  
Line 179: objDR = objCmd2.ExecuteReader  
Line 180:  
Line 181: lstRelated.datasource = objDR  
 
 
Source File: C:Program FilesEnsimWEBpplianceSiteDataDomainsebrandon.caROOTInetpubwwwrootphoto.aspx Line: 179  
 
Stack Trace:  
 
 
[OdbcException (0x80131937): ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.0.51b-community-nt]You have an error in your SQL syntax: check the manual that corresponds to your MySQL server version for the right syntax to use near 's photography,%') ORDER BY picture_id DESC LIMIT 8' at line 1]  
System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) +35  
System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) +1735  
System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) +60  
System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) +75  
System.Data.Odbc.OdbcCommand.ExecuteReader() +6  
ASP.photo_aspx.PopulatePictureData() in C:Program FilesEnsimWEBpplianceSiteDataDomainsebrandon.caROOTInetpubwwwrootphoto.aspx:179  
ASP.photo_aspx.Page_Load(Object Src, EventArgs E) in C:Program FilesEnsimWEBpplianceSiteDataDomainsebrandon.caROOTInetpubwwwrootphoto.aspx:36  
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15  
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34  
System.Web.UI.Control.OnLoad(EventArgs e) +99  
System.Web.UI.Control.LoadRecursive() +47  
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061  
 
 
 
 
----------------------------------------  
Version Information: Microsoft .NET Framework Version:2.0.50727.42: ASP.NET Version:2.0.50727.42