You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tapestry.apache.org by Aaron Bartell <al...@gmail.com> on 2006/02/03 16:34:54 UTC
** FORUM POLICE** RE: For sql experts
Don't mean to be nitpicky but. .. to keep the list as focused as possible
it is best to not post something here that has nothing to do with Tapestry.
I know it is easy because you are already subscribed to this list, but there
are many SQL forums and mailing lists out there that this would be more
appropriate in.
A google search brings up some good results:
http://www.google.com/search?hl=en&lr=&q=sql+forum
http://forums.belution.com/en/sql/
http://www.sqlteam.com/forums/
Thanks in advance for moving this to a different forum.
-----Original Message-----
From: Jonnalagadda, Sumithra [mailto:sumithra@amgen.com]
Sent: Friday, February 03, 2006 9:11 AM
To: 'Tapestry users'
Subject: For sql experts
SELECT DEPTNUM.REF_VALUE, CAMNUM.REF_VALUE, (SELECT PN1.NOTE_TEXT FROM
PARTY_NOTE PN 1WHERE PN.1PARTY_ID = DEPTNUM.PARTY_ID and
max(pn1.last_update_dt)) NOTE FROM PARTY_REFERENCE DEPTNUM, PARTY_REFERENCE
CAMNUM, PARTY_ASSOC REL WHERE DEPTNUM.PARTY_ID = REL.TO_PARTY_ID AND
REL.FROM_PARTY_ID = CAMNUM.PARTY_ID AND DEPTNUM.PARTY_REF_TYPE_CD = 'TYPE1
AND CAMNUM.PARTY_REF_TYPE_CD = 'TYPE2'
The problem is the the sub query
SELECT PN1.NOTE_TEXT FROM PARTY_NOTE PN 1WHERE PN.1PARTY_ID =
DEPTNUM.PARTY_ID and max(pn1.last_update_dt
is not working.
My requirement is in the sub query I want to select those notes with
last_update_dt is maximun for each party.
Any help is appriciated.
---------------------------------------------------------------------
To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tapestry-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tapestry-user-help@jakarta.apache.org
Re: ***Forum criminals labor uniun member*** let it be
Posted by Leonardo Quijano Vincenzi <le...@dtqsoftware.com>.
I don't agree. Ocassional OT is cool, nobody gets mad. But lets keep it
spare for everybody's sake. Some of us are receiving 50+ e-mails per
list, and that's a lot to sort through. It's easy to lose an important
conversation between OT posts.
This is not to flame every OTer... sometimes is nice to do it. Just
don't abuse.
--
Ing. Leonardo Quijano Vincenzi
DTQ Software
Patrick Casey wrote:
> I'm with Ron on this one. I don't mind the occasional OT post; I've been
> guilty of using this forum for non tapestry stuff myself and I don't see
> anything intrinsically wrong with it. Ultimately it's a community of like
> minded people, and folks are occasionally going to stray into OT land.
>
> I don't see that as a problem; rather I see it as a sign of the strength of
> the community.
>
> --- Pat
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tapestry-user-help@jakarta.apache.org
***Forum criminals labor uniun member*** playing with words :)
Posted by Ron Piterman <rp...@gmx.net>.
one should diffrenciate between bad role understanding, abuse, and
benefit - what he was doing is taking a benefit but not abusing -
otherwise I would have been the first one (or maybe second - if you draw
faster...) to shout ;-)
Aaron Bartell wrote:
> I disagree. If there was very little traffic (less than 20 posts a day) and
> it wasn't a high profile list then there would be few who would care and OT
> posts would be just fine. But this is a high profile list and it gets A LOT
> of posts a day.
>
> The fact of the matter is that for Sumithra to get an answer to a simple
> question it caused the other 500 people on this list to first read his email
> to see if they could help with his supposed Tapestry question. But after
> finding out that it wasn't a Tapestry question at all but rather laziness of
> finding the right forum they hit the delete key.
>
> In my mind there is a protocol to follow (at least that's how it works on
> the other mailing lists I frequent) and if somebody is posting something
> that is totally off topic then it should be addressed so other don't think
> it is ok to post off topic.
>
> I am not trying to make a big deal of this. If this is a forum that allows
> OT threads I will shut my trap.
>
> I drop my case (though I still agree with myself :-)
> Aaron Bartell
>
>
> -----Original Message-----
> From: Patrick Casey [mailto:patcasey@adelphia.net]
> Sent: Friday, February 03, 2006 10:49 AM
> To: 'Tapestry users'
> Subject: RE: ***Forum criminals labor uniun member*** let it be
>
>
> I'm with Ron on this one. I don't mind the occasional OT post; I've been
> guilty of using this forum for non tapestry stuff myself and I don't see
> anything intrinsically wrong with it. Ultimately it's a community of like
> minded people, and folks are occasionally going to stray into OT land.
>
> I don't see that as a problem; rather I see it as a sign of the strength of
> the community.
>
> --- Pat
>
>
>>-----Original Message-----
>>From: news [mailto:news@sea.gmane.org] On Behalf Of Ron Piterman
>>Sent: Friday, February 03, 2006 8:38 AM
>>To: tapestry-user@jakarta.apache.org
>>Subject: ***Forum criminals labor uniun member*** let it be
>>
>>this is one of the more friendly and high-response-rates forums I know
>>- so let the people enjoy...
>>cheers,
>>Ron
>>
>>
>>
>>
>>Aaron Bartell wrote:
>>
>>>Don't mean to be nitpicky but. .. to keep the list as focused as
>>
>>possible
>>
>>>it is best to not post something here that has nothing to do with
>>
>>Tapestry.
>>
>>>I know it is easy because you are already subscribed to this list,
>>>but
>>
>>there
>>
>>>are many SQL forums and mailing lists out there that this would be
>>>more appropriate in.
>
> <snip>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tapestry-user-help@jakarta.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tapestry-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tapestry-user-help@jakarta.apache.org
*** Union Representative*** :-)RE: ***Forum criminals labor uniun member*** let it be
Posted by Aaron Bartell <al...@gmail.com>.
I disagree. If there was very little traffic (less than 20 posts a day) and
it wasn't a high profile list then there would be few who would care and OT
posts would be just fine. But this is a high profile list and it gets A LOT
of posts a day.
The fact of the matter is that for Sumithra to get an answer to a simple
question it caused the other 500 people on this list to first read his email
to see if they could help with his supposed Tapestry question. But after
finding out that it wasn't a Tapestry question at all but rather laziness of
finding the right forum they hit the delete key.
In my mind there is a protocol to follow (at least that's how it works on
the other mailing lists I frequent) and if somebody is posting something
that is totally off topic then it should be addressed so other don't think
it is ok to post off topic.
I am not trying to make a big deal of this. If this is a forum that allows
OT threads I will shut my trap.
I drop my case (though I still agree with myself :-)
Aaron Bartell
-----Original Message-----
From: Patrick Casey [mailto:patcasey@adelphia.net]
Sent: Friday, February 03, 2006 10:49 AM
To: 'Tapestry users'
Subject: RE: ***Forum criminals labor uniun member*** let it be
I'm with Ron on this one. I don't mind the occasional OT post; I've been
guilty of using this forum for non tapestry stuff myself and I don't see
anything intrinsically wrong with it. Ultimately it's a community of like
minded people, and folks are occasionally going to stray into OT land.
I don't see that as a problem; rather I see it as a sign of the strength of
the community.
--- Pat
> -----Original Message-----
> From: news [mailto:news@sea.gmane.org] On Behalf Of Ron Piterman
> Sent: Friday, February 03, 2006 8:38 AM
> To: tapestry-user@jakarta.apache.org
> Subject: ***Forum criminals labor uniun member*** let it be
>
> this is one of the more friendly and high-response-rates forums I know
> - so let the people enjoy...
> cheers,
> Ron
>
>
>
>
> Aaron Bartell wrote:
> > Don't mean to be nitpicky but. .. to keep the list as focused as
> possible
> > it is best to not post something here that has nothing to do with
> Tapestry.
> > I know it is easy because you are already subscribed to this list,
> > but
> there
> > are many SQL forums and mailing lists out there that this would be
> > more appropriate in.
<snip>
---------------------------------------------------------------------
To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tapestry-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tapestry-user-help@jakarta.apache.org
RE: ***Forum criminals labor uniun member*** let it be
Posted by Patrick Casey <pa...@adelphia.net>.
I'm with Ron on this one. I don't mind the occasional OT post; I've been
guilty of using this forum for non tapestry stuff myself and I don't see
anything intrinsically wrong with it. Ultimately it's a community of like
minded people, and folks are occasionally going to stray into OT land.
I don't see that as a problem; rather I see it as a sign of the strength of
the community.
--- Pat
> -----Original Message-----
> From: news [mailto:news@sea.gmane.org] On Behalf Of Ron Piterman
> Sent: Friday, February 03, 2006 8:38 AM
> To: tapestry-user@jakarta.apache.org
> Subject: ***Forum criminals labor uniun member*** let it be
>
> this is one of the more friendly and high-response-rates forums I know -
> so let the people enjoy...
> cheers,
> Ron
>
>
>
>
> Aaron Bartell wrote:
> > Don't mean to be nitpicky but. .. to keep the list as focused as
> possible
> > it is best to not post something here that has nothing to do with
> Tapestry.
> > I know it is easy because you are already subscribed to this list, but
> there
> > are many SQL forums and mailing lists out there that this would be more
> > appropriate in.
<snip>
---------------------------------------------------------------------
To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tapestry-user-help@jakarta.apache.org
***Forum criminals labor uniun member*** let it be
Posted by Ron Piterman <rp...@gmx.net>.
this is one of the more friendly and high-response-rates forums I know -
so let the people enjoy...
cheers,
Ron
Aaron Bartell wrote:
> Don't mean to be nitpicky but. .. to keep the list as focused as possible
> it is best to not post something here that has nothing to do with Tapestry.
> I know it is easy because you are already subscribed to this list, but there
> are many SQL forums and mailing lists out there that this would be more
> appropriate in.
>
> A google search brings up some good results:
> http://www.google.com/search?hl=en&lr=&q=sql+forum
> http://forums.belution.com/en/sql/
> http://www.sqlteam.com/forums/
>
>
> Thanks in advance for moving this to a different forum.
>
>
> -----Original Message-----
> From: Jonnalagadda, Sumithra [mailto:sumithra@amgen.com]
> Sent: Friday, February 03, 2006 9:11 AM
> To: 'Tapestry users'
> Subject: For sql experts
>
>
> SELECT DEPTNUM.REF_VALUE, CAMNUM.REF_VALUE, (SELECT PN1.NOTE_TEXT FROM
> PARTY_NOTE PN 1WHERE PN.1PARTY_ID = DEPTNUM.PARTY_ID and
> max(pn1.last_update_dt)) NOTE FROM PARTY_REFERENCE DEPTNUM, PARTY_REFERENCE
> CAMNUM, PARTY_ASSOC REL WHERE DEPTNUM.PARTY_ID = REL.TO_PARTY_ID AND
> REL.FROM_PARTY_ID = CAMNUM.PARTY_ID AND DEPTNUM.PARTY_REF_TYPE_CD = 'TYPE1
> AND CAMNUM.PARTY_REF_TYPE_CD = 'TYPE2'
>
> The problem is the the sub query
> SELECT PN1.NOTE_TEXT FROM PARTY_NOTE PN 1WHERE PN.1PARTY_ID =
> DEPTNUM.PARTY_ID and max(pn1.last_update_dt
>
> is not working.
>
> My requirement is in the sub query I want to select those notes with
> last_update_dt is maximun for each party.
>
> Any help is appriciated.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tapestry-user-help@jakarta.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tapestry-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tapestry-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tapestry-user-help@jakarta.apache.org