31 : COLLEGE, POSITION1 + '/' + position2 as position, height, player, grad_year, NEW_COLLEGE, university
32 : FROM DBO.view_PLAYER_DATA_ACTIVE_SEASON
33 : WHERE Club like <cfqueryparam cfsqltype="cf_sql_integer" value="#session.club#"> and
34 : (ACTIVE LIKE 'Y' OR ACTIVE LIKE 'R') AND
35 : reg_TEAM LIKE <cfqueryparam cfsqltype="cf_sql_integer" value="#form.team#"> AND
|