Hi all,

I have this function where i i use mssqlalchmy to to fetch data from a mssql database. I am fetching data from a column but what i am interested in, is just to get a data from last field/row on that column.

is there are way to get that done from template?. this what i have done from the template.html but i am getting an error : could not parse the remainder '[-1]'

template.html

<table class="table table-striped">
  <thead>
<tr>
 
  <th> GL Rate</th>

</thead>

</tr>
{%for a in results%}

<tr>

  <td>{{a.buy_rate[-1]}}</td>

  </tr>

{%endfor%}
</table>

view.py
def rate(request):
    engine=create_engine('mssql+pymssql://username:passwprd@localhost /database')
    connection=engine.connect()
    metadata=MetaData()
    funds=Table('mccurtdt',metadata,autoload=True,autoload_with=engine)
   
    stmt=select([funds.columns.buy_rate])
    stmt=stmt.where(and_(funds.columns.rate_type=='MID',funds.columns.from_currency=='AUD',))
    results=connection.execute(stmt).fetchall()
    return render_to_response('rate.html',locals())

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAPCf-y5EMP6qx59zzfQ-xx-7kz2QbUO%2Bq23pPvJdXTb0B9fdqw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.