Groups
Sign in
Groups
web2py-users
Conversations
Labels
API
Catalina
DAL
Field
GAE
GIS
HL7
JavaSctipt
LOAD
MySQL
Paypal
PostgreSQL
REST
RFC
URL
admin
advocacy
ajax
apache
app
appadmin
args
array
auth
backups
bug
bugfixes
cache
calendar
callback
components
contract
contrib
controller
create
criticism
crud
css
csv
dal
database
date
db
debugging
delete
demo
deployment
development
docker
documentation
e-learning
edit
error
error_handling
exception
expiration
folder
for
form
forms
framework
gluon
grid
html
html_helpers
ide
imap
import
input
internationalization
is_scheduler
javascript
jquery
json
keyed
l
legacy
links
login_bare
mac
mail
markmin
minor
models
modules
movuca
networking
nginx
nosql
operators
packages
password
payments
plugin
plugins
post
primarykey
product
py4web
pyDAL
pycharm
pyodel
python
python3
pythonanywhere
query
redirect
redis
registration
release
request
requires_login
rewriting
routing
save
scheduler
service
services
session
session_auth
sessions
setup
site
smtp
social
sqlform
sqlite
ssl
static
stupid_css
symbol
table
tampering
testing
trunk
typo
upgrade
upload
uploadfolder
uploads
users
uwsgi
validation
versios
views
w
web2py
web2pyslices
websockets
widget
wiki
About
Send feedback
Help
web2py-users
Contact owners and managers
1–30 of 34885
Mark all as read
Report group
0 selected
João Matos
, …
Anthony
5
4/2/19
Q&A
Is it possible to show the results from a SELECT (made with SQLite using db.executesql) in a grid?
Thanks for the tip Anthony. Is the purpose of the fake_migrate parameter only for the scenarios in
unread,
grid
sqlite
Q&A
Is it possible to show the results from a SELECT (made with SQLite using db.executesql) in a grid?
Thanks for the tip Anthony. Is the purpose of the fake_migrate parameter only for the scenarios in
4/2/19
João Matos
, …
Anthony
19
3/25/19
Q&A
Does web2py/DAL allow for creating atomic operations (begin transaction/end transaction)?
@John and @Anthony Thanks for your time. @John I disagree with you about the corner thing. With
unread,
PostgreSQL
dal
sqlite
Q&A
Does web2py/DAL allow for creating atomic operations (begin transaction/end transaction)?
@John and @Anthony Thanks for your time. @John I disagree with you about the corner thing. With
3/25/19
João Matos
,
Leonel Câmara
3
3/20/19
Q&A
When using SQLite does web2py use the older rollback-mode transaction mechanism or the newer WAL?
Thanks. quarta-feira, 20 de Março de 2019 às 23:16:46 UTC, Leonel Câmara escreveu: Looking at: https:
unread,
dal
sqlite
Q&A
When using SQLite does web2py use the older rollback-mode transaction mechanism or the newer WAL?
Thanks. quarta-feira, 20 de Março de 2019 às 23:16:46 UTC, Leonel Câmara escreveu: Looking at: https:
3/20/19
João Matos
, …
Anthony
10
5/5/19
Q&A
I would like to log of all SQL commands web2py sends to SQLite. Is it possible?
Logger is defined here: https://github.com/web2py/pydal/blob/master/pydal/base.py#L254 Debug logging
unread,
dal
sqlite
Q&A
I would like to log of all SQL commands web2py sends to SQLite. Is it possible?
Logger is defined here: https://github.com/web2py/pydal/blob/master/pydal/base.py#L254 Debug logging
5/5/19
Tom Campbell
,
Massimo Di Pierro
2
5/5/18
Q&A
SQLite data file in production-backing up
.htaccess? I would not recommend using apache. Use nginx. On Thursday, 3 May 2018 03:35:39 UTC-5, Tom
unread,
sqlite
Q&A
SQLite data file in production-backing up
.htaccess? I would not recommend using apache. Use nginx. On Thursday, 3 May 2018 03:35:39 UTC-5, Tom
5/5/18
LoveWeb2py
,
Anthony
14
10/3/17
Q&A
Insert into reference:list not working - FOREIGN KEY constraint failed field:upload
I moved all of the table files to an archive directory and let everything rebuild and it worked great
unread,
dal
sqlite
Q&A
Insert into reference:list not working - FOREIGN KEY constraint failed field:upload
I moved all of the table files to an archive directory and let everything rebuild and it worked great
10/3/17
Artem
, …
Pbop
9
9/1/17
Q&A
Two database join query
In SQL Server, you can run queries across database tables following the syntax you mention if you
unread,
dal
models
query
sqlite
table
Q&A
Two database join query
In SQL Server, you can run queries across database tables following the syntax you mention if you
9/1/17
Maurice Ling
6/9/17
Q&A
ValueError in encypted field using filter_in/filter_out
Hi I am trying to encrypt a field (using pyDes.py which is located in modules folder of my
unread,
Field
dal
sqlite
Q&A
ValueError in encypted field using filter_in/filter_out
Hi I am trying to encrypt a field (using pyDes.py which is located in modules folder of my
6/9/17
Maurice Ling
6/7/17
Q&A
Key length error when trying to store encrypted value into field using gluon.contrib.AES
Hi all, I am trying to store one or more encrypted values into their respective fields, which has to
unread,
Field
contrib
dal
error
sqlite
Q&A
Key length error when trying to store encrypted value into field using gluon.contrib.AES
Hi all, I am trying to store one or more encrypted values into their respective fields, which has to
6/7/17
Oasis Agano
, …
Pierre
3
5/13/17
Q&A
Web2py Postgresql Groupby issue
here: http://web2py.com/books/default/search/29?search=groupby s = db.table.field_a | db.table.
unread,
PostgreSQL
query
sqlite
Q&A
Web2py Postgresql Groupby issue
here: http://web2py.com/books/default/search/29?search=groupby s = db.table.field_a | db.table.
5/13/17
Oasis Agano
, …
Anthony
7
9/30/16
Q&A
Sum issues while computing the total of a table field
Solved by this Controller def dashboard_admin(): query = (db.payslip.state == 'Confirmed')
unread,
dal
sqlite
Q&A
Sum issues while computing the total of a table field
Solved by this Controller def dashboard_admin(): query = (db.payslip.state == 'Confirmed')
9/30/16
Jörg Schneider
8/12/16
Q&A
sqlite-Error with list:reference
I want to reference a project with a list of auth.users and get 'sqlite3.IntegrityError'>
unread,
dal
sqlite
table
Q&A
sqlite-Error with list:reference
I want to reference a project with a list of auth.users and get 'sqlite3.IntegrityError'>
8/12/16
Shayn Raney
, …
Anthony
7
3/10/16
Q&A
unable to see sqlite tables created through console using python console using gluon
On Wednesday, March 9, 2016 at 7:11:12 PM UTC-5, Shayn Raney wrote: This is some rabbit hole, looks
unread,
sqlite
Q&A
unable to see sqlite tables created through console using python console using gluon
On Wednesday, March 9, 2016 at 7:11:12 PM UTC-5, Shayn Raney wrote: This is some rabbit hole, looks
3/10/16
Niphlod
,
Dave S
5
12/10/15
Q&A
Re: Accessing / connecting to web2py database with GUI
On Thursday, December 10, 2015 at 3:39:07 PM UTC-8, Dave S wrote: [...] SQLite3 is a fairly robustly
unread,
admin
dal
sqlite
Q&A
Re: Accessing / connecting to web2py database with GUI
On Thursday, December 10, 2015 at 3:39:07 PM UTC-8, Dave S wrote: [...] SQLite3 is a fairly robustly
12/10/15
Maurice Waka
6/10/15
Q&A
convert sqlite code to DAL
I have been working with sqlite DB for some time but want to integrate my codes to web2py esp. DAL.
unread,
sqlite
web2pyslices
Q&A
convert sqlite code to DAL
I have been working with sqlite DB for some time but want to integrate my codes to web2py esp. DAL.
6/10/15
Ron Chatterjee
, …
Richard Vézina
27
4/27/15
Q&A
creating DAL from SQL file
You know what... You may consider using an older web2py version... If possible the version which saw
unread,
dal
sqlite
Q&A
creating DAL from SQL file
You know what... You may consider using an older web2py version... If possible the version which saw
4/27/15
Ruchir Sharma
11/18/14
Q&A
Validating user input: No SPACES in textbox
Hello, I need validated input from user in a particular field. The input entered by user must not
unread,
sqlform
sqlite
validation
Q&A
Validating user input: No SPACES in textbox
Hello, I need validated input from user in a particular field. The input entered by user must not
11/18/14
LoveWeb2py
, …
Anthony
4
10/21/14
Q&A
did I structure my table and table reference wrong?
Note, qa.question.title will do a recursive select (a separate additional query for each record), so
unread,
dal
sqlite
Q&A
did I structure my table and table reference wrong?
Note, qa.question.title will do a recursive select (a separate additional query for each record), so
10/21/14
Niels Jensen
,
Derek
3
9/9/14
Q&A
Best way to store tabular data when database isn't really needed?
Good point. I guess I'm just used to storing disposable data in disposable variables. I won't
unread,
app
dal
sqlite
Q&A
Best way to store tabular data when database isn't really needed?
Good point. I guess I'm just used to storing disposable data in disposable variables. I won't
9/9/14
Ali Kayes
,
Massimo Di Pierro
2
8/8/14
Q&A
web2py db manual table entries
Do you have a shell open with a transaction uncommitted? Or perhaps another instance of web2py that
unread,
dal
models
sqlite
table
Q&A
web2py db manual table entries
Do you have a shell open with a transaction uncommitted? Or perhaps another instance of web2py that
8/8/14
Leonel Câmara
, …
lyn2py
10
7/10/14
Q&A
DAL Bug?
But lyn2pi that's what the delete is doing (marking them inactive), my only peeve is with the
unread,
bug
dal
sqlite
Q&A
DAL Bug?
But lyn2pi that's what the delete is doing (marking them inactive), my only peeve is with the
7/10/14
Gideon George
,
Massimo Di Pierro
2
7/3/14
Q&A
How can I import an existing database to my db.py model?
You should be able from the shell to do: db = DAL('myql:....') db.executesql(open('...../
unread,
dal
import
sqlite
Q&A
How can I import an existing database to my db.py model?
You should be able from the shell to do: db = DAL('myql:....') db.executesql(open('...../
7/3/14
KRG KCIHTRAK
, …
Massimo Di Pierro
3
6/25/14
Q&A
how to making a field unique based on another field's value
It is not too simple. Given: db.define_table('table1', Field('name')) db.define_table
unread,
sqlite
Q&A
how to making a field unique based on another field's value
It is not too simple. Given: db.define_table('table1', Field('name')) db.define_table
6/25/14
Wonton
, …
黄祥
7
4/14/14
Q&A
Broken migration
Oks, it's clear to me now. I'll change this. Thank you very much again! On Monday, April 14,
unread,
Field
dal
sqlite
table
Q&A
Broken migration
Oks, it's clear to me now. I'll change this. Thank you very much again! On Monday, April 14,
4/14/14
Wonton
,
Massimo Di Pierro
3
3/5/14
Q&A
DAL ignoring accents
Thank you Massimo, I'll do that. On Monday, March 3, 2014 1:19:08 AM UTC+1, Massimo Di Pierro
unread,
dal
sqlite
Q&A
DAL ignoring accents
Thank you Massimo, I'll do that. On Monday, March 3, 2014 1:19:08 AM UTC+1, Massimo Di Pierro
3/5/14
Rene Dohmen
, …
Niphlod
4
2/28/14
Q&A
Weird truncate performance problem after upgrade to 2.8.2
wait a second....... - DROP - TRUNCATE - DELETE what are you doing in web2py and what are you issuing
unread,
dal
sqlite
Q&A
Weird truncate performance problem after upgrade to 2.8.2
wait a second....... - DROP - TRUNCATE - DELETE what are you doing in web2py and what are you issuing
2/28/14
pythonic...@gmail.com
, …
Niphlod
9
1/5/14
Q&A
How to declare a pre-defined sqlite database
Thanks! I'll give it a go and see what happens. :-) On Sunday, January 5, 2014 1:02:52 PM UTC,
unread,
dal
models
sqlite
Q&A
How to declare a pre-defined sqlite database
Thanks! I'll give it a go and see what happens. :-) On Sunday, January 5, 2014 1:02:52 PM UTC,
1/5/14
dave
,
Massimo Di Pierro
4
8/18/13
Q&A
db.mytable.myfield.contains() gives an error Query Not Supported: parser stack overflow
you can pass a list, http://www.web2py.com/book/default/chapter/06#like,-regexp,-startswith,-contains
unread,
dal
error
sqlite
Q&A
db.mytable.myfield.contains() gives an error Query Not Supported: parser stack overflow
you can pass a list, http://www.web2py.com/book/default/chapter/06#like,-regexp,-startswith,-contains
8/18/13
Dave Carlson
, …
Jim Gregory
6
8/3/13
Q&A
Copy data from one db into another
Are you using any special characters in the password for the MySQL database? I've found that can
unread,
error_handling
models
sqlite
Q&A
Copy data from one db into another
Are you using any special characters in the password for the MySQL database? I've found that can
8/3/13
Cform
,
Alan Etkin
2
7/2/13
Q&A
Specific SQLForm Field Selection and Variables
This might be sort of an easy question so I apologize. I am making an application where the user
unread,
forms
sqlite
validation
Q&A
Specific SQLForm Field Selection and Variables
This might be sort of an easy question so I apologize. I am making an application where the user
7/2/13