Hi, not very critical, but I would like to report that: The sql generator produces identical entries for queries over multiple tables w/ identical column names, e.g.:
SELECT table_a.id, table_b.id FROM table_a, table_b table_a has got a column 'id' as well as table_b. The result is something like: <id>12345</id> <!-- this comes from table_a --> <id>12345</id> <!-- this also is the value of table_a, NOT table_b's! --> Defining SELECT table_a.id AS table_a_id, table_b.id AS table_b_id FROM ... solves the problem, and is probably the better solution for getting the entries afterwards as <xsl:value-of select="table_b_id"/> rather than <xsl:value-of select="id[2]"/>. But, as I said, maybe there is something that can be improved. ~ Dieter PS: Thanks for opensourcing your software, Orbeon. ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl _______________________________________________ orbeon-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/orbeon-user
