Yes, that is true,you'd have to join by the primary ID field of the other
table. But, looking at your table, couldn't you use the ID instead of the
date? I guess I'm a bit anal about the way I like tables, I always use the
ID fields.
On Tue, Feb 19, 2013 at 9:30 PM, Dan Kozlowski wrote:
> Jim
Jim,
Sorry to bother you again but still can't get this working. I need to join
my 2 tables by a date and not the DB ID key. Not sure if this can be done
since it looks like Web2Py looks to join by DB ID only. In SQL this would
be a simple join by date after building a date index on the date fi
Dan
the problem is that you are using SQLFORM.grid instead of
SQLFORM.smartgrid. Try changing that and you should be good. Sorry for
the delay, had a busy weekend
-Jim
On Saturday, February 16, 2013 12:20:22 PM UTC-6, Dan Kozlowski wrote:
>
> Jim,
>
> I still can't get it working. I hav
Jim,
I still can't get it working. I have dailycounts which is one record per
day and has many history records per day. Looking for a button to show all
the history records when a day is selected form dailycounts. Below is the
controller and DAL
Thanks
def dailycounts():
grid=SQLFORM.gr
This should be the default behavior if you have your tables and relations
defined properly. If it isn't then you can provide other links using the
'links' parameter that you can pass to SQLFORM.smartgrid. If that doesn't
make sense, post the code, table defs and call to SQLFORM.smartgrid and w
5 matches
Mail list logo
