03-31-2006, 11:58 PM
|
#4 (permalink)
|
| Multicellular Eukaryote
Join Date: Jun 2003 Location: Melbourne, Australia
Posts: 12,752
| Quote: Server Error in '/' Application. Syntax error converting the varchar value '16477?=dig' to a column of data type int.
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: Syntax error converting the varchar value '16477?=dig' to a column of data type int. Source Error:
Line 78: cmd = new SqlCommand("SELECT articleid, headline, headlinedate, mzid, name, summary, zonename, parentname, article FROM xlaANMarticles, xlaANMpublishers, xlaANMzones WHERE xlaANMarticles.articleid = '"+article_id+"' AND xlaANMpublishers.publisherid = xlaANMarticles.publisherid AND xlaANMzones.zoneid = xlaANMarticles.mzid", conn_news_sys);
Line 79: reader = cmd.ExecuteReader(); Line 80: while (reader.Read()) {
Line 81: article_date.Text = reader.GetString(reader.GetOrdinal("headlinedate") );
Line 82: article_head.Text = reader.GetString(reader.GetOrdinal("headline")); Source File: D:\TR-live\read_article.cs Line: 80 Stack Trace:
[SqlException: Syntax error converting the varchar value '16477?=dig' to a column of data type int.]
System.Data.SqlClient.SqlDataReader.Read() +176
ShowArticle.Page_Load(Object sender, EventArgs e) in D:\TR-live\read_article.cs:80
System.EventHandler.Invoke(Object sender, EventArgs e) +0
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +750
|
__________________ 1 + 1 = 3 if you define 3 as a result of 1 + 1 |
| |