This is a good catch, and an easy fix: instead of accessing the columns by name in the SQLProcessor, I now access them by index. I just checked in the fix. You can get the source from CVS, and I am also sending you by separate email the updated SQLProcessor classes so you can patch your current orbeon.jar. Please let us know if that fixes the issue.
-Erik
Dieter Stein wrote:
Hi,
> We could do a little more if two columns have the same name, > but that would have to be configurable.
Not really, e.g. Cocoon responds with the correct values for identical column names in different tables without any additional configuration. Also, I think it's problematic to add another element (here: <id>) but fill it with the wrong *value*.
~ Dieter
> 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.tm > pl
> > > _______________________________________________
> > 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
------------------------------------------------------- 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
