| Author |
 Topic Search  Topic Options
|
snooper 
Mod Builder Group
Joined: 23 April 2002
Location: Israel
Status: Offline
Points: 333
|
 Posted: 13 February 2003 at 8:08am |
well hello Morningz...
if its so simple, how come you didnt manage to help me with the correct answer in your first 2 messages??
and FYI, been there and done that. neither of these site addresses this issue.
|
 |
MorningZ
Senior Member
Joined: 06 May 2002
Location: United States
Status: Offline
Points: 1793
|
Posted: 13 February 2003 at 8:21am |
|
ohh, i see now...
i "owe it to you" to do your work for you.. ha.... don't think so.. i was simply giving you some links to help yourself out and find the answer instead of having to have your hand held.....
take it or leave it, but your snotty reply like that, you just lost all future help and respect from me
|
|
Contribute to the working anarchy we fondly call the Internet
|
|
snooper
Mod Builder Group
Joined: 23 April 2002
Location: Israel
Status: Offline
Points: 333
|
Posted: 13 February 2003 at 8:40am |
"snotty" - i dont think so...
but if this is what you call "help" - i'll leave it for sure.
This forum is not meant to help people, as i have been helped, and have tried to help, many times before. this is not a "take a hike, you didnt do your homework" style forum, its meant to help people out.
if you feel you dont want to bother helping, or that you want to guise your inablility to help as something else - then please dont post answers. if you have a direct link to a helpful resource, then by all means, post it. but dont lecture people. with a reply like that - i would have prefered to get no replies at all....
there are many other fine folks here on the forum that actually WANT to help, so go find someone else to lecture to and be condescending to.
(..and if you still think this is snotty - go look it up..)
|
|
jaz9090
Groupie
Joined: 25 October 2002
Location: United Kingdom
Status: Offline
Points: 135
|
Posted: 13 February 2003 at 9:08am |
|
Instead of telling people that they are no-good programmers, and calling them snotty just try and help or just dont comment at all
|
|
MorningZ
Senior Member
Joined: 06 May 2002
Location: United States
Status: Offline
Points: 1793
|
Posted: 13 February 2003 at 9:33am |
 jaz9090 wrote:
Instead of telling people that they are no-good programmers |
i'm at a loss where i called anyone a bad programmer? I simply stated (and even provided links) to where he could find the answers out at... is there something wrong with that? (i am guessing by the negavtive feedback that there is)
as for the "snotty" remark by me, it was in reference that this guy obviously just wants someone to do it for him, judging by the line:
"lets keep at this... we'll (you'll!) get it in the end :)"
and then i read whining because two people posted code to try to help and "waaah, it doesn't work"
maybe others see this thing differently, but i don't see any effort on his part to learn what the problem was and help himself out... we've all been down this road before of not knowing how to do something.. good programmers, as opposed to "bad", can do some research and find out how to do it.....
|
|
Contribute to the working anarchy we fondly call the Internet
|
|
Bunce
Senior Member
Joined: 10 April 2002
Location: Australia
Status: Offline
Points: 846
|
Posted: 13 February 2003 at 10:25am |
No, you're right Morningz.
Snooper, those sights are excellent references to help you learn the basics of set theory (SQL Statements).
Once you understand this, you will understand that what you are trying to do, can't be done this way.
That said, IF the ID is an incrementing key and you want to use the minimum ID of a group of categories, to order the records, then you can use something like this:
SELECT Category, Min(ID) AS MinOfID
FROM tbl
GROUP BY Category
ORDER BY Min(ID);
Cheers,
Andrew
Edited by Bunce
|
|
There have been many, many posts made throughout the world...
This was one of them.
|
|
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Posted: 13 February 2003 at 11:36am |
The first option I gave, why is it not a cigar, it is the output you are looking for just not sorted by ID which is not possible in this type of query. The second option DOES work unless you pasted ID in there. The error message you wrote suggests that you have the field ID in there which you can't unless you put it into an aggregate function like Bunce said. Nevertheless it does not make sense to use Min function as this is a fake sorting, why would you sort by ID anyway?
|
|
snooper
Mod Builder Group
Joined: 23 April 2002
Location: Israel
Status: Offline
Points: 333
|
Posted: 13 February 2003 at 1:39pm |
to michael: i want to sort by the ID, because i want the records displayed in the entry order, not by the ABC. ie i want: b>a>c and not a>b>c
i am still not sure WHY this is not do-able, but i ACCEPT it.
to Andrew: thanks! Your suggestion worked exactly as i wanted! :)
thanks to all the helpful folks who answered, and thats to Andrew for the winning answer!
Snooper
|
|
SQL DISTINCT stuff