Personally, I would try it several different ways and benchmark them to
see
which is the best use of resources. I agree that SQL cursors are highl
y
inefficient, but I suspect that they will be more efficient than doing
the
same thing in the middleware layer (i.e., ColdFusion). As Dean pointed
out, even the native SQL 2000 support for this is pretty slow. I've ne
ver
tried this, so your results may be surprising to everyone - especially
me.
=B)
Be cautious if you create it as a CFX, since it is difficult to get CFX
s to
multi-thread properly and dangerous to multi-thread them if they don't.
Test the thing to death or CFLOCK it to prevent it from multi-threading
.
To do otherwise will risk the uptime stats on your CF server, the batte
ry
life of your pager, and the peacefulness of your sleep. =B)
|----------------------+-----------------------------------------------
---|
|Eric A. Laney |"The right to do something does not mean that
|
|Systems Engineer |doing it is right."
|
|LAN Optimization Team |
|
|Verizon Data Services |
|
|Voice: 813.978.4404 | William Saf
ire|
|Pager: 888.985.8519 |
|
|----------------------+-----------------------------------------------
---|
"Yanik
Lupien" To: SQL <sql@houseoffusion
com>
<yanikl@visic cc:
.com> Subject: RE: SQL List
2001-09-27
11:08
Please
respond to
sql
Ok.
I only have MS SQL 7.0 and Our application is for MS SQL only. I will
create
a CFX that do this kind of task.
Thank!
Sorry for my english!
Yanik Lupien
-----Message d'origine-----
De : Dean H. Saxe [mailto:[EMAIL PROTECTED]]
Envoy� : Thursday, September 27, 2001 11:03
� : SQL
Objet : Re: SQL List
Eric,
Good suggestion, but its highly inefficient.
Apparently SQL Server 2000 has some functionality to allow you to aggre
gate
column data like that... but beware, its not portable across different
RDBMS and I would guess its performance is not so hot.
-dhs
At 10:16 AM 9/27/01 -0400, [EMAIL PROTECTED] wrote:
>The only way I know to get a relational database to output a
>comma-delimited list is to use a cursor.
>
|-------------------+--------------------------------------------------
---|
>|Eric A. Laney |"We have seen too much success to have become
|
>|Systems Engineer |obsessed with failure."
|
>|LAN Optimization |
|
>|Team |
|
>|Verizon Data | Lyndon B. Johnson (1908-1973)^Quoted in
National|
>|Services | Review, 31 December
1963|
>|Voice: 813.978.4404|
|
>|Pager: 888.985.8519|
|
>| |
|
>
|-------------------+--------------------------------------------------
---|
>
>
>
>
>
>
>
> "Yanik
>
> Lupien" To: SQL
> <[EMAIL PROTECTED]>
> <yanikl@visic cc:
>
> .com> Subject: SQL
> List
>
>
> 2001-09-27
>
> 09:46
>
> Please
>
> respond
> to
>
> sql
>
>
>
>
>
>
>
>
>
>Hi,
>
>I have a small question.
>
>This is my table :
>
>English French
>-------- --------
>Dog Chien
>Dog Pitou
>Cat Chat
>Cat Minou
>Animal Animal
>
>I want something like : Select English, XXXX(French) from table group
by
>English : to get a list of "French"
>
>English French
>-------- --------
>Dog Chien, Pitou
>Cat Chat, Minou
>Animal Animal
>
>It is possible ?
>
>Yanik Lupien
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
