!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
cfquery name="viewlist" datasource="#request.dsn#"> select boardID,boardNAME from board order by boardID /cfquery>
html> head> title>CCForum栏目一览/title> /head> body>
center>h3>CCForum栏目一览/h3>/center>br>br> table border="1" align="center"> tr>td align="center">b>编号/b>/td>td align="center">b>名称/b>/td>/tr> cfoutput query="viewlist"> tr>td align="center">#boardID#/td>td align="left">#boardname#/td>/tr> /cfoutput> /table> p> center> a href="web.cfm" target="_blank">以WEB方式用EXCEL打开/a>br>br> a href="doc.cfm" target="_blank">以WEB方式用word打开/a>br>br> a href="file.cfm" target="_blank">生成EXCEL文件并下载/a>br>br>br> CopyRight(C)wait hunanet.com /center> /body> /html>
!-----这个文件是用来在线以EXCEL文件形式打开的代码---->
!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> cfsetting enablecfoutputonly="Yes"> cfquery name="getboard" datasource="#request.dsn#"> select boardID,boardNAME from board order by boardID /cfquery>
!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> cfsetting enablecfoutputonly="Yes"> cfquery name="getboard" datasource="#request.dsn#"> select boardID,boardNAME from board order by boardID /cfquery>