[web2py] Web2py SQLFORM.grid with executesql

2015-11-14 Thread TYRANISTAR
Hello, I am making a web2py application and I have my two mysql tables defined in my models db.py file: db.define_table('table1', Field('id','integer'), Field('name','string'), migrate=False) db.define_table('table2', Field('id','integer'), Field('name','string'), migrate=False) I want

[web2py] SQLFORM calling a MySQL database returns Not authorized Insufficient privileges error

2015-04-28 Thread TYRANISTAR
Hello, I've made an application where I call a MySQL database and give the user the option of choosing the columns of the database to appear. Nevertheless when I try to click the link I get the Not authorized Insufficient privileges error without even having the chance to login. I used

[web2py] Re: Internal error Ticket issued: unrecoverable

2014-03-12 Thread TYRANISTAR
on filesystem. Did you accidentally change permissions? On Tuesday, 11 March 2014 09:20:44 UTC-5, TYRANISTAR wrote: Hello everyone, I have a simple application that returns a MySQL table using a SQLFORM.grid and requires a username-password authentication. My web2py application runs

[web2py] Internal error Ticket issued: unrecoverable

2014-03-11 Thread TYRANISTAR
Hello everyone, I have a simple application that returns a MySQL table using a SQLFORM.grid and requires a username-password authentication. My web2py application runs on Debian server via an Apache webserver. Up to this time it worked perfectly but after some point (for no good reason) it's

[web2py] Re: Union of tables displayed in SQLFORM.grid

2013-10-04 Thread TYRANISTAR
Thank you for your reply. Do you have an example on how to do that? Sorry for asking but I am still a newbie at web2py. Τη Πέμπτη, 3 Οκτωβρίου 2013 4:10:22 μ.μ. UTC+3, ο χρήστης TYRANISTAR έγραψε: Hello everyone, I have a big mysql table that I want to break into smaller ones in order

[web2py] Union of tables displayed in SQLFORM.grid

2013-10-03 Thread TYRANISTAR
Hello everyone, I have a big mysql table that I want to break into smaller ones in order to retrieve its results quicker via a web2py interface. Question is is there a way to call a union of the smalleer tables via SQLFORM.grid (giving the number and names of tables as arguments) and if not is

[web2py] SQLFORM.smartgrid linked tables links display empty tables and don't display the appropriate fields

2013-09-23 Thread TYRANISTAR
Hello everyone, I have two tables defined as such: # db.define_table('total_ec_numbers', Field('id','integer', label=T('ID')), Field('query_name','string', label=T('Gene ID')), Field('hit_name','string', label=T('Hit name')), Field('hit_accession','string', label=T('Hit

[web2py] SQLFORM.smartgrid linked tables

2013-09-20 Thread TYRANISTAR
Dear all, I have two mysql tables having the same entries in one of their fields (different number of rows though) and i want to link them using SQLFORM.smartgrid (or SQLFORM.grid if that's more convenient). I've defined the tables as such: db.define_table('total_genes',