{% if result.kind == 'error' %}
  <div class="alert alert-danger"><code>{{ result.error }}</code></div>
{% elif result.kind == 'affected' %}
  {% if result.affected >= 0 %}
    <p>Rows modified: <code>{{ result.affected }}</code></p>
  {% else %}
    <p>Done.</p>
  {% endif %}
{% elif not result.rows %}
  <p>Empty result set.</p>
{% else %}
  <div class="table-wrapper">
  <table class="table table-striped small cell-content">
    <thead>
      <tr>
        {% if show_bulk %}
          <th style="width:24px;"><input id="toggle-pk-all" type="checkbox" aria-label="Select all rows" /></th>
        {% endif %}
        {% for col in result.columns %}
          <th data-col="{{ col }}">
            {% if in_script %}
              {{ col }}
            {% else %}
              {% set target = (-loop.index if loop.index == ordering else loop.index) %}
              <a href="{{ url_for(request.endpoint, table=table, sql=sql, ordering=target) }}">{{ col }}{% if ordering %}{% if loop.index == ordering %}&#9660;{% elif loop.index == -ordering %}&#9650;{% endif %}{% endif %}</a>
            {% endif %}
          </th>
        {% endfor %}
        <th></th>
      </tr>
    </thead>
    <tbody>
      {% for row in result.rows %}
        <tr>
          {% if show_bulk %}
            <td><input class="toggle-pk" name="pk" type="checkbox" value="{{ result.keys[loop.index0] }}" aria-label="Select row" /></td>
          {% endif %}
          {% for value in row %}
            {% set fk = fk_lookup and fk_lookup.get(result.columns[loop.index0]) %}
            <td{% if value is number %} class="num"{% endif %}>
              {% if value is none %}<code>NULL</code>{% elif fk %}<a href="{{ value|fk_link(fk) }}" title="{{ fk[0] }}.{{ fk[1] }}">{{ value }}</a>{% else %}{{ value|value_filter|safe }}{% endif %}
            </td>
          {% endfor %}
          <td>
            <a class="rowaction copy-row" href="#" title="Copy row as JSON" aria-label="Copy row as JSON"><svg class="icon"><use href="#i-copy"/></svg></a>
            {% if show_detail %}
              <a class="rowaction" href="{{ url_for('table_row_detail', table=table, pk=result.keys[loop.index0]) }}" title="View" aria-label="View"><svg class="icon"><use href="#i-eye"/></svg></a>
            {% endif %}
            {% if show_edit %}
              <a class="rowaction" href="{{ url_for('table_update', table=table, pk=result.keys[loop.index0]) }}" title="Edit" aria-label="Edit"><svg class="icon"><use href="#i-pencil"/></svg></a>
              <a class="rowaction" href="{{ url_for('table_delete', table=table, pk=result.keys[loop.index0]) }}" title="Delete" aria-label="Delete"><svg class="icon"><use href="#i-trash"/></svg></a>
            {% endif %}
          </td>
        </tr>
      {% endfor %}
    </tbody>
  </table>
  </div>
  {% if in_script and result.has_next %}
    <p><small>Showing first {{ result.rows|length }} rows.</small></p>
  {% endif %}
{% endif %}