RE: [DB] Tasks for newbies

["MCCAY,LARRY (HP-NewJersey,ex2)" <la...@hp.com>]

Attached is an extract function interval for dayname - with which you can
extract(dayname from datefield) and return the english name for day of the
week.

This is not part of the typical interval set within MySQL for instance - but
seems useful nonetheless.

enjoy.

-Larry



> -----Original Message-----
> From: Paul Hammant [mailto:Paul_Hammant@yahoo.com]
> Sent: Friday, January 04, 2002 5:06 PM
> To: MCCAY,LARRY (HP-NewJersey,ex2)
> Subject: Re: [DB] Tasks for newbies
> 
> 
> Larry,
> 
> >Attached are some extract function interval implementations:
> >daysecond, hourminute, hoursecond, minutesecond, yearmonth
> >
> >I hope that they are appropriate implementations - I added an
> >AbstractTemporalStringFunction to extend them from.  If this 
> is not inline
> >with expectations - just kick it back to me.
> >
> No they are fine.  I fixed the imports.  Too many in some 
> cases, and .* 
> (a jakarta no-no) in others.
> 
> >I have added them to the SelectColumnHelper and attached my 
> version of that
> >as well.
> >
> >I have also created a test3.script for testing these - just 
> in case they are
> >not ready to be merged into test2.script.
> >
> Indeed.  I have even reverse engineered (not hard) the new 
> build.xml file.
> 
> SelectColumnHelper had some legacies of CVS's merge in it. 
> I've trimmed 
> those too.  I so much prefer proper revision control systems like 
> 'Perforce'.
> 
> Keep up the good work.  Do you fancy taking on one of the alternate 
> parsers.  We want to have one that writes Java source and 
> invokes javac* 
> to copile it.  It would be slower for CreateTable and first 
> invocations 
> of SimpleSelect, but much faster on susequent runs (which im my 
> experience amount to 99.999% of all traffic).
> 
> * There was a Cocoon module I wanted to migrate to Excalibur 
> that wraps 
> com.sun.tools.Javac, but we have problems in that in JDK1.4 javac has 
> lost its public access.  It was static anyway and main(..) is a an 
> antipattern IMHO.  Luckily jikes is still lanchable by the 
> Cocoon class.
> 
> Clearly, unless it you balk at the prospect we'll also need committer 
> access for you.  Given the Meritocracy nature of this place, 
> it should 
> not be hard.  Also, it is always proposed for a vote by an existing 
> committer and never asked for by the recipient (a mistake I 
> made a year 
> and a bit ago).
> 
> Regards,
> 
> - Paul H
> 

Re: [DB] Tasks for newbies

[Jeff Turner <je...@socialchange.net.au>]

In SelectColumnHelper.java:

...
>           if (colVec.size() > function.getMaxCols() | colVec.size() < function.getMinCols() ) {
>               throw new ActionException("Function "+aElem.getNodeName()+" can only have "+function.getMaxCols()+" child
>+columns");
...

Should that be '||', not '|'?

--Jeff


On Mon, Jan 07, 2002 at 05:59:19PM -0500, MCCAY,LARRY (HP-NewJersey,ex2) wrote:
> Attached is an extract function interval for dayname - with which you can
> extract(dayname from datefield) and return the english name for day of the
> week.
> 
> This is not part of the typical interval set within MySQL for instance - but
> seems useful nonetheless.
> 
> enjoy.
> 
> -Larry

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>

Re: [DB] Tasks for newbies

[Paul Hammant <Pa...@yahoo.com>]

Larry,

Thanks for (I think) your fourth contribution.

Regards,

- Paul H

>Attached is an extract function interval for dayname - with which you can
>extract(dayname from datefield) and return the english name for day of the
>week.
>
>This is not part of the typical interval set within MySQL for instance - but
>seems useful nonetheless.
>
>enjoy.
>
>-Larry
>



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>