You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Guenther Schmidt <gu...@epost.de> on 2003/03/13 11:35:22 UTC
sql result tags = column names minus case / any way to get case sensitive tags?
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 <maxNumberOfTenants>... instead of
<maxnumberoftenants>...... ?
Thanks
Guenther
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org
Re: sql result tags = column names minus case / any way to get case sensitive tags?
Posted by Brian Johnson <jo...@yahoo.com>.
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:johnsbrn@yahoo.com]
>> Sent: Thursday, March 13, 2003 4:14 PM
>> To: cocoon-users@xml.apache.org
>> 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
> lmorandini@ieee.org
> http://utenti.tripod.it/lmorandini/index.html
> ---------------------------------------------
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org
RE: sql result tags = column names minus case / any way to get case sensitive tags?
Posted by Luca Morandini <lu...@tin.it>.
> -----Original Message-----
> From: Brian Johnson [mailto:johnsbrn@yahoo.com]
> Sent: Thursday, March 13, 2003 4:14 PM
> To: cocoon-users@xml.apache.org
> 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
lmorandini@ieee.org
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org
Re: sql result tags = column names minus case / any way to get case sensitive tags?
Posted by Brian Johnson <jo...@yahoo.com>.
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:johnsbrn@yahoo.com]
>> Sent: Thursday, March 13, 2003 3:35 PM
>> To: cocoon-users@xml.apache.org; cocoon-dev@xml.apache.org
>> 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
> lmorandini@ieee.org
> http://utenti.tripod.it/lmorandini/index.html
> ---------------------------------------------
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org
RE: sql result tags = column names minus case / any way to get case sensitive tags?
Posted by Luca Morandini <lu...@tin.it>.
> -----Original Message-----
> From: Brian Johnson [mailto:johnsbrn@yahoo.com]
> Sent: Thursday, March 13, 2003 3:35 PM
> To: cocoon-users@xml.apache.org; cocoon-dev@xml.apache.org
> 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
lmorandini@ieee.org
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org
Re: sql result tags = column names minus case / any way to get case sensitive tags?
Posted by Brian Johnson <jo...@yahoo.com>.
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 <maxNumberOfTenants>... instead of
>> <maxnumberoftenants>...... ?
>
> this purely depends on your jdbc driver. IOW probably not.
>
> Chris.
> --
> C h r i s t i a n H a u l
> haul@informatik.tu-darmstadt.de
> fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
>
Re: sql result tags = column names minus case / any way to get case sensitive tags?
Posted by Brian Johnson <jo...@yahoo.com>.
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 <maxNumberOfTenants>... instead of
>> <maxnumberoftenants>...... ?
>
> this purely depends on your jdbc driver. IOW probably not.
>
> Chris.
> --
> C h r i s t i a n H a u l
> haul@informatik.tu-darmstadt.de
> fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org
Re: sql result tags = column names minus case / any way to get case sensitive tags?
Posted by Christian Haul <ha...@dvs1.informatik.tu-darmstadt.de>.
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 <maxNumberOfTenants>... instead of
> <maxnumberoftenants>...... ?
this purely depends on your jdbc driver. IOW probably not.
Chris.
--
C h r i s t i a n H a u l
haul@informatik.tu-darmstadt.de
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org