MySQL Forums
Forum List  »  Other Migration

Syntax problem - Sybase to MySql
Posted by: Peter Toby
Date: August 09, 2004 12:25AM

I'm a new user to MySql and am attempting to convert a website from Adaptive Server Anywher V7 to MySql 4.0.20a.

I've converted all of the data without many hassles (phew!), but am having some difficulty with the existing SQL sytax (the site is written in Cold Fusion by the way).

The one main query I'm having problems with is this one:

SELECT ( SELECT LIST(Category_desc, ',') AS catlist FROM subscriber_to_category, category where Category.Category_ID = Subscriber_to_category.Category_ID AND subscriber_ID = <cfqueryparam value="#Session.subscriber_ID#" cfsqltype="CF_SQL_INTEGER"> ) AS listcat, Subscriber_ID, Category_desc, Subscriber_to_category.Category_ID, Active, Subscriber_start, Subscriber_end
FROM Subscriber_to_category, category
WHERE Subscriber_ID = #Session.subscriber_ID#
AND Category.Category_ID = Subscriber_to_category.Category_ID
ORDER BY Subscriber_to_category.category_id DESC

The problem is with the 'SELECT LIST(Category_desc, ',') - there doesn't seem to be an equivalent in MySql sytax.

Anybody have any suggestions....please?

Options: ReplyQuote


Subject
Views
Written By
Posted
Syntax problem - Sybase to MySql
3714
August 09, 2004 12:25AM
1990
August 09, 2004 04:20AM
2503
August 11, 2004 10:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.