I've spent all morning trying to write my own page, not rely on UltraDev, but I have a problem I think I've been staring at for too long. I'm creating a detail page where someone can read the full text of a news article by clicking on a link. My problem is writing a select statement that pulls the correct record:
Here's my link from the first page: <a href="displaypage.asp?recordid=<%=strSQL.Fields("NewsNo").Value%>">Click for more details</a>
And here's my select statement on the detail page:
<%
dim m_strDSN, news, strSQL, NewsNo
NewsNo = CInt(Request.QueryString("recordid"))
m_strDSN=Application("DBDSN")
set news = server.createobject("ADODB.Connection")
news.open m_strDSN
set strSQL = news.Execute("Select * from DailyNews where recordid = "& NewsNo")"
%>
Which gives me a
Microsoft VBScript compilation error '800a03ee'
Expected ')'
Suggestions?
Thanks in advance!