sql and perl
Alexandre Jaquet
I would like to show on a web page all items who have a different name
(nom in french) but mysql doesn't work correctly (as I know postgresql
and other database)
SELECT DISTINCT nom, id_vinyl,auteur,label,prix, pochette, date_stock
FROM view_nouveaute WHERE id_vinyl = id_vinyl
return me
nom1 1 auteur1 label1 12 pochette/0.jpg 0000-00-00
nom1 2 auteur1 label1 12 pochette/1.jpg 0000-00-00
nom1 15 auteur1 label1 12 pochette/14.jpg 0000-00-00
nom1 16 auteur1 label1 12 pochette/15.jpg 0000-00-00
nom1 17 auteur1 label1 12 pochette/16.jpg 0000-00-00
nom1 18 auteur1 label1 12 pochette/17.jpg 0000-00-00
nom1 19 auteur1 label1 12 pochette/18.jpg 0000-00-00
nom1 20 auteur1 label1 12 pochette/19.jpg 0000-00-00
nom2 21 auteur2 label2 12 pochette/20.jpg 0000-00-00
nom2 22 auteur2 label2 12 pochette/21.jpg 0000-00-00
nom2 23 auteur2 label2 12 pochette/22.jpg 0000-00-00
nom2 24 auteur2 label2 12 pochette/23.jpg nom2 29 auteur2
label2 12 pochette/28.jpg 0000-00-00
nom2 30 auteur2 label2 12 pochette/29.jpg 0000-00-00
It doesn't take result who got ONLY different name.
Any idea to solve it ?
Thanks in advance.
Alexandre Jaquet
A. Sinan Unur
news:4294ba7f$0$1163$5402...@news.sunrise.ch:
> I'm having trouble with a sql query on mysql with perl,
You posted no Perl code.
> I would like to show on a web page all items who have a different name
> (nom in french) but mysql doesn't work correctly (as I know postgresql
> and other database)
How is that a Perl issue?
> SELECT DISTINCT nom, id_vinyl,auteur,label,prix, pochette, date_stock
> FROM view_nouveaute WHERE id_vinyl = id_vinyl
That is not Perl.
> return me
This could be Perl.
> nom1 1 auteur1 label1 12 pochette/0.jpg
> 0000-00-00 nom1 2 auteur1 label1 12
> pochette/1.jpg 0000-00-00 nom1 15 auteur1 label1
This is definitely not Perl.
> Any idea to solve it ?
No.
> Thanks in advance.
"Thanks in advance" is one of the rudest, bossiest statements of all
time. As such, it is no wonder that it gets used frequently by people
who do not appreciate the value of others' time.
Sinan
--
A. Sinan Unur <1u...@llenroc.ude.invalid>
(reverse each component and remove .invalid for email address)
comp.lang.perl.misc guidelines on the WWW:
http://mail.augustmail.com/~tadmc/clpmisc/clpmisc_guidelines.html
Alexandre Jaquet
> Alexandre Jaquet <al...@freesurf.ch> wrote in
> news:4294ba7f$0$1163$5402...@news.sunrise.ch:
>
>
>>I'm having trouble with a sql query on mysql with perl,
>
>
> You posted no Perl code.
>
>
>>I would like to show on a web page all items who have a different name
>>(nom in french) but mysql doesn't work correctly (as I know postgresql
>>and other database)
>
>
> How is that a Perl issue?
>
>
>>SELECT DISTINCT nom, id_vinyl,auteur,label,prix, pochette, date_stock
>>FROM view_nouveaute WHERE id_vinyl = id_vinyl
>
>
> That is not Perl.
>
>
>>return me
>
>
> This could be Perl.
>
>
>
>>nom1 1 auteur1 label1 12 pochette/0.jpg
>>0000-00-00 nom1 2 auteur1 label1 12
>>pochette/1.jpg 0000-00-00 nom1 15 auteur1 label1
>
>
> This is definitely not Perl.
>
>
>>Any idea to solve it ?
>
>
> No.
>
>
>>Thanks in advance.
>
>
> "Thanks in advance" is one of the rudest, bossiest statements of all
> time. As such, it is no wonder that it gets used frequently by people
> who do not appreciate the value of others' time.
>
> Sinan
>
Here not, it's a form of courtesy. If you don't know how to solve it no
trouble.
"who do not appreciate the value of others' time." Don't speak about
yourself...
Your post he's just stupid.
Alexandre Jaquet
xho...@gmail.com
> I'm having trouble with a sql query on mysql with perl,
>
> I would like to show on a web page all items who have a different name
> (nom in french)
A name different from what?
> but mysql doesn't work correctly (as I know postgresql
> and other database)
I find this hard to believe.
> SELECT DISTINCT nom, id_vinyl,auteur,label,prix, pochette, date_stock
> FROM view_nouveaute WHERE id_vinyl = id_vinyl
The "distinct" applies to all columns in the result set, not just to the
nom column. That isn't just a mysql thing. And it definitely isn't a Perl
thing.
Xho
--
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service $9.95/Month 30GB
Dave
"Alexandre Jaquet" <al...@freesurf.ch> wrote in message
news:4294ba7f$0$1163$5402...@news.sunrise.ch...
Est-ce que vous êtes au courant de 'fr.comp.lang.perl'? Je crois que peut
être vous pouvez mieux exprimé le problème en français - et le groupe me
semble plus poli qu`ici aussi.
David
Debo
LOL! Gotta love the foreign-language jabs...
I needed that.
-Debo
Dave
"Debo" <mddi...@NOSPAM.student.cs.uwaterloo.ca> wrote in message
news:Pine.GSO.4.58.05...@rees.math.uwaterloo.ca...
Just an observation. I don`t know if its a cultural thing or an average age
thing...
Dave
John Bokma
> "Thanks in advance" is one of the rudest, bossiest statements of all
> time.
It is?
> As such, it is no wonder that it gets used frequently by people
> who do not appreciate the value of others' time.
I started an email yesterday with:
"I hope you don't mind me bothering you again"
and at the bottom:
"Many thanks in advance,"
So that was extremely rude I guess?
Can you give a better way of writing this?
--
John Small Perl scripts: http://johnbokma.com/perl/
Perl programmer available: http://castleamber.com/
Happy Customers: http://castleamber.com/testimonials.html
John Bokma
> et le groupe me semble plus poli qu`ici aussi
Yeah, sure. So newbies helping newbies?
A. Sinan Unur
news:Xns96618C896E...@130.133.1.4:
> A. Sinan Unur wrote:
>
>> "Thanks in advance" is one of the rudest, bossiest statements of all
>> time.
>
> It is?
>
>> As such, it is no wonder that it gets used frequently by people
>> who do not appreciate the value of others' time.
>
> I started an email yesterday with:
>
> "I hope you don't mind me bothering you again"
>
> and at the bottom:
>
> "Many thanks in advance,"
>
> So that was extremely rude I guess?
>
> Can you give a better way of writing this?
It is presumptious. Thanking in advance *presumes* that the other party
is willing and able to do what you want. It *presumes* that what you
want will be done because you have stated that you want it.
The favor that is being asked is thus no longer a favor because it being
taken for granted by the asking party.
Only a boss or a commander can state a request, and expect that it will
be done.
I prefer to close with "I appreciate your taking the time to ..."
Now, this is all a personal preference obviously.
You will notice that I do not respond this way *every time* someone says
"thanks in advance". The OP has already demonstrated that whenever a
question comes to his mind, he will post here *before* doing any
research himself. The obviously off-topic SQL question was just the last
drop.
kevin...@gmail.com
WOW-
Such strong feelings from a simple mistake!
Here's my take;
1. "TIA" is not rude- that's YOUR projection, which is never a good
basis for posting.
2. Alexandre didn't post from Google (or some such) and not all Usenet
servers distribute all newsgroups - he just took a shot and you flamed
him hard for what appears to be, well, "venting your spleen".
In short, if you are going to post an angry response, KNOW WHERE YOUR
FEELINGS OF ANGER COME FROM- and after 18 years of posting, I can tell
you there are very few instances that warrant it, unless you're LOOKING
for trouble, which I'm sure you're not.
The noise ratio is low in this group- be thankful.
Sinan, your hostility towards the poster created MORE noise that if you
posted a simple "...Hi Alexandre; You'll have better luck looking in
a mysql newsgroup"... yes?
Please, Have a nice day (unless that's rude in your book, too)
kevDot
Alexandre Jaquet
everything are good right now =)
mais merci du conseil David =)
ax...@white-eagle.invalid.uk
> 2. Alexandre didn't post from Google (or some such) and not all Usenet
> servers distribute all newsgroups - he just took a shot and you flamed
> him hard for what appears to be, well, "venting your spleen".
No... but this is a Perl group not an /.*SQL/ one... nothing wrong with OT
discussions developing (in my view anyway), but asking for such in the
first place on here is wrong.
> In short, if you are going to post an angry response, KNOW WHERE YOUR
> FEELINGS OF ANGER COME FROM- and after 18 years of posting, I can tell
> you there are very few instances that warrant it, unless you're LOOKING
> for trouble, which I'm sure you're not.
After many years of reading and posting to Usenet, the use of capital
letters in unwarranted places normally identifies a kook.
Axel
andrewf...@gmail.com
without even reading a third of it much less the thanks part
andrewf...@gmail.com
what you want that way
Eric Schwartz
> you're too hung up on protocol, I somehow understood the entire post
> without even reading a third of it much less the thanks part
Who's too hung up on protocol? Please quote enough of the message
you're replying to that everybody can understand the context. Not
everybody reads USENET through Google-- in fact, most (most here,
anyway) don't.
-=Eric
--
Come to think of it, there are already a million monkeys on a million
typewriters, and Usenet is NOTHING like Shakespeare.
-- Blair Houghton.
Tad McClellan
> you're
Who is?
Please quote some context in followups like everybody else does.
> too hung up on protocol,
Off-topic postings are universally reviled.
You are not likely to be able to convince folks to let them pass.
> I somehow understood the entire post
Who said that they didn't understand the post?
We don't know which of the many posts in this thread you are talking
about (since you didn't quote any of it), but it looks to me like
nearly everybody understood perfectly that it was not a question
about Perl.
--
Tad McClellan SGML consulting
ta...@augustmail.com Perl programming
Fort Worth, Texas
Tad McClellan
> try adding "GROUP BY nom" to the end of the query and see if you get
> what you want that way
and if that fixes the problem when using Perl, then it would also
have fixed the problem when using Java or Python or Visual Basic.
It was not a Perl question.
andrewf...@gmail.com
I bet if you look in the usenet archives you'd see people posting
inquiries in the wrong group since the 80's and then the next post from
people like you and half the other people in this newsgroup not
answering the off topic question but indstead wasting your time trying
to change the world one person at a time and insisting they read some
horribly verbose newsgroup FAQ. It's never going to stop and people
with quick questions that need quick answers aren't going to read the
5000 word FAQ so I guarantee you and the others will be alot happier
changing yourselves rather than insisting on changing others.
Fabian Pilkowski
> "It was not a Perl question. "
Ok, one has told you to quote some context. But your quoting style is
not the commonly used way doing this. You could simply realize this by
comparing your postings with other ones. It would be nice if you learn
how to quote properly. This day --but in another thread-- I've already
posted a link to a website where quoting is explained. Please read
http://www.netmeister.org/news/learn2quote.html
I know that Google intends to provide us an easy-to-use interface for
newsgroups, but they don't care about the proper way. Please check out
if you could use Google in the recommended manner.
>
> I bet if you look in the usenet archives you'd see people posting
> inquiries in the wrong group since the 80's and then the next post from
> people like you and half the other people in this newsgroup not
> answering the off topic question but indstead wasting your time trying
> to change the world one person at a time
If nobody remarks that one has to use the group intended for his problem
instead of choosing any group he want, such posting would become more
and more. To avoid this, the poster has to realize that he only get some
help if he choose the right group. It gives bases for the fact that
newsgroups are organized in this kind. Here in clp.misc, no one will be
bothered with questions about SQL -- I hope you could understand this.
If someone is interested in SQL questions, he would subscribe to one of
the SQL groups.
> and insisting they read some
> horribly verbose newsgroup FAQ. It's never going to stop and people
> with quick questions that need quick answers aren't going to read the
> 5000 word FAQ so I guarantee you and the others will be alot happier
> changing yourselves rather than insisting on changing others.
But if others would see that the perl gurus will answer to SQL specific
questions too, they would ask their questions in this group (instead of
subscribing to another one).
Keeping mum is a kind of tolerance, and that is not desired.
Last but not least, this has absolutely nothing to do with perl and is
accordingly off topic here. But I'm sure if you really want to discuss
such usenet-basics you'll find the right group for this ;-)
regards,
fabian
Tad McClellan
> "It was not a Perl question. "
>
> I bet if you look
If who does?
Please provide an attribution when you quote someone, it is the
polite thing to do.
You have this vast experience on Usenet yet you won't make a
followup that follows established convention?
I admit to doubting your credibility.
> in the usenet archives
I've done a good bit of actual participation, so there is no need
to go look, I've seen it first hand.
> you'd see people posting
> inquiries in the wrong group since the 80's and then the next post from
> people like you and half the other people in this newsgroup not
> answering the off topic question but indstead wasting your time trying
> to change the world one person at a time and insisting they read some
> horribly verbose newsgroup FAQ. It's never going to stop
I bet if you look an the newspaper archives you'd see people
robbing convenience stores since before the 80's and then people
like police officers (and even regular citizens) not giving
money to the robber but instead wasting their time trying to
change the world one person at a time and insisting that they
serve time in jail. It's never going to stop
> and people
> with quick questions that need quick answers aren't going to read the
> 5000 word FAQ
and people that need money aren't going to earn it.
> so I guarantee you and the others will be alot happier
Expect a lot of warranty claims then.
I will never be happy with off-topic postings.
> changing yourselves rather than insisting on changing others.
We should just give robbers money rather than insisting that
they earn it like everybody else does.
andrewf...@gmail.com
not the commonly used way doing this. You could simply realize this by
comparing "
Who cares? You understood didn't you? We are two people communicating,
we are not network protocols negotiating.
"If nobody remarks that one has to use the group intended for his
problem
instead of choosing any group he want, such posting would become more
and more. To avoid this, the poster has to realize that he only get
some
help if he choose the right group."
If everyone agreed with you nobody would post responses, yet they do
because they want to and thank god there is nothing you can do about
that. Don't interfere with our friendly discourse. Ignore it as you
might ignore tv channels you don't watch. Maybe you are such a slow
reader that these off-topic headings interfere with your schedule but I
doubt that.
"Keeping mum is a kind of tolerance, and that is not desired. "
There are more noble battles you could spend your time fighting.
andrewf...@gmail.com
"I bet if you look an the newspaper archives you'd see people
robbing convenience stores since before the 80's and then people
like police officers (and even regular citizens) not giving
money to the robber but instead wasting their time trying to
change the world one person at a time"
Thievery costs people property and possibly their health, posting off
topic doesn't. The comparison is insulting. What you are trying to do
is shape this newsgroups to be what you and a few other people want it
to be, but the fact is that it's what the people who participate make
out of it. There is no enforcable rule that says anything even has to
be on topic and infact it look like that's why they have
comp.lang.perl.moderated so why don't you go there instead?
Jay Tilton
: I guarantee you and the others will be alot happier
: changing yourselves rather than insisting on changing others.
You are correct. Some of the biggest Perl-propellerheads around chose to
change their own behavior: they chose to stop reading the newsgroup
completely. The quality of their own lives improved immediately and
dramatically.
Yup. Packing up and moving out of this shithole Perl ghetto sounds more
and more like the best thing to do. Cede the turf to all the punks and
thugs and googlegroupians so they can kill nobody but each other.
Jürgen Exner
> This response is to Tad McClellan and his recent reponse:
> "I bet if you look an the newspaper archives you'd see people
> robbing convenience stores since before the 80's and then people
> like police officers (and even regular citizens) not giving
> money to the robber but instead wasting their time trying to
> change the world one person at a time"
>
> Thievery costs people property and possibly their health, posting off
> topic doesn't. The comparison is insulting. What you are trying to do
> is shape this newsgroups to be what you and a few other people want it
> to be, but the fact is that it's what the people who participate make
> out of it.
Almost right. Participants in Usenet determined a long, long time ago (some
twenty years or so) how this medium would work best. And they shaped Usenet
exactly the way they wanted. Who are you that you who hasn't contributed
anything to the society yet are telling the society to change their
behaviour just because you please to do it different than anyone else?
> There is no enforcable rule that says anything even has to
> be on topic and infact it look like that's why they have
> comp.lang.perl.moderated so why don't you go there instead?
If you don't like the rules somewhere then why did you even come to there in
the first place? Why don't you create your own society with the rules you
like?
No, social behaviour on Usenet is not enforcable. You are right in that
regard.
But nobody has to put up with ignorant or malicious behaviour. So long then
***PLONK***
jue
Tad McClellan
> This response is to Tad McClellan and his recent reponse:
> "I bet if you look an the newspaper archives you'd see people
> robbing convenience stores since before the 80's and then people
> like police officers (and even regular citizens) not giving
> money to the robber but instead wasting their time trying to
> change the world one person at a time"
>
> Thievery costs people property and possibly their health, posting off
> topic doesn't.
It steals time from your (supposed) peers who *do* actually have
some Perl issue to discuss.
Off-topic postings hurt the community.
Some people have no concern for the community. I am not such a person.
> The comparison is insulting.
Then it has served its intended purpose.
> What you are trying to do
> is shape this newsgroups to be what you and a few other people want it
> to be,
You have it backwards.
The majority wants on-topic postings.
You are in the minority if you defend making off-topic posts.
So, what *you* are trying to do is shape this newsgroups to be what
you and a few other people want it to be.
This is beginning to smell trollish...
> There is no enforcable rule that says anything even has to
> be on topic
Right.
There should be only One Newsgroup where all 50,000 daily posts
go, then this silliness about topics would become moot.
Why bother with tens of thousands of newsgroups when one will
do just fine?
Just create
net.needle.in.haystack
and be done with it. Problem solved!
> so why don't you go there instead?
I don't take direction very well, particularly from someone
I respect as much as I do you.
(Have you tried alt.perl? Not much of this manners crap there.
It may be more to your liking than a Big-8 newsgroup.
)
Tad McClellan
> We are two people communicating,
There are hundreds (or thousands) of people here, not two.
ax...@white-eagle.invalid.uk
> Thievery costs people property and possibly their health, posting off
> topic doesn't. The comparison is insulting. What you are trying to do
Well... it was a kindly warning... we do not have to respond to totally
OT postings... is there a reason we should? Actually we can... and say
the topic is OT... give us one good reason we should not.
> is shape this newsgroups to be what you and a few other people want it
> to be, but the fact is that it's what the people who participate make
> out of it. There is no enforcable rule that says anything even has to
> be on topic and infact it look like that's why they have
> comp.lang.perl.moderated so why don't you go there instead?
Why do you not go there instead? No, there is no enforceable rule... any
more than postings about 'Big breasted girls'... but it is pleasant to
keep a forum on topic.
Axel
andrewf...@gmail.com
some Perl issue to discuss. "
Very little.
"Off-topic postings hurt the community"
That must mean the community is pretty weak.
"The majority wants on-topic postings. "
Prove it.
"This is beginning to smell trollish... "
I think the same thing of you. I'm promoting tolerance and you're
promoting your singular view of how things should be. Based on your
argument you realy should be in the moderated group so your remaining
here and having this converstation must just be for fun.
"I don't take direction very well, particularly from someone I respect
as much as I do you. "
I asked you a question, I didn't give you an order.
andrewf...@gmail.com
any
more than postings about 'Big breasted girls'... but it is pleasant to
keep a forum on topic. "
The funny thing is that if a topic is "big breasted girls" nobody will
reply "this has nothing to do with perl" or anything else for that
matter, however if a topic is somewhat, but not totaly related to perl
then you get self righteous and self important people replying "this
has nothing to do with perl". And this poster has most likely never
been here before and most likely will never come back but those
responders think they are earning respect for defending their ever
threatened community from the ominous off topic posting scum.
andrewf...@gmail.com
more
and more like the best thing to do. Cede the turf to all the punks and
thugs and googlegroupians so they can kill nobody but each other. "
It's not that bad. Off topic posts are usualy easy to identify and
ignore if you choose. I don't sympathize with you at all. I think you
like to complain about it to remind yourself that you're smarter than
someone who couldn't find the right group.
David H. Adler
> "Yup. Packing up and moving out of this shithole Perl ghetto sounds
> more
> and more like the best thing to do. Cede the turf to all the punks and
>
> thugs and googlegroupians so they can kill nobody but each other. "
>
> It's not that bad. Off topic posts are usualy easy to identify and
> ignore if you choose.
Sadly, people who actually have much to contribute disagree with you and
have long since left here. I specifically am thinking of people like
Larry Wall and Tom Christiansen. If you don't think that's a great loss,
you're sorely mistaken.
dha
--
David H. Adler - <d...@panix.com> - http://www.panix.com/~dha/
All hail El Cabeza Del Oro! <http://www.panix.com/~dha/elcabeza.html>
RedGrittyBrick
*PLONK*
Tad McClellan
Yeah, that's where it went from "smelling trollish" to being
"confirmed trolling".
Hence the subsequent lack of follo^H^H^H^H^Hfood for It.
andrewf...@gmail.com
I've made to your poor logic. You like to criticize people who post in
the wrong group because it makes you feel good, it's as simple as that.
Otherwise you'd go to the moderated group. What you do is the very
definition of what makes a person a troll.