White space problems
From: C (cammclaren_at_tiscali.co.uk)
Date: 02/09/05
- Next message: Robert Klemme: "Re: White space problems"
- Previous message: Joe Weinstein: "Re: JDBC and Multiple record sets"
- Next in thread: Robert Klemme: "Re: White space problems"
- Reply: Robert Klemme: "Re: White space problems"
- Reply: Karsten Baumgarten: "Re: White space problems"
- Reply: dar7yl: "Re: White space problems"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Wed, 9 Feb 2005 09:20:08 -0000
I'm trying to display the rows of a sql database in a web page, but the row
called "Bedlington station",
having a space in, is causing problems. How do I fix this? I've tried
enclosing single quotes in the double quotes,
and using \" also tried %20 but nothing works. Any ideas?
code:
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<sql:query var="queryresults" dataSource="jdbc/poolDB">
SELECT * FROM x31
</sql:query>
<html>
<head><title>JSP Page</title></head>
<body>
<table border=1>
<tr>
<th>Arrive</th>
</tr>
<c:forEach var="row" items="${queryresults.rows}">
<tr>
<td><c:out value="${row.NORCAT}" /></td>
// <td><c:out value="${row.Bedlington Station}" /></td>
</tr>
</c:forEach>
</table>
</body>
</html>
- Next message: Robert Klemme: "Re: White space problems"
- Previous message: Joe Weinstein: "Re: JDBC and Multiple record sets"
- Next in thread: Robert Klemme: "Re: White space problems"
- Reply: Robert Klemme: "Re: White space problems"
- Reply: Karsten Baumgarten: "Re: White space problems"
- Reply: dar7yl: "Re: White space problems"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
