asp-wml -databse
Hi, im a newbie to ASP and WML,
Anyway im trying to connect to a databse using asp and wml this error keeps appearing
Error in document
The XML document you have requested contains a lexical or syntactic error at line 18, column 11. (byte 280 of stream).
and below is my code
<% Response.ContentType = "text/vnd.wap.wml" %>
<?xml version="1.0"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.3//EN" "http://www.wapforum.org/DTD/wml13.dtd" >
<%
Dim RSalbum
strconn = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("db/cds.mdb")
set conn = server.createobject("adodb.connection")
conn.open strconn %>
<wml>
<card id="card1" title="CDS:albumschart">
<%SQLQuery = "SELECT ChartPosition, AlbumName, Artist, Price FROM album WHERE ChartPosition <=10 ORDER BY ChartPosition"
Set RSalbum = conn.Execute(SQLQuery) %>
<%RSalbum.movefirst
do while not RSalbum.eof %>
<p><%=RSalbum("ChartPosition")%></p>
<p><%=RSalbum("AlbumName")%></p>
<p><%=RSalbum("Artist")%></p>
<p><%=RSalbum("Price")%></p>
<% RSalbum.movenext
Loop %>
</card>
</wml>
Can anyone please advise me as to where i am going wrong
Thanks for your help
-Andy
Andy
|