|Re: REGARDING SQL 99||Massimo Di Pierro||10/5/12 7:24 AM|
I am not sure about your assignment.
You can build a simple web2py applications like this:
db = DAL('sqlite://mydb.sqlite')
form = SQLFORM.factory(Field('sql','text'))
rows = db.executesql(sql)
return dict(page = DIV(DIV(form),DIV(BEAUTIFY(rows))))
it will make a form and allows you to interact with 'sqlite' database called 'mydb.sqlite' You can replace the
'sqlite://mydb.sqlite' string to interact with any other existing database. BBBBUUUUUTTTTT.....
1) No database follows exactely the SQL99 standard
2) web2py was not designed to do this. It was designed NOT to do this.
3) web2py was designed so that users NEVER write SQL. Ever. SQL is dangerous, unsafe, error prone, database dependent (it is not standard as they say in school).
4) I am not sure I am understanding your assignment correctly and, in fact, I am pretty sure I am not.
On Friday, 5 October 2012 05:04:52 UTC-5, dantuluri jaganadha raju wrote:
|Re: REGARDING SQL 99||Derek||10/8/12 2:02 PM|
Massimo, I agree with your points, not necessarily 3, but then again, i've had many years of experience writing sql queries, so i know what can go wrong, and i know why you might say that to a beginner.