Re: [web2py] Access DB2/400 from IBM i (AS/400) PASE environment

2017-04-29 Thread ramstein74
This topic is very important. Having web2py running in a top tech ibm machine is worthy of notice.Any help on this ... PLEASE Anyone know if there is a quick way to tell the DAL to ignore the case of the table/field names when connecting? Enviado a partir do meu smartphone Samsung Galaxy.

[web2py] Re: dal

2017-04-29 Thread Anthony
Additionally, to enforce the constraint with form submissions, you can do something like this: https://groups.google.com/d/msg/web2py/CRPySzABQTk/8jylUabyFTQJ. Anthony On Saturday, April 29, 2017 at 8:47:55 AM UTC-4, Pierre wrote: > > you would have to add a new constraint at the database

[web2py] Sponsoring a web2py to android recipe

2017-04-29 Thread Oasis Agano
Hello, I needed help to connect android to web2py and couldnt find any documentation online, i'm wondering if it is possible to pay someone to write a working recipe that has all the steps and code that are needed to connect and interact with web2py through an android native application. The

[web2py] Help with building query functions in a web app - links to tutorials etc

2017-04-29 Thread 'Matthew J Watts' via web2py-users
Hi there everyone! I'm new to Web2py, i'm really enjoying using the framework so far. I am trying to rebuild a legacy database. I want to produce a web app that can query data from multiple tables using drop down boxes e.g. locations, species etc.. I want to be able to select info using

[web2py] Re: dal

2017-04-29 Thread Pierre
you would have to add a new constraint at the database level like this: query="ALTER TABLE %s ADD CONSTRAINT %s UNIQUE (amcno,unitid);" %(tablename,constraintname) result=db.executesql(query) here a postgresql example to set the new constraint in a controller: def

[web2py] Re: dal

2017-04-29 Thread T.R.Rajkumar
What is the web2py way of ensuring uniqueness of amcno+unitid composite. amcno is not unique, unitid is also not unique but amcno+unitid need to be unique. how to ensure that? On Friday, April 28, 2017 at 1:12:24 PM UTC+5:30, T.R.Rajkumar wrote: > > I have a table in which two fields say amcno