All pastes #163804 Raw Edit

Something

public xml v1 · immutable
·published 2006-09-07 22:22 UTC
rendered paste body
<IXLSNACK NAME="sql_call">			<PARAM NAME="QUERY">          SELECT pr.player_id, pr.period,                 decode(pg.home, 0, '@')||substr(tm2.name,0, length(tm2.name)-4) AS opp_name,                NVL (pr.sw_points, 0) swp, (case when nvl(pr.points_for, 0) > nvl(pr.points_vs,0) then 'W ' else 'L ' end)                ||nvl(pr.points_for,0)||' - '||nvl(pr.points_vs,0) as result            FROM player_results pr,               (SELECT NAME, player_id, position_id                  FROM player_research                 WHERE timeframe_id = 1) tm,               (SELECT NAME, player_id, position_id                  FROM player_research                 WHERE timeframe_id = 1) tm2,               cfoot_stat.player_game pg           WHERE pr.player_id = :var1               AND pr.player_id = tm.player_id               AND pr.opp_team_id = tm2.player_id               AND pr.position_id = 1               AND tm.position_id = pr.position_id               AND tm2.position_id = pr.position_id               AND pr.player_id = pg.player_id               AND pr.period = pg.period               AND pr.period < current_pick_period ()           ORDER BY period ASC			</PARAM>			<PARAM NAME="BIND_VAR_1">player_id</PARAM>			<PARAM NAME="ALTERNATING_ROWS">1</PARAM>			<PARAM NAME="ROW_ODD_PREFIX"><tr class="odd"></PARAM>			<PARAM NAME="ROW_EVEN_PREFIX"><tr class="even"></PARAM>			<PARAM NAME="ROW_ODD_SUFFIX"></tr></PARAM>			<PARAM NAME="ROW_EVEN_SUFFIX"></tr></PARAM>			<PARAM NAME="FIELD_1_SUFFIX">                            <td>&FIELD_2&</td>                <td>&FIELD_3&</td>                <td>&FIELD_5&</td>                <td>&FIELD_4&</td>                        </PARAM>			<PARAM NAME="FIELD_2_INV"></PARAM>			<PARAM NAME="FIELD_3_INV"></PARAM>			<PARAM NAME="FIELD_4_INV"></PARAM>      <PARAM NAME="FIELD_5_INV"></PARAM>			<PARAM NAME="MISSING"></PARAM>		</IXLSNACK>