[Zope] INTERBASE cannot do this type of query ?

Jan H. Haul jan@haul.de
Thu, 14 Dec 2000 19:10:52 +0100


Francois-regis Chalaoux wrote:

> Error, Products.gvibDA.gvib.gvibExceptions.ProgrammingError: - Dynamic SQL Error -- SQL error code = -206 -- Column
> unknown -- MOUSE
> 
> SQL used:
> 
> select IND_SPECIE
> from ZEB_INDIVIDU
> where IND_SPECIE = "MOUSE"

Use single quotes around 'MOUSE'.

In SQL, single qoutes are for string literals, double quotes for
column names (there are people who think spaces in column names
or mixed lower/upper case column names are neat.... NOT).

Jan