Dieter,
That's right, we just read the column names as returned by the database. We could do a little more if two columns have the same name, but that would have to be configurable. Maybe the best solution is simply for you to provide an alias, as you suggest. Different databases also behave differently. Some, like Oracle I think, will automatically append numbers if different columns have the same name.
-Erik
Dieter Stein wrote:
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
------------------------------------------------------- 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
