Connector does not handle SUM(table_name.Column)
Posted by: jacek.blaszczynski
Date: October 29, 2004 08:00AM

Hello!

The following SQL query works perfect with any DB I use in my development work (MSDE, Oracle 9i, MySQL 4.1.7) with all connectors except MySQL Connector

SELECT u.UserID, User, Password, email, RegisteredSince, LastModified, UNameModified, sum(r.RoleID) FROM Users u, UsersRoles r WHERE User=@user AND r.UserID = u.UserID GROUP BY u.UserID;

ATTENTION: I have replaced @ with ? there for MySQL Connector - its nonsense syntax anyway.

Is it a bug?

Cheers

Jacek

Options: ReplyQuote


Subject
Written By
Posted
Connector does not handle SUM(table_name.Column)
October 29, 2004 08:00AM


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.