MS SQL problem

[Nurettin Omer Hamzaoglu]

Hi all,

I've 3 tables COMPANY, COMPANY_SOFTWARES, SOFWARES. COMPANY_SOFTWARES table holds the 
data of the softwares used in the companies like;

COMPANY TABLE
COMPANY_ID   COMPANY_NAME
--   
10   My Company

COMPANY SOFTWARES TABLE
COMPANY_ID   SOFTWARE_ID
--   --
10   1
10   2
10   3

SOFWARES TABLE
SOFTWARE_ID   SOFTWARE_NAME
---   -
1 X
2 Y
3 Z

I need a result like;
COMPANY_ID   COMAPNY_NAME   SOFTWARES
--      -
10   My Company X, Y, Z


I've used a query like;

SELECT
COMPANY_ID,
COMPANY_NAME,
(
SELECT 
SOFTWARE_NAME 
FROM 
COMPANY_SOFTWARES COS, 
SOFTWARES S
WHERE 
S.SOFTWARE_ID=CS.SOFTWARE_ID AND 
COS.COMPANY_ID = C.COMPANY_ID
) AS SOFWARE_NAMES
FROM
COMPANY C
WHERE
AND C.COMPANY_ID = 10

But I get an error message;
Subquery returned more than 1 value. This is not permitted when the subquery follows 
=, !=, , = , , = or when the subquery is used as an expression.

I've read that in MySQL there is CONCAT function for the result I want but I couldn't 
find any solution in MSSQL server, any solutions, suggestions?

Thanks in advance.



~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183241
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

img serving images from different domin, good or bad for preformance, any suggestions?

[Nurettin Omer Hamzaoglu]

Hi,

I've heard that serving images from a different domain like www.images.com
is better for CF Apllication Server performance. For example I've domain called
www.myproject.com and I'm calling images img src="">
I'm gonna create a new domain www.myprojectimages.com and serve
images from there img src="">

Any of you know if this improves the performance of the CF Application Server, any suggestions?

Thanks in advance.

Nurettin Omer Hamzaoglu
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: img serving images from different domin, good or bad for preformance, any suggestions?

[Nurettin Omer Hamzaoglu]

Hi,

I've heard this performance improvment idea from a CF Developer, he said he
read it
somewhere on Macromedia site. I've searched for it at Macromedia and Yahoo
but
can't find anything. I think some of you have read about it, but it seems
like there is no
article on this story :) Maybe as Micha mentioned, it may improve the
performance of
the web server and if the web server is on a server other than CF
Application server.
Thanks for the replies, helped much.

Nurettin Omer Hamzaoglu
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]