Re: sql result tags = column names minus case / any way to get case sensitive tags?
I have a couple other patches for the SQLTransformer that I have been working on. Mainly dealing with better error handling and a missing returncode when an insert/update is called. Just wanted to double check to see if it was a bad idea to maintain the case for some reason. Brian On Thursday, March 13, 2003, at 10:28 AM, Luca Morandini wrote: -Original Message- From: Brian Johnson [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 4:14 PM To: [EMAIL PROTECTED] Subject: Re: sql result tags = column names minus case / any way to get case sensitive tags? In my case, I would rather have it use the case returned by the query. Maybe calling toLowerCase() should be an option? It certainly could be an option... and a very simple to implement at that :) You could, for instance, submit a patch to cocoon-dev and see whether they agree or not. BTW, the default option should be "lowercase", to avoid breaking existing code. Regards, - Luca Morandini GIS Consultant [EMAIL PROTECTED] http://utenti.tripod.it/lmorandini/index.html - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: sql result tags = column names minus case / any way to get case sensitive tags?
> -Original Message- > From: Brian Johnson [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 13, 2003 4:14 PM > To: [EMAIL PROTECTED] > Subject: Re: sql result tags = column names minus case / any way to get > case sensitive tags? > > > In my case, I would rather have it use the case returned by the query. > Maybe calling toLowerCase() should be an option? It certainly could be an option... and a very simple to implement at that :) You could, for instance, submit a patch to cocoon-dev and see whether they agree or not. BTW, the default option should be "lowercase", to avoid breaking existing code. Regards, - Luca Morandini GIS Consultant [EMAIL PROTECTED] http://utenti.tripod.it/lmorandini/index.html - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: sql result tags = column names minus case / any way to get case sensitive tags?
In my case, I would rather have it use the case returned by the query. Maybe calling toLowerCase() should be an option? Brian On Thursday, March 13, 2003, at 09:53 AM, Luca Morandini wrote: -Original Message- From: Brian Johnson [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2003 3:35 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: sql result tags = column names minus case / any way to get case sensitive tags? The SQLTransformer calls toLowerCase() on the column names when it serializes them. I'm not sure what the reason for this is. Does anybody know? Is it because case is driver dependent? Brian I presume it is for having the same element names in output, regardless the case of names specifed in the query or returned from > the database's data dictionary. Regards, - Luca Morandini GIS Consultant [EMAIL PROTECTED] http://utenti.tripod.it/lmorandini/index.html - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: sql result tags = column names minus case / any way to get case sensitive tags?
> -Original Message- > From: Brian Johnson [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 13, 2003 3:35 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: sql result tags = column names minus case / any way to get > case sensitive tags? > The SQLTransformer calls toLowerCase() on the column names when it > serializes them. I'm not sure what the reason for this is. Does anybody > know? Is it because case is driver dependent? > Brian I presume it is for having the same element names in output, regardless the case of names specifed in the query or returned from the database's data dictionary. Regards, - Luca Morandini GIS Consultant [EMAIL PROTECTED] http://utenti.tripod.it/lmorandini/index.html - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: sql result tags = column names minus case / any way to get case sensitive tags?
The SQLTransformer calls toLowerCase() on the column names when it serializes them. I'm not sure what the reason for this is. Does anybody know? Is it because case is driver dependent? Brian On Thursday, March 13, 2003, at 07:42 AM, Christian Haul wrote: On 13.Mar.2003 -- 10:35 AM, Guenther Schmidt wrote: Hi all, is there a possibility to retrieve case sensitive column names, i.e. result tags. My "select * from rentObjects where ... " returns all column names (result tags) case insensitive. Is there a way to retrieve ... instead of .. ? this purely depends on your jdbc driver. IOW probably not. Chris. -- C h r i s t i a n H a u l [EMAIL PROTECTED] fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: sql result tags = column names minus case / any way to get case sensitive tags?
On 13.Mar.2003 -- 10:35 AM, Guenther Schmidt wrote: > Hi all, > > is there a possibility to retrieve case sensitive column names, i.e. result > tags. > > My "select * from rentObjects where ... " returns all column names (result > tags) case insensitive. > > Is there a way to retrieve ... instead of > .. ? this purely depends on your jdbc driver. IOW probably not. Chris. -- C h r i s t i a n H a u l [EMAIL PROTECTED] fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]