ASPÊý¾Ý¿â±íÖµÏÔʾÎÊÌâ~~~Çó¾È£¡£¡£¡£¡
<!--#include file="conn.asp" -->
<%
set rs=server.create("adodb.recordset")
set rs=conn.execute("select Ãû³Æ from ¶ÁÈ¡±í")'¶ÁÈ¡±íÖеÄÃû³ÆÁÐÖµÓУºÃû³Æ£¬ÃÜÂë
do while not rs.bof and not rs.eof
%>
<%
set rs1=Server.CreateObject("ADODB.Recordset")
sqlstring="select "&rs("Ãû³Æ")&" from ʵÑé"'È»ºó¶ÁÈ¡±íÖеÄÖµ¸ø"&rs("Ãû³Æ")&"
rs1.open sqlstring,conn,1,1
do while not rs1.bof and not rs1.eof
%>
<%=rs1("Ãû³Æ")%>'ÎÊÌâÕâÀֻÊÇÏÔʾÃû³ÆµÄÁÐÖµ£¬ÊµÑé±íÖеÄÃÜÂëÁÐÃûµÄÁÐÃûֵûÓÐÏÔʾ³öÀ´
<%
rs1.movenext
loop
%>
<%
response.write err.description &" "
rs.movenext
loop
%>
¶ÁÈ¡±íºÍʵÑé±íÊÇʲô¹ØÏµ£¿
¶ÁÈ¡±íÖÐµÄ Ãû³ÆµÄÖµ ÊÇ ÊµÑé±íÖеÄÁÐÃû£¿
Êǵϰ£¬rs("Ãû³Æ")µÄÖµÊÇʲô£¿
Ҫȡrs1("Ãû³Æ"), rs1("ÃÜÂë")µÄ»°£¬rs("Ãû³Æ")ÖеÄÖµÓ¦¸ÃÊÇ "Ãû³Æ,ÃÜÂë,xx" µÄÐÎʽ¡£
ÓеãÂÒ°¡,²»ÖªµÀÂ¥Ö÷ÊÇÔõôÑùÏëµÄ,
´ÓµÚÒ»¸ö±íÖÐÈ¡³öÃû³ÆºÍÃÜÂëµÄÁÐÃû,È»ºóÔÙ¸ù¾ÝÈ¡³öµÄÁÐÃû,ÔÚµÚ¶þ¸ö±íÖÐÈ¡³öÖµ.
Ö÷ÒªÊÇ
Ïà¹ØÎÊ´ð£º
ÓÉÓÚ¶ÔÒ³ÃæÊ¹ÓÃÁËα¾²Ì¬
²¢ÇÒ¶ÔID½øÐÐÁ˼ÓÃÜ¡£
Ö÷Òª´úÂëÈçÏ£º
httpd.ini
RewriteRule /List-([0-9,a-z]*).html /List.asp\?ComId=$1 [N,I]
³ÌÐò´úÂë
AΪ¼ÓÃÜ£¬BΪ½âÃܺ¯Êý
<a href=&q ......
Îļþ£ºfolder.inc
HTML code:
<%
Dim folderini,pos,pageName
fPath = Request.ServerVariables("PATH_TRANSLATED")
pos = instrRev(fPath,"\")
folderini = Left(fPath,pos)+&qu ......
ÎÒÕÒÁËÒ»¸öα¾²Ì¬´úÂ룬ÈçÏ£º
index.asp
<!--#include file="config.asp"-->
<ol>
<%
Set rs=server.CreateObject("adodb.recordset") & ......
ÓÐËÄܸø½²½²£¬Ôõô×öÂð£¿
ллÀ²£¡
¸ÊÌØÍ¼ ÊÇɶ£¿
½âÌâ˼·.¿´Ò»Ï½ø¶ÈÌõµÄÏÔʾ..
ÆäʵÄã¾ÍŪһ¶Ñtable ÿ¸ötableµÄ¿í¶È²»Í¬.µ×É«²»Í¬¼´¿É
µ±È»ÓÃdiv¿ØÖÆÎ»ÖøüºÃ
ÄãŪ100¸ötable¸ù¾Ý½ø¶ÈÆäÖÐǰ20¸ö·Ö¸øµ ......