One thing I see is that

 
db(request.vars.query).select(db.sarua.All,limitby(1,250)).export_to_csv_file(s)

should be

 
db(request.vars.query).select(db.sarua.ALL,limitby=(0,250)).export_to_csv_file(s)



On Apr 10, 4:56 pm, Johann Spies <[email protected]> wrote:
> I have this in my view:
>
> <a href={{URL(r=request,f='csv',vars=dict(query=query))}}>
>    Download as csv-file </a>
>
> And this controller:
>
> def csv():
>    import cStringIO
>    s=cStringIO.StringIO()
>    response.headers['Content-Type']='application/vnd.ms-excel'
>    
> db(request.vars.query).select(db.sarua.All,limitby(1,250)).export_to_csv_file(s)
>    return s.getvalue()
>
> When I click on the link, it seems the browser shows some sort
> activity but there is no download taking place. What am I doing wrong?
>
> I will be so glad if I can get this working.  I have spent many hours
> in trying to get it to work.
>
> Regards
> Johann
> --
> "Finally, brethren, whatsoever things are true,  whatsoever things are
> honest, whatsoever things are  just, whatsoever things are pure,
> whatsoever things are lovely, whatsoever things are of good report; if
> there be any virtue, and if there be any praise, think on these
> things."    Philippians 4:8

Reply via email to