SQLTABLE truncates at around 16 chars by default. Here is an example
to change that value to 100 in a view (this was obtained from the
book, for further details go there).
{{extend 'layout.html'}}
<h1>Records</h2>
{{=SQLTABLE(db().select(db.person.ALL),
headers='fieldname:capitalize',
truncate=100,
upload=URL('download'))
}}
On Mar 17, 12:27 am, "Adnan S." <[email protected]> wrote:
> Thanks Massimo.
>
> This does it, but with another problem.
>
> For some reason some of the fields get truncated with 3 dots at the
> end. Like the email, and the datetime field.
>
> Could it be that classes "odd" and "even" are limiting the size of
> fields?
>
> Here is the output, and it's the same with, and without the .xml:
>
> <tr class="odd">
> <td>123</td>
> <td>Name 1</td>
> <td>Last Name 1</td>
> <td>email181@ro...</td>
> <td/>
> <td>2010-02-07 17...</td>
> <td>146.4</td>
> <td>9544671</td>
> </tr>
>
> On Mar 16, 6:43 pm, Massimo Di Pierro <[email protected]>
> wrote:
>
> > if you use trunk and simply return orders and call the action
> > with .xml it should do what you asked.
> > You do not need a view
>
> > On Mar 16, 2:33 pm, "Adnan S." <[email protected]> wrote:
>
> > > Maybe I should ask instead, can anyone please point me in the right
> > > direction, to find out a proper way to export the xml file when
> > > joining 2 tables, and want only several fields in the xml file?
>
> > > Thanks.
>
> > > On Mar 15, 10:25 pm, "Adnan S." <[email protected]> wrote:
>
> > > > I used the code that Massimo posted for returning the xml, which works
> > > > perfectly fine when exporting from a single table, but when selecting
> > > > fields from two tables it gets stuck, due to table names propagated in
> > > > the resultset. Being a newbie w web2py and python I'm not finding an
> > > > elegant solution around it, but I know it must be there.
>
> > > > Here is a code snippet:
>
> > > > def export_orders_xml():
> > > > ...
> > > > orders = db(db.order_items.item_id==int(request.args(0)))\
> > > > (db.order_items.order_id==db.order1.id)\
> > > > .select(
> > > > db.order_items.order_id, \
> > > > db.order1.first_name, \
> > > > db.order1.last_name, \
> > > > )
>
> > > > return xml_list(orders)
>
> > > > #xml tags
> > > > def export_xml(rows, fields):
> > > > users=[]
> > > > for row in rows: users.append(TAG.user(*[TAG[f](row[f]) for f in
> > > > fields]))
> > > > return TAG.users(*users).xml()
>
> > > > #xml view
> > > > def xml_list(rows):
> > > > response.headers['Content-Type']='application/xml'
> > > > return export_xml(rows,['order_items','order1'])
> > > > # would prefer to use it this way: return export_xml(rows,
> > > > ['first_name','last_name'])
>
> > > > I think TAG should go around something like this:
> > > > row['table_name'].field, but not sure how to get to it :)
>
> > > > Rendered output:
> > > > - <users>
> > > > - <user>
> > > > <order_items><Row {'order_id': 123}></order_items>
> > > > - <order1>
> > > > <Row {'first_name': 'John', 'order_items': <gluon.dal.Set
> > > > object at
> > > > 0x1176689d0>, 'last_name': 'Test', 'update_record': <function <lambda>
> > > > at 0x117644050>, 'delete_record': <function <lambda> at 0x117644a28>}>
> > > > </order1>
> > > > </user>
>
>
