Hi I have the following code
RSRecs = db(query).select(
db.weekly_data_reporting.supplier_code,
db.weekly_data_reporting.supplier_name,
db.weekly_data_reporting.item,
db.weekly_data_reporting.orderno,
db.weekly_data_reporting.usedon,
db.weekly_data_reporting.days,
db.weekly_data_reporting.status,
db.weekly_data_reporting.itemgroup,
db.projects.project_name,
db.forecasts.ALL,
orderby=[db.weekly_data_reporting.project,db.weekly_data_reporting.itemgroup,db.weekly_data_reporting.supplier_name,db.weekly_data_reporting.orderno],
left=db.forecasts.on(db.weekly_data_reporting.item==db.forecasts.item),
)
All data is returned except that every field in forecasts.item is empty. I
have tripple checked and I do have an item in "forecasts.item" that matches
"weekly_data_reporting.item". I am using postgres as my database.
Can you see anything wrong with my code?
--
---
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
