Where is the query that cases the error? The error is not caused when
tables are created.
On Sunday, 24 February 2013 16:52:31 UTC-6, Dan Kozlowski wrote:
>
> 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.
