Thank you, worked like a charm!
In my application, we are tracking the techs, but they do not have
permission to use the app, so they are not in the the auth table. I will
keep all of your input in mind as I continue to work in web2py, this is
great info especially for a beginner like me!!
On Tuesday, May 7, 2013 2:09:40 PM UTC-6, Anthony wrote:
>
> *tip: '{{db.executesql('SELECT first_name, last_name FROM tech WHERE id =
>> 'row.tech';')}}',*
>
>
> There are several things wrong with the above. First, you're getting a
> syntax error because you've got 'row.tech' in single quotes inside a string
> that is also in single quotes. Second, the SQL string is just a string that
> gets passed to the database, so it cannot contain Python variables like
> "row.tech". Finally, if you want to write something into a template inside
> the {{...}} delimiters, you need to use "=" (i.e., {{=db.executesql(...)}}).
> Anyway, there's no reason to use executesql() here -- this does the same
> thing as the DAL select.
>
> Also, why does the db.tech table include first_name and last_name columns
> -- aren't those redundant with the same columns in db.auth_user?
>
> Anyway, since row.tech is the id in the db.tech table, you can use it to
> select the record from that table and fill in a string with the fields you
> want:
>
> tip: '{{='%(first_name)s %(last_name)s' % db.tech(row.tech)}}'
>
> However, that will do an additional select for each tech, which is
> inefficient if you have a long list. Instead, you might consider making
> your initial query a join and include the name fields in the main rows
> object:
>
> def mycal():
> rows=db((db.work_order.tech==auth.user.id) & (db.work_order.tech==db.
> tech.id))\
> .select(db.work_order.ALL, db.tech.first_name, db.tech.last_name)
>
> and in the view:
>
> tip: '{{='%(first_name)s %(last_name)s' % row.as_dict()['tech']}}'
>
> Anthony
>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
