NYCPHP Meetup

[Phil Powell]

<cfquery name="getAll" datasource="#request.dsn#">
      SELECT U.userID, U.fname, U.lname, U.phone, U.lastLoggedIn, 
             U.choiceId, U.experience, R.label AS roleLabel
      FROM Role R, UserRoleAssoc URA, Team T, User U, UserTeamAssoc UTA
      WHERE U.userId = URA.userID
       AND URA.roleId = R.roleId
       AND U.userId = UTA.userID (+)
       AND T.teamId = UTA.teamID (+)
       AND U.userID > 1
      ORDER BY #orderBy# #orderByTxt#
    </cfquery>

I am at my wit's end on this one, and I thought ANSI Syntax for mySQL was evil!

Thanx
Phil
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20030917/9d0f0816/attachment.html>