===表news=========if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[News]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[News] GOCREATE TABLE [dbo].[News] ( [ID] [bigint] IDENTITY (1, 1) NOT NULL , [TypeID] [int] NOT NULL , [Title] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NOT NULL , [Content] [text] COLLATE Chinese_PRC_CI_AS NULL , [PictureID] [int] NULL , [FileID] [int] NULL , [AddTime] [datetime] NOT NULL , [FromIP] [char] (15) COLLATE Chinese_PRC_CI_AS NOT NULL , [ReadCount] [bigint] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ====表newstype===== if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NewsType]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[NewsType] GOCREATE TABLE [dbo].[NewsType] ( [TypeID] [int] IDENTITY (1, 1) NOT NULL , [TypeContent] [varchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO======news_view=============if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[News_View]') and OBJECTPROPERTY(id, N'IsView') = 1) drop view [dbo].[News_View] GOSET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GOCREATE VIEW dbo.News_View AS SELECT dbo.NewsType.TypeContent AS NewsType, dbo.News.* FROM dbo.News INNER JOIN dbo.NewsType ON dbo.News.TypeID = dbo.NewsType.TypeIDGO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GOnews_view由news表和newstype表生成。我一个一个地改,终于发现newsrs("newstype")出错,而这个恰是表typecontent的别名,是不是视图就不行了,郁闷!
<%=newsrs.getString("title") %> --〉 <%=newsrs.getString("Title") %> 养成区别大小写的习惯sql="select * from News_View where id='"+newsid+"'"; --> sql="select * from News_View where id="+newsid; id为整形可以不写引号
drop table [dbo].[News]
GOCREATE TABLE [dbo].[News] (
[ID] [bigint] IDENTITY (1, 1) NOT NULL ,
[TypeID] [int] NOT NULL ,
[Title] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Content] [text] COLLATE Chinese_PRC_CI_AS NULL ,
[PictureID] [int] NULL ,
[FileID] [int] NULL ,
[AddTime] [datetime] NOT NULL ,
[FromIP] [char] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ReadCount] [bigint] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
====表newstype=====
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NewsType]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[NewsType]
GOCREATE TABLE [dbo].[NewsType] (
[TypeID] [int] IDENTITY (1, 1) NOT NULL ,
[TypeContent] [varchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO======news_view=============if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[News_View]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[News_View]
GOSET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GOCREATE VIEW dbo.News_View
AS
SELECT dbo.NewsType.TypeContent AS NewsType, dbo.News.*
FROM dbo.News INNER JOIN
dbo.NewsType ON dbo.News.TypeID = dbo.NewsType.TypeIDGO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GOnews_view由news表和newstype表生成。我一个一个地改,终于发现newsrs("newstype")出错,而这个恰是表typecontent的别名,是不是视图就不行了,郁闷!
--〉
<%=newsrs.getString("Title") %>
养成区别大小写的习惯sql="select * from News_View where id='"+newsid+"'";
-->
sql="select * from News_View where id="+newsid;
id为整形可以不写引号
--〉
新闻类型:<%=newsrs.getString("NewsType")%>