PHWinfo banniere

Titres
PORTAIL ANNUAIRE ARTICLES COMPARATEUR HÉBERGEURS DEVIS FORUMS RÉDUCTEUR D'URL
Précédent   PHWinfo > Autres forums > Forum Programmation & Conception > comp.lang.php > OT - an SQL question
S'inscrire FAQ Membres Recherche Messages du jour Marquer les forums comme lus
OT - an SQL question

Réponse
 
LinkBack Outils de la discussion
Vieux 12/11/2007, 15h16   #26
Steve
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: OT - an SQL question


"Darko" <darko.maksimovic@gmail.com> wrote in message
news:1194836950.029815.172190@22g2000hsm.googlegro ups.com...
> On Nov 12, 1:00 am, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>> Shelly wrote:
>> > Jerry Stuckle wrote:
>> >> Shelly wrote:
>> >>> I know [Jerry and co.] that this is off-topic, but the sql group
>> >>> that I could find online doesn't have much traffic, so here goes.

>>
>> >>> I cam across this code:

>>
>> >>> SELECT AnnoID, AnnoTitle,
>> >>> (SELECT EventTitle FROM mEVENTS WHERE tblANNOUNCE.AnnoLink =
>> >>> mEVENTS.EventID)
>> >>> as AnnoLink,
>> >>> date_format(AnnoDate,'%M %D %Y') as date
>> >>> FROM tblANNOUNCE
>> >>> ORDER BY AnnoDate DESC, AnnoLink, AnnoTitle

>>
>> >>> I am having trouble reading this. Is this the same as:

>>
>> >>> SELECT a.AnnoID, AnnoTitle, e.EventTitle as AnnoLink,
>> >>> date_format(AnnoDate,'%M %D %Y') as date
>> >>> FROM tblANNOUNCE AS a, mEVENTS AS e
>> >>> WHERE a.AnnoLink = e,EventID
>> >>> ORDER BY date DESC, AnnoLink, AnnoTitle

>>
>> >>> In other words, do they do exactly the same thing? I can't get the
>> >>> former to run on the current version of MySQL. Apparantly (I was
>> >>> told) it ran on a later version of MySQL.

>>
>> >> Yes, it's off topic. And your inability to find comp.databases.mysql
>> >> does not excuse you posting it here.

>>
>> > I do not have access to comp.database.mysql on my news server and,
>> > frankly
>> > Jerry, I couldn't care less about your opinion here.

>>
>> Shelly,
>>
>> You can continue to be an asshole - or you can ask your ISP to carry
>> comp.databases.mysql. Or you can access it via google groups.
>>
>> But as long as you're posting off-topic subjects here because you're to
>> f'ing lazy to access the correct group. I will call you on it.
>>
>> Get it through your thick skull. This is NOT your personal group.
>> This is one for PHP.
>>
>> --
>> ==================
>> Remove the "x" from my email address
>> Jerry Stuckle
>> JDS Computer Training Corp.
>> jstuck...@attglobal.net
>> ==================

>
> Sorry for being direct, but while not rarely you post messages in form
> of:
> ".... asshole ..."


'not rarely' is about right. i was labeled 'asshole', 'stupid', 'lousy', and
'senseless' by jerry last week. apparently, he doesn't like being disagreed
with...especially if you back your argument(s) while he fails to be able to.



  Réponse avec citation
Vieux 12/11/2007, 15h17   #27
Steve
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: OT - an SQL question

ROFL

"Shelly" <sheldonlg.news@asap-consult.com> wrote in message
news:13jgetqcccdesce@corp.supernews.com...
>I wish to thank:
> Zeldorblat,
> Rik Wasmus,
> Darko,
> Anr Daemon, and
> Steve
> for your . As for Jerry, if you didn't read "OT"s, then you wouldn't
> have noticed that this thank you is top posted.
>
> --
> Shelly
>
>
>
> Jerry Stuckle wrote:
>> Shelly wrote:
>>> Jerry Stuckle wrote:
>>>> Hey - I call them like I see them.
>>>
>>> Me too, and I don't give a f-k about what self-appointed newsgroup
>>> nazis think. Oops, I just realized I am breaking my own rule of
>>> responding to you, but, oh well, rules were made to be broken.
>>>
>>> Hey somebody, go get Jerry a very big ladder. He needs it to get
>>> down from that super-high horse in order to take a crap once he
>>> loosens his extremely tight ass.
>>>
>>> Jerry, if you are to "stooooopid" to know what "OT - " means, then I
>>> can't it if you deign to read it. It was put there so that YOU
>>> wouldn't waste your time, but since all you seem to want to do is
>>> bitch, bitch, bitch, then I guess I wasted MY time putting it there.
>>>

>>
>> And it's no frigging excuse for you to post mysql questions here when
>> there are good mysql newsgroups for you to post in.
>>
>> Get it through your stoopid head - THIS IS NOT YOUR PERSONAL
>> GROUP!
>> POST YOUR MYSQL QUESTIONS IN A MYSQL NEWSGROUP AND STOP BUGGING US
>> WITH YOUR LAZINESS!

>
>



  Réponse avec citation
Vieux 12/11/2007, 15h19   #28
Steve
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: OT - an SQL question

'horse's ass'...ROF.

and since when have you EVER relied on PROOF to champion ANY of your
opinions, jerry?


"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:JI2dnWL93Oli16XanZ2dnUVZ_qPinZ2d@comcast.com. ..
> Shelly wrote:
>> I wish to thank:
>> Zeldorblat,
>> Rik Wasmus,
>> Darko,
>> Anr Daemon, and
>> Steve
>> for your . As for Jerry, if you didn't read "OT"s, then you wouldn't
>> have noticed that this thank you is top posted.
>>

>
> And you are a horse's ass, Shelly. This is even more proof.
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstucklex@attglobal.net
> ==================
>



  Réponse avec citation
Vieux 12/11/2007, 15h28   #29
Jerry Stuckle
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: OT - an SQL question

Steve wrote:
> "Darko" <darko.maksimovic@gmail.com> wrote in message
> news:1194836950.029815.172190@22g2000hsm.googlegro ups.com...
>> On Nov 12, 1:00 am, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>>> Shelly wrote:
>>>> Jerry Stuckle wrote:
>>>>> Shelly wrote:
>>>>>> I know [Jerry and co.] that this is off-topic, but the sql group
>>>>>> that I could find online doesn't have much traffic, so here goes.
>>>>>> I cam across this code:
>>>>>> SELECT AnnoID, AnnoTitle,
>>>>>> (SELECT EventTitle FROM mEVENTS WHERE tblANNOUNCE.AnnoLink =
>>>>>> mEVENTS.EventID)
>>>>>> as AnnoLink,
>>>>>> date_format(AnnoDate,'%M %D %Y') as date
>>>>>> FROM tblANNOUNCE
>>>>>> ORDER BY AnnoDate DESC, AnnoLink, AnnoTitle
>>>>>> I am having trouble reading this. Is this the same as:
>>>>>> SELECT a.AnnoID, AnnoTitle, e.EventTitle as AnnoLink,
>>>>>> date_format(AnnoDate,'%M %D %Y') as date
>>>>>> FROM tblANNOUNCE AS a, mEVENTS AS e
>>>>>> WHERE a.AnnoLink = e,EventID
>>>>>> ORDER BY date DESC, AnnoLink, AnnoTitle
>>>>>> In other words, do they do exactly the same thing? I can't get the
>>>>>> former to run on the current version of MySQL. Apparantly (I was
>>>>>> told) it ran on a later version of MySQL.
>>>>> Yes, it's off topic. And your inability to find comp.databases.mysql
>>>>> does not excuse you posting it here.
>>>> I do not have access to comp.database.mysql on my news server and,
>>>> frankly
>>>> Jerry, I couldn't care less about your opinion here.
>>> Shelly,
>>>
>>> You can continue to be an asshole - or you can ask your ISP to carry
>>> comp.databases.mysql. Or you can access it via google groups.
>>>
>>> But as long as you're posting off-topic subjects here because you're to
>>> f'ing lazy to access the correct group. I will call you on it.
>>>
>>> Get it through your thick skull. This is NOT your personal group.
>>> This is one for PHP.
>>>
>>> --
>>> ==================
>>> Remove the "x" from my email address
>>> Jerry Stuckle
>>> JDS Computer Training Corp.
>>> jstuck...@attglobal.net
>>> ==================

>> Sorry for being direct, but while not rarely you post messages in form
>> of:
>> ".... asshole ..."

>
> 'not rarely' is about right. i was labeled 'asshole', 'stupid', 'lousy', and
> 'senseless' by jerry last week. apparently, he doesn't like being disagreed
> with...especially if you back your argument(s) while he fails to be able to.
>
>
>
>


Maybe because that's how you acted?

You had no arguments. Rather, you kept trying to change the subject and
claim I said things I never did. Typical of your behavior when you
don't have an argument. As anyone who goes back and looks at the thread
can see.

I finally cut it off because you couldn't support your argument.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

  Réponse avec citation
Vieux 12/11/2007, 15h44   #30
Steve
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: OT - an SQL question


"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:7eCdnTnJ0-C7_qXanZ2dnUVZ_tjinZ2d@comcast.com...
> Steve wrote:
>> "Darko" <darko.maksimovic@gmail.com> wrote in message
>> news:1194836950.029815.172190@22g2000hsm.googlegro ups.com...
>>> On Nov 12, 1:00 am, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>>>> Shelly wrote:
>>>>> Jerry Stuckle wrote:
>>>>>> Shelly wrote:
>>>>>>> I know [Jerry and co.] that this is off-topic, but the sql group
>>>>>>> that I could find online doesn't have much traffic, so here goes.
>>>>>>> I cam across this code:
>>>>>>> SELECT AnnoID, AnnoTitle,
>>>>>>> (SELECT EventTitle FROM mEVENTS WHERE tblANNOUNCE.AnnoLink =
>>>>>>> mEVENTS.EventID)
>>>>>>> as AnnoLink,
>>>>>>> date_format(AnnoDate,'%M %D %Y') as date
>>>>>>> FROM tblANNOUNCE
>>>>>>> ORDER BY AnnoDate DESC, AnnoLink, AnnoTitle
>>>>>>> I am having trouble reading this. Is this the same as:
>>>>>>> SELECT a.AnnoID, AnnoTitle, e.EventTitle as AnnoLink,
>>>>>>> date_format(AnnoDate,'%M %D %Y') as date
>>>>>>> FROM tblANNOUNCE AS a, mEVENTS AS e
>>>>>>> WHERE a.AnnoLink = e,EventID
>>>>>>> ORDER BY date DESC, AnnoLink, AnnoTitle
>>>>>>> In other words, do they do exactly the same thing? I can't get the
>>>>>>> former to run on the current version of MySQL. Apparantly (I was
>>>>>>> told) it ran on a later version of MySQL.
>>>>>> Yes, it's off topic. And your inability to find comp.databases.mysql
>>>>>> does not excuse you posting it here.
>>>>> I do not have access to comp.database.mysql on my news server and,
>>>>> frankly
>>>>> Jerry, I couldn't care less about your opinion here.
>>>> Shelly,
>>>>
>>>> You can continue to be an asshole - or you can ask your ISP to carry
>>>> comp.databases.mysql. Or you can access it via google groups.
>>>>
>>>> But as long as you're posting off-topic subjects here because you're to
>>>> f'ing lazy to access the correct group. I will call you on it.
>>>>
>>>> Get it through your thick skull. This is NOT your personal group.
>>>> This is one for PHP.
>>>>
>>>> --
>>>> ==================
>>>> Remove the "x" from my email address
>>>> Jerry Stuckle
>>>> JDS Computer Training Corp.
>>>> jstuck...@attglobal.net
>>>> ==================
>>> Sorry for being direct, but while not rarely you post messages in form
>>> of:
>>> ".... asshole ..."

>>
>> 'not rarely' is about right. i was labeled 'asshole', 'stupid', 'lousy',
>> and 'senseless' by jerry last week. apparently, he doesn't like being
>> disagreed with...especially if you back your argument(s) while he fails
>> to be able to.

>
> Maybe because that's how you acted?


jerry, you've seen my posts. i was quite polite. before the final post, i
didn't even levy anything remotely vulgar. and in the final post when i did,
it was frustration that was not directed at you. go back at re-read that
post.

> You had no arguments.


jerry, in all of my at least 7 posts, there were multiple arguments made
*and* supported. your argument was that you didn't like the way i formatted
sql. your reasoning was because my way took up screen space. i made several
counters to that which made sense to more than just me. but, THAT was where
your support ended.

don't tell me i had NO arguments. especially when i clearly worked circles
around your single argument. in the end, you opinion revolved around 'jerry
likes it this way because jerry likes it this way'...and, i really don't
care what jerry likes or dislikes.

> Rather, you kept trying to change the subject and claim I said things I
> never did.


you chimed in with a subject change. i kept trying to get you to see the
point was formatting sql, not HOW STEVE FORMATS SQL. you snipped out all of
that and in its place, posted '<crap>'. great rebuttal. lol.

> Typical of your behavior when you don't have an argument. As anyone who
> goes back and looks at the thread can see.


yeah, you should only hope no one does. then you'll be defending your
audacious attitude in more than JUST THIS THREAD today. roflmao!

> I finally cut it off because you couldn't support your argument.


dude! were you on the SAME subject, you'd notice i was. however on YOUR
subject - an irrelevant tangent, btw - there's no point in arguing that my
opinion is better or worse than someone elses. get over it already!

screen-space?! really jerry? THAT is supporting an argument? i'm busting a
gut...all over again!


  Réponse avec citation
Vieux 12/11/2007, 15h48   #31
Steve
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: OT - an SQL question


"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:7eCdnTnJ0-C7_qXanZ2dnUVZ_tjinZ2d@comcast.com...
> Steve wrote:
>> "Darko" <darko.maksimovic@gmail.com> wrote in message
>> news:1194836950.029815.172190@22g2000hsm.googlegro ups.com...
>>> On Nov 12, 1:00 am, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>>>> Shelly wrote:
>>>>> Jerry Stuckle wrote:
>>>>>> Shelly wrote:

> Maybe because that's how you acted?
>
> You had no arguments. Rather, you kept trying to change the subject and
> claim I said things I never did. Typical of your behavior when you don't
> have an argument. As anyone who goes back and looks at the thread can
> see.
>
> I finally cut it off because you couldn't support your argument.


and jerry, let me end with restating the following that you won't address.
it's the false accusation that can be refuted WITH PROOF. but again, and
that which lead me to state here that you do not care for proof, you just
shut down when you can't back yourself up. here it is:

====

jerry stuckle:

> And you should see who started the insults.


me:

really? make a bet with you. go to the earliest thread that you can and
quote the insult i flung at you. i'll do the same. the one who has the
earliest date stamp wins, ok?

let's get started...

Message-ID: <8YCdndIBAbkzsq7anZ2dnUVZ_hmtnZ2d@comcast.com>

jerry: "Don't be an asshole again, Steve"
jerry: "Yep, programmers with any sense don't do it that way."
jerry: "I said the way you did it is stupid."
jerry: "But like anyone with no argument, you keep
trying to put words into my mouth."

wow, i almost quoted the ENTIRE response dated: 2007-11-08 11:47 AM !!!

ok, now it's your turn.


  Réponse avec citation
Vieux 12/11/2007, 16h54   #32
Darko
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: OT - an SQL question

On Nov 12, 3:13 pm, "Steve" <no....@example.com> wrote:
> "Darko" <darko.maksimo...@gmail.com> wrote in message
>
> news:1194836894.792496.171840@c30g2000hsa.googlegr oups.com...
>
>
>
> > On Nov 11, 2:53 am, "Shelly" <sheldonlg.n...@asap-consult.com> wrote:
> >> ZeldorBlat wrote:
> >> > On Nov 10, 8:29 pm, "Shelly" <sheldonlg.n...@asap-consult.com> wrote:
> >> >> I know [Jerry and co.] that this is off-topic, but the sql group
> >> >> that I could find online doesn't have much traffic, so here goes.

>
> >> >> I cam across this code:

>
> >> >> SELECT AnnoID, AnnoTitle,
> >> >> (SELECT EventTitle FROM mEVENTS WHERE tblANNOUNCE.AnnoLink =
> >> >> mEVENTS.EventID)
> >> >> as AnnoLink,
> >> >> date_format(AnnoDate,'%M %D %Y') as date
> >> >> FROM tblANNOUNCE
> >> >> ORDER BY AnnoDate DESC, AnnoLink, AnnoTitle

>
> >> >> I am having trouble reading this. Is this the same as:

>
> >> >> SELECT a.AnnoID, AnnoTitle, e.EventTitle as AnnoLink,
> >> >> date_format(AnnoDate,'%M %D %Y') as date
> >> >> FROM tblANNOUNCE AS a, mEVENTS AS e
> >> >> WHERE a.AnnoLink = e,EventID
> >> >> ORDER BY date DESC, AnnoLink, AnnoTitle

>
> >> >> In other words, do they do exactly the same thing? I can't get the
> >> >> former to run on the current version of MySQL. Apparantly (I was
> >> >> told) it ran on a later version of MySQL.

>
> >> > They should be the same. I generally see the first type of query when
> >> > someone doesn't really understand joins. It also typically results in
> >> > horrible performance.

>
> >> Hmmm. I learned the second type about 25 years ago and is always how I
> >> do
> >> those joins. My client's customer changed servers and the new server has
> >> an
> >> older version of MySQL. They ran into problems with many queries. I
> >> started looking at the code, and the first one I came accross was the
> >> first
> >> version (longer in length, I stripped it down for the posting). I copied
> >> that code and went to phpmyadmin and did a sql query. It barfed and
> >> complained mightily on the sub-select. I tried to analyze what the
> >> original
> >> coder was intending to do, and came up with the second one (I wrote that
> >> one). That one worked. I just wanted some verification from other
> >> professionals that I was reading the original correctly in what the coder
> >> was intending to do -- before I proceeded on my merry way modifying code
> >> in
> >> some twenty modules.

>
> >> --
> >> Shelly

>
> > Theoretically, the two give the same results, because they're both
> > Descartes' product
> > of all rows. However, as Steve pointed out, SQL server might make a
> > different execution
> > plan if it counters a normal join. There are, however, more problems
> > with this - what happens
> > if the subquery returns more than one result? Also, I think sql server
> > will do "jumps" on each
> > row, instead of multiplying them all and then remove the ones not
> > meeting the given criteria.

>
> do you mean a 'cartesian' product? all rows in a * all rows in b == total
> rows joined? i don't think that's what's going on here. it's a 'good' join
> as a sub-select because it there is criteria on the sub-select that will
> match rows with equality.
>
> you are correct though re. multiple rows retuned in the sub-select. that's
> another reason to do a formal join.


Yes, I meant Cartesian. Cartesian is names after Descartes, so I said
it that way.

  Réponse avec citation
Vieux 12/11/2007, 16h58   #33
Darko
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: OT - an SQL question

On Nov 12, 1:17 pm, "Shelly" <sheldonlg.n...@asap-consult.com> wrote:
> Gary L. Burnore wrote:
> > On Mon, 12 Nov 2007 06:39:42 -0500, "Shelly"
> > <sheldonlg.n...@asap-consult.com> top posted like an ignorant moron
> > and wrote:

>
> >> I wish to thank:
> >> Zeldorblat,
> >> Rik Wasmus,
> >> Darko,
> >> Anr Daemon, and
> >> Steve
> >> for your . As for Jerry, if you didn't read "OT"s, then you
> >> wouldn't have noticed that this thank you is top posted.

>
> > Maybe you should start using [TP] so we know you don't care?

>
> That was top posted for the benefit of one, and only one, person. Except
> for "thank you's", I always in-line post.
>
> --
> Shelly


You're welcome, really, but please don't think we encourage you to do
off topics,
even when supplied with OT in the title; it's not a big excuse, and is
generally
not tolerated in any newsgroup.

I might have criticized Jerry for "asshole" words, but I wouldn't like
to be misunderstood
as support to you, because Jerry is definitely right in the whole
issue, but he just
doesn't realize that swearing collides with netiquette just as well as
writing off topics.

  Réponse avec citation
Vieux 12/11/2007, 17h00   #34
Steve
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: OT - an SQL question


"Darko" <darko.maksimovic@gmail.com> wrote in message
news:1194882858.888294.110260@v2g2000hsf.googlegro ups.com...
> On Nov 12, 3:13 pm, "Steve" <no....@example.com> wrote:
>> "Darko" <darko.maksimo...@gmail.com> wrote in message
>>
>> news:1194836894.792496.171840@c30g2000hsa.googlegr oups.com...
>>
>>
>>
>> > On Nov 11, 2:53 am, "Shelly" <sheldonlg.n...@asap-consult.com> wrote:
>> >> ZeldorBlat wrote:
>> >> > On Nov 10, 8:29 pm, "Shelly" <sheldonlg.n...@asap-consult.com>
>> >> > wrote:
>> >> >> I know [Jerry and co.] that this is off-topic, but the sql group
>> >> >> that I could find online doesn't have much traffic, so here goes.

>>
>> >> >> I cam across this code:

>>
>> >> >> SELECT AnnoID, AnnoTitle,
>> >> >> (SELECT EventTitle FROM mEVENTS WHERE tblANNOUNCE.AnnoLink =
>> >> >> mEVENTS.EventID)
>> >> >> as AnnoLink,
>> >> >> date_format(AnnoDate,'%M %D %Y') as date
>> >> >> FROM tblANNOUNCE
>> >> >> ORDER BY AnnoDate DESC, AnnoLink, AnnoTitle

>>
>> >> >> I am having trouble reading this. Is this the same as:

>>
>> >> >> SELECT a.AnnoID, AnnoTitle, e.EventTitle as AnnoLink,
>> >> >> date_format(AnnoDate,'%M %D %Y') as date
>> >> >> FROM tblANNOUNCE AS a, mEVENTS AS e
>> >> >> WHERE a.AnnoLink = e,EventID
>> >> >> ORDER BY date DESC, AnnoLink, AnnoTitle

>>
>> >> >> In other words, do they do exactly the same thing? I can't get the
>> >> >> former to run on the current version of MySQL. Apparantly (I was
>> >> >> told) it ran on a later version of MySQL.

>>
>> >> > They should be the same. I generally see the first type of query
>> >> > when
>> >> > someone doesn't really understand joins. It also typically results
>> >> > in
>> >> > horrible performance.

>>
>> >> Hmmm. I learned the second type about 25 years ago and is always how
>> >> I
>> >> do
>> >> those joins. My client's customer changed servers and the new server
>> >> has
>> >> an
>> >> older version of MySQL. They ran into problems with many queries. I
>> >> started looking at the code, and the first one I came accross was the
>> >> first
>> >> version (longer in length, I stripped it down for the posting). I
>> >> copied
>> >> that code and went to phpmyadmin and did a sql query. It barfed and
>> >> complained mightily on the sub-select. I tried to analyze what the
>> >> original
>> >> coder was intending to do, and came up with the second one (I wrote
>> >> that
>> >> one). That one worked. I just wanted some verification from other
>> >> professionals that I was reading the original correctly in what the
>> >> coder
>> >> was intending to do -- before I proceeded on my merry way modifying
>> >> code
>> >> in
>> >> some twenty modules.

>>
>> >> --
>> >> Shelly

>>
>> > Theoretically, the two give the same results, because they're both
>> > Descartes' product
>> > of all rows. However, as Steve pointed out, SQL server might make a
>> > different execution
>> > plan if it counters a normal join. There are, however, more problems
>> > with this - what happens
>> > if the subquery returns more than one result? Also, I think sql server
>> > will do "jumps" on each
>> > row, instead of multiplying them all and then remove the ones not
>> > meeting the given criteria.

>>
>> do you mean a 'cartesian' product? all rows in a * all rows in b == total
>> rows joined? i don't think that's what's going on here. it's a 'good'
>> join
>> as a sub-select because it there is criteria on the sub-select that will
>> match rows with equality.
>>
>> you are correct though re. multiple rows retuned in the sub-select.
>> that's
>> another reason to do a formal join.

>
> Yes, I meant Cartesian. Cartesian is names after Descartes, so I said
> it that way.


makes sense.


  Réponse avec citation
Vieux 12/11/2007, 17h09   #35
Steve
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: OT - an SQL question


"Darko" <darko.maksimovic@gmail.com> wrote in message
news:1194883114.254275.311400@19g2000hsx.googlegro ups.com...
> On Nov 12, 1:17 pm, "Shelly" <sheldonlg.n...@asap-consult.com> wrote:
>> Gary L. Burnore wrote:
>> > On Mon, 12 Nov 2007 06:39:42 -0500, "Shelly"
>> > <sheldonlg.n...@asap-consult.com> top posted like an ignorant moron
>> > and wrote:

>>
>> >> I wish to thank:
>> >> Zeldorblat,
>> >> Rik Wasmus,
>> >> Darko,
>> >> Anr Daemon, and
>> >> Steve
>> >> for your . As for Jerry, if you didn't read "OT"s, then you
>> >> wouldn't have noticed that this thank you is top posted.

>>
>> > Maybe you should start using [TP] so we know you don't care?

>>
>> That was top posted for the benefit of one, and only one, person. Except
>> for "thank you's", I always in-line post.
>>
>> --
>> Shelly

>
> You're welcome, really, but please don't think we encourage you to do
> off topics,
> even when supplied with OT in the title; it's not a big excuse, and is
> generally
> not tolerated in any newsgroup.
>
> I might have criticized Jerry for "asshole" words, but I wouldn't like
> to be misunderstood
> as support to you, because Jerry is definitely right in the whole
> issue, but he just
> doesn't realize that swearing collides with netiquette just as well as
> writing off topics.


i've been where shel has been though. w/lamp is almost a consolidated
subject. however, if you have a question about something *other than* apache
or php, you could wait for days getting a response. there are a scarce few
who use php on windows but plenty of windows usenet groups. however, if you
post your question here about php/windows config, you'll get a quick
response - if you weed out the jerry stuckle diatribes. same for
mysql...there just aren't many people checking that group as regularly -
much less, qualified respondents.

just ignore those to whom you think should post elsewhere. i mean, not
getting a response is the reason for shel (or others) to post the question
here in the first place. right?

the only time i have a problem is when it is clear the op has NOT rtfm
and/or posts ot here without the thought of posting elsewhere more
appropriate to the nature of the question. as it is, shel has pased both my
criteria here...so, i tried to give the best answer i could in the most
polite fashion i could.

cheers.


  Réponse avec citation
Vieux 12/11/2007, 19h20   #36
Shelly
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: OT - an SQL question

Darko wrote:
> On Nov 12, 1:17 pm, "Shelly" <sheldonlg.n...@asap-consult.com> wrote:
>> Gary L. Burnore wrote:
>>> On Mon, 12 Nov 2007 06:39:42 -0500, "Shelly"
>>> <sheldonlg.n...@asap-consult.com> top posted like an ignorant moron
>>> and wrote:

>>
>>>> I wish to thank:
>>>> Zeldorblat,
>>>> Rik Wasmus,
>>>> Darko,
>>>> Anr Daemon, and
>>>> Steve
>>>> for your . As for Jerry, if you didn't read "OT"s, then you
>>>> wouldn't have noticed that this thank you is top posted.

>>
>>> Maybe you should start using [TP] so we know you don't care?

>>
>> That was top posted for the benefit of one, and only one, person.
>> Except for "thank you's", I always in-line post.
>>
>> --
>> Shelly

>
> You're welcome, really, but please don't think we encourage you to do
> off topics,


I don't.

> even when supplied with OT in the title; it's not a big excuse, and is
> generally
> not tolerated in any newsgroup.


I agree, and so try to keep it to an absolute minimum. It is only when I
can't get at the answer through regular channels.....

> I might have criticized Jerry for "asshole" words, but I wouldn't like
> to be misunderstood
> as support to you, because Jerry is definitely right in the whole
> issue, but he just


I know he is concerning the off-topics and top-posting. I agree with him on
those. This reminds me of something. I used to work for a French company
and every three months I would go to Paris for a week on business. They
told me the difference between the Germans, the French and the Americans.

To the Germans a schedule is just that. You stick to the schedule --- even
it no longer makes sense.
To the French a schedule is a suggestion.
To the Americans a schedule is just that, but you can change the schedule to
changing conditions.

I like to think of myself as American. I guess Jerry is "German".

Another way of looking at it is that there is always a small percentage of
bugs and stuff in all the processed food we eat. It is kept below some very
low level. If we insisted on absolutely zero level, then we would starve.
I like to eat.

So while I generally follow the rules, there ARE exceptions. To minimize
the effect of that, I put our a roadsign of "OT:". Unfortuanately, some
people can't drive.

> doesn't realize that swearing collides with netiquette just as well as
> writing off topics.


YOU CAN SAY THAT AGAIN.

--
Shelly
(notice that the sig follows netiquette (once I learned about it).


  Réponse avec citation
Vieux 12/11/2007, 21h17   #37
Sanders Kaufman
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: OT - an SQL question

Just look for the google return address - it's a sure bet, the post will be
top-posted.

But times are a-changing, and a new breed is coming up in the ranks.
They top-post.
We can fight it, or we can capitalize on it.




"The Natural Philosopher" <a@b.c> wrote in message
news:1194870434.66200.2@demeter.uk.clara.net...
> Good idea!
>
>
> Gary L. Burnore wrote:
>> On Mon, 12 Nov 2007 06:39:42 -0500, "Shelly"
>> <sheldonlg.news@asap-consult.com> top posted like an ignorant moron
>> and wrote:
>>
>>> I wish to thank:
>>> Zeldorblat,
>>> Rik Wasmus,
>>> Darko,
>>> Anr Daemon, and
>>> Steve
>>> for your . As for Jerry, if you didn't read "OT"s, then you
>>> wouldn't have noticed that this thank you is top posted.

>>
>> Maybe you should start using [TP] so we know you don't care?
>>



  Réponse avec citation
Vieux 13/11/2007, 12h25   #38
1001 Webs
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: OT - an SQL question

On Nov 12, 7:20 pm, "Shelly" <sheldonlg.n...@asap-consult.com> wrote:
> Darko wrote:
> > On Nov 12, 1:17 pm, "Shelly" <sheldonlg.n...@asap-consult.com> wrote:
> >> Gary L. Burnore wrote:
> >>> On Mon, 12 Nov 2007 06:39:42 -0500, "Shelly"
> >>> <sheldonlg.n...@asap-consult.com> top posted like an ignorant moron
> >>> and wrote:

>
> >>>> I wish to thank:
> >>>> Zeldorblat,
> >>>> Rik Wasmus,
> >>>> Darko,
> >>>> Anr Daemon, and
> >>>> Steve
> >>>> for your . As for Jerry, if you didn't read "OT"s, then you
> >>>> wouldn't have noticed that this thank you is top posted.

>
> >>> Maybe you should start using [TP] so we know you don't care?

>
> >> That was top posted for the benefit of one, and only one, person.
> >> Except for "thank you's", I always in-line post.

>
> >> --
> >> Shelly

>
> > You're welcome, really, but please don't think we encourage you to do
> > off topics,

>
> I don't.
>
> > even when supplied with OT in the title; it's not a big excuse, and is
> > generally
> > not tolerated in any newsgroup.

>
> I agree, and so try to keep it to an absolute minimum. It is only when I
> can't get at the answer through regular channels.....
>
> > I might have criticized Jerry for "asshole" words, but I wouldn't like
> > to be misunderstood
> > as support to you, because Jerry is definitely right in the whole
> > issue, but he just

>
> I know he is concerning the off-topics and top-posting. I agree with him on
> those. This reminds me of something. I used to work for a French company
> and every three months I would go to Paris for a week on business. They
> told me the difference between the Germans, the French and the Americans.
>
> To the Germans a schedule is just that. You stick to the schedule --- even
> it no longer makes sense.
> To the French a schedule is a suggestion.
> To the Americans a schedule is just that, but you can change the schedule to
> changing conditions.
>
> I like to think of myself as American. I guess Jerry is "German".
>
> Another way of looking at it is that there is always a small percentage of
> bugs and stuff in all the processed food we eat. It is kept below some very
> low level. If we insisted on absolutely zero level, then we would starve.
> I like to eat.
>
> So while I generally follow the rules, there ARE exceptions. To minimize
> the effect of that, I put our a roadsign of "OT:". Unfortuanately, some
> people can't drive.
>
> > doesn't realize that swearing collides with netiquette just as well as
> > writing off topics.

>
> YOU CAN SAY THAT AGAIN.


You'd better agree to everything Jerry says, Shelly.
Or else, he will beat you up as he did with his wife:
Court System: DISTRICT COURT FOR MONTGOMERY COUNTY - CIVIL SYSTEM
Case Number: 0602SP019022003 Claim TypeOMESTIC VIOLENCE
Complaint No: 001(STUCKLE, ELIZABETH M) VsSTUCKLE, JERRY D )

  Réponse avec citation
Vieux 13/11/2007, 13h37   #39
Jerry Stuckle
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: OT - an SQL question

1001 Webs wrote:
> On Nov 12, 7:20 pm, "Shelly" <sheldonlg.n...@asap-consult.com> wrote:
>> Darko wrote:
>>> On Nov 12, 1:17 pm, "Shelly" <sheldonlg.n...@asap-consult.com> wrote:
>>>> Gary L. Burnore wrote:
>>>>> On Mon, 12 Nov 2007 06:39:42 -0500, "Shelly"
>>>>> <sheldonlg.n...@asap-consult.com> top posted like an ignorant moron
>>>>> and wrote:
>>>>>> I wish to thank:
>>>>>> Zeldorblat,
>>>>>> Rik Wasmus,
>>>>>> Darko,
>>>>>> Anr Daemon, and
>>>>>> Steve
>>>>>> for your . As for Jerry, if you didn't read "OT"s, then you
>>>>>> wouldn't have noticed that this thank you is top posted.
>>>>> Maybe you should start using [TP] so we know you don't care?
>>>> That was top posted for the benefit of one, and only one, person.
>>>> Except for "thank you's", I always in-line post.
>>>> --
>>>> Shelly
>>> You're welcome, really, but please don't think we encourage you to do
>>> off topics,

>> I don't.
>>
>>> even when supplied with OT in the title; it's not a big excuse, and is
>>> generally
>>> not tolerated in any newsgroup.

>> I agree, and so try to keep it to an absolute minimum. It is only when I
>> can't get at the answer through regular channels.....
>>
>>> I might have criticized Jerry for "asshole" words, but I wouldn't like
>>> to be misunderstood
>>> as support to you, because Jerry is definitely right in the whole
>>> issue, but he just

>> I know he is concerning the off-topics and top-posting. I agree with him on
>> those. This reminds me of something. I used to work for a French company
>> and every three months I would go to Paris for a week on business. They
>> told me the difference between the Germans, the French and the Americans.
>>
>> To the Germans a schedule is just that. You stick to the schedule --- even
>> it no longer makes sense.
>> To the French a schedule is a suggestion.
>> To the Americans a schedule is just that, but you can change the schedule to
>> changing conditions.
>>
>> I like to think of myself as American. I guess Jerry is "German".
>>
>> Another way of looking at it is that there is always a small percentage of
>> bugs and stuff in all the processed food we eat. It is kept below some very
>> low level. If we insisted on absolutely zero level, then we would starve.
>> I like to eat.
>>
>> So while I generally follow the rules, there ARE exceptions. To minimize
>> the effect of that, I put our a roadsign of "OT:". Unfortuanately, some
>> people can't drive.
>>
>>> doesn't realize that swearing collides with netiquette just as well as
>>> writing off topics.

>> YOU CAN SAY THAT AGAIN.

>
> You'd better agree to everything Jerry says, Shelly.
> Or else, he will beat you up as he did with his wife:
> Court System: DISTRICT COURT FOR MONTGOMERY COUNTY - CIVIL SYSTEM
> Case Number: 0602SP019022003 Claim TypeOMESTIC VIOLENCE
> Complaint No: 001(STUCKLE, ELIZABETH M) VsSTUCKLE, JERRY D )
>
>


ROFLMAO! This troll is following me around all over the internet now!

For those who don't know him, he's Ahmed Hendy, 35 Avda America, Madrid,
Spain. He thinks he's a web designer/developer, but he isn't.

He's just another troll. But he isn't even as smart as the hatter.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

  Réponse avec citation
Vieux 13/11/2007, 15h08   #40
Steve
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: OT - an SQL question


"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news92dnf8lXdPkB6TanZ2dnUVZ_u3inZ2d@comcast.com. ..
> 1001 Webs wrote:
>> On Nov 12, 7:20 pm, "Shelly" <sheldonlg.n...@asap-consult.com> wrote:
>>> Darko wrote:
>>>> On Nov 12, 1:17 pm, "Shelly" <sheldonlg.n...@asap-consult.com> wrote:
>>>>> Gary L. Burnore wrote:
>>>>>> On Mon, 12 Nov 2007 06:39:42 -0500, "Shelly"
>>>>>> <sheldonlg.n...@asap-consult.com> top posted like an ignorant moron
>>>>>> and wrote:
>>>>>>> I wish to thank:
>>>>>>> Zeldorblat,
>>>>>>> Rik Wasmus,
>>>>>>> Darko,
>>>>>>> Anr Daemon, and
>>>>>>> Steve
>>>>>>> for your . As for Jerry, if you didn't read "OT"s, then you
>>>>>>> wouldn't have noticed that this thank you is top posted.
>>>>>> Maybe you should start using [TP] so we know you don't care?
>>>>> That was top posted for the benefit of one, and only one, person.
>>>>> Except for "thank you's", I always in-line post.
>>>>> --
>>>>> Shelly
>>>> You're welcome, really, but please don't think we encourage you to do
>>>> off topics,
>>> I don't.
>>>
>>>> even when supplied with OT in the title; it's not a big excuse, and is
>>>> generally
>>>> not tolerated in any newsgroup.
>>> I agree, and so try to keep it to an absolute minimum. It is only when
>>> I
>>> can't get at the answer through regular channels.....
>>>
>>>> I might have criticized Jerry for "asshole" words, but I wouldn't like
>>>> to be misunderstood
>>>> as support to you, because Jerry is definitely right in the whole
>>>> issue, but he just
>>> I know he is concerning the off-topics and top-posting. I agree with
>>> him on
>>> those. This reminds me of something. I used to work for a French
>>> company
>>> and every three months I would go to Paris for a week on business. They
>>> told me the difference between the Germans, the French and the
>>> Americans.
>>>
>>> To the Germans a schedule is just that. You stick to the schedule ---
>>> even
>>> it no longer makes sense.
>>> To the French a schedule is a suggestion.
>>> To the Americans a schedule is just that, but you can change the
>>> schedule to
>>> changing conditions.
>>>
>>> I like to think of myself as American. I guess Jerry is "German".
>>>
>>> Another way of looking at it is that there is always a small percentage
>>> of
>>> bugs and stuff in all the processed food we eat. It is kept below some
>>> very
>>> low level. If we insisted on absolutely zero level, then we would
>>> starve.
>>> I like to eat.
>>>
>>> So while I generally follow the rules, there ARE exceptions. To
>>> minimize
>>> the effect of that, I put our a roadsign of "OT:". Unfortuanately, some
>>> people can't drive.
>>>
>>>> doesn't realize that swearing collides with netiquette just as well as
>>>> writing off topics.
>>> YOU CAN SAY THAT AGAIN.

>>
>> You'd better agree to everything Jerry says, Shelly.
>> Or else, he will beat you up as he did with his wife:
>> Court System: DISTRICT COURT FOR MONTGOMERY COUNTY - CIVIL SYSTEM
>> Case Number: 0602SP019022003 Claim TypeOMESTIC VIOLENCE
>> Complaint No: 001(STUCKLE, ELIZABETH M) VsSTUCKLE, JERRY D )
>>
>>

>
> ROFLMAO! This troll is following me around all over the internet now!
>
> For those who don't know him, he's Ahmed Hendy, 35 Avda America, Madrid,
> Spain. He thinks he's a web designer/developer, but he isn't.
>
> He's just another troll. But he isn't even as smart as the hatter.


ooooo! that's probably the worst thing that could be said of another human
being! in fact, i didn't think that was possible.


  Réponse avec citation
Vieux 13/11/2007, 15h23   #41
1001 Webs
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: OT - an SQL question

On Nov 13, 1:37 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
> 1001 Webs wrote:
> > On Nov 12, 7:20 pm, "Shelly" <sheldonlg.n...@asap-consult.com> wrote:
> >> Darko wrote:
> >>> On Nov 12, 1:17 pm, "Shelly" <sheldonlg.n...@asap-consult.com> wrote:
> >>>> Gary L. Burnore wrote:
> >>>>> On Mon, 12 Nov 2007 06:39:42 -0500, "Shelly"
> >>>>> <sheldonlg.n...@asap-consult.com> top posted like an ignorant moron
> >>>>> and wrote:
> >>>>>> I wish to thank:
> >>>>>> Zeldorblat,
> >>>>>> Rik Wasmus,
> >>>>>> Darko,
> >>>>>> Anr Daemon, and
> >>>>>> Steve
> >>>>>> for your . As for Jerry, if you didn't read "OT"s, then you
> >>>>>> wouldn't have noticed that this thank you is top posted.
> >>>>> Maybe you should start using [TP] so we know you don't care?
> >>>> That was top posted for the benefit of one, and only one, person.
> >>>> Except for "thank you's", I always in-line post.
> >>>> --
> >>>> Shelly
> >>> You're welcome, really, but please don't think we encourage you to do
> >>> off topics,
> >> I don't.

>
> >>> even when supplied with OT in the title; it's not a big excuse, and is
> >>> generally
> >>> not tolerated in any newsgroup.
> >> I agree, and so try to keep it to an absolute minimum. It is only when I
> >> can't get at the answer through regular channels.....

>
> >>> I might have criticized Jerry for "asshole" words, but I wouldn't like
> >>> to be misunderstood
> >>> as support to you, because Jerry is definitely right in the whole
> >>> issue, but he just
> >> I know he is concerning the off-topics and top-posting. I agree with him on
> >> those. This reminds me of something. I used to work for a French company
> >> and every three months I would go to Paris for a week on business. They
> >> told me the difference between the Germans, the French and the Americans.

>
> >> To the Germans a schedule is just that. You stick to the schedule --- even
> >> it no longer makes sense.
> >> To the French a schedule is a suggestion.
> >> To the Americans a schedule is just that, but you can change the schedule to
> >> changing conditions.

>
> >> I like to think of myself as American. I guess Jerry is "German".

>
> >> Another way of looking at it is that there is always a small percentage of
> >> bugs and stuff in all the processed food we eat. It is kept below some very
> >> low level. If we insisted on absolutely zero level, then we would starve.
> >> I like to eat.

>
> >> So while I generally follow the rules, there ARE exceptions. To minimize
> >> the effect of that, I put our a roadsign of "OT:". Unfortuanately, some
> >> people can't drive.

>
> >>> doesn't realize that swearing collides with netiquette just as well as
> >>> writing off topics.
> >> YOU CAN SAY THAT AGAIN.

>
> > You'd better agree to everything Jerry says, Shelly.
> > Or else, he will beat you up as he did with his wife:
> > Court System: DISTRICT COURT FOR MONTGOMERY COUNTY - CIVIL SYSTEM
> > Case Number: 0602SP019022003 Claim TypeOMESTIC VIOLENCE
> > Complaint No: 001(STUCKLE, ELIZABETH M) VsSTUCKLE, JERRY D )

>
> ROFLMAO! This troll is following me around all over the internet now!
>
> For those who don't know him, he's Ahmed Hendy, 35 Avda America, Madrid,
> Spain. He thinks he's a web designer/developer, but he isn't.



Taxpayer Services Division

Entity Name: SMARTECH HOMES, INC.
Dept ID #: D07297567

Principal Office (Current): 9920 BRIXTON LANE, BETHESDA, MD 20817
Resident Agent (Current): JERRY D. STUCKLE, 9920 BRIXTON LANE,
BETHESDA, MD 20817

DEPT. ACTION - FORFEITURE 10/06/2006 12:03-AM
THE ENTITY WAS FORFEITED FOR FAILURE TO FILE PROPERTY RETURN FOR 2005.
For a Maryland entity, its existence has been ended by the State for
some delinquency.

Good Standing: No

-----------------------------------------------------
Kind Regards,

Rafael Martinez-Minuesa

www.1001webs.net
Puerto Marina, Benalmadena,
MALAGA - 29630
Spain
Phone: +34.620443347
EmailAddress: info-at-1001webs.net

  Réponse avec citation
Vieux 13/11/2007, 15h25   #42
Jerry Stuckle
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: OT - an SQL question

1001 Webs wrote:
> On Nov 13, 1:37 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>> 1001 Webs wrote:
>>> On Nov 12, 7:20 pm, "Shelly" <sheldonlg.n...@asap-consult.com> wrote:
>>>> Darko wrote:
>>>>> On Nov 12, 1:17 pm, "Shelly" <sheldonlg.n...@asap-consult.com> wrote:
>>>>>> Gary L. Burnore wrote:
>>>>>>> On Mon, 12 Nov 2007 06:39:42 -0500, "Shelly"
>>>>>>> <sheldonlg.n...@asap-consult.com> top posted like an ignorant moron
>>>>>>> and wrote:
>>>>>>>> I wish to thank:
>>>>>>>> Zeldorblat,
>>>>>>>> Rik Wasmus,
>>>>>>>> Darko,
>>>>>>>> Anr Daemon, and
>>>>>>>> Steve
>>>>>>>> for your . As for Jerry, if you didn't read "OT"s, then you
>>>>>>>> wouldn't have noticed that this thank you is top posted.
>>>>>>> Maybe you should start using [TP] so we know you don't care?
>>>>>> That was top posted for the benefit of one, and only one, person.
>>>>>> Except for "thank you's", I always in-line post.
>>>>>> --
>>>>>> Shelly
>>>>> You're welcome, really, but please don't think we encourage you to do
>>>>> off topics,
>>>> I don't.
>>>>> even when supplied with OT in the title; it's not a big excuse, and is
>>>>> generally
>>>>> not tolerated in any newsgroup.
>>>> I agree, and so try to keep it to an absolute minimum. It is only when I
>>>> can't get at the answer through regular channels.....
>>>>> I might have criticized Jerry for "asshole" words, but I wouldn't like
>>>>> to be misunderstood
>>>>> as support to you, because Jerry is definitely right in the whole
>>>>> issue, but he just
>>>> I know he is concerning the off-topics and top-posting. I agree with him on
>>>> those. This reminds me of something. I used to work for a French company
>>>> and every three months I would go to Paris for a week on business. They
>>>> told me the difference between the Germans, the French and the Americans.
>>>> To the Germans a schedule is just that. You stick to the schedule --- even
>>>> it no longer makes sense.
>>>> To the French a schedule is a suggestion.
>>>> To the Americans a schedule is just that, but you can change the schedule to
>>>> changing conditions.
>>>> I like to think of myself as American. I guess Jerry is "German".
>>>> Another way of looking at it is that there is always a small percentage of
>>>> bugs and stuff in all the processed food we eat. It is kept below some very
>>>> low level. If we insisted on absolutely zero level, then we would starve.
>>>> I like to eat.
>>>> So while I generally follow the rules, there ARE exceptions. To minimize
>>>> the effect of that, I put our a roadsign of "OT:". Unfortuanately, some
>>>> people can't drive.
>>>>> doesn't realize that swearing collides with netiquette just as well as
>>>>> writing off topics.
>>>> YOU CAN SAY THAT AGAIN.
>>> You'd better agree to everything Jerry says, Shelly.
>>> Or else, he will beat you up as he did with his wife:
>>> Court