I am getting the following message when I join the 2 files.
Query Not Supported: (1054, "Unknown column *'daily_counts.add_date*' in
'order clause'")
No records found
db.define_table('daily_counts',
Field('encrypt_count','integer'),
Field('decrypt_count','integer'),
Field('error_count','integer'),
Field('cycle_count','integer'),
Field('directory_create_count','integer'),
Field('client_add_count','integer'),
Field('client_update_count','integer'),
Field('client_delete_count','integer'),
Field('encryption_key_count','integer'),
*Field('add_date','date', unique=True),*
Field('add_time','time'),
Field('add_db_user','string'),
Field('add_app_user','string'),
Field('update_date','date'),
Field('update_time','time'),
Field('update_db_user','string'),
Field('update_app_user','string'))
db.define_table('history2',
Field('client_id','string',length=10),
Field('command','string',length=255),
Field('encrypt_key','string',length=50),
Field('from_dir','string',length=100),
Field('to_dir','string',length=100),
Field('archive_dir','string',length=100),
Field('error_dir','string',length=100),
Field('in_filename','string',length=100),
Field('out_filename','string',length=100),
Field('encryption_type','string'),
* Field('add_dateid',db.daily_counts),*
Field('add_date','date'),
Field('add_time','time'),
Field('add_db_user','string'),
Field('add_app_user','string'))
--
---
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.
