Goodspeed

导航

09 2004 档案

[ASP] Request.ServerVariables
摘要：Server Variable Value 阅读全文

posted @ 2004-09-29 13:52 Goodspeed 阅读(3058) 评论(1) 推荐(0) 编辑

ASP.net的客户端脚本
摘要：// 在标签之前 this.RegisterStartupScript("2", ""); //在标签之后 this.RegisterClientScriptBlock("1", ""); //创建客户端数组在之前 RegisterArrayDeclaration("FavoriteFolks", "'Goo... 阅读全文

posted @ 2004-09-21 12:27 Goodspeed 阅读(1588) 评论(1) 推荐(0) 编辑

[SQL] 上月的月头和月尾
摘要：DECLARE @now datetime,@LastMonth datetimeDECLARE @star datetime,@end datetimeSET @now = DATEADD(dd,DATEDIFF(dd,'1900-1-1',getDATE()),'1900-1-1') --当前日期SET @LastMonth = DATEADD(mm,-1,@now) -- 上个月的今天S... 阅读全文

posted @ 2004-09-20 10:50 Goodspeed 阅读(1588) 评论(0) 推荐(0) 编辑

[SQL] 生成无级树
摘要：--处理示例--示例数据create table tb(ID int,Name varchar(10),ParentID int)insert tb select 1,'AAAA' ,0union all select 2,'BBBB' ,0union all select 3,'CCCC' ,0union all select 4,'AAAA-1' ,1union all ... 阅读全文

posted @ 2004-09-16 14:54 Goodspeed 阅读(1655) 评论(0) 推荐(0) 编辑

RecodeSet排序
摘要：strSQL = "SELECT EmployeeID,LastName,FirstName FROM Employees;"set rs=server.CreateObject("adodb.recordset")rs.CursorLocation = 3 rs.Open strSQL,conn,0,1 rs.Sort = " FirstName" 阅读全文

posted @ 2004-09-14 12:58 Goodspeed 阅读(1154) 评论(0) 推荐(0) 编辑

ASP和ASP.net中多结果集的返回
摘要：ASP Test " For Each Field In rs.Fields strResponse = strResponse & "" & Field.Name & "" Next strResponse = strResponse & "" '输出表体 Do Until rs.EOF strResponse = str... 阅读全文

posted @ 2004-09-13 16:49 Goodspeed 阅读(1293) 评论(0) 推荐(0) 编辑