I have a pair of temp columns:
id name
1 bob
2 ted
3 jim
1 jon
1 tim
3 mic
5 tim
Any way to query them out to show all the ID=1 with the name in 1 row
in an HTML table?
id name
1 bob,jon,tim
2 ted
3 jim,mic
5 tim
You didn't like the answer you got in the SQL server newsgroup?
SQL is not the tool for this. Do this client side.
What's so hard in returning the recordset ordered by id and name and
building the logic in code?
news:1101222669.566633.175940@z14g2000cwz.googlegroups.com.. .
> I have a pair of temp columns:
> id name
> 1 bob
> 2 ted
> 3 jim
> 1 jon
> 1 tim
> 3 mic
> 5 tim
>
> Any way to query them out to show all the ID=1 with the name in 1 row
> in an HTML table?
>
> id name
> 1 bob,jon,tim
> 2 ted
> 3 jim,mic
> 5 tim
>
Joe suggested you do the same thing that I suggested.
The words are different but the meaning is the same.
Joe Celko wrote:
>Or you can do the display functions for the application in the front end
>where it belongs in a tiered architecture.
news:1101225690.491120.84270@c13g2000cwb.googlegroups.com...
> Did you READ the answer I got in the SQL group?
> That's why I brought it to the ASP group.
>
Did you READ the answer I got in the SQL group?
That's why I brought it to the ASP group.
sql = "SELECT id, name FROM table ORDER BY id, name"
set rs = conn.execute(sql)
cID = -1
response.write "
| ID | Names" do while not rs.eof rID = clng(rs(0)) if rID > cID then cID = rID response.write " |
|---|---|
| " & _ cID & " | " & rs(1) else response.write ", " & rs(1) end if rs.movenext loop rs.close: set rs = nothing response.write " |
RS1.OPEN "SELECT DISTINCT * FROM myTable ORDER BY Id"
Response.Write "
| " & RS1("id") & " | " RS2.Open "SELECT * FROM myTable WHERE id=" & RS1("id") & " ORDER BY name" Do while not RS2.Eof Response.Write RS2("name") & "," RS2.MoveNext Loop Response.Write " |
Ugh, I don't know where to begin.
Why are you using a recordset object? Why are you using SELECT *? Why are
you using DISTINCT? Why do you think you need two loops?
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Maarten"
news:GLKod.33193$uU5.1699908@phobos.telenet-ops.be...
>
> RS1.OPEN "SELECT DISTINCT * FROM myTable ORDER BY Id"
>
> Response.Write ""
> Response.Write ""
"
>
> Do while not RS1.Eof
> Response.Write "" & RS1("id") & " "
>
> RS2.Open "SELECT * FROM myTable WHERE id=" & RS1("id") & " ORDER BY
> name"
> Do while not RS2.Eof
> Response.Write RS2("name") & ","
> RS2.MoveNext
> Loop
> Response.Write "
> RS1.MoveNext
> Loop
>
> Response.Write "
> Response.Write ""
>
>
Why so much questions Aaron?
We posted at the same time, so i did'nt see your answer.
This is my way, what not mean it is the right way. But it is better than
what Raydan posted. This kind of answer don't help.
Why are you not closing your
| " & RS1("id") & " | " >> >> RS2.Open "SELECT * FROM myTable WHERE id=" & RS1("id") & " ORDER BY >> name" >> Do while not RS2.Eof >> Response.Write RS2("name") & "," >> RS2.MoveNext >> Loop >> Response.Write " |
*sigh*
> Why are you not closing your
Somewhere in a group i read that someone call you a 'wisy nouse' or
something like that. I think i must say he is right.
Maybe you are a MVP in SQL Server, however in HTML ???
If the
> Somewhere in a group i read that someone call you a 'wisy nouse' or
> something like that. I think i must say he is right.
I have absolutely no idea what a 'wisy nouse' is, so I'll take your word for
it.
> Maybe you are a MVP in SQL Server, however in HTML ???
Actually, I was an ASP MVP for several years before I changed ranks.
> If the
> If you actually TRY the code, you will see that all
> Why in most cases you shouldn't use ADODB.Recordset:
> http://www.aspfaq.com/2191
>
> Why you should never use SELECT *:
> http://www.aspfaq.com/2096
>
> Why you should avoid DISTINCT:
> http://www.aspfaq.com/show.asp?id=2424#db
> (look for "Avoid DISTINCT")
>
> Why you shouldn't nest recordsets:
> http://www.aspfaq.com/show.asp?id=2424#db
> (Look for "Do not nest recordsets in ASP!")
>
I'm very sorry. This is what aspFaq tells. Check Google and read the
opposite in many sites. Most of then advise SELECT * instead of Column for
speed. DISTINCT instead of GROUP BY, pffff.
Bizar if you check the SQL code generated for a query by lets say Access, or
Cristal Reports they both choose for DISTINCT?
After all your and my code do the job. Maybe in some case yours faster than
mine. Who cares because after all the hardware is the big factor.
The Bible or the Koran are both holy for them who believe in. Who tell which
is realy the one?
I believe you are one of the author of aspFaq, so it is normal that this
site is the holy one for you.
Maybe you are a experient MVP, as person you have a lot to learn. In the
first place, respect.
> I'm very sorry. This is what aspFaq tells. Check Google and read the
> opposite in many sites. Most of then advise SELECT * instead of Column for
> speed. DISTINCT instead of GROUP BY, pffff.
Can you show some examples?
> Bizar if you check the SQL code generated for a query by lets say Access,
or
> Cristal Reports they both choose for DISTINCT?
Catering to bad database design. You shouldn't NEED distinct, and you
certainly shouldn't encourage it when you don't know it's necessary.
> After all your and my code do the job. Maybe in some case yours faster
than
> mine. Who cares because after all the hardware is the big factor.
So throw good practices to the wind, hmmm? All right.
> Maybe you are a experient MVP, as person you have a lot to learn. In the
> first place, respect.
I asked some pretty legitimate questions in my initial reply, none of which
you have answered yet, except "this is the way it works for me."
Happy Thanksgiving!
Here's what I get from googling "select *". No wonder Maarten is so
knowledgeable.
http://www.google.com/search?hl=en&q=select+*&btnG=Google+Se arch
Bob Lehmann
"Aaron [SQL Server MVP]"
news:%23vliB2x0EHA.2016@TK2MSFTNGP15.phx.gbl...
> > I'm very sorry. This is what aspFaq tells. Check Google and read the
> > opposite in many sites. Most of then advise SELECT * instead of Column
for
> > speed. DISTINCT instead of GROUP BY, pffff.
>
> Can you show some examples?
>
> > Bizar if you check the SQL code generated for a query by lets say
Access,
> or
> > Cristal Reports they both choose for DISTINCT?
>
> Catering to bad database design. You shouldn't NEED distinct, and you
> certainly shouldn't encourage it when you don't know it's necessary.
>
> > After all your and my code do the job. Maybe in some case yours faster
> than
> > mine. Who cares because after all the hardware is the big factor.
>
> So throw good practices to the wind, hmmm? All right.
>
> > Maybe you are a experient MVP, as person you have a lot to learn. In the
> > first place, respect.
>
> I asked some pretty legitimate questions in my initial reply, none of
which
> you have answered yet, except "this is the way it works for me."
>
> Happy Thanksgiving!
>
>
>> Happy Thanksgiving!
Ooh Aaron is American. The people who think they are the most clever people
on earth. Yes even in there own country they are not able to keep towers up,
and then Iraq. Maybe your army and security services fall back on sites like
aspFaq and your attitude. Thats explain also why you think you are the best.
You are Aaron, surely you are, but you stay a poor American.
I've seen a lot of nasty language on this group before but that takes the
cake.
Never before killfiled anyone but: "plonk".
-- Another poor american
Even though I'm Canadian... "Plonk"
Besides, he blasted me too.
I also don't think that this is Maarten's first entry into this type of
post.
"Mark Schupp"
news:%23rgHUQ90EHA.1296@TK2MSFTNGP10.phx.gbl...
> I've seen a lot of nasty language on this group before but that takes the
> cake.
>
> Never before killfiled anyone but: "plonk".
>
> -- Another poor american
>
>
>
It took a while for me to read all the posted replies. I believe as well
Maarten as Aaron offers justcoder1 a way to solve his problem. Maybe the
code of Maarten is not a school example, but she works and cause no problem
nor for ASP nor ADO.
Aaron was indeed a little hard in his reply to maarten, from who i believe
he offers his code in thought he did something to help another person in the
group (and not only in this group or reply). Aaron keeps acting like his
point of view is the only good one, so maarten hits hem back under the belt.
Indeed nasty talk but i presume maarten is a Dutchman, European. And
broadcast stations in Europe show no great impressions of American in the
world. I know this because i live in Belgium and i must admit: since Iraq,
the elections reports and some big scandals, my admiration for Americans is
lot lesser than lets say 2 year ago.
And with poor Amrican, maybe Maarten points to the fact that the US$ is only
fraction of the Euro today.
Rudi.
Maarten wrote:
>>> Happy Thanksgiving!
>
> Ooh Aaron is American. The people who think they are the most clever
> people on earth. Yes even in there own country they are not able to
> keep towers up, and then Iraq. Maybe your army and security services
> fall back on sites like aspFaq and your attitude. Thats explain also
> why you think you are the best. You are Aaron, surely you are, but
> you stay a poor American.
Congratulations. You've just destroyed your last remaining shred of
credibility, as well as any illusions anyone may have held concerning your
intelligence. Granted, you had neither remaining in any abundance after your
third post in this thread, but now ... all anyone has to do in the future to
refute one of your stupidities is to point the reader at this post, which
says it all. Two logical fallacies, insensitive cruelty (some of us had
friends or relatives who died in that act of terrorism) and blatant bigotry,
all in one paragraph. I hope you're proud of yourself.
Amazing.
Unless, this is a brilliant piece of satire and you are just having us all
on ... no, the "towers" comment negates that thought.
Goodbye
plonk
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
No Rudi, i'm also from Belgium (Wvl). And with poor i mean on human level.
Maarten.
Rudi wrote:
> It took a while for me to read all the posted replies. I believe as
> well Maarten as Aaron offers justcoder1 a way to solve his problem.
> Maybe the code of Maarten is not a school example, but she works and
> cause no problem nor for ASP nor ADO.
>
> Aaron was indeed a little hard in his reply to maarten, from who i
> believe he offers his code in thought he did something to help
> another person in the group (and not only in this group or reply).
> Aaron keeps acting like his point of view is the only good one, so
> maarten hits hem back under the belt. Indeed nasty talk but i presume
> maarten is a Dutchman, European. And broadcast stations in Europe
> show no great impressions of American in the world. I know this
> because i live in Belgium and i must admit: since Iraq, the elections
> reports and some big scandals, my admiration for Americans is lot
> lesser than lets say 2 year ago.
> And with poor Amrican, maybe Maarten points to the fact that the US$
> is only fraction of the Euro today.
> Rudi.
plonk
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
Reply of Raydan to the original poster:
>>You didn't like the answer you got in the SQL server newsgroup?
>>SQL is not the tool for this. Do this client side.
>>What's so hard in returning the recordset ordered by id and name and
>>building the logic in code?
Is this an answer or this pure criticism? For many people even returning
such a rs is HARD to do.
Thx Bob, if for you ever European is a 'plonk' (what it means - can find it
in a dictionary), it only demonstrates what maarten try to explain. Rudi.
Rudi, van waar ben je, ik zie dat je op dezelfde telenet hub 81.165.239.61
zit als ikzelf?
kortrijk
Rudi,
"plonk" means you have been added to someones "ignore this poster forever"
file.
Maarten didn't get plonked for disagreeing with Aaron, or even with the
initial nastiness which was, however rude, in the context of the technical
discussion.
He got "plonked" dragging Aaron's nationality into it in an offensive
manner.
You got "plonked" for the same reason. It was lesson offensive that Maarten
but what has the value of the Euro got to do with the best way to create an
HTML table.
--Mark Schupp
> Thx Bob, if for you ever European is a 'plonk' (what it means - can find
it
> in a dictionary), it only demonstrates what maarten try to explain. Rudi.
There are two different definitions.
(a) "Person with Little Or No Knowledge."
(b) the sound of a person hitting a killfile.
You could have found this easily searching an acronym dictionary.
And by the way, I'm not American. I'll leave it as an exercise to the
reader to determine which definition(s) apply to rudi and maarten.
Wow, you said it much better than I did. My initial reply didn't even make
it past the "naughty words" filter. :-)
"Bob Barrows [MVP]"
news:OfVO3l90EHA.3840@tk2msftngp13.phx.gbl...
> Maarten wrote:
> >>> Happy Thanksgiving!
> >
> > Ooh Aaron is American. The people who think they are the most clever
> > people on earth. Yes even in there own country they are not able to
> > keep towers up, and then Iraq. Maybe your army and security services
> > fall back on sites like aspFaq and your attitude. Thats explain also
> > why you think you are the best. You are Aaron, surely you are, but
> > you stay a poor American.
>
> Congratulations. You've just destroyed your last remaining shred of
> credibility, as well as any illusions anyone may have held concerning your
> intelligence. Granted, you had neither remaining in any abundance after
your
> third post in this thread, but now ... all anyone has to do in the future
to
> refute one of your stupidities is to point the reader at this post, which
> says it all. Two logical fallacies, insensitive cruelty (some of us had
> friends or relatives who died in that act of terrorism) and blatant
bigotry,
> all in one paragraph. I hope you're proud of yourself.
>
> Amazing.
>
> Unless, this is a brilliant piece of satire and you are just having us all
> on ... no, the "towers" comment negates that thought.
>
> Goodbye
>
> plonk
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>
I shame myself for living so close to Maarten.
Some things cannot be said all cause a disagreement with another 'helper'.
And all cold hearted thoughts he said makes him a little fool, who indicated
he has no knowledge of the world
we're all living in.
Now at this point allready i think i better skip all postings because of
Maarten thoughts, whether his postings
are correct solutions or not.
Phil
The Netherlands
"Bob Barrows [MVP]"
news:OfVO3l90EHA.3840@tk2msftngp13.phx.gbl...
> Maarten wrote:
> >>> Happy Thanksgiving!
> >
> > Ooh Aaron is American. The people who think they are the most clever
> > people on earth. Yes even in there own country they are not able to
> > keep towers up, and then Iraq. Maybe your army and security services
> > fall back on sites like aspFaq and your attitude. Thats explain also
> > why you think you are the best. You are Aaron, surely you are, but
> > you stay a poor American.
>
> Congratulations. You've just destroyed your last remaining shred of
> credibility, as well as any illusions anyone may have held concerning your
> intelligence. Granted, you had neither remaining in any abundance after
your
> third post in this thread, but now ... all anyone has to do in the future
to
> refute one of your stupidities is to point the reader at this post, which
> says it all. Two logical fallacies, insensitive cruelty (some of us had
> friends or relatives who died in that act of terrorism) and blatant
bigotry,
> all in one paragraph. I hope you're proud of yourself.
>
> Amazing.
>
> Unless, this is a brilliant piece of satire and you are just having us all
> on ... no, the "towers" comment negates that thought.
>
> Goodbye
>
> plonk
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>
Philmans wrote:
> I shame myself for living so close to Maarten.
Don't. Bigotry and stupidity are not dependant on geography. Some of my
fellow Americans have said things that were just as disgusting. And landed
as quickly in my killfile - along with those who attempted to justify their
behavior.
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
On Fri, 26 Nov 2004 07:04:57 GMT, "Maarten"
wrote:
>>> Happy Thanksgiving!
>
>Ooh Aaron is American. The people who think they are the most clever people
>on earth. Yes even in there own country they are not able to keep towers up,
>and then Iraq. Maybe your army and security services fall back on sites like
>aspFaq and your attitude. Thats explain also why you think you are the best.
>You are Aaron, surely you are, but you stay a poor American.
Sure, that'll win you points. On my end, it earned you a place in the
killfile...
Jeff
Yes Aaron, thats the only way an American can discuss. With naughty words
and the mighty word I I and I.
See what happens in your country if your Harry Potter (Prime Minister
Balkenende) rules like a American. No wonder there comes a lot of protest
against the terrorism.
Shaking hands, big smile, visiting veterans, one need more brains the rule a
nation. The American people, according to the reports on tv to which Rudi
points, over 60% of the Americans live in poverty, no social security and
for who they choose if there are election? They stay poor and it get worser
with the day (see the $, only 68% of the Euro).
Thanx Jeff, you just react like i wish you should do :-) No only poor ...,
also stupid enough to post.
Aaron [SQL Server MVP] wrote:
>>Thx Bob, if for you ever European is a 'plonk' (what it means - can find
>
> it
>
>>in a dictionary), it only demonstrates what maarten try to explain. Rudi.
>
>
> There are two different definitions.
>
> (a) "Person with Little Or No Knowledge."
>
> (b) the sound of a person hitting a killfile.
>
c) Cheap wine (in Oz it is anyway) :)