Comments (5)
I don't think I want to make quoting columns as default option. It makes the generated queries ugly. One way to support it is to set a flag to enable quoting columns.
db.quoting_columns = True
or have a web.config setting.
I'm willing to support this if someone sends a patch. Any takers?
from webpy.
i think its idiot to make it work like that, not only is it to support a bad programming practice, cause it would allow for reserved words to be used, it could also bit developers in the ass years from now who needs to migrate the data-sets to another database environment. Making webpy forgive this "error", would not be preferred by me.
ps. sorry for digging up a issue 2 years ago, just wanted to put in my 2 cents ;-)
from webpy.
Actually, it causes error in mysql 5.5, . A syntax error is raised by mysql when INSERT is made without quoting the column names.
from webpy.
Isn't it fixed yet? Coz i didn't find any fix in web.db code =( Anyway, to be able to use db.insert i use some unpleasant 'hack':
db.insert('tablename',**{'"field1"':'value1','"field2"':'value2'})
from webpy.
Do you guys still have this issue? I personally didn't experience this issue at all with the latest web.py-0.39.
Please try web.py-0.39 first, if still not work, please share some code snippet to help reproduce this issue.
from webpy.
Related Issues (20)
- Use re.fullmatch HOT 5
- CORS origin not working HOT 2
- how to get the balance of nft ? erc721
- python2 to python3 changes
- python2 to python3 changes
- python2 to python3 difference
- UnicodeError while handling a bug HOT 6
- when will it be v1.0? HOT 1
- mssql can not get data HOT 1
- failed to compile the project due to "ImportError" HOT 3
- Document development setup HOT 1
- CI failing lint/ruff on unchanged lines HOT 2
- UnicodeDecodeError in 0.70 HOT 3
- pip install web.py doesn't install the latest version. HOT 4
- Just a suggestion, is there any plan to unify the name? HOT 1
- Please add nginx unit as "production" platform! HOT 7
- sqlite3's default datetime and timestamp adapters are deprecated as of Py3.12 HOT 1
- Python 3.12: tokenize.TokenError: ('unterminated string literal HOT 4
- Maintainance of the project HOT 10
- Can't shutdown the server. HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from webpy.