[web2py] MySQL and web2py error 1103

2017-07-28 Thread Jorgeluis Ortega
Hi, I'm working with web2py for some months, which seems to be a very interesting tool. I want to know if there is the possibility of manipulating MySQL data from my app inventor through web2py. I have tried a few methods but it gives me an error 1103 unable to post or put the text. I want t

Re: [web2py] MySQL and web2py

2011-02-04 Thread Vasile Ermicioi
you need to define your models before using dal expressions or you can execute raw sql db = DAL('mysql://username:password@localhost/test') list_of_dicts = db.executesql("SELECT * FROM mytable", as_dict=True)

Re: [web2py] MySQL and web2py

2011-02-04 Thread Bruno Rocha
I do not know how uwamp works, but for sure, web2py will connect to mysql using the connection string: mysql://username:password@localhost/test Just take the username, password, ip or host name and datatabase name in your model file define: db = DAL('mysql://username:password@localhost/test') h

[web2py] MySQL and web2py

2011-02-04 Thread stargate
Lets say I am running the web2py Server in windows. And for my mySQL database i am using http://www.uwamp.com/ Can web2py connect to that database using the connection string it has given in the example. What would i have to do to get the database working with web2py.