Re: [web2py] wordpress2py

2010-05-02 Thread Thadeus Burgess
Well... he forgot to include the license and everything :) And doesn't mention where to even get the module. -- Thadeus On Sun, May 2, 2010 at 12:12 PM, Thadeus Burgess thade...@thadeusb.com wrote: He stole my code! -- Thadeus On Sun, May 2, 2010 at 9:24 AM, mdipierro mdipie

Re: [web2py] wordpress2py

2010-05-02 Thread Thadeus Burgess
, 2010 at 12:31 PM, Jason Brower encomp...@gmail.com wrote: He may be a novice at this, or may think it's too simple for a license. Let's be calm and figure the situation out before throwing something like that out. BR, Jason On Sun, 2010-05-02 at 12:12 -0500, Thadeus Burgess wrote: He stole my

Re: [web2py] wordpress2py

2010-05-02 Thread Thadeus Burgess
When I first looked at it I just scanned and thought he was claiming it as his own. But it does not seem to be that way, he is just mirroring information, which I suppose is fine. However he should be including proper citations and sources for the content, with links to them. /overreaction off

Re: [web2py] Disabling few functions for certain users

2010-04-30 Thread Thadeus Burgess
You need to store the preferences in the database, what seems to be happening is you are setting the disabled actions, but its being lost on the next request. So along with your auth_user table you probably need to add a couple boolean columns to disable these options, this way it is persistant.

Re: [web2py] chained option box

2010-04-30 Thread Thadeus Burgess
Your model looks good. You will need to use javascript and ajax to get the effects that you desire. Basically, hook into the first options box change event, and on_change send an ajax request to the server requesting the 'spenton' fields for 'spent', and then take the returned results and

Re: [web2py] Disabling few functions for certain users

2010-04-30 Thread Thadeus Burgess
I don't think that this is the case. Because since you have both normal users and facebook users =? And you do not have to be logged in to retrieve password. -- Thadeus On Fri, Apr 30, 2010 at 9:38 AM, Jonathan Lundell jlund...@pobox.com wrote: On Apr 30, 2010, at 7:22 AM, Thadeus Burgess

Re: [web2py] Re: Small bug in helpers

2010-04-30 Thread Thadeus Burgess
This is because of a python syntax. You just can't have variables with a dash in the name :) (this goes for almost every other programming language) -- Thadeus On Fri, Apr 30, 2010 at 9:13 PM, mdipierro mdipie...@cs.depaul.edu wrote: You cannot do

Re: [web2py] Re: Web2py or Python 2.5 consumes too much RAM

2010-04-30 Thread Thadeus Burgess
I can confirm that with 9.04, 9.10, and 10.04 do not have this problem. -- Thadeus On Fri, Apr 30, 2010 at 9:17 PM, mdipierro mdipie...@cs.depaul.edu wrote: I have seen this before with ubuntu 8.04. There is a memory leak. I do not think it is in web2py but could not get to the bottom if

Re: [web2py] Re: Web2py Utilities

2010-04-29 Thread Thadeus Burgess
there! I want to get the layout manager working better so that you can hot-swap layouts like in wordpress. -- Thadeus On Thu, Apr 29, 2010 at 9:09 AM, DenesL denes1...@yahoo.ca wrote: Thanks for sharing. On Apr 28, 9:02 pm, Thadeus Burgess thade...@thadeusb.com wrote: I have decided to share

Re: [web2py] Re: Application logging

2010-04-29 Thread Thadeus Burgess
+1 for a enterprise logging system that you can configure the backend :) -- Thadeus On Thu, Apr 29, 2010 at 10:52 AM, Mathieu Clabaut mathieu.clab...@gmail.com wrote: The use of python logging modules inside web2py will ideally allow people to use syslog or any other logging back end

[web2py] Apps that can share models

2010-04-29 Thread Thadeus Burgess
I know this has come up previously, however there is still no good solution to this problem. I have two apps that I want them to share a couple of the same database models. In import-based frameworks this is easy, you just import the database models like any other python package. So far these

Re: [web2py] restart web2py command line

2010-04-29 Thread Thadeus Burgess
How are you running web2py? If I need to kill a web2py process that I started from the command line, but lost its process id I do the following command $: ps aux | grep web2py tburgess 12854 0.0 0.5 394812 62296 ?Sl 11:24 0:04 /usr/bin/python2.6 -u

Re: [web2py] Proposed patch for SQLTABLE

2010-04-29 Thread Thadeus Burgess
There is also a bug in appadmin that when you sort you get the list sorted, but if you browse the next 100 records, the sorting reverses itself. Do you think this would fix that bug as well? -- Thadeus On Thu, Apr 29, 2010 at 3:35 PM, Philip philip.el...@gmail.com wrote: I'm not sure the

Re: [web2py] Cannot compile: there are errors in your app:

2010-04-29 Thread Thadeus Burgess
Something is wrong with your syntax somewhere. You can try and temporarily patch applications/admin/compile and remove the exception catch, that way you can determine the exact line that is causing the error. -- Thadeus On Thu, Apr 29, 2010 at 9:41 PM, DJ sebastianjaya...@gmail.com wrote:

Re: [web2py] request with args

2010-04-28 Thread Thadeus Burgess
session.flash = message On this note, I would almost like to suggest a patch to the usage of response.flash. Currently it is just a string, however I suggest that we make it standard to use it as a list. Several times I have had my response.flash overwritten by either a plug-in or my own when I

Re: [web2py] NTLM Challenge Response

2010-04-28 Thread Thadeus Burgess
Try. raise(HTTP(401, headers={'WWW-Authenticate': 'NTLM'})) -- Thadeus On Wed, Apr 28, 2010 at 11:33 AM, Mark Larsen larsen...@gmail.com wrote: I'm curious if something like this: http://www.rgagnon.com/javadetails/java-0441.html Can be done with web2py? Essentially I need to:

Re: [web2py] Re: request with args

2010-04-28 Thread Thadeus Burgess
So you shoudl do def update_form(): if not (club and address and nfas and persoon): session.flash = You have been redirected because you did not supply all of the correct data redirect(URL(r=request, a='init', c='clublocator', f='application_form')) return dict(form=form) Then

Re: [web2py] Re: web2py-zen

2010-04-28 Thread Thadeus Burgess
good job hamdy! -- Thadeus On Wed, Apr 28, 2010 at 7:20 PM, hamdy.a.farag hamdy.a.fa...@inbox.com wrote: :)  me

Re: [web2py] zoolander

2010-04-28 Thread Thadeus Burgess
reminds me of clevercss. -- Thadeus On Wed, Apr 28, 2010 at 7:51 PM, mdipierro mdipie...@cs.depaul.edu wrote: http://fitzgen.github.com/zoolander/

[web2py] Web2py Utilities

2010-04-28 Thread Thadeus Burgess
I have decided to share some of the libraries that I have found useful when creating web2py apps. This contains lots of goodies, and some nice shortcuts. * Common shortcuts * Widgets * py2jquery module * Heirarchical category module. * Database store configuration settings

Re: [web2py] Re: zoolander

2010-04-28 Thread Thadeus Burgess
API to generate CSS. I think zoolander clevercss as the web2py template languages is to Django's. zoolander is a single very very short file. I am thinking it may even go into contrib. Massimo On Apr 28, 8:00 pm, Thadeus Burgess thade...@thadeusb.com wrote: reminds me of clevercss

Re: [web2py] Re: zoolander

2010-04-28 Thread Thadeus Burgess
web2py views are an easy way to make your CSS dynamic. I just do not find any practical application for it. Kudos to the author, its a neat little experimental project.

Re: [web2py] Re: Webfaction rocks

2010-04-27 Thread Thadeus Burgess
You should be able to tell your browser (if firefox) to accept the SSL certificate anyways. At least, you have to do that with self-signed certificates as well. As far as publishing SSH, sometimes I just fire up a program called gFTP (for Ubuntu Linux), and SFTP (ssh-ftp) into my account, and

Re: [web2py] Pypi

2010-04-27 Thread Thadeus Burgess
Are we supposed to be able to easy_install this? -- Thadeus On Tue, Apr 27, 2010 at 11:48 PM, mdipierro mdipie...@cs.depaul.edu wrote: Does this work for you? http://pypi.python.org/pypi?:action=displayname=web2pyversion=1.77.3 I posted 1.54 long ago but I forgot to uncheck the hide

Re: [web2py] Re: Webfaction rocks

2010-04-25 Thread Thadeus Burgess
- SSH into the machine, navigate to your root web2py directory (containing web2py.py), and then run ``python2.5 web2py.py -a yourpass`` - Then rename parameters_8000.py to parameters_443.py - Make sure you have HTTPS triggered for your domain inside the webfaction control panel. Replace your app

Re: [web2py] Re: ValueError: invalid literal for int() with base 10:

2010-04-24 Thread Thadeus Burgess
Since the Reference object now will query for a reference record when you call it, you can do things like:: dogs = db().select(db.dog.ALL) for dog in dogs: dog.name dog.owner.name So the refernece column is actually called owner, insetad of owner_id. It doesn't make sense to do

Re: [web2py] Re: ValueError: invalid literal for int() with base 10:

2010-04-24 Thread Thadeus Burgess
I see. Clarified! -- Thadeus On Sat, Apr 24, 2010 at 1:34 PM, DenesL denes1...@yahoo.ca wrote: he also had a 'companyapplication' table with an 'app -- Subscription settings: http://groups.google.com/group/web2py/subscribe?hl=en

[web2py] Bug in crondance

2010-04-23 Thread Thadeus Burgess
If I have empty lines in my crontab file I get the follow traceback. Remove empty lines crontab works. Traceback (most recent call last): File /home/tburgess/Applications/web2py/web2py.py, line 20, in module gluon.widget.start(cron=True) File

Re: [web2py] Re: Bug in crondance

2010-04-23 Thread Thadeus Burgess
Oops, my bad, I should have noticed the previous post. -- Thadeus On Fri, Apr 23, 2010 at 12:18 PM, mdipierro mdipie...@cs.depaul.edu wrote: There is already a bug report for this and a fix in the pipeline. I will post to trunk tonight. Massimo On Apr 23, 11:54 am, Thadeus Burgess thade

[web2py] How to use YAML fixturing with web2py

2010-04-22 Thread Thadeus Burgess
I wrote a blog post on fixutres and pre-loading your database with default data. http://thadeusb.com/weblog/archive/2010/4/21/using_fixtures_in_web2py/36 I am looking for an implementation to load YAML files that consists of one file (it only has to perform loading on the most basic YAML

Re: [web2py] repeated call of form.accepts produces odd results

2010-04-22 Thread Thadeus Burgess
Of course, accepts() is not ment to be called multiple times. The reason it swallows is because it uses sessions to prevent double submission. So basically calling form.accepts twice is like double submitting the form from your controller. To avoid protection against double submission, just call

Re: [web2py] Re: http://www.web2py.com doesnt load

2010-04-22 Thread Thadeus Burgess
the night before but weeks before. Most people only download stable releases. Massimo On Apr 21, 7:49 pm, Thadeus Burgess thade...@thadeusb.com wrote: I like Yarko's proposal of R- as it will stay in line with B- B2-, RC- etc etc. Hopefully we can get to a point we start having release

Re: [web2py] Re: Display contents of a folder

2010-04-22 Thread Thadeus Burgess
Yes, for the view. It is web2py helpers constructing valid XHTML code that is properly escaped. Also, for situations like this, the X-Sendfile header would be perfect ! -- Thadeus On Thu, Apr 22, 2010 at 9:25 AM, greenpoise danel.sega...@gmail.com wrote: It works. Thanks. Is this

Re: [web2py] Re: Display contents of a folder

2010-04-22 Thread Thadeus Burgess
to predefine wildcards and it worked fine. What is X-Sendfile? thanks Dan On Apr 22, 11:35 am, Thadeus Burgess thade...@thadeusb.com wrote: Yes, for the view. It is web2py helpers constructing valid XHTML code that is properly escaped. Also, for situations like this, the X-Sendfile header would

Re: [web2py] Re: rocket performance

2010-04-22 Thread Thadeus Burgess
I know I have been talking about x-sendfile alot lately Is there any reason that rocket should support it? -- Thadeus On Tue, Apr 20, 2010 at 4:06 PM, mdipierro mdipie...@cs.depaul.edu wrote: ok. will fix this soon. On Apr 20, 4:03 pm, Timothy Farrell tfarr...@swgen.com wrote: Ton's

Re: [web2py] Re: Auto Creating Users/Groups/Roles

2010-04-22 Thread Thadeus Burgess
I just wrote a blog post on this! http://groups.google.com/group/web2py/browse_thread/thread/1a522db61b5e5d44 -- Thadeus On Thu, Apr 22, 2010 at 1:12 PM, Patrick arcaneli...@gmail.com wrote: On Apr 22, 12:18 pm, Jonathan Lundell jlund...@pobox.com wrote: On Apr 22, 2010, at 9:32 AM,

Re: [web2py] Web2py Upload Function

2010-04-22 Thread Thadeus Burgess
Take a look at welcome/controllers/default.py-def download And http://code.google.com/p/web2py/source/browse/gluon/sqlhtml.py#291 And http://code.google.com/p/web2py/source/browse/gluon/sql.py#2667 And http://code.google.com/p/web2py/source/browse/gluon/sql.py#2694 And

Re: [web2py] Re: http://www.web2py.com doesnt load

2010-04-21 Thread Thadeus Burgess
, - Yarko On Apr 20, 11:27 am, mdipierro mdipie...@cs.depaul.edu wrote: This is easier than I thought. Thanks to yarko for insisting about this. Please make sure I do it properly. On Apr 20, 10:27 am, Thadeus Burgess thade...@thadeusb.com wrote: You mean, I will finally have a way to run

Re: [web2py] Re: Auto Creating Users/Groups/Roles

2010-04-21 Thread Thadeus Burgess
How about password = CRYPT()(passwd)[0] -- Thadeus On Wed, Apr 21, 2010 at 6:54 PM, mdipierro mdipie...@cs.depaul.edu wrote:    ticket_master = db.auth_user.insert(first_name=fname,                                last_name=lname,                                email=maile,              

[web2py] Webfaction rocks

2010-04-20 Thread Thadeus Burgess
I just wanted to pass along how awesome webfaction rocks! I just signed up for an account with them. During the signup process they ask what software you will be using with the service. I specified OTHER-web2py. When I got the email of the server, I went to the URL and there was already a web2py

Re: [web2py] Re: Webfaction rocks

2010-04-20 Thread Thadeus Burgess
is not an issue. -- Thadeus On Tue, Apr 20, 2010 at 12:02 PM, mr.freeze nat...@freezable.com wrote: Nice. So no more slicehost or is this an additional account? On Apr 20, 11:47 am, Thadeus Burgess thade...@thadeusb.com wrote: I just wanted to pass along how awesome webfaction rocks! I just

Re: [web2py] Re: Webfaction rocks

2010-04-20 Thread Thadeus Burgess
I did have trouble getting admin to work properly, it complains about request.env.http_host being a None type, so I was unable to use admin without patching its security checks. However I am comfortable enough with ssh to publish the app manually. -- Thadeus On Tue, Apr 20, 2010 at 1:24 PM,

Re: [web2py] Re: Webfaction rocks

2010-04-20 Thread Thadeus Burgess
That might be it. I had not enabled SSL. However, since I will not be using admin, I do not have time to test if that fixes it. -- Thadeus On Tue, Apr 20, 2010 at 3:58 PM, Yarko Tymciurak resultsinsoftw...@gmail.com wrote: On Apr 20, 3:43 pm, Thadeus Burgess thade...@thadeusb.com wrote: I

Re: [web2py] Re: Webfaction rocks

2010-04-20 Thread Thadeus Burgess
you find webfaction speed? It has been slow for me lately, particularly ssh. On Apr 21, 3:08 am, Thadeus Burgess thade...@thadeusb.com wrote: This is an additional account for a client I am working with. I have heard the most success with webfaction and web2py so I wanted to try it out. So good

Re: [web2py] creating links to '#blah'

2010-04-19 Thread Thadeus Burgess
You probably want, XML('#comments', sanitize=False) -- Thadeus On Mon, Apr 19, 2010 at 7:38 AM, G. Clifford Williams g...@notadiscussion.com wrote: I'm trying to figure out how to get links created in web2py that point to an anchor name here is the code I'm using:            

Re: [web2py] Re: Session id gets re-used

2010-04-19 Thread Thadeus Burgess
The session ID is only unique between your web browser and your application. Try this test using two different web browsers. -- Thadeus On Mon, Apr 19, 2010 at 1:21 AM, Adi aditya.sa...@gmail.com wrote: Update: This seems to work in user():  if request.args(0) == 'login':      

Re: [web2py] Re: storing sessions for auth users

2010-04-19 Thread Thadeus Burgess
Or have a settings table that is linked by user id? They only get the site customizations if they are logged in? -- Thadeus On Mon, Apr 19, 2010 at 8:01 AM, selecta gr...@delarue-berlin.de wrote: that should work On Apr 19, 1:06 pm, Jason Brower encomp...@gmail.com wrote: On the same

Re: [web2py] Re: Uploaded file streaming

2010-04-19 Thread Thadeus Burgess
Also, you can set the X-Sendfile header if your webserver supports it. Basically, you set this header as the location of the file you want to serve, the webserver will then discard everything in response.body, and serve the file itself. You get the benefits of back-end authorization, and the

Re: [web2py] http://www.web2py.com doesnt load

2010-04-19 Thread Thadeus Burgess
Most likely your IP has been blocked by Massimo's aggressive security script. Until yall can figure out what happened, I have mirrored 1.77.1 here: http://static.thadeusb.com/web2py%201.77.1/ -- Thadeus On Mon, Apr 19, 2010 at 1:50 PM, Pystar aitoehi...@gmail.com wrote: Hello guys, I

Re: [web2py] IE6 problems

2010-04-19 Thread Thadeus Burgess
Display the following code inside your layout.html file. http://pastebin.com/exyxkACz -- Thadeus On Mon, Apr 19, 2010 at 6:15 PM, mdipierro mdipie...@cs.depaul.edu wrote: User yanni has reported this problem with IE6 http://i.imgur.com/ivWKA.jpg I do not have a windows machine but if

[web2py] Let the web server stream your files, not response.download!

2010-04-18 Thread Thadeus Burgess
http://bit.ly/ar4k8X -- Thadeus -- Subscription settings: http://groups.google.com/group/web2py/subscribe?hl=en

Re: [web2py] Re: Let the web server stream your files, not response.download!

2010-04-18 Thread Thadeus Burgess
will not be enforced. Massimo On Apr 18, 11:34 am, Thadeus Burgess thade...@thadeusb.com wrote: http://bit.ly/ar4k8X -- Thadeus -- Subscription settings:http://groups.google.com/group/web2py/subscribe?hl=en

Re: [web2py] Re: Let the web server stream your files, not response.download!

2010-04-18 Thread Thadeus Burgess
Precisely! -- Thadeus On Sun, Apr 18, 2010 at 6:43 PM, mdipierro mdipie...@cs.depaul.edu wrote: I see. Than the current download function could be improved to take advantage of this. On Apr 18, 3:01 pm, Thadeus Burgess thade...@thadeusb.com wrote: It works with apache, as long as you

[web2py] Traceback on delete plugin.

2010-04-18 Thread Thadeus Burgess
Traceback (most recent call last): File /home/thadeusb/Applications/web2py/gluon/restricted.py, line 178, in restricted exec ccode in environment File /home/thadeusb/Applications/web2py/applications/admin/controllers/default.py, line 1058, in module File

Re: [web2py] Re: web2py on IDE

2010-04-17 Thread Thadeus Burgess
Instead of Create new file you can have Create Controller/Create Model/Create View etc etc.. And it will just make the file in the proper place for that framework. I would also like to see, for web2py, is to have exec/build mapped to F5, but for web2py projects it will launch a single instance of

Re: [web2py] Re: prepolutating a SQLFORM.factory form

2010-04-16 Thread Thadeus Burgess
Because SQLFORM builds the HTML as soon as you instantiate the class. So you cannot edit anything after you create your form, since all of the html is already built, in strings. Specifying the default is the way to go here (annoying... I know). I usually perform the following if record_id:

Re: [web2py] Re: SQLForm and empty list in fields parameter

2010-04-16 Thread Thadeus Burgess
I think you want FORM(INPUT(_type=submit)) -- Thadeus On Fri, Apr 16, 2010 at 8:31 AM, mdipierro mdipie...@cs.depaul.edu wrote: What is the purpose of a SQLFORM without any field? On Apr 16, 3:52 am, Felix felix1...@gmail.com wrote: Hi,    I am using the SQLForm, in which I would like

Re: [web2py] Re: When and how to use command line option -f FOLDER?

2010-04-16 Thread Thadeus Burgess
web2py_latest introduced some bug. Iceberg On Apr8, 11:44pm, Thadeus Burgess thade...@thadeusb.com wrote: Iceberg, I am confused as to why you have two instances of web2py running the same app code? Unless they can use separate routes? -Thadeus On Thu, Apr 8, 2010 at 10:22 AM

Re: [web2py] Re: Documentation on setting up web2py and Google App Engine (GAE) in a windows XP environment.

2010-04-15 Thread Thadeus Burgess
Mercurial -- Thadeus On Thu, Apr 15, 2010 at 12:27 PM, Yanni apoe...@gmail.com wrote: Thank you. Is there a version control system that you can recommend, or that integrates well with web2py? On Apr 15, 10:06 am, mdipierro mdipie...@cs.depaul.edu wrote: On Apr 15, 11:29 am, Yanni

Re: [web2py] sqlite and 'unique'

2010-04-15 Thread Thadeus Burgess
sqlite does not enforce types/length, or uniqueness. You can insert a string into an integer field for all sqlite is concerned. -- Thadeus On Thu, Apr 15, 2010 at 3:17 PM, Keith Edmunds k...@midnighthax.com wrote: I have the following (sqlite) table definition:

Re: [web2py] file uploads from legacy database

2010-04-14 Thread Thadeus Burgess
Write your own download function for these? The reason is because web2py stores the filenames in a safe format. -- Thadeus On Wed, Apr 14, 2010 at 7:54 AM, selecta gr...@delarue-berlin.de wrote: I am currently migrating a legacy db (mysql) to web2py. I have written some tooling that I

[web2py] JSON and JqueryFullCalendar

2010-04-14 Thread Thadeus Burgess
To be able to use jQuery fullCalendar with a json data store, we need the ability to return an array that is the json instead of a dict. Currently, you can only return a dict from your view, but not a list that can be encoded in the format that fullCalendar supports. -- Thadeus -- To

Re: [web2py] Re: model files can not end with a comment

2010-04-13 Thread Thadeus Burgess
Agreed, we need more code comments! Massimo, no more commits unless they contain descriptive comments! I'm sure there was a reason it doesn't. Most programming languages require a newline at the end of your source code file. It probably has something to do with cross-platform compatibility.

Re: [web2py] using inline tables in the query (subquery in the FROM field)

2010-04-13 Thread Thadeus Burgess
Interesting, what would be the possibility of adding this as a feature to the new dal? -- Thadeus On Tue, Apr 13, 2010 at 5:06 AM, canna c.ne...@gmail.com wrote: Hello everybody! I really need help with a query I'm trying to execute in Web2Py DAL is there a way to use an inline table in

Re: [web2py] Re: model files can not end with a comment

2010-04-13 Thread Thadeus Burgess
. And comment the line with a link to this group posting and why the change was made. -- Thadeus On Tue, Apr 13, 2010 at 10:28 AM, Jonathan Lundell jlund...@pobox.com wrote: On Apr 13, 2010, at 8:16 AM, Thadeus Burgess wrote: Agreed, we need more code comments! Massimo, no more commits unless

Re: [web2py] Re: web2py book and softcron

2010-04-13 Thread Thadeus Burgess
If we are working on cron can I inject a feature request? Support for multiple crontab files in applications/myapp/cron crontab, or plugin_hi.crontab can be read. Alpha order ? -- Thadeus On Tue, Apr 13, 2010 at 10:47 AM, AchipA attila.cs...@gmail.com wrote: Technically, we don't need to

Re: [web2py] Re: using inline tables in the query (subquery in the FROM field)

2010-04-13 Thread Thadeus Burgess
, Thadeus Burgess thade...@thadeusb.com wrote: Interesting, what would be the possibility of adding this as a feature to the new dal? -- Thadeus On Tue, Apr 13, 2010 at 5:06 AM, canna c.ne...@gmail.com wrote: Hello everybody! I really need help with a query I'm trying to execute in Web2Py

Re: [web2py] Re: using inline tables in the query (subquery in the FROM field)

2010-04-13 Thread Thadeus Burgess
some more about it. On Apr 13, 1:36 pm, Thadeus Burgess thade...@thadeusb.com wrote: I have no immediate use for it. However, basing queries off of sub-queries(sub-table) happens a lot in the ms-access world. -- Thadeus On Tue, Apr 13, 2010 at 1:08 PM, mdipierro mdipie...@cs.depaul.edu wrote

Re: [web2py] DAL SQL exercise of the day

2010-04-13 Thread Thadeus Burgess
Also, reply only to DenesL, so you don't give away the answer! -- Thadeus On Tue, Apr 13, 2010 at 3:25 PM, DenesL denes1...@yahoo.ca wrote: Using the person dog tables, from the examples in the book, create a query to find which persons have less than 4 dogs (0-3). It seems deceivingly

Re: [web2py] Re: using inline tables in the query (subquery in the FROM field)

2010-04-13 Thread Thadeus Burgess
, Thadeus Burgess thade...@thadeusb.com wrote: it is almost like you need another object, SubTable, which can be built from the results of a Set object. But SubTable can do anything a regular table can do, its information is just dynamic. mySubTable = db()._select(db.TasksTimeLog.TheDate

Re: [web2py] html5

2010-04-12 Thread Thadeus Burgess
+5 4 html5 -- Thadeus On Mon, Apr 12, 2010 at 11:59 AM, mdipierro mdipie...@cs.depaul.edu wrote: should we replace in welcome !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http:// www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd with !DOCTYPE html pros? cons? --

Re: [web2py] Re: model files can not end with a comment

2010-04-12 Thread Thadeus Burgess
I find this surprisingly humorous office_space_reference Its always some mundane detail! This isn't a mundane detail Michael! /office_space_reference -- Thadeus On Mon, Apr 12, 2010 at 3:59 PM, DenesL denes1...@yahoo.ca wrote: Very simple, in db.py: db=SQLDB(...)

Re: [web2py] Re: Why am I getting this error ?

2010-04-12 Thread Thadeus Burgess
lucky, I'm jealous! -- Thadeus On Mon, Apr 12, 2010 at 4:32 PM, mdipierro mdipie...@cs.depaul.edu wrote: I have no idea but you can stop to my office tomorrow and we will post the solution then. Massimo On Apr 12, 2:05 pm, topher.baron topher.ba...@gmail.com wrote: I should have been

Re: [web2py] Re: model files can not end with a comment

2010-04-12 Thread Thadeus Burgess
I can reproduce tburg...@-dev:~/Applications/web2py$ python web2py.py -S pms -M web2py Enterprise Web Framework Created by Massimo Di Pierro, Copyright 2007-2010 Version 1.76.5 (2010-03-20 12:12:17) Database drivers available: SQLite3 Traceback (most recent call last): File

Re: [web2py] Re: csv download: how to do it

2010-04-11 Thread Thadeus Burgess
If you are running local just print to stdout print request.vars.query. -Thadeus On Sun, Apr 11, 2010 at 12:32 PM, Johann Spies johann.sp...@gmail.com wrote: Thanks Thaddeus.  I am not winning (yet)! I have now: def csv():    import cStringIO    s=cStringIO.StringIO()    import

Re: [web2py] new feature idea

2010-04-11 Thread Thadeus Burgess
Nice, and this way insert_url is anything that you want it to be? -Thadeus On Sun, Apr 11, 2010 at 12:35 PM, Rafael Pinheiro moriarty.pinhe...@gmail.com wrote: For some time i am missing a small feature on web2py, the IS_IN_DB validator forces the widget to be a OptionWidget populated from

Re: [web2py] Re: Self join query missing AS

2010-04-11 Thread Thadeus Burgess
Does the following provide the results that you are looking for? db(db.question.id 0)(db.keyword.keyword == 'this')(db.keyword.keyword == 'that').select() -Thadeus On Sat, Apr 10, 2010 at 9:36 AM, mdipierro mdipie...@cs.depaul.edu wrote: I would do

Re: [web2py] Re: Self join query missing AS

2010-04-11 Thread Thadeus Burgess
Sorry, try this db(db.question.id == db.keyword.id)(db.keyword.keyword == 'this')(db.keyword.keyword == 'that').select() -Thadeus On Sun, Apr 11, 2010 at 7:46 PM, Thadeus Burgess thade...@thadeusb.com wrote: Does the following provide the results that you are looking for? db

Re: [web2py] the web2py book, source code

2010-04-11 Thread Thadeus Burgess
Awesome! Great work Massimo, In db_book.py can you replace def tt with gluon.prettydate? And I just noticed... we can open binary files in the online editor? I never knew ! . -- ThadeusB On Sun, 2010-04-11 at 13:06 -0700, mdipierro wrote: Since many of you have asked

Re: [web2py] Re: csv download: how to do it

2010-04-10 Thread Thadeus Burgess
Hi Johann, Make sure to set the content-disposition header if you would like to set the filename. Also, the filename extension has to match your content-type or the browser might reject it, however that depends on the browser. -- Thadeus On Sat, 2010-04-10 at 23:56 +0200, Johann Spies wrote:

Re: [web2py] dynamic mysql columns

2010-04-10 Thread Thadeus Burgess
I have to ask... Why on earth do you have dynamic columns? Can you tell us more as to why you *need* this, maybe there is a better way. You can always dynamically build your db.define_table() statements, the DAL will migrate them as needed. SO first, build your dynamic fields in a python list

Re: [web2py] Re: How to by-pass user/login page for authentication

2010-04-09 Thread Thadeus Burgess
From any controller. return dict(auth_form=auth()) Then you can just {{=auth_form}} in your controllers view. -Thadeus On Fri, Apr 9, 2010 at 7:19 AM, Rohan yourbuddyro...@gmail.com wrote: Thanks Yarko, I don't want to use auth.requires_login() to index function as it will lead the

Re: [web2py] Re: web2py URLs

2010-04-09 Thread Thadeus Burgess
and routes_out should not be affected since they only rewrite the URL before web2py interprets it. On Apr 8, 12:43 pm, Thadeus Burgess thade...@thadeusb.com wrote: I just want it to be able to routes_in on both with ; and without ;. This is because my blog is indexed on google, and I want my old

[web2py] Helpful web2py gedit snippets

2010-04-09 Thread Thadeus Burgess
Just some python snippets for html, to be used with web2py templates. {tab -- {{python code}} =tab -- {{=python variable}} iftab -- {{ if condition: code pass }} fortab -- {{ for i in obj: code pass }} -Thadeus -- To unsubscribe, reply using remove me as the subject.

Re: [web2py] Yet another site to add to the list of sites running web2py....

2010-04-09 Thread Thadeus Burgess
That is cool! -Thadeus On Fri, Apr 9, 2010 at 10:25 AM, Jason Brower encomp...@gmail.com wrote: http://whodunitballoons.com I have had a lot of freedom making this one.  I am so excited about it I wanted to show it before it was done.  You guys can keep an eye on it in the future if you

[web2py] Re: bug in dal.py _first() and SQLFORM ._tablename

2010-04-09 Thread Thadeus Burgess
AS: syntax error -Thadeus On Thu, Apr 8, 2010 at 2:57 PM, Thadeus Burgess thade...@thadeusb.com wrote: Massimo, I am attaching a application that can replicate this issue. Works fine on sql.py Breaks on dal.py This application is designed after my big application, the represent

Re: [web2py] Re: bug in dal.py _first() and SQLFORM ._tablename

2010-04-09 Thread Thadeus Burgess
, in log_execute     ret = self.cursor.execute(*a,**b) OperationalError: near AS: syntax error -Thadeus On Thu, Apr 8, 2010 at 2:57 PM, Thadeus Burgess thade...@thadeusb.com wrote: Massimo, I am attaching a application that can replicate this issue. Works fine on sql.py Breaks on dal.py

Re: [web2py] Memory usage inspection

2010-04-09 Thread Thadeus Burgess
heapy guppy can do this. If you install it, a later version of web2py appadmin has cache statistics in it using guppy-heapy, it can give you an overall feel for what kinds of objects are taking up so much memory. There are lots of other factors, such as what webserver, how are you executing

[web2py] Re: bug in dal.py _first() and SQLFORM ._tablename

2010-04-08 Thread Thadeus Burgess
? On Apr 7, 2010, at 10:58 PM, Thadeus Burgess wrote: I am not using different datasets, or using different queries. So here we go, let me explain in every minuet detail this process. cd ~ hg clone https://web2py.googlecode.com/hg web2py cd web2py ln -s ~/path/to/my/application applications

Re: [web2py] Re: When and how to use command line option -f FOLDER?

2010-04-08 Thread Thadeus Burgess
Does that mean it will use other_web2py routes.py and the like? -Thadeus On Thu, Apr 8, 2010 at 1:18 AM, mdipierro mdipie...@cs.depaul.edu wrote: here is how it works now (its was more convoluted before) web2py must find gluon folder in path. it also expects to find applications/ in

Re: [web2py] Re: When and how to use command line option -f FOLDER?

2010-04-08 Thread Thadeus Burgess
before of after the change of path. Should be tried and eventually we can fix it. On Apr 8, 10:16 am, Thadeus Burgess thade...@thadeusb.com wrote: Does that mean it will use other_web2py routes.py and the like? -Thadeus On Thu, Apr 8, 2010 at 1:18 AM, mdipierro mdipie...@cs.depaul.edu wrote

Re: [web2py] Feed validator

2010-04-08 Thread Thadeus Burgess
response.headers['Content-Type'] = 'applications/rss+xml' -Thadeus On Thu, Apr 8, 2010 at 10:31 AM, Francisco Costa m...@franciscocosta.com wrote: Hello, When validating my feed i get this recomendation: Feeds should not be served with the text/html media type:

Re: [web2py] Re: Problem with MANY-MANY relationship

2010-04-08 Thread Thadeus Burgess
I have proposed a signal/slot system for the new DAL. Simply, The DAL provides an interface to register functions for common operations, such as select/insert/update/delete. You will simply db.register('pre_delete', myFunc) db.register('post_delete', myFunc) The only difference is when myFunc

Re: [web2py] Re: Feed validator

2010-04-08 Thread Thadeus Burgess
...@franciscocosta.com wrote: I've notice that, but I want to control the content of the feed. Thanks for your answer On Apr 8, 4:56 pm, mdipierro mdipie...@cs.depaul.edu wrote: This should be done automatically if you call you action with .rss On Apr 8, 10:45 am, Thadeus Burgess thade...@thadeusb.com wrote

Re: [web2py] Re: web2py URLs

2010-04-08 Thread Thadeus Burgess
How will we be able to configure to use one or the other? Will it be able to do Both at the same time (for routes_in of course). I ask since certain web2py sites are scanned in google, you don't want the old links to dis-appear. -Thadeus On Thu, Apr 8, 2010 at 11:30 AM, mdipierro

Re: [web2py] Re: Problem with MANY-MANY relationship

2010-04-08 Thread Thadeus Burgess
Ive sent emails on the list twice, and one email to you personally about this. I have not implemented it since it never received any feedback. There will be a 'pre' and 'post' of 'select', 'insert', 'update', 'delete', separated by an underscore. The dal will maintain a list of functions for

Re: [web2py] Re: building database querys from parts

2010-04-08 Thread Thadeus Burgess
http://thadeusb.com/weblog/view/web2py_dynamic_queries -Thadeus On Thu, Apr 8, 2010 at 5:35 AM, DenesL denes1...@yahoo.ca wrote: Yes q1 = db.software.os == os q2 = db.software.x == y filter1 = q1 q2 # q1 and q2 filter2 = q1 | q2 # q1 or q2 filter3 = ~q1 q2 # not q1 and q2 set1 =

Re: [web2py] Re: web2py URLs

2010-04-08 Thread Thadeus Burgess
, at 9:37 AM, Thadeus Burgess wrote: How will we be able to configure to use one or the other? I'm thinking an alternative variable in routes.py. Also, there would be (I think) a provision for application-specific routes.py files, so once the application is resolved at the top level

Re: [web2py] new feature for Firebird and Oracle users

2010-04-08 Thread Thadeus Burgess
PostgreSQL uses sequences too, any chance of getting support for it as well? -Thadeus On Thu, Apr 8, 2010 at 3:41 PM, DenesL denes1...@yahoo.ca wrote: Firebird and Oracle do not have auto-increment numeric fields, so generators or sequences with a trigger are used to assign the value of

Re: [web2py] Re: auth.settings.actions_disabled.append('register')

2010-04-08 Thread Thadeus Burgess
Where are you including auth.settings.actions_disabled.append('register') ? -Thadeus On Thu, Apr 8, 2010 at 4:43 PM, carlo syseng...@gmail.com wrote: thank you Yarko for replying. Well it is really a strange behaviour, I am trying to isolate the problem. For now I have the feeling that

<    1   2   3   4   5   6   7   8   9   10   >