Syntax error using request.getParameter in query
I'm trying to pass a variable in a URL to a print version page for my web site. I'm getting an error stating:
Lexical Error: String constant not properly terminated
at this point in the code:
pageTitle=<%= request.getParameter("title")
Below is the entire snippet. I know it's something simple, but I'm new to jsp and just can't get it to work.
thanks,
Kirk
<%
//select the content from database according to the id
String query="SELECT pageTitle, pageMetaDescription, pageMetaKeywords, pageHeadline, pageText, callout, image, pageFileName FROM tblPageContent WHERE pageTitle=<%= request.getParameter("title") %>";
ResultSet rs=statement.executeQuery(query);
while(rs.next()){
title=rs.getString(1);
metadescription=rs.getString(2);
metakeywords=rs.getString(3);
headline=rs.getString(4);
pagetext=rs.getString(5);
callout=rs.getString(6);
image=rs.getString(7);
filename=rs.getString(8);
}
%>
|