ASP with WML help required if you can.
Hi, Im working on a wml site, with asp database. I have a news section in the site, on the page news.asp I have 3 news headlines and each headline with a link to display MORE of the story. I can output the headlines no problem. I can also make a new card in the deck and output some text and the link works. However when I make my new card in the deck and try to output the asp news story, Im getting errors. I shall paste my code see if anyone has any tips. Thanks!
Neil
<%
Response.ContentType = "text/vnd.wap.wml"
Dim objConn, objRS
Set objConn = Server.CreateObject("ADODB.Connection")
Set ObjRS = Server.CreateObject("ADODB.Recordset")
objConn.Provider = "Microsoft.Jet.OLEDB.4.0"
strDBFile = Server.MapPath(".") & "\dsn.mdb"
objConn.Open strDBFile
Set objRS.ActiveConnection = objConn
objRS.Open "SELECT * from news"
%>
<?xml version="1.0"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN" "http://www.wapforum.org/DTD/wml_1.1.xml">
<wml>
<card id="news" title="News">
<p>
Current News Stories:<br/>
</p>
<%
While Not objRS.EOF
%>
<p><%=objRS.Fields("headline").Value><br/></p>
<p><a href="#story<%=objRS.Fields("newsid").Value%>">Mor e</a></p>
<%
objRS.MoveNext()
Wend
%>
<p><br/></p>
<p><a href="index.asp">Home</a></p>
</card>
<card id="story001" title="News">
<p>ASP story here</p>
<p><br/></p>
</card>
<card id="story002" title="News">
<p>ASP story here</p>
<p><br/></p>
</card>
<card id="story003" title="News">
<p>ASP story here</p>
<p><br/></p>
</card>
</wml>
|