View Single Post
Old 04-01-2006, 12:58 AM   #4 (permalink)
Apokalipse
Apokalipse's Avatar
 

Join Date: Jun 2003

Location: Melbourne, Australia

Posts: 13,692

Apokalipse has a spectacular aura aboutApokalipse has a spectacular aura about

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