Re: [Zope] INTERBASE cannot do this type of query ?
14 Dec
2000
14 Dec
'00
6:10 p.m.
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
9244
Age (days ago)
9244
Last active (days ago)
0 comments
1 participants
participants (1)
-
Jan H. Haul