<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
<channel>
<title><![CDATA[三思随然 - 程序代码]]></title>
<link>http://www.yongzi.com/</link>
<description><![CDATA[主动即自由，阅历即财富！简简单单，一切随然！]]></description>
<language>zh-cn</language>
<copyright><![CDATA[Copyright 2005 PBlog3 v2.8]]></copyright>
<webMaster><![CDATA[1118221@qq.com(随然晓阳)]]></webMaster>
<generator>PBlog2 v2.4</generator> 
<image>
	<title>三思随然</title>
	<url>http://www.yongzi.com/images/logos.gif</url>
	<link>http://www.yongzi.com/</link>
	<description>三思随然</description>
</image>

			<item>
			<link>http://www.yongzi.com/article.asp?id=885</link>
			<title><![CDATA[html页面强制刷新，清缓存]]></title>
			<author>1118221@qq.com(随然)</author>
			<category><![CDATA[程序代码]]></category>
			<pubDate>Thu,23 Apr 2020 22:08:12 +0800</pubDate>
			<guid>http://www.yongzi.com/default.asp?id=885</guid>
		<description><![CDATA[如果需要用户每次访问网页都是最新内容<br/>可以在html页面头部添加<br/><br/>&lt;meta http-equiv=&#34;Pragma&#34; content=&#34;no-cache&#34;&gt;<br/>&lt;meta http-equiv=&#34;Cache-Control&#34; content=&#34;no-cache&#34;&gt;<br/>&lt;meta http-equiv=&#34;Expires&#34; content=&#34;0&#34;&gt;<br/>]]></description>
		</item>
		
			<item>
			<link>http://www.yongzi.com/article.asp?id=860</link>
			<title><![CDATA[用asp读取Javascri&#112;t 设定的 cookie 值]]></title>
			<author>1118221@qq.com(随然)</author>
			<category><![CDATA[程序代码]]></category>
			<pubDate>Sat,22 Apr 2017 23:25:01 +0800</pubDate>
			<guid>http://www.yongzi.com/default.asp?id=860</guid>
		<description><![CDATA[如果一个网站用到PHP和ASP两种代码，要共用 cookie 的话，其中一种方法可以在PHP文件中用Javascri&#112;t创建cookie 然后在asp文件中读取。<br/><br/>&lt;script language=&#34;Javascri&#112;t&#34;&gt;<br/><br/>function SetCookie(name,value){<br/>&nbsp;&nbsp;&nbsp;&nbsp;expires=new Date();<br/>&nbsp;&nbsp;&nbsp;&nbsp;expires.setTime(expires.getTime()+(86400*365));<br/>&nbsp;&nbsp;&nbsp;&nbsp;document.cookie=name+&#34;=&#34;+value+&#34;; expires=&#34;+expires.toGMTString()+&#34;; path=/&#34;;<br/>}<br/><br/>&lt;/script&gt;<br/><br/>上面SetCookie(&#34;person&#34;,&#34;id=xiao&amp;age=22&#34;);设置了person的两个属性<br/>上面就成功的将person对象写入了cookie,person 就是一个cookie字典了<br/><br/>asp读取&lt;%<br/>Response.Write Request.Cookies (&#34;person&#34;)(&#34;id&#34;)<br/>%&gt;<br/>这样就可取得:person的属性id了<br/><br/><br/>以上是网上查阅代码<br/><br/>以下是我自己简写的<br/>&lt;script language=&#34;Javascri&#112;t&#34;&gt;<br/>document.cookie=&#34;user=userid=&#34;+data.jobnumber+&#34;&amp;username=xiao; path=/&#34;;<br/>&lt;/script&gt;<br/><br/>asp读取&lt;%<br/>Response.Write Request.Cookies (&#34;user&#34;)(&#34;userid&#34;)<br/>%&gt;<br/><br/>以下是Javascri&#112;t读取cookie 值的代码<br/>获取指定名称的cookie值：getCookie(name) <br/>该函数返回名称为name的cookie值，如果不存在则返回空。<br/><br/>&lt;script language=&#34;Javascri&#112;t&#34; type=&#34;text/javascri&#112;t&#34;&gt; <br/>&lt;!-- <br/>function getCookie(name){ <br/>var strCookie=document.cookie; <br/>var arrCookie=strCookie.split(&#34;; &#34;); <br/>for(var i=0;i&lt;arrCookie.length;i++){ <br/>var arr=arrCookie[i].split(&#34;=&#34;); <br/>if(arr[0]==name)return arr[1]; <br/>} <br/>return &#34;&#34;; <br/>} <br/>//--&gt; <br/>&lt;/script&gt; <br/><br/>]]></description>
		</item>
		
			<item>
			<link>http://www.yongzi.com/article.asp?id=765</link>
			<title><![CDATA[将ASP动态网页转换成和生成HTML静态页面的方法]]></title>
			<author>1118221@qq.com(随然)</author>
			<category><![CDATA[程序代码]]></category>
			<pubDate>Sun,24 Apr 2011 17:31:03 +0800</pubDate>
			<guid>http://www.yongzi.com/default.asp?id=765</guid>
		<description><![CDATA[代码适用范围：网站的某个或者某些页面访问量比较大，经常读取数据库，给服务器增加负担，访问速度也比较慢。如果该页面调用的数据库较多，但网站内容不经常更新，就可以直接将该页面生成HTML网页，等下次内容更新的时候，再生成一次。或者写一个代码，隔一段时间生成一次。<br/><br/>源代码：<br/><div class="UBBPanel codePanel"><div class="UBBTitle"><a onClick="copycode(code17057);" style="float:right;cursor: pointer;font-weight: normal; font-style: normal">复制内容到剪贴板</a><img src="http://www.yongzi.com/images/code.gif" style="margin:0px 2px -3px 0px;" alt="程序代码"/> 程序代码</div><div class="UBBContent" id=code17057>&lt;form method=&#34;post&#34; action=&#34;?&#34;&gt;<br/>&lt;div align=&#34;center&#34;&gt;<br/>&lt;input name=&#34;asp2html&#34; type=&#34;submit&#34; value=&#34;生成静态主页&#34;/&gt;<br/>&lt;/div&gt;<br/>&lt;/form&gt;<br/>&lt;%<br/>If request.Form(&#34;asp2html&#34;)&lt;&gt;&#34;&#34; Then<br/>%&gt;<br/><br/>&lt;%<br/>Function GetPage(url) <br/> &#39;获得文件内容<br/> dim Retrieval<br/> Set Retrieval = Cr&#101;ateObject(&#34;Microsoft.XMLHTTP&#34;) <br/> With Retrieval <br/>&nbsp;&nbsp;.Open &#34;Get&#34;, url, False &#39;, &#34;&#34;, &#34;&#34; <br/>&nbsp;&nbsp;.Send <br/>&nbsp;&nbsp;GetPage = BytesToBstr(.ResponseBody)<br/> End With <br/> Set Retrieval = Nothing <br/>End Function<br/><br/>Function BytesToBstr(body)<br/> dim objstream<br/> set objstream = Server.Cr&#101;ateObject(&#34;adodb.stream&#34;)<br/> objstream.Type = 1<br/> objstream.Mode =3<br/> objstream.Open<br/> objstream.Write body<br/> objstream.Position = 0<br/> objstream.Type = 2<br/> objstream.Charset = &#34;GB2312&#34;<br/> BytesToBstr = objstream.ReadText<br/> objstream.Close<br/> set objstream = nothing<br/>End Function<br/><br/>on error resume next<br/>Url=&#34;<a href="http://www.xxx.com/index.asp" target="_blank" rel="external">http://www.xxx.com/index.asp</a>&#34; &#39;要读取的页面地址<br/>response.write &#34;开始更新首页...&lt;BR&gt;&#34;<br/>wstr = GetPage(Url)<br/><br/>&#39;response.write(wstr)<br/>Set fs=Server.Cr&#101;ateObject(&#34;Scripting.FileSystemObject&#34;)<br/><br/>&#39;if not MyFile.FolderExists(server.MapPath(&#34;/html/&#34;)) then <br/>&#39;MyFile.Cr&#101;ateFolder(server.MapPath(&#34;/html/&#34;))&#39;<br/>&#39;end if<br/><br/>&#39;要存放的页面地址<br/>dizhi=server.MapPath(&#34;index.htm&#34;)<br/>If (fs.FileExists(dizhi)) Then<br/>fs.Del&#101;teFile(dizhi)<br/>End If<br/><br/>Set CrFi=fs.Cr&#101;ateTextFile(dizhi)<br/>Crfi.Writeline(wstr)<br/>set CrFi=nothing<br/>set fs=nothing<br/>response.write &#34;...&lt;font color=red&gt;更新完成！&lt;/font&gt;&#34;<br/>%&gt;<br/><br/>&lt;%<br/>End If<br/>%&gt;</div></div><br/>直接保存成一个asp文件，上传到网站运行即可。注意，需要把URL(要转化的asp地址)和dizhi(要保存的html地址)设置好，一般这两个文件在同一个目录，才能保证图片或者css、js起作用。<br/>]]></description>
		</item>
		
			<item>
			<link>http://www.yongzi.com/article.asp?id=758</link>
			<title><![CDATA[利用ASP代码编写的404错误页实现所有网址精确转向功能]]></title>
			<author>1118221@qq.com(随然)</author>
			<category><![CDATA[程序代码]]></category>
			<pubDate>Fri,08 Apr 2011 21:45:21 +0800</pubDate>
			<guid>http://www.yongzi.com/default.asp?id=758</guid>
		<description><![CDATA[需要实现的功能：<br/>例如：<br/>用户访问 <a href="http://www.blueidc.cn/test.htm" target="_blank" rel="external">http://www.blueidc.cn/test.htm</a>&nbsp;&nbsp; <br/>自动转向为 <a href="http://www.sunrc.com/test.htm" target="_blank" rel="external">http://www.sunrc.com/test.htm</a><br/><br/>首先说说自定义404页面的方法。打开本机IIS网站，查看属性，自定义错误，找到404错误，双击修改其消息类型为 URL (消息类型不能为“文件”，否则不能转向)，Url设置为网站根目录下文件。比如我希望自定义错误页面为网站中根目录下的404.asp这个文件，则设置URL为 /404.asp ，注意前面的斜杠。设置完成之后，当请求的文件不存在时，IIS会调用我们指定的脚本实现转向所有页面功能。<br/><br/>下面的代码是 404.asp 文件的代码，使用的时候只需要修改代码里面的域名就可以了。<br/><br/><div class="UBBPanel codePanel"><div class="UBBTitle"><a onClick="copycode(code69750);" style="float:right;cursor: pointer;font-weight: normal; font-style: normal">复制内容到剪贴板</a><img src="http://www.yongzi.com/images/code.gif" style="margin:0px 2px -3px 0px;" alt="程序代码"/> 程序代码</div><div class="UBBContent" id=code69750>&lt;%<br/>Response.Status = &#34;404 Not Found&#34;<br/><br/>Function GetUserCurURL()<br/>&nbsp;&nbsp;&nbsp;&nbsp;If Request.ServerVariables(&#34;HTTPS&#34;) = &#34;on&#34; Then<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;GetUserCurURL = &#34;<a href="https://" target="_blank" rel="external">https://</a>&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;Else<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;GetUserCurURL = &#34;<a href="http://" target="_blank" rel="external">http://</a>&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;End If<br/>&nbsp;&nbsp;&nbsp;&nbsp;GetUserCurURL = GetUserCurURL &amp; Request.ServerVariables(&#34;SERVER_NAME&#34;)<br/>&nbsp;&nbsp;&nbsp;&nbsp;If (Request.ServerVariables(&#34;SERVER_PORT&#34;) &lt;&gt; 80) Then GetUserCurURL = GetUserCurURL &amp; &#34;:&#34; &amp; Request.ServerVariables(&#34;SERVER_PORT&#34;)<br/>&nbsp;&nbsp;&nbsp;&nbsp;GetUserCurURL = GetUserCurURL &amp; Request.ServerVariables(&#34;URL&#34;)<br/>&nbsp;&nbsp;&nbsp;&nbsp;If (Request.QueryString &lt;&gt; &#34;&#34;) Then GetUserCurURL = GetUserCurURL &amp; &#34;?&#34; &amp; Request.QueryString<br/>End Function<br/><br/>thecururl=Request.ServerVariables(&#34;http_host&#34;)<br/><br/>if thecururl=&#34;www.blueidc.cn&#34; o&#114; thecururl=&#34;blueidc.cn&#34; then<br/>&nbsp;&nbsp; redirecturl=Replace(GetUserCurURL(),&#34;blueidc.cn&#34;,&#34;sunrc.com&#34;)<br/>&nbsp;&nbsp; redirecturl=Replace(redirecturl,&#34;404.asp?404;<a href="http://" target="_blank" rel="external">http://</a>sunrc.com:80/&#34;,&#34;&#34;)<br/>&nbsp;&nbsp; redirecturl=Replace(redirecturl,&#34;404.asp?404;<a href="http://" target="_blank" rel="external">http://</a>www.sunrc.com:80/&#34;,&#34;&#34;)<br/>&nbsp;&nbsp; response.redirect redirecturl<br/>end if<br/>%&gt;</div></div><br/><br/>正确定义 404 错误页面：<br/>一、 对于已经存在的信息由于路径改变而导致访问不了时，应该在IIS 中定义404 错误指向一个动态页面，在页面里面使用301 跳转到新的地址，此时服务器返回301 状态码。<br/><br/>二、当访问一个错误的链接时，将调用404 页面，但由于在IIS 里面设置的不同将导致返回不同的状态码：<br/>1. 404 指向的是一个htm 文件，此时页面返回的404 状态码，这是正确的。<br/>2. 404 指向的是一个URL，例如 /error.asp，如果不在页面里面进行设置，仅仅是返回提示的HTML 代码，将导致页面返回200 状态码，此时的危害在于，当很多页面找不到时，都返回和访问正常页面时返回一样的200 状态码，将使搜索引擎认为该链接存在，并以错误页面的内容进行收录，当这样的链接很多时，将导致大量页面重复，使网站排名降低。处理方法：在显示完提示内容后，增加语句： Response.Status=&#34;404 Not Found&#34; ，这样就保证页面返回404 状态码。<br/>3. 避免在调用 404 页面的时候返回302 状态码，容易被搜索引擎认为是重定向作弊。<br/><br/>404页面详细介绍地址：<a href="http://baike.baidu.com/view/1402912.htm" target="_blank" rel="external">http://baike.baidu.com/view/1402912.htm</a>]]></description>
		</item>
		
			<item>
			<link>http://www.yongzi.com/article.asp?id=741</link>
			<title><![CDATA[ASP网站判断手机访问网站自动跳转的代码参考示例]]></title>
			<author>1118221@qq.com(随然)</author>
			<category><![CDATA[程序代码]]></category>
			<pubDate>Wed,11 Aug 2010 23:42:23 +0800</pubDate>
			<guid>http://www.yongzi.com/default.asp?id=741</guid>
		<description><![CDATA[手机访问网站，自动判断是否为手机访问进行相关跳转。asp网站可用如下代码：<br/><br/><div class="UBBPanel codePanel"><div class="UBBTitle"><a onClick="copycode(code94608);" style="float:right;cursor: pointer;font-weight: normal; font-style: normal">复制内容到剪贴板</a><img src="http://www.yongzi.com/images/code.gif" style="margin:0px 2px -3px 0px;" alt="程序代码"/> 程序代码</div><div class="UBBContent" id=code94608>if InStr(LCase(Request.ServerVariables(&#34;HTTP_ACCEPT&#34;)),&#34;text/vnd.wap.wml&#34;)&gt;0 then<br/>&nbsp;&nbsp;&nbsp;&nbsp;response.redirect&nbsp;&nbsp;&#34;wap.asp&#34; &#39;如果是手机访问则跳转到wap.asp<br/>&nbsp;&nbsp;&nbsp;&nbsp;response.end<br/>else<br/>&nbsp;&nbsp;&nbsp;&nbsp;response.redirect&nbsp;&nbsp;&#34;default.asp&#34; &#39;如果电脑访问跳转到首页<br/>&nbsp;&nbsp;&nbsp;&nbsp;response.end <br/>end if</div></div><br/><br/>本站使用ASP的<a href="http://www.pjhome.net" target="_blank">pj</a>blog程序，头部添加代码如下：<br/><div class="UBBPanel codePanel"><div class="UBBTitle"><a onClick="copycode(code34128);" style="float:right;cursor: pointer;font-weight: normal; font-style: normal">复制内容到剪贴板</a><img src="http://www.yongzi.com/images/code.gif" style="margin:0px 2px -3px 0px;" alt="程序代码"/> 程序代码</div><div class="UBBContent" id=code34128>&lt;%If InStr(LCase(Request.ServerVariables(&#34;HTTP_ACCEPT&#34;)),&#34;text/vnd.wap.wml&#34;) &gt; 0 Then Response.Redirect &#34;wap.asp&#34;%&gt;</div></div>]]></description>
		</item>
		
			<item>
			<link>http://www.yongzi.com/article.asp?id=724</link>
			<title><![CDATA[ASP版HTML新闻内容自动分页程序]]></title>
			<author>1118221@qq.com(随然)</author>
			<category><![CDATA[程序代码]]></category>
			<pubDate>Sat,05 Jun 2010 18:01:19 +0800</pubDate>
			<guid>http://www.yongzi.com/default.asp?id=724</guid>
		<description><![CDATA[ASP版HTML新闻内容自动分页程序<br/><div class="UBBPanel codePanel"><div class="UBBTitle"><a onClick="copycode(code95239);" style="float:right;cursor: pointer;font-weight: normal; font-style: normal">复制内容到剪贴板</a><img src="http://www.yongzi.com/images/code.gif" style="margin:0px 2px -3px 0px;" alt="程序代码"/> 程序代码</div><div class="UBBContent" id=code95239>&lt;%<br/>&#39;==================================================================<br/>&#39;程序说明：用于自动生成新闻静态页，手动添加分页功能，自动生成页码<br/>&#39;<br/>&#39;程序作者：Www.Leadbbs.Com 简体中文版 QQ: 7275244<br/>&#39;<br/>&#39;程序用途：演示用，CopyLeft :p<br/>&#39;<br/>&#39;时间：2005年9月28日<br/>&#39;<br/>&#39;使用方法：绝对路径下建立info目录，建立Template.Html文件，<br/>&#39;===================================================================<br/>if Request.ServerVariables(&#34;REQUEST_METHOD&#34;) = &#34;POST&#34; then<br/>Dim Fso &#39;FileSystemObject<br/>Dim Mp &#39;存放MapPath<br/>Dim ObjStream &#39;ObjStream<br/>Dim ObjHtml &#39;ObjHtml建立文件<br/>Dim FileName &#39;文件名<br/>Dim CountPage &#39;计算内容中的页数<br/>Dim ContentTemp &#39;内容临时变量<br/>Dim i &#39;临时计数变量<br/>Dim NewsContent &#39;存储新闻内容变量<br/>Dim NowPage &#39;存放当前页数变量<br/>Dim NewsPage &#39;存储分页信息<br/>FileName = &#34;Test&#34;<br/>NewsContent = &#34;&#34;<br/>NewsPage = &#34;&#34;<br/>Content = Request(&#34;Content&#34;)<br/>&#39;写入数据库<br/>&#39;Ins&#101;rt Into Article<br/>&#39;按照标记分页程式<br/>ContentTemp = Split(Content,&#34;$分页符$&#34;)<br/>CountPage = Ubound(ContentTemp)<br/>if CountPage = -1 then<br/>Response.Write(&#34;错误：没有输入新闻内容！&#34;)<br/>Response.End()<br/>End if<br/>&#39;==============<br/>&#39;输出检测信息<br/>&#39;==============<br/>&#39;Response.Write(&#34;共有页数:&#34; &amp; CountPage+1)<br/>&#39;Response.Write(&#34;每页显示信息为：&lt;br&gt;&#34;)<br/>&#39;For i = 0 to CountPage<br/>&#39;Response.Write(&#34;第&#34; &amp; i + 1 &amp; &#34;页:&#34; &amp; ContentTemp(i) &amp; &#34;&lt;br&gt;&#34;)<br/>&#39;Next<br/>&#39;==============<br/>&#39;检测输出结束<br/>&#39;==============<br/>&#39;开始生成HTML页<br/>Set Fso = Cr&#101;ateObject(&#34;Scripting.FileSystemObject&#34;)<br/>For i = 0 to CountPage<br/>&#39;==================<br/>&#39;判断页数，成生页码<br/>&#39;==================<br/>if CountPage &gt; 0 then &#39;不是单页新闻，需要显示分页信息<br/>if i = 0 then<br/>NowPage = 1 &#39;当前页<br/>NewsPage = GetPageCount(NowPage,CountPage+1,FileName)<br/>else<br/>NowPage = i + 1<br/>NewsPage = GetPageCount(NowPage,CountPage+1,FileName)<br/>FileName = FileName &amp; &#34;_&#34; &amp; NowPage<br/>end if<br/>end if<br/>&#39;==================<br/>&#39;生成页码结束<br/>&#39;==================<br/>Mp = Server.MapPath(&#34;/Template.Html&#34;)<br/>Set ObjStream = Fso.OpenTextFile(Mp,1,-2)<br/>while not ObjStream.AtEndOfStream<br/>NewsContent= NewsContent &amp; ObjStream.ReadLine &amp; vbcrlf &#39;读出文件内容<br/>wend<br/>&#39;Response.Write(&#34;文件：&#34; &amp; FileName &amp; &#34;.Html 第&#34; &amp; i + 1 &amp; &#34;次写入值为：&#34; &amp; ContentTemp(i) &amp; &#34;&lt;br&gt;&#34;)<br/>NewsContent=Replace(NewsContent,&#34;{Content}&#34;,ContentTemp(i))<br/>NewsContent=Replace(NewsContent,&#34;{NewsPage}&#34;,NewsPage)<br/>Dir = Server.MapPath(&#34;/info&#34;) &amp; &#34;\&#34;<br/>Set ObjHtml = Fso.Cr&#101;ateTextFile(Dir &amp; &#34;/&#34; &amp; FileName &amp; &#34;.Html&#34;)<br/>ObjHtml.WriteLine NewsContent<br/>NewsContent = &#34;&#34; &#39;复原新闻内容变量<br/>FileName = Left(FileName,4) &#39;复原原文件名称<br/>Next<br/>Set Fso = Nothing<br/>Response.Redirect(Request.ServerVariables(&#34;HTTP_REFERER&#34;))<br/>End if<br/><br/>Function GetPageCount(NowPage,CountPage,FileName) &#39;自动生成页码<br/>&#39;==========显示结果============<br/>&#39;上一页 1 2 3 下一页<br/>&#39;上一页 ... 4 5 6 下一页<br/>&#39;上一页 1 2 3 ... 下一页<br/>&#39;上一页 ... 4 5 6 ... 下一页<br/>&#39;==============================<br/>Dim ShowPageNum &#39;定义显示页码数量<br/>Dim PageUp &#39;上页<br/>Dim PageDown &#39;下页<br/>Dim i &#39;循环变量<br/>ShowPageNum = 7 &#39;最好是单数，好看一些 ... 11 12 13 &lt;14&gt; 15 16 17 ...<br/>PageUp = &#34;&#34;<br/>PageDown = &#34;&#34;<br/>if NowPage=1 then<br/>GetPageCount = GetPageCount &amp; &#34;&lt;a href=&#34;&#34;&#34; &amp; FileName &amp; &#34;.html&#34;&#34;&gt;&lt;font color=&#34;&#34;#ff0000&#34;&#34;&gt;&lt;b&gt;1&lt;/b&gt;&lt;/font&gt;&lt;/a&gt; &#34;<br/>else<br/>GetPageCount = GetPageCount &amp; &#34;&lt;a href=&#34;&#34;&#34; &amp; FileName &amp; &#34;.html&#34;&#34;&gt;1&lt;/a&gt; &#34;<br/>end if<br/><br/>if CountPage &lt;= ShowPageNum then<br/>For i = 2 to CountPage<br/>GetPageCount = GetPageCount &amp; &#34;&lt;a href=&#34;&#34;&#34; &amp; FileName &amp; &#34;_&#34; &amp; i &amp; &#34;.html&#34;&#34;&gt;&#34; &amp; GetColor(i,NowPage) &amp; &#34;&lt;/a&gt; &#34;<br/>Next<br/>else &#39;页数大于自定义的显示页码数量<br/>if (NowPage - 3) &gt; 1 and (NowPage + 3) &lt; CountPage then<br/>GetPageCount = &#34;... &#34;<br/>For i = NowPage - 3 to NowPage + 3<br/>GetPageCount = GetPageCount &amp; &#34;&lt;a href=&#34;&#34;&#34; &amp; FileName &amp; &#34;_&#34; &amp; i &amp; &#34;.html&#34;&#34;&gt;&#34; &amp; GetColor(i,NowPage) &amp; &#34;&lt;/a&gt; &#34;<br/>Next<br/>GetPageCount = GetPageCount &amp; &#34;...&#34;<br/>else<br/>if (NowPage - 3) &gt; 1 and (NowPage + 3) =&gt; CountPage then<br/>GetPageCount = &#34;... &#34;<br/>For i = CountPage - ShowPageNum to CountPage<br/>GetPageCount = GetPageCount &amp; &#34;&lt;a href=&#34;&#34;&#34; &amp; FileName &amp; &#34;_&#34; &amp; i &amp; &#34;.html&#34;&#34;&gt;&#34; &amp; GetColor(i,NowPage) &amp; &#34;&lt;/a&gt; &#34;<br/>Next<br/>else<br/>For i = 2 to ShowPageNum<br/>GetPageCount = GetPageCount &amp; &#34;&lt;a href=&#34;&#34;&#34; &amp; FileName &amp; &#34;_&#34; &amp; i &amp; &#34;.html&#34;&#34;&gt;&#34; &amp; GetColor(i,NowPage) &amp; &#34;&lt;/a&gt; &#34;<br/>Next<br/>GetPageCount = GetPageCount &amp; &#34;...&#34;<br/>end if<br/>end if<br/>End if<br/>&#39;加首头页尾<br/>if NowPage &gt; 1 then<br/>if NowPage &gt; 2 then<br/>PageUp = &#34;&lt;a href=&#34;&#34;&#34; &amp; FileName &amp; &#34;_&#34; &amp; NowPage - 1 &amp; &#34;.html&#34;&#34;&gt;上页&lt;/a&gt; &#34;<br/>else<br/>PageUp = &#34;&lt;a href=&#34;&#34;&#34; &amp; FileName &amp; &#34;.html&#34;&#34;&gt;上页&lt;/a&gt; &#34;<br/>end if<br/>end if<br/>if NowPage &lt; CountPage then<br/>PageDown = &#34;&lt;a href=&#34;&#34;&#34; &amp; FileName &amp; &#34;_&#34; &amp; NowPage + 1 &amp; &#34;.html&#34;&#34;&gt;下页&lt;/a&gt; &#34;<br/>End if<br/>GetPageCount = &#34;&lt;a href=&#34;&#34;&#34; &amp; FileName &amp; &#34;.html&#34;&#34;&gt;首页&lt;/a&gt; &#34; &amp; PageUp &amp; GetPageCount &amp; PageDown &amp; &#34;&lt;a href=&#34;&#34;&#34; &amp; FileName &amp; &#34;_&#34; &amp; CountPage &amp; &#34;.html&#34;&#34;&gt;末页&lt;/a&gt;&#34;<br/>End Function<br/><br/>Function GetColor(i,NowPage) &#39;当前页标志色<br/>if i = NowPage then<br/>GetColor = &#34;&lt;font color=&#34;&#34;#ff0000&#34;&#34;&gt;&lt;b&gt;&#34; &amp; NowPage &amp; &#34;&lt;/b&gt;&lt;/font&gt;&#34;<br/>else<br/>GetColor = i<br/>end if<br/>End Function<br/>%&gt;</div></div><br/>&lt;form name=&#34;form1&#34; method=&#34;post&#34; action=&#34;1.asp&#34;&gt;<br/>&lt;textarea name=&#34;Content&#34; cols=&#34;100&#34; rows=&#34;8&#34;&gt;&lt;/textarea&gt;<br/>&lt;input type=&#34;button&#34; name=&#34;Submit&#34; value=&#34;插入分页&#34; onClick=&#34;form1.Content.value+=&#39;$分页符$&#39;;form1.Content.focus();&#34;&gt;<br/>&lt;input type=&#34;submit&#34; name=&#34;Submit&#34; value=&#34;提交&#34;&gt;<br/>&lt;/form&gt;]]></description>
		</item>
		
			<item>
			<link>http://www.yongzi.com/article.asp?id=621</link>
			<title><![CDATA[用ASP获取指定范围内的一组不重复的随机整数]]></title>
			<author>1118221@qq.com(随然)</author>
			<category><![CDATA[程序代码]]></category>
			<pubDate>Sat,04 Jul 2009 21:35:23 +0800</pubDate>
			<guid>http://www.yongzi.com/default.asp?id=621</guid>
		<description><![CDATA[该ASP函数可以获取指定范围内的一组不重复的随机整数，具体调用方法请查看说明。<br/><div class="UBBPanel codePanel"><div class="UBBTitle"><a onClick="copycode(code88611);" style="float:right;cursor: pointer;font-weight: normal; font-style: normal">复制内容到剪贴板</a><img src="http://www.yongzi.com/images/code.gif" style="margin:0px 2px -3px 0px;" alt="程序代码"/> 程序代码</div><div class="UBBContent" id=code88611>&lt;%<br/>&#39;调用方法：<br/>&#39;获取10个1到100之间的整数<br/>Response.Write GetrndNumber(1,100,10)<br/><br/>Function GetrndNumber(intStart,intEnd,intCount)<br/>&nbsp;&nbsp;&nbsp;&nbsp; Rem 取指定范围内不同的随机整数<br/>&nbsp;&nbsp;&nbsp;&nbsp; Rem intStart:起始值<br/>&nbsp;&nbsp;&nbsp;&nbsp; Rem intEnd:结束值<br/>&nbsp;&nbsp;&nbsp;&nbsp; Rem intCount:值个数<br/>&nbsp;&nbsp;&nbsp;&nbsp; Rem no_mIss<br/>&nbsp;&nbsp;&nbsp;&nbsp; Rem 调用:GetrndNumber(1,9,5)<br/>&nbsp;&nbsp;&nbsp;&nbsp; On error resume next<br/>&nbsp;&nbsp;&nbsp;&nbsp; Dim i,reValue,strreValue<br/>&nbsp;&nbsp;&nbsp;&nbsp; reValue = &#34;&#34; : strreValue = &#34;,&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp; If Not isNumeric(intStart) o&#114; Not isNumeric(intEnd) _<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; o&#114; Not isNumeric(intCount)&nbsp;&nbsp;Then Response.write &#34;参数错误!&#34; : Response.End<br/>&nbsp;&nbsp;&nbsp;&nbsp; If intCount&gt;(intEnd - intStart)+1 Then Response.write &#34;参数错误!&#34; : Response.End<br/>&nbsp;&nbsp;&nbsp;&nbsp; randomize<br/>&nbsp;&nbsp;&nbsp;&nbsp; For i = 0 to intCount - 1<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; reValue = Int((intEnd - intStart + 1) * Rnd + intStart)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If instr(strreValue,&#34;,&#34; &amp; reValue &amp; &#34;,&#34;)&gt;0 Then<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; i = i - 1<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Else<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; strreValue = strreValue &amp; reValue &amp; &#34;,&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; End If<br/>&nbsp;&nbsp;&nbsp;&nbsp; Next<br/>&nbsp;&nbsp;&nbsp;&nbsp; strreValue = left(strreValue,len(strreValue) - 1)<br/>&nbsp;&nbsp;&nbsp;&nbsp; strreValue = Replace(strreValue,&#34;,&#34;,&#34;&#34;,1,1)<br/>&nbsp;&nbsp;&nbsp;&nbsp; GetrndNumber = strreValue<br/>End Function<br/>%&gt;</div></div><br/><br/>获取随机数以后，如果还需要从小到大或者从大到小排序，你可以参阅本站另外一篇关于排序的函数的文章<br/>常用的几种asp排序方法介绍 <a target="_blank" href="http://yty.cc/article.asp?id=522" rel="external">http://yty.cc/article.asp?id=522</a><br/><br/>这里我也提供和上面函数相关的排序例子：<br/><div class="UBBPanel codePanel"><div class="UBBTitle"><a onClick="copycode(code15314);" style="float:right;cursor: pointer;font-weight: normal; font-style: normal">复制内容到剪贴板</a><img src="http://www.yongzi.com/images/code.gif" style="margin:0px 2px -3px 0px;" alt="程序代码"/> 程序代码</div><div class="UBBContent" id=code15314>&lt;%<br/>&#39;获取10个1到100之间的整数<br/>RndStr=GetrndNumber(1,100,10)&nbsp;&nbsp;&#39;这个函数在上面的例子中，你可以把上面的函数拷贝到这里来<br/>Response.Write RndStr<br/>Dim aData<br/>aData = split(RndStr,&#34;,&#34;)<br/>Call ResponseArray(QuickSort(aData),&#34;从小到大排序&#34;)<br/><br/>Function QuickSort(a_Data)<br/>&nbsp;&nbsp;&nbsp;&nbsp;Dim i, j<br/>&nbsp;&nbsp;&nbsp;&nbsp;Dim bound, t<br/>&nbsp;&nbsp;&nbsp;&nbsp;bound = UBound(a_Data)<br/><br/>&nbsp;&nbsp;&nbsp;&nbsp;For i = 0 To bound-1<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;For j = i+1 To bound<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;If Cint(a_Data(i)) &gt; Cint(a_Data(j)) Then &#39;这里的大于&gt;如果改成小于&lt; 则按照从大到小排序<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;t = a_Data(i)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;a_Data(i) = a_Data(j)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;a_Data(j) = t<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;End If<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Next<br/>&nbsp;&nbsp;&nbsp;&nbsp;Next<br/><br/>&nbsp;&nbsp;&nbsp;&nbsp;QuickSort = a_Data<br/>End Function<br/><br/>&#39;输出数组<br/>Sub ResponseArray(a_Data, str)<br/>&nbsp;&nbsp;&nbsp;&nbsp;Dim s<br/>&nbsp;&nbsp;&nbsp;&nbsp;s = &#34;&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;Response.Write &#34;&lt;b&gt;&#34; &amp; str &amp; &#34;：&lt;/b&gt;&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;For i = 0 To UBound(a_Data)<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;s = s &amp; a_Data(i) &amp; &#34;,&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;Next<br/>&nbsp;&nbsp;&nbsp;&nbsp;s = Left(s, Len(s)-1)<br/>&nbsp;&nbsp;&nbsp;&nbsp;Response.Write s<br/>&nbsp;&nbsp;&nbsp;&nbsp;Response.Write &#34;&lt;hr&gt;&#34;<br/>End Sub<br/>%&gt;</div></div>]]></description>
		</item>
		
			<item>
			<link>http://www.yongzi.com/article.asp?id=620</link>
			<title><![CDATA[ASP实现access随机显示不重复记录解决方案]]></title>
			<author>1118221@qq.com(随然)</author>
			<category><![CDATA[程序代码]]></category>
			<pubDate>Sat,04 Jul 2009 17:31:26 +0800</pubDate>
			<guid>http://www.yongzi.com/default.asp?id=620</guid>
		<description><![CDATA[网上这方面的代码很多，随便搜索一下就可以看到很多不同的代码。<br/>我这里列举几种我比较喜欢的方法。<br/>方案一：比较简洁的方式<br/><div class="UBBPanel codePanel"><div class="UBBTitle"><a onClick="copycode(code41436);" style="float:right;cursor: pointer;font-weight: normal; font-style: normal">复制内容到剪贴板</a><img src="http://www.yongzi.com/images/code.gif" style="margin:0px 2px -3px 0px;" alt="程序代码"/> 程序代码</div><div class="UBBContent" id=code41436>Randomize<br/>dim i,DispRecord<br/>i=0<br/>DispRecord=10 &#39;设置显示的随机记录数量<br/><br/>sql=&#34;sel&#101;ct id,caption from table&#34;<br/>set rs=server.Cr&#101;ateObject(&#34;adodb.recordset&#34;)<br/>rs.open sql,conn,1,3<br/><br/>lngCount = rs.RecordCount<br/>redim idList(lngCount)<br/>while i&lt;DispRecord<br/><br/>&nbsp;&nbsp;&nbsp;&nbsp; lngRnd = Int((lngCount * Rnd) + 1)<br/>&nbsp;&nbsp;&nbsp;&nbsp; rs.AbsolutePosition = lngRnd<br/>&nbsp;&nbsp;&nbsp;&nbsp; if isEmpty(idList(lngRnd)) then &#39;如果第lngRnd条记录在数组中为空，则显示该条记录<br/><br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;response.write rs(0)&amp;&#34;&lt;Br&gt;&#34;&nbsp;&nbsp; &#39;你可以自己设定需要输出的内容<br/><br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;idList(lngRnd)=1&nbsp;&nbsp;&nbsp;&nbsp; &#39;第lngRnd条记录已经显示，把他在数组中的值设定为1，下次就不再显示<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;i=i+1<br/>&nbsp;&nbsp;&nbsp;&nbsp; end if<br/><br/>wend<br/>rs.close<br/>set rs=nothing<br/>Erase idList</div></div><br/><br/>方案二：可以生成指定范围内不重复的随机记录<br/><div class="UBBPanel codePanel"><div class="UBBTitle"><a onClick="copycode(code8324);" style="float:right;cursor: pointer;font-weight: normal; font-style: normal">复制内容到剪贴板</a><img src="http://www.yongzi.com/images/code.gif" style="margin:0px 2px -3px 0px;" alt="程序代码"/> 程序代码</div><div class="UBBContent" id=code8324>&lt;%<br/>Dim objConn, objRs, db, strSQL<br/>Dim totalCount, rndArray, rsOutputMax, intI<br/>&#39;-----------------<br/>&#39;|连接数据库|<br/>&#39;-----------------<br/>db = &#34;db/dbname.mdb&#34;<br/>strSQL = &#34;Sel&#101;ct id,name FROM table_name&#34;<br/>Set objConn = Server.Cr&#101;ateObject(&#34;ADODB.Connection&#34;)<br/>objConn.Open &#34;provider=Microsoft.Jet.OLEDB.4.0;Data Source=&#34; &amp; Server.MapPath(db)<br/>Set objRs = Server.Cr&#101;ateObject(&#34;ADODB.Recordset&#34;)<br/>objRs.Open strSQL, objConn, 1, 3<br/>&#39;--------------<br/>&#39;|读取数据|<br/>&#39;--------------<br/>totalCount = objRs.RecordCount &#39;生成随机数范围的上限<br/>rsOutputMax = 10 &#39;输出记录条数<br/>rndArray = myRnd(rsOutputMax,totalCount,1)<br/>Response.Write &#34;&nbsp;&nbsp;id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;name&#34;<br/>Response.Write &#34;------------------&#34;<br/>For intI = 1 To rsOutputMax<br/>&nbsp;&nbsp;objRs.AbsolutePosition = rndArray(intI)<br/>&nbsp;&nbsp;Response.Write &#34;&nbsp;&nbsp;&#34; &amp; objRs(&#34;id&#34;) &amp; &#34;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#34; &amp; objRs(&#34;name&#34;) &amp; &#34;&lt;br&gt;&#34;<br/>Next<br/>&#39;--------------<br/>&#39;|清理资源|<br/>&#39;--------------<br/>Set objRs = Nothing<br/>objConn.Close<br/>Set objConn = Nothing<br/>&#39;--------------------------------------------------<br/>&#39;|生成指定范围内不重复随机数的函数|<br/>&#39;|nMax:输出随机数的个数&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|<br/>&#39;|upper:指定范围上限&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br/>&#39;|lower:指定范围下限&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |<br/>&#39;--------------------------------------------------<br/>Function myRnd(nMax,upper,lower)<br/>&nbsp;&nbsp;Dim a(), i, j, k, reCount<br/>&nbsp;&nbsp;ReDim a(nMax)<br/>&nbsp;&nbsp;Randomize Timer<br/>&nbsp;&nbsp;For i = 1 To nMax<br/>&nbsp;&nbsp;&nbsp;&nbsp;reCount = False<br/>&nbsp;&nbsp;&nbsp;&nbsp;k = Int((upper - lower + 1) * Rnd + lower)<br/>&nbsp;&nbsp;&nbsp;&nbsp;For j = 1 To i - 1<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;If k = a(j) Then reCount = True : Exit For<br/>&nbsp;&nbsp;&nbsp;&nbsp;Next<br/>&nbsp;&nbsp;&nbsp;&nbsp;If reCount = True Then<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;i = i - 1<br/>&nbsp;&nbsp;&nbsp;&nbsp;Else<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;a(i) = k<br/>&nbsp;&nbsp;&nbsp;&nbsp;End If<br/>&nbsp;&nbsp;Next<br/>&nbsp;&nbsp;myRnd = a<br/>End Function<br/>%&gt;</div></div><br/><br/>方案三：和上面连个代码大同小异，只是实现方式不一样<br/><div class="UBBPanel codePanel"><div class="UBBTitle"><a onClick="copycode(code7660);" style="float:right;cursor: pointer;font-weight: normal; font-style: normal">复制内容到剪贴板</a><img src="http://www.yongzi.com/images/code.gif" style="margin:0px 2px -3px 0px;" alt="程序代码"/> 程序代码</div><div class="UBBContent" id=code7660>&lt;%<br/>&#39;连接数据库代码略<br/>DIM sql,rs<br/>sql=&#34;sel&#101;ct top 100 * from table o&#114;der by rnd(id)&#34;<br/>Set rs=server.Cr&#101;ateObject(&#34;adodb.recordset&#34;)<br/>rs.open sql,conn,1,1<br/>DIM Appeared<br/>Call DisRndRecord(10,rs.recordCount)&#39;调用函数该位置显示记录<br/>&#39;#DisRndRecord(DisNum,rsBound)<br/>&#39;#参数DisNum：显示数量<br/>&#39;#参数rsBound：随机数产生范围<br/>Sub DisRndRecord(DisNum,rsBound)<br/>DIM i,ThisRnd<br/>If rsBound&lt;DisNum Then DisNum=rsBound&#39;记录总数小于要抽取记录条数的情况<br/>For i=0 To DisNum-1<br/>ThisRnd=GetRnd(rsBound)&#39;取得一个不重复的随机数<br/>rs.Move(ThisRnd)&#39;游标移动到随机数位置数读取<br/>Response.Write &#34;&lt;br&gt;&#34;&amp;rs(&#34;id&#34;)<br/>rs.Move(-ThisRnd)<br/>Next<br/>End Sub<br/>&#39;# 函数GetRnd(bound)返回一个不重复的随机数字<br/>&#39;#参数bound：随机范围<br/>Function GetRnd(bound)<br/>DIM ranNum<br/>Randomize()<br/>ranNum=int(bound*rnd)<br/>If Instr(Appeared,&#34;[&#34;&amp;ranNum&amp;&#34;]&#34;) Then&#39;产生的随机数是否出现过<br/>ranNum=getRnd(bound)<br/>End If<br/>Appeared=Appeared&amp;&#34;[&#34;&amp;ranNum&amp;&#34;]&#34;&#39;记录已出现的随机数<br/>GetRnd=ranNum<br/>End Function<br/>rs.close<br/>Set rs=Nothing<br/>conn.close<br/>Set conn=Nothing<br/>%&gt;</div></div><br/><br/>方案四：网上很多朋友使用过的代码，个人还是推荐前三种代码<br/><div class="UBBPanel codePanel"><div class="UBBTitle"><a onClick="copycode(code83093);" style="float:right;cursor: pointer;font-weight: normal; font-style: normal">复制内容到剪贴板</a><img src="http://www.yongzi.com/images/code.gif" style="margin:0px 2px -3px 0px;" alt="程序代码"/> 程序代码</div><div class="UBBContent" id=code83093>&lt;%<br/>’-------------------------数据库连接-----------------------<br/>Set objConn = Server.Cr&#101;ateObject(&#34;ADODB.Connection&#34;)<br/>objConn.ConnectionString = &#34;Provider=Microsoft.Jet.OLEDB.4.0;&#34; &amp;_<br/>&#34;Data Source=&#34; &amp; Server.MapPath(&#34;data.mdb&#34;)<br/>objConn.Open<br/><br/>’-------------------------检索数据-----------------------<br/>strSQL = &#34;Sel&#101;ct id,DataColumn FROM DataTable&#34;&nbsp;&nbsp;&nbsp;&nbsp;’Sql语句，检索数据库<br/>Set objRS = Server.Cr&#101;ateObject(&#34;ADODB.Recordset&#34;)&nbsp;&nbsp;&nbsp;&nbsp;’创建记录集<br/>objRS.Open strSQL, objConn, 1, 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;’执行检索<br/>Count=objRS.RecordCount&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;’得到记录总数<br/>Item=4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ’需要显示的记录数<br/>’-------------------------检索数据完毕-----------------------<br/><br/>redim a(Item, 2),t(Count)&nbsp;&nbsp; ’定义2数组，数组a用来储存记录，数组t用来删选记录<br/><br/>’初始数组数值，目的为了插入数据以后和此值做比较<br/>for each j in t<br/>&nbsp;&nbsp;&nbsp;&nbsp;j=0<br/>next<br/><br/>’ 随机抽取记录号<br/>Randomize timer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;’初始化随机数生成器 <br/>for j=1 to Item<br/>&nbsp;&nbsp;&nbsp;&nbsp;k=int(rnd*Count+1)&nbsp;&nbsp;&nbsp;&nbsp;’从总数里面随机取一条记录<br/>&nbsp;&nbsp;&nbsp;&nbsp;do while t(k)&lt;&gt;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;’判断是否记录是否已在数组中<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;k=int(rnd*Item+1)<br/>&nbsp;&nbsp;&nbsp;&nbsp;loop<br/>&nbsp;&nbsp;&nbsp;&nbsp;t(k)=1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;’第k条记录被选中，设置为1，下次将不再选中<br/>next<br/>’--------------------------------------<br/>j=1:i=1’定义下标<br/><br/>’ 循环选取数据集objRS中的部分记录存放到数组中<br/>Do While Not objRS.Eof<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if t(j)=1 then<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;a(i,1)=objRS(&#34;id&#34;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;’记录id<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;a(i,2)=objRS(&#34;DataColumn&#34;)&nbsp;&nbsp;&nbsp;&nbsp; ’记录内容<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;i=i+1<br/>&nbsp;&nbsp;&nbsp;&nbsp; end if<br/>j=j+1<br/>objRS.MoveNext <br/>Loop<br/><br/>’----------------------------显示内容--------------------<br/>for i=1 to Item<br/>&nbsp;&nbsp;&nbsp;&nbsp;Response.write &#34;序号&#34;&amp;a(i,1)&amp;&#34;&lt;br&gt;&#34;<br/>&nbsp;&nbsp;&nbsp;&nbsp;Response.write &#34;内容&#34;&amp;a(i,2)&amp;&#34;&lt;p&gt;&#34;<br/>next<br/>’----------------------------显示内容完毕--------------------<br/><br/>’释放资源<br/>objRs.Close<br/>set objRs=nothing<br/>objConn.Close<br/>set objConn=nothing<br/>%&gt;</div></div>]]></description>
		</item>
		
			<item>
			<link>http://www.yongzi.com/article.asp?id=561</link>
			<title><![CDATA[HTML转换成UBB代码的JAVASCRIPT和ASP函数程序]]></title>
			<author>1118221@qq.com(随然)</author>
			<category><![CDATA[程序代码]]></category>
			<pubDate>Sun,05 Apr 2009 20:37:38 +0800</pubDate>
			<guid>http://www.yongzi.com/default.asp?id=561</guid>
		<description><![CDATA[在做网站的过程中，经常会遇到把UBB代码的文字内容转换成HTML代码显示出来，有的时候也会把HTML代码转换成UBB代码。比如在使用ASP+WML制作WAP网站的过程中，就遇到了这个问题。<br/>文字内容包含有&lt;table&gt;&lt;tr&gt;&lt;td&gt;等HTML的代码，手机浏览时无法正常在WML页面中显示出来，所以就可以把这些HTML代码标签转换成UBB代码，然后再转换成简单的WML支持的HTML代码显示出来。<br/>下面提供两种代码供大家选择：<br/>第一种：JAVASCRIPT代码<br/><div class="UBBPanel"><div class="UBBTitle"><img src="http://www.yongzi.com/images/html.gif" style="margin:0px 2px -3px 0px"> HTML代码</div><div class="UBBContent"><TEXTAREA rows="8" id="temp37322"><script Language=&#34;JavaScript1.2&#34;>
//coded by windy_sk <windy_sk@126.com> 20031218

function html_trans(str) {
	str = str.replace(/\r/g,&#34;&#34;);
	str = str.replace(/on(load|click|dbclick|mouseover|mousedown|mouseup)=&#34;[^&#34;]+&#34;/ig,&#34;&#34;);
	str = str.replace(/<script[^>]*?>([\w\W]*?)<\/script>/ig,&#34;&#34;);
	
	str = str.replace(/<a[^>]+href=&#34;([^&#34;]+)&#34;[^>]*>(.*?)<\/a>/ig,&#34;\n<a target="_blank" href="http://www.yongzi.com/$1" rel="external">$2</a>\n&#34;);
	
	str = str.replace(/<font[^>]+color=([^ >]+)[^>]*>(.*?)<\/font>/ig,&#34;\n[color=$1]$2[/color]\n&#34;);
	
	str = str.replace(/<img[^>]+src=&#34;([^&#34;]+)&#34;[^>]*>/ig,&#34;\n<img src="http://www.yongzi.com/$1" border="0" alt=""/>\n&#34;);
	
	str = str.replace(/<([\/]?)b>/ig,&#34;[$1b]&#34;);
	str = str.replace(/<([\/]?)strong>/ig,&#34;[$1b]&#34;);
	str = str.replace(/<([\/]?)u>/ig,&#34;[$1u]&#34;);
	str = str.replace(/<([\/]?)i>/ig,&#34;[$1i]&#34;);
	
	str = str.replace(/ /g,&#34; &#34;);
	str = str.replace(/&amp;/g,&#34;&amp;&#34;);
	str = str.replace(/&#34;/g,&#34;\&#34;&#34;);
	str = str.replace(/</g,&#34;<&#34;);
	str = str.replace(/>/g,&#34;>&#34;);
	
	str = str.replace(/<br>/ig,&#34;\n&#34;);
	str = str.replace(/<[^>]*?>/g,&#34;&#34;);
	str = str.replace(/\[url=([^\]]+)\]\n(\[img\]\1\[\/img\])\n\[\/url\]/g,&#34;$2&#34;);
	str = str.replace(/\n+/g,&#34;\n&#34;);
	
	return str;
}

function trans(){
	var str = &#34;&#34;;
	rtf.focus();
	rtf.document.body.innerHTML = &#34;&#34;;
	rtf.document.execCommand(&#34;paste&#34;);
	str = rtf.document.body.innerHTML;
	if(str.length == 0) {
		alert(&#34;剪切版不存在超文本数据！&#34;);
		return &#34;&#34;;
	}
	return html_trans(str);
}
</script>

<textarea style=&#34;width:100%; height:200px&#34; id=&#34;text&#34; class=&#34;textarea&#34; onbeforepaste=&#34;if(document.getElementById('x_paste').checked){window.clipboardData.setData('text',trans());this.focus();}&#34;><&#47textarea><br />
<iframe scrolling=&#34;no&#34; id=&#34;rtf&#34; src=&#34;about:blank&#34; MARGINHEIGHT=&#34;0&#34; MARGINWIDTH=&#34;0&#34; style=&#34;width:0px; height:0px;&#34;></iframe>
<input type=&#34;button&#34; value=&#34;转换剪切版超文本数据&#34; onclick=&#34;document.getElementById('text').value += trans()&#34;>
<input type=&#34;checkbox&#34; id=&#34;x_paste&#34;> <label for=&#34;x_paste&#34;>启用超文本粘贴转换</label>
<script>
rtf.document.designMode=&#34;On&#34;;
</script></TEXTAREA><br/><INPUT onclick="runEx('temp37322')"  type="button" class="userbutton" value="运行此代码"/> <INPUT onclick="doCopy('temp37322')"  type="button" class="userbutton" value="复制此代码"/> <INPUT onclick="saveCode('temp37322')" type="button" class="userbutton" value="保存此代码"><br/> [Ctrl+A 全部选择 提示：你可先修改部分代码，再按运行]</div></div>使用说明<br/>1、选择HTML内容，比如有链接，或者颜色的拷贝。 <br/>2、点击运行代码按钮 <br/>3、直接点击转换 <br/>4、出来的就是论坛专用的 ubb 代码了。<br/><br/>第二种：ASP代码<br/><div class="UBBPanel codePanel"><div class="UBBTitle"><a onClick="copycode(code58425);" style="float:right;cursor: pointer;font-weight: normal; font-style: normal">复制内容到剪贴板</a><img src="http://www.yongzi.com/images/code.gif" style="margin:0px 2px -3px 0px;" alt="程序代码"/> 程序代码</div><div class="UBBContent" id=code58425>&lt;%&nbsp;&nbsp; <br/>function html2ubb(l1)&nbsp;&nbsp; <br/>if len(trim(l1))&gt;0 then&nbsp;&nbsp; <br/>else&nbsp;&nbsp; <br/>exit function&nbsp;&nbsp; <br/>end if&nbsp;&nbsp; <br/>dim l4,I1,I2,I3&nbsp;&nbsp; <br/>dim i,I4:I4=array(16,19,21,24,32,45)&nbsp;&nbsp; <br/>I1=l1&nbsp;&nbsp; <br/>set I2=new regexp&nbsp;&nbsp; <br/>I2.global=true&nbsp;&nbsp; <br/>I2.ignorecase=true&#39;忽略大小写&nbsp;&nbsp; <br/>I2.pattern=&#34;/r&#34;:I1=I2.replace(I1,&#34;&#34;)&nbsp;&nbsp; <br/>I2.pattern=&#34;on(load|click|dbclick|mouseover|mousedown|mouseup)=&#34;&#34;[^&#34;&#34;]+&#34;&#34;&#34;:I1=I2.replace(I1,&#34;&#34;)&nbsp;&nbsp; <br/>I2.pattern=&#34;&lt;script[^&gt;]*?&gt;([\w\W]*?)&lt;\/script&gt;&#34;:I1=I2.replace(I1,&#34;&#34;)&nbsp;&nbsp; <br/>I2.pattern=&#34;&lt;a[^&gt;]+href=&#34;&#34;([^&#34;&#34;]+)&#34;&#34;[^&gt;]*&gt;(.*?)&lt;\/a&gt;&#34;:I1=I2.replace(I1,&#34;<a target="_blank" href="http://www.yongzi.com/$1" rel="external">$2</a>&#34;)&nbsp;&nbsp; <br/>I2.pattern=&#34;&lt;font[^&gt;]+color=([^ &gt;]+)[^&gt;]*&gt;(.*?)&lt;\/font&gt;&#34;:I1=I2.replace(I1,&#34;[color=$1]$2[/color]&#34;)&nbsp;&nbsp; <br/>I2.pattern=&#34;&lt;img[^&gt;]+src=&#34;&#34;([^&#34;&#34;]+)&#34;&#34;[^&gt;]*&gt;&#34;:I1=I2.replace(I1,&#34;<img src="http://www.yongzi.com/$1" border="0" alt=""/>&#34;)&nbsp;&nbsp; <br/>I2.pattern=&#34;&lt;([\/]?)b&gt;&#34;:I1=I2.replace(I1,&#34;[$1b]&#34;)&nbsp;&nbsp; <br/>I2.pattern=&#34;&lt;([\/]?)strong&gt;&#34;:I1=I2.replace(I1,&#34;[$1b]&#34;)&nbsp;&nbsp; <br/>I2.pattern=&#34;&lt;([\/]?)u&gt;&#34;:I1=I2.replace(I1,&#34;[$1u]&#34;)&nbsp;&nbsp; <br/>I2.pattern=&#34;&lt;([\/]?)i&gt;&#34;:I1=I2.replace(I1,&#34;[$1i]&#34;)&nbsp;&nbsp; <br/>I2.pattern=&#34; &#34;:I1=I2.replace(I1,&#34; &#34;)&nbsp;&nbsp; <br/>I2.pattern=&#34;&amp;&#34;:I1=I2.replace(I1,&#34;&amp;&#34;)&nbsp;&nbsp; <br/>I2.pattern=&#34;&#34;&#34;&#34;:I1=I2.replace(I1,&#34;&#34;&#34;&#34;)&nbsp;&nbsp;<br/>I2.pattern=&#34;&lt;&#34;:I1=I2.replace(I1,&#34;&lt;&#34;)&nbsp;&nbsp;<br/>I2.pattern=&#34;&gt;&#34;:I1=I2.replace(I1,&#34;&gt;&#34;)&nbsp;&nbsp;<br/>I2.pattern=&#34;&lt;br /&gt;&#34;:I1=I2.replace(I1,vbcrlf)&nbsp;&nbsp;<br/>I2.pattern=&#34;&lt;[^&gt;]*?&gt;&#34;:I1=I2.replace(I1,&#34;&#34;)&nbsp;&nbsp;<br/>I2.pattern=&#34;\n+&#34;:I1=I2.replace(I1,vbcrlf)&nbsp;&nbsp;<br/>set I2=nothing&nbsp;&nbsp;<br/>html2ubb=I1&nbsp;&nbsp;<br/>end function&nbsp;&nbsp;<br/>%&gt;</div></div><br/>使用方法：<br/>htmlcontent=&#34;含有HTML代码的内容&#34;<br/>Response.Write html2ubb(htmlcontent)<br/><br/><img src="http://www.yongzi.com/images/download.gif" alt="下载文件" style="margin:0px 2px -4px 0px"/> <a href="http://www.yongzi.com/attachments/month_0904/m20094521218.rar" target="_blank">点击下载上面两个代码文件</a><br/><br/>提供几个网页供大家参考：<br/><a href="http://tool.alimama.com/htmltoubb.php" target="_blank" rel="external">http://tool.alimama.com/htmltoubb.php</a><br/><a href="http://www.7747.net/online/gj/htmtoubb.htm" target="_blank" rel="external">http://www.7747.net/online/gj/htmtoubb.htm</a><br/><a href="http://www.blueidea.com/tech/web/2003/1486.asp" target="_blank" rel="external">http://www.blueidea.com/tech/web/2003/1486.asp</a><br/><a href="http://blog.csdn.net/MPU/archive/2009/02/23/3929212.aspx" target="_blank" rel="external">http://blog.csdn.net/MPU/archive/2009/02/23/3929212.aspx</a>]]></description>
		</item>
		
			<item>
			<link>http://www.yongzi.com/article.asp?id=548</link>
			<title><![CDATA[ASP 中如何判断用户名是否为字母和数字的组合]]></title>
			<author>1118221@qq.com(随然)</author>
			<category><![CDATA[程序代码]]></category>
			<pubDate>Wed,25 Feb 2009 22:44:56 +0800</pubDate>
			<guid>http://www.yongzi.com/default.asp?id=548</guid>
		<description><![CDATA[最近常有朋友问我如何在ASP中象在JavaScrip里一样控制输入的值只能是英文或数字，现在我整理如下，下面我以接收变量string的值讲解如下：<br/>方法一：<br/>str=Request(&#34;string&#34;)<br/>temp=Server.URLEncode(str)<br/>if str=temp then<br/>&nbsp;&nbsp;&nbsp;&nbsp;response.write &#34;你输入的不是英文或数字&#34;<br/>end if<br/>文法二：<br/>str=Request(&#34;string&#34;)<br/>for i=1 to len(str)<br/>&nbsp;&nbsp;&nbsp;&nbsp; a=mid(string,i,1)<br/>&nbsp;&nbsp;&nbsp;&nbsp; if ((asc(a)&lt;&#34;0&#34; and asc(a)&gt;&#34;9&#34; ) o&#114; (asc(a)&lt;asc(&#34;a&#34;) and asc(a)&gt;asc(&#34;z&#34;))) then <br/>　　response.write &#34;你输入的不是英文或数字&#34;<br/>　end if<br/>next i]]></description>
		</item>
		
</channel>
</rss>
