Re: White space problems

From: Lee Fesperman (firstsql_at_ix.netcom.com)
Date: 02/10/05 

Date: Thu, 10 Feb 2005 02:22:08 GMT

dar7yl wrote:
>
> "C" <cammclaren@tiscali.co.uk> wrote in message
> news:4209d5c2$1_1@mk-nntp-2.news.uk.tiscali.com..
> > 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?
>
> The SQL language supports backtick ( ` )
> as the delimeter for column names
> ie, SELECT `Bedlington station` FROM ....

Standard SQL uses double quotes (") rather than backtick. See the first page of the SQL
Tutorial at http://www.firstsql.com/tutor.htm. 

-- 
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS  (http://www.firstsql.com)

Relevant Pages