"Bouvet Konsulent" <[EMAIL PROTECTED]> schrieb am 28.04.2005 12:05:37:
> hello again,
> thank you for all your help, it has been very useful.
>
You are welcome.
> 1. Your diagnoisis was right. Using criteria.setLimit(0); made the
> query work fine
>
> 2. I tried to do a
> ChannelDocumentLatestPeer.doSelectJoinDocument(crit);
> This did not work very well, however. The generated SQL was exactly
> like the query which generated a 'ORA-00918: column ambiguously
> defined' error.
> I am using Oracle 8.1.7, which does not handle joins very well.
> Keywords like 'inner join' were not introduced before version 9.
> Maybe that has something to do with it? Does Torque generate SQL
> based on the _version_ of the database, by using the corresponding
jdbc-jar?
No, this would also fail within Oracle 10g. It is a problem with the way
oracle handles limit/offset and how it is handled in Torque.
>
> 3. I ended up doing
> List docs = DocumentPeer.doSelectVillageRecords(crit);
> transfer docs into objects
> building a criteria for ChannelDocumentLatest
> List l = ChannelDocumentLatestPeer.doSelectVillageRecords(cdlCriteria);
> transfer l into object 'latest'
> doc.setOriginatingChannel(latest.getOriginatingChannelId());
>
> so I ended up with one more SQL-query to get my foreign key to add
> to the Document-object, but I guess that is ok.
I do the same most of the time.
>
> once more: thank you for your help!
>
> cheers,
> pj
>
Thomas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
