View Single Post
Old 03-31-2006, 11:58 PM   #4 (permalink)
Apokalipse
Multicellular Eukaryote
 
Apokalipse's Avatar
 
Join Date: Jun 2003
Location: Melbourne, Australia
Posts: 12,752
Default

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
Apokalipse is offline   Reply With Quote