+---[ Olaf Zanger ]--
| hi Andrew and others,
|
| > I get errors:
| > when i first want to view a page with the
| > test
| >
| > pg.error
| > error value: error: attribute 'phrases_phrase_id_seq' not found
|
| i changed the column name of the id from "phrase_id" to "id"
hi Andrew and others,
> I get errors:
> when i first want to view a page with the
> test
>
> pg.error
> error value: error: attribute 'phrases_phrase_id_seq' not found
i changed the column name of the id from "phrase_id" to "id" and get
still the same error message as above.
so i figured that
hi Phil,
> The left join is a notation that says to get all records from the left hand
> side of the join and only those records where the criteria matches from the
> right hand side.
>
> It is btw a part of most RDBMS engines I've ever used, so it's not that
> unusual a syntax.
>
> You can als
hi andrew,
thanks for the description. i figured it as far as that:
you need in postgresql (this is tested only from zope with zsql method,
since some other things don't work in the ZBabel Produkt with
postgresql):
sqlGetPhrasesToUpdate:
select distinct Phrases.*
WHERE md5Hash not in
(
sel
something similar by using unions.
hth
Phil
[EMAIL PROTECTED]
- Original Message -
From: "Olaf Zanger" <[EMAIL PROTECTED]>
To: "Zope Mailinglist" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, January 04, 2001 9:50 AM
Subject: [Zope] ZBab
Hi there,
i'm using ZPyGreSQL successfully for my database. To keep it simple i
don't want to use MySQL for ZBabel.
ZBabel though uses some MySQL specific syntax which i am unsuccessfully
translating to PostgreSQL syntax:
Description "md5Hash" are the same fore entries with different "lang"
fie
