[web2py] Re: Web2PY MySQL DB connection and data retrieval

2017-01-19 Thread Dave S
On Wednesday, January 18, 2017 at 8:54:00 PM UTC-8, Sankhajit Das wrote: > > > > On Thursday, January 19, 2017 at 10:11:53 AM UTC+5:30, Sankhajit Das wrote: >> >> how can i store all the sqlite database in a variable? smbdy help me >> with full code pls >> > > > or how can i write all the sqli

[web2py] Re: Web2PY MySQL DB connection and data retrieval

2017-01-18 Thread Sankhajit Das
On Thursday, January 19, 2017 at 10:11:53 AM UTC+5:30, Sankhajit Das wrote: > > how can i store all the sqlite database in a variable? smbdy help me > with full code pls > or how can i write all the sqlite data in a text file??/ -- Resources: - http://web2py.com - http://web2py.

[web2py] Re: Web2PY MySQL DB connection and data retrieval

2017-01-18 Thread Sankhajit Das
how can i store all the sqlite database in a variable? smbdy help me with full code pls -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received

[web2py] Re: Web2PY MySQL DB connection and data retrieval

2017-01-18 Thread Sankhajit Das
On Tuesday, January 17, 2017 at 8:14:01 PM UTC+5:30, Sankhajit Das wrote: > > hey. I have created a mysql database in my web2py app. >> > now i want to create another sqlite database such that whatever data i > enter > in sqlite database. it automatically gets copied in mysql database. > Pls so

[web2py] Re: Web2PY MySQL DB connection and data retrieval

2017-01-17 Thread 黄祥
perhaps you can put delete() or truncate() function to delete data in database table in form accepts() or form accepted() function best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.googl

[web2py] Re: Web2PY MySQL DB connection and data retrieval

2017-01-17 Thread Sankhajit Das
how can we delete data automatically from a table in database after clicking submit button of a form in web2py -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues

[web2py] Re: Web2PY MySQL DB connection and data retrieval

2017-01-17 Thread Dave S
On Tuesday, January 17, 2017 at 6:44:01 AM UTC-8, Sankhajit Das wrote: > > hey. I have created a mysql database in my web2py app. >> > now i want to create another sqlite database such that whatever data i > enter > in sqlite database. it automatically gets copied in mysql database. > Pls someb

[web2py] Re: Web2PY MySQL DB connection and data retrieval

2017-01-17 Thread Sankhajit Das
> > hey. I have created a mysql database in my web2py app. > now i want to create another sqlite database such that whatever data i enter in sqlite database. it automatically gets copied in mysql database. Pls somebody help me do ds with full code. -- Resources: - http://web2py.com - http:/

[web2py] Re: Web2PY MySQL DB connection and data retrieval

2013-10-18 Thread Vj
Got it. It worked now. Thanks. On Friday, October 18, 2013 1:31:11 PM UTC-4, Vj wrote: > > All, > > A new web2py & python user here. > > I am trying to build a sample webapp using web2py. My plan is to use MySQL > DB (tables already created with data). I want to retrieve data from the > table

[web2py] Re: Web2PY MySQL DB connection and data retrieval

2013-10-18 Thread Niphlod
if you don't want web2py to create the table, you need to do db.define_table('tablename', Field() . migrate=False ) Read here for the gotchas http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Legacy-databases-and-keyed-tables On Friday, October 18, 20