Re: [Zope] INTERBASE cannot do this type of query ?

2000-12-14 Thread Jan H. Haul 

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 )

RE: [Zope] INTERBASE cannot do this type of query ?

2000-12-14 Thread Bob Tierney 


For chuckles try 'MOUSE' instead of "MOUSE"

Bob


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
Francois-regis Chalaoux
Sent: Thursday, December 14, 2000 8:12 AM
To: [EMAIL PROTECTED]
Subject: [Zope] INTERBASE cannot do this type of query ?
Sensitivity: Personal


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"

___
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 )




___
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 )

[Zope] INTERBASE cannot do this type of query ?

2000-12-14 Thread Francois-regis Chalaoux 

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"

___
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 )