Hi!
i found the error: If you first get the logging info from the inner
class it is easy to see:
DEBUG transformation.SQLTransformer$Query - Executing select pn_navn
"fullnavn",pn_fornavn "given",pn_etternavn "family",PN_MNAVN
"middlename",pe_brukerid "userid" , PN_INIT "initial", p.PE_ID "perid"
fromhin.pernavn n,hin.person p
where n.pn_peid_pe = p.pe_id
and p.pe_id > 0
order by pe_brukerid
As you can see, the sql transformer did som trimming on the string he
read, and so the space between "from" and the correct constructed table
version vanishes...
Is that a bug or a feature?
For oracle i have a fix, the others, sorry must figure out something by
themself. Yust change the from line to something like that:
from dual,<sql:substitute-value sql:name="org"/>.pernavn
n,<sql:substitute-value sql:name="org"/>.person p
and there does not vanish any space any more ;-)
Best regards
Søren Krum
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@cocoon.apache.org
For additional commands, e-mail: users-h...@cocoon.apache.org
