<% set conn=server.createobject("adodb.connection") conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("example3.mdb") %> <% exec="select * from mekk" set rs=server.createobject("adodb.recordset") rs.open exec,conn,1,1 %> <table width="100%" border="1" cellspacing="0" cellpadding="1"> <tr> <td><%="歌手"%></td> <td><%="专辑"%></td> <td><%="歌曲"%></td> <td><%="流派"%></td> </tr> <%do while not rs.eof%> <tr> <td><%=rs("gs")%></td> <td><%=rs("zj")%></td> <td><a href="file8.asp"><%=rs("gq")%></a></td> <td><%=rs("lp")%></td> </tr> <%rs.movenext loop%> </table> 上面是index.asp代码没错,下面是file8.asp

<OBJECT id=MediaPlayer1 style="LEFT: 0px; VISIBILITY: visible; POSITION: absolute; TOP: 0px;z-index:2" codeBase=http://activex.microsoft.com/activex/controls/mplayer/en/nsmp2inf.cab#Version=5,1,52,701standby=

Loading type=application/x-oleobject height=300 width=320 classid=CLSID:6BF52A52-394A-11d3-B153-00C04F79FAA6 VIEWASTEXT> <PARAM NAME="URL" VALUE="">

<param name="AudioStream" value="-1"> <param name="AutoSize" value="0"> <param name="AutoStart" value="-1"> <param name="AnimationAtStart" value="0"> <param name="AllowScan" value="-1"> <param name="AllowChangeDisplaySize" value="-1"> <param name="AutoRewind" value="0"> <param name="Balance" value="0"> <param name="BaseURL" value> <param name="BufferingTime" value="5"> <param name="CaptioningID" value> <param name="ClickToPlay" value="-1"> <param name="CursorType" value="0"> <param name="CurrentPosition" value="-1"> <param name="CurrentMarker" value="0"> <param name="DefaultFrame" value> <param name="DisplayBackColor" value="0"> <param name="DisplayForeColor" value="16777215"> <param name="DisplayMode" value="0"> <param name="DisplaySize" value="4"> <param name="Enabled" value="-1"> <param name="EnableContextMenu" value="-1"> <param name="EnablePositionControls" value="0"> <param name="EnableFullScreenControls" value="0"> <param name="EnableTracker" value="-1"> <param name="InvokeURLs" value="-1"> <param name="Language" value="-1"> <param name="Mute" value="0"> <param name="PlayCount" value="1"> <param name="PreviewMode" value="0"> <param name="Rate" value="1"> <param name="SAMILang" value> <param name="SAMIStyle" value> <param name="SAMIFileName" value> <param name="SelectionStart" value="-1"> <param name="SelectionEnd" value="-1"> <param name="SendOpenStateChangeEvents" value="-1"> <param name="SendWarningEvents" value="-1"> <param name="SendErrorEvents" value="-1"> <param name="SendKeyboardEvents" value="0"> <param name="SendMouseClickEvents" value="0"> <param name="SendMouseMoveEvents" value="0"> <param name="SendPlayStateChangeEvents" value="-1"> <param name="ShowCaptioning" value="0"> <param name="ShowControls" value="-1"> <param name="ShowAudioControls" value="-1"> <param name="ShowDisplay" value="0"> <param name="ShowGotoBar" value="0"> <param name="ShowPositionControls" value="-1"> <param name="ShowStatusBar" value="-1"> <param name="ShowTracker" value="-1"> <param name="TransparentAtStart" value="-1"> <param name="VideoBorderWidth" value="0"> <param name="VideoBorderColor" value="0"> <param name="VideoBorder3D" value="0"> <param name="Volume" value="70"> <param name="WindowlessVideo" value="0"> </OBJECT>

求教<PARAM NAME="URL" VALUE="">这段怎么与数据库里"gq"字段连接

改两个地方 ...... <% exec="select * from mekk" set rs=server.createobject("adodb.recordset") rs.open exec,conn,1,1 %> <table width="100%" border="1" cellspacing="0" cellpadding="1"> <tr> <td><%="歌手"%></td> <td><%="专辑"%></td> <td><%="歌曲"%></td> <td><%="流派"%></td> </tr> <%do while not rs.eof%> <tr> <td><%=rs("gs")%></td> <td><%=rs("zj")%></td> <td> <a href="file8.asp?id=<%=rs("id")%>"><%=rs("gq")%></a> </td> <td><%=rs("lp")%></td> </tr> <%rs.movenext loop%> </table>

第二个地方: file8.asp <% set conn=server.createobject("adodb.connection") conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("example3.mdb") %> ...... <PARAM NAME="URL" VALUE="<%=conn.execute("select gq from mekk where id="&trim(request.querystring("id"))&"")(0)%">

上楼仁兄是通过主键定位查找歌曲名,这主意不错.但是我刚试过file8.asp文件运行出错.

谢谢没有剑的圣骑士!!!

能不能生成一个wpl播放列表文件?

也可以啊~用FSO啊~