Your query looks wrong to me.
Do you want to have the saldos.id from another table? In this case the
query should look like: "SELECT * FROM name, saldos INNER JOIN saldos ON
name.id = saldos.id"
or you want to use a variable. In this case add: db.query("SELECT * FROM
name INNER JOIN saldos ON name.id = saldos.id", vars=locals())
But I may be wrong.
Am Montag, 23. März 2015 15:19:49 UTC+1 schrieb Santiago Bassani:
>
> HI,
> I've been trying to make a simple join using MySQL and webpy. The problem
> is that i don't understand very well what is wrong.
>
> the problem : "need more than 1 value to unpack"
>
> code : class modify:
> def GET(self):
> modify_query = db.query("SELECT * FROM name INNER JOIN
> saldos ON name.id = saldos.id")
> return render.modify(query = modify_query)
>
>
> if someone can helpme out I would appreciate
>
--
You received this message because you are subscribed to the Google Groups
"web.py" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/webpy.
For more options, visit https://groups.google.com/d/optout.
