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

_______________________________________________
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )

Reply via email to