This is the code that i am using, no sign of forms! My worry is could people get hold of my database pathname?
<% Response.ContentType = "text/vnd.wap.wml" %>
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN" "http://www.wapforum.org/DTD/wml_1.1.xml">
<wml>
<card title="Forum">
<p align="left">Most recent topics being discussed, click on topic to view last post:</p>
<p align="left">
<%
Dim adoCon
Dim strCon
Set adoCon = Server.CreateObject("ADODB.Connection")
strCon = "Provider=Microsoft.Jet.OLEDB.4.0; DATA Source='\\xxxxxxx.mdb';"
adoCon.Open strCon
Dim rsForum
Dim strSql
Set rsForum = Server.CreateObject("ADODB.Recordset")
strSql= "SELECT TOP 10 tblTopic.* FROM tblTopic ORDER BY tblTopic.Last_entry_date DESC"
rsForum.CursorType = 3
rsForum.Open strSql, adoCon
%>
<%
Do while NOT rsForum.EOF
%>
<a href="http://www.rebelgaa.com/wap/forum/post.asp?TID=<% = rsForum("Topic_ID") %>"><% = rsForum("Subject") %></a><br/><br/>
<%
rsForum.MoveNext
Loop
%>
<%
rsForum.Close
Set rsForum = Nothing
Set strCon = Nothing
Set adoCon = Nothing
%>
</p>
<p align="center"><a href="/wap/index.asp">Main Page</a></p>
</card>
</wml>