Re: SQL RTRIM
Re: SQL RTRIM
- Subject: Re: SQL RTRIM
- From: Pascal Robert <email@hidden>
- Date: Tue, 13 Mar 2012 07:52:56 -0400
If you need trimming only for certain fields, yes you can do it in code by having cover methods on the getter. E.g., if you have an attribute called "trimMe", just override that method to trim the value return by super.trimMe()
But does calling RTRIM in fetching is really an expansive operation? I doubt it.
> hm. but i don't understand this thing:
> this avoiding RTRIM will be works on SELECT or UPDATE or both?
> for example i have CMS application. so there i need trimming (of course i can do this in java).
> but when i do fetching i don't need trimming.
>
> 2012/3/13 Chuck Hill <email@hidden>
> Yes, that is correct. If that does not work, then there is a bug. Let us know how it works out.
>
> Chuck
>
>
> On 2012-03-12, at 11:11 PM, Ron X wrote:
>
> > What is the Value Type in the EOModel? <<
> > Data type: String (RTRIM)
> > External type: VARCHAR
> > Class: java.lang.String
> >
> > as i understood - i need just change String (RTRIM) to String and i shall not see all these RTRIMs in SQL-log, right?
> >
> > 2012/3/12 Pascal Robert <email@hidden>
> >
> > Le 2012-03-12 à 15:06, Pascal Robert a écrit :
> >
> > >
> > > Le 2012-03-12 à 14:55, Chuck Hill a écrit :
> > >
> > >>
> > >> On 2012-03-12, at 11:24 AM, Ramsey Gurley wrote:
> > >>
> > >>> Google's search seems to work better than ours too :-/ If I search for debugger on the wiki, I can't find:
> > >>>
> > >>> http://wiki.wocommunity.org/display/WOL/Using+the+debugger
> > >>>
> > >>> But if I search google for "debugger site:wocommunity.org" it's the first result.
> > >>
> > >> And if you google "debugger WebObjects" WikiBooks is the fourth link. :-P
> > >>
> > >> Even if we use Elastic Search, I'd guess TFWS* will use Google not the WOCommunity site.
> > >>
> > >> * Those Few Who Search
> > >
> > > 71.23% Search Traffic 6,439 Visits
> > > 15.12% Referral Traffic 1,367 Visits
> > > 13.65% Direct Traffic 1,234 Visits
> > >
> > > Visits With Site Search 360 Visits 3.30%
> > >
> > > So 6439 visits coming from Google searches, and 360 visits who did a search inside the wiki. Hence the importance of finding and replacing old links to the new ones...
> >
> > While we are at it:
> >
> > Google Search: Top 1,000 daily queries.
> >
> > wiki.wocommunity.org
> >
> > Query Impressions Clicks Average Position CTR
> > 1. wolips 1,000 170 2.0 18.24%
> > 2. eclipse encoding 320 70 3.0 19.70%
> > 3. eclipse default encoding 90 60 1.5 55.67%
> > 4. eclipse character encoding 70 50 1.1 63.24%
> > 5. webobjects 1,600 50 13 3.07%
> > 6. eclipse change encoding 60 35 1.0 54.10%
> > 7. selenium commands 170 35 4.3 24.24%
> > 8. project wonder 200 30 1.6 15.50%
> > 9. selenium examples 320 30 5.5 9.45%
> > 10. webobjects tutorial 150 30 12 19.08%
> >
> > So the wiki is more useful for people looking at how to change the encoding in Eclipse than with WebObjects information! I'm wondering why we have more than 1000 search for "wolips" on Google in the last 30 days.
> >
> > For wocommunity.org:
> >
> > Query Impressions Clicks Average Position CTR
> > 1. webobjects 1,600 110 3.5 8.04%
> > 2. web objects 400 22 3.2 6.25%
> > 3. wocommunity 35 22 1.0 72.73%
> > 4. wowodc 30 22 1.0 66.67%
> > 9. apple store wo < 10 < 10 0.00%
> > 10. apple web objects 16 < 10 8.5 0.00%
> > 11. apple webobjects 60 < 10 8.3 0.00%
> >
> >
> > _______________________________________________
> > Do not post admin requests to the list. They will be ignored.
> > Webobjects-dev mailing list (email@hidden)
> > Help/Unsubscribe/Update your Subscription:
> >
> > This email sent to email@hidden
> >
>
> --
> Chuck Hill Senior Consultant / VP Development
>
> Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
> http://www.global-village.net/gvc/practical_webobjects
>
>
>
>
>
>
>
>
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden