[web2py] Re: Cant make a simple database

2011-03-09 Thread pbreit
I'm so bummed I can't use the table name "order". So far I've considered "orders" but that would be my only plural and "purchase". Are there any other good names for orders. I know, this isn't world peace or anything.

Re: [web2py] Re: advanced form question

2011-03-09 Thread Manuele Pesenti
Il 09/03/2011 04:44, DenesL ha scritto: That is called cascaded fields. One example:http://groups.google.com/group/web2py/msg/b2d536d444001565 Use the advanced group search http://groups.google.com/groups/advanced_search?safe=off&q=group:web2py to find more entries with "cascaded" (type the word

[web2py] CascadingSelect class (slice 85)

2011-03-09 Thread Nik
Found this slice earlier. My objective is to display a filtered lists of villages based on user's previous selection. I get the error ('village') after I cloned CascadingSelect class from slice 85[1] for use in the tables[2]. the difference here is that my keys are strings instead of the integer

[web2py] Re: very slow pageload time (20+ secs)

2011-03-09 Thread cjrh
On Mar 9, 7:52 pm, Philip wrote: > Does anyone know of any common root causes of performance problems > like that? You are going to have to find the part that is slow. That means some kind of profiling or instrumenting scheme where you can gather measurements.

[web2py] Re: greetings from PyCon

2011-03-09 Thread Anthony
I think it went very well from the audience perspective as well. Massimo's computer was set on Chicago time (Atlanta is an hour later), so he accidentally gave us our break an hour late -- but no one seemed to notice or care because Massimo's tour de force of web2py's capabilities was so engagi

[web2py] Re: Cant make a simple database

2011-03-09 Thread DenesL
order is a keyword in the database, just change the table name to orders. On Mar 9, 10:49 pm, Jamboo wrote: > I tried making this simple database, and then tried the db admin panel > and then a ticket gets generated. I tried copying the examples from > Chapter 3 of the web2py book and I get the

[web2py] Cant make a simple database

2011-03-09 Thread Jamboo
I tried making this simple database, and then tried the db admin panel and then a ticket gets generated. I tried copying the examples from Chapter 3 of the web2py book and I get the same type of message. I have the db and error here http://www.pastie.org/1654196 ## db.py db = DA

[web2py] Re: some functionality to mix html and {{python expression}} is broken since 1.92.3, even back to 1.91.6

2011-03-09 Thread dlypka
I have now reproduced the issue in a small project. So I will create an incident and attach a zip tomorrow. On Mar 8, 2:33 pm, dlypka wrote: > I will try to reduce it to a small example. From the call stack it > looks like web2py is confused between python code and html.  It seems > to be executi

[web2py] Re: plugin_wiki: KeyError: 'active'

2011-03-09 Thread Anthony
Yes, this error occurred during the PyCon tutorial this morning. Massimo used his Emacs foo to fix the problem on the spot in about 30 seconds and then proceeded with his example without skipping a beat. I think he's planning to push a fix out tonight or tomorrow. Anthony On Wednesday, March

[web2py] Re: [tip] Head JS script loader

2011-03-09 Thread Carlos
Hi Bruno, How does HeadJs compare with RequireJs and LabJs?. http://requirejs.org/ http://labjs.com/ Thanks, Carlos

[web2py] Re: ('active') when running plugin_wiki

2011-03-09 Thread villas
Yes, plugin_wiki is broken because the field active was deleted. I already reported this and I hope Massimo will fix it soon. On Mar 9, 11:24 pm, mat -- wrote: > Hi > > I downloaded latest version of Web2py and plugin_wiki. > > I setup Janrain. I can login. > > I created a new app and uploaded pl

[web2py] [tip] Head JS script loader

2011-03-09 Thread Bruno Rocha
Head JS script loader With Head JS your scripts load like images - completely separated from the page rendering process. The page is ready sooner. Always. This is guaranteed even with a single combined JavaScript file. See it yourself: Sample page with 5 SCRIPT SRC tags

[web2py] Re: plugin_wiki: KeyError: 'active'

2011-03-09 Thread villas
I have already posted several messages about this issue. Plugin_wiki is broken at the moment. Massimo has deleted the 'active' field (because 'active' is a reserved word). He may eventually replace it with another field named 'activated' or similar. On Mar 10, 1:16 am, LotS wrote: > I use the

[web2py] filtering selection list

2011-03-09 Thread Nik
i need to validate a field based on an external read-only database (i call it gdb) there are four tables that are related by their own codes gdb.r_table.code gdb.p_table.code gdb.t_table.code gdb.v_table.code I have no use for the the id field of each table. Each table has, among others: r_table.

[web2py] Re: plugin_wiki: KeyError: 'active'

2011-03-09 Thread pbreit
One thing that looks odd to men is the mixed slashes in the file path: C:\web2py\applications\myapp2/views\plugin_wiki/index.html Is that how it works on Windows?

[web2py] Re: plugin_wiki: KeyError: 'active'

2011-03-09 Thread pbreit
Looks like the same issue: https://groups.google.com/d/topic/web2py/eCaXXPR67CM/discussion I unfortunately don't know much about plugin_wiki but with 2 people now experiencing the problem good chance of a bug.

[web2py] plugin_wiki: KeyError: 'active'

2011-03-09 Thread LotS
I use the source version of web2py: Version 1.93.2 (2011-03-04 23:48:59) on Windows XP. I managed to install plugin_wiki. After I signed in with an authenticated user id, the "Pages" on the menu will be shown. Click on it and I can access to the /plugin_wiki/index After I created a meta-menu pag

[web2py] Lacking nginx deployment guide

2011-03-09 Thread minux
Hi folks, As a newbie to the fabulous framework, I am a bit put off when I reached to the end of the web2py chapter about deployment and (as it happened to me with Django before) I saw no receipt to deploy on nginx, which is my favorite web server. I searched around but could not find any complet

[web2py] PyCon-web2py

2011-03-09 Thread Ovidio Marinho
No primeiro dia web2py eh o primeiro tutorial do evento On the first day eh web2py the first tutorial of the event http://us.pycon.org/2011/schedule/tutorials/ -- Ovidio Marinho Falcao Neto ovidio...@gmail.com Tecnologia da Informaçao Casa Civil do Governa

[web2py] Re: Cron not running/starting on windows

2011-03-09 Thread Brian M
I don't think cron works when running as a Windows service - at least it didn't in the past https://groups.google.com/forum/#!searchin/web2py/windows$20cron/web2py/OX7pXEGlSGM/hkspXZWKV1gJ I ended up just using a scheduled task that used wget to fetch certain controllers I wanted to run regular

Re: [web2py] Dotcloud hosting great tutorial but stuck

2011-03-09 Thread Jonathan Lundell
On Mar 9, 2011, at 3:49 PM, stargate wrote: > > I am following the following tutorial for web2py deployment > > http://docs.dotcloud.com/static/tutorials/web2py/ > > the problem i am stuck at is when i try to run the following command What exactly do you mean by "stuck"? > > web2py$ ln -s wsg

[web2py] Re: Dotcloud hosting great tutorial but stuck

2011-03-09 Thread pbreit
That command is going to create an alias on your Mac that when will go along with the rest of your files when you do the "dotcloud push". You can see the alias if you type this into your terminal: ls -al

[web2py] Re: Dotcloud hosting great tutorial but stuck

2011-03-09 Thread ron_m
That is a symlink creation so the assumption if using that command is wsgihandler.py exists in the current directory and you are creating a symbolic link named wsgi.py which points to wsgihandler.py. If you use ls while logged in on the server do you see wsgihandler.py, run the ls command. If n

[web2py] Dotcloud hosting great tutorial but stuck

2011-03-09 Thread stargate
I am following the following tutorial for web2py deployment http://docs.dotcloud.com/static/tutorials/web2py/ the problem i am stuck at is when i try to run the following command web2py$ ln -s wsgihandler.py wsgi.py I am doing this from macos Terminal Thanks for any help

[web2py] ('active') when running plugin_wiki

2011-03-09 Thread mat --
Hi I downloaded latest version of Web2py and plugin_wiki. I setup Janrain. I can login. I created a new app and uploaded plugin_wiki as a plugin. I can create a first page and save it using plugin_wiki features. But second time I click the "Page" tab i get the following error: Version web2py

[web2py] Re: conditionally include in view

2011-03-09 Thread ron_m
I use this in a portion of the views coded for what I am working on and it works for me. I just ran the page with the test true and again with the test false and I get the include file content inside the {{if condition:}} branch if the condition is True and the html in the {{else:} branch if the

[web2py] Re: No login possible in Firefox, but in chrome

2011-03-09 Thread ron_m
The symptoms look exactly like a user I had a problem with logging into my application but for them cookies were disabled, re-enabling cookies fixed it. Firefox cookie settings are a little obscure, here is a web reference http://support.mozilla.com/en-US/kb/Websites%20say%20cookies%20are%20blo

Re: [web2py] greetings from PyCon

2011-03-09 Thread Ovidio Marinho
After what happened to publish it with web2py 2011/3/9 Massimo Di Pierro > I am at PyCon in Atlanta. Greetings to all of you. The web2py tutorial > went very well (at least from my prospective) there were about 18 in > the room which is more than I was told would attend. > > If you are in Atlant

[web2py] greetings from PyCon

2011-03-09 Thread Massimo Di Pierro
I am at PyCon in Atlanta. Greetings to all of you. The web2py tutorial went very well (at least from my prospective) there were about 18 in the room which is more than I was told would attend. If you are in Atlanta, see you in the lobby at 6pm and we go out for dinner. Massimo

[web2py] Re: conditionally include in view

2011-03-09 Thread Massimo Di Pierro
Include is executed whether or not the condition is true. It is not python code therefore it is executed before the python code is executed. It is not a good idea to put the include in a condition. On Mar 9, 12:24 pm, m t wrote: > Hi, > > I have such code: > {{if someData:}} >      {{include 'add

[web2py] Re: problem with type Int

2011-03-09 Thread Massimo Di Pierro
Can I see more of the code without ... On Mar 9, 3:17 pm, LightOfMooN wrote: > value=request.vars.myvar > > try: >     value = int(value) > except: >     pass > > if type(value)==int: >     insert() > > it rises > (current transaction is aborted, > commands ignored until end of transaction bl

[web2py] Re: character special in DAL

2011-03-09 Thread Massimo Di Pierro
you cannot. You can have a field.label with the id but not in the field name. On Mar 9, 6:51 am, cabildocl wrote: > I need create a field in DAL, what include a character special "-". > How i can do this? > > Greetings

[web2py] Re: 1.93.2 broken update_record!

2011-03-09 Thread Massimo Di Pierro
This should not cause corpupted data in the database, anyway, expect a new stable web2py tomorrow since this is fixed in trunk. On Mar 8, 7:08 pm, Clayton wrote: > Please note that this bug silently causes corrupt data to be written > to the database! Please, please release an update pronto... >

[web2py] Re: DAL tutorial video

2011-03-09 Thread mikech
I posted the link in Dzone so vote up if you can. Any search on Web2py should bring it up. re: the text of the session, I would like this too.

[web2py] Re: very slow pageload time (20+ secs)

2011-03-09 Thread howesc
I agree with villas - *but* check for those renegade queries in your models. once upon a time i tried loading config options and other data in db.py so they would be globally available as lookups without querying the DB each time. it worked like a champ, until i got lots of data, then it was

[web2py] Re: redirection to /default/user/profile

2011-03-09 Thread DenesL
plus the decoration of index: @auth.requires_login() On Mar 9, 11:04 am, Jonathan Lundell wrote: > On Mar 9, 2011, at 5:00 AM, DenesL wrote: > > > > > I did use -I but it did not show any redirects. > > Anyway, I still don't know why it gets redirected to profile when it > > is not properly defin

[web2py] conditionally include in view

2011-03-09 Thread m t
Hi, I have such code: {{if someData:}} {{include 'additional.html'}} {{pass}} problem is that even when 'someData' is NOT true - file 'additional.html' is included. Is there some trick to select on view level which includes shall be loaded?

[web2py] problem with type Int

2011-03-09 Thread LightOfMooN
value=request.vars.myvar try: value = int(value) except: pass if type(value)==int: insert() it rises (current transaction is aborted, commands ignored until end of transaction block) even if value > 2147483647 But why? It's so strange, because type(value) must be long.

[web2py] Re: Cron not running/starting on windows

2011-03-09 Thread pbreit
Do you know if the script runs without error? What I do sometimes is put the script into controller.py and try to run it from there. My only guess at this point is perhaps there might be a permission problem writing to the "cron" directory. In your Windows Task Manager can you see that multiple

[web2py] Re: very slow pageload time (20+ secs)

2011-03-09 Thread Philip
Would that impact appadmin? Just going to app/appadmin/index takes 15-20 seconds, and viewing a table in the admin interface takes almost 30 seconds, even for a table of only 50 rows. It seems that something is bogging down the whole thing, not specific functions or controllers. Since database si

[web2py] Re: very slow pageload time (20+ secs)

2011-03-09 Thread villas
Somewhere in your code you are probably fetching all the rows. Look at all your queries and see whether you can paginate results somehow (using limitby). Look at IS_IN_DB validators etc which create drop down boxes and consider using sub-sets of data to populate them, or replace with autocomplete.

[web2py] Re: No login possible in Firefox, but in chrome

2011-03-09 Thread pbreit
Have you customized your login at all? Can you think of any edits you have made to your app that could impact login/register? CSS files? JavaScript files? Auth settings? Does it seem like the form does not even submit? Do you have the file web2py_ajax.html in your app folder?

[web2py] very slow pageload time (20+ secs)

2011-03-09 Thread Philip
I am having an issue with an application. Page load times are 20+ seconds. This is true for all pages, even in admin functions (as soon you select the application in question). It appears to be a database problem, since the problem appeared after adding about 15,000 records to an application tha

[web2py] Re: From and action disambiguation

2011-03-09 Thread StUStD
SOLVED: the magic formname in: if form.accepts(request.vars, formname=): ... with different formname for both forms solved the problem. Thanks for the wonderful web2py! On Mar 9, 5:06 pm, StUStD wrote: > I have two selection forms in one html page (see below), each with two > s

Re: [web2py] routes on GAE

2011-03-09 Thread howesc
+1 for app.example.yaml if it weren't for source control i would have been SOL a crap-ton of times. :)

[web2py] Re: python tutorial video

2011-03-09 Thread stefaan
> It is a tool I am working out, trying to automate my teaching job. I seem to remember you mentioned using some mac os program "Say" to generate the speech. If it could be replaced with e.g. the text-to-speech as offered by google on their translate.google.com page, it 'd become cross-platform a

Re: [web2py] Re: python tutorial video

2011-03-09 Thread David J.
No it not ok: I dont think that will be Massimo's intention; When he releases the update it will kept a BIG secret and he will not notify anyone; as he usually does! Only kidding; you will be the first to know! On 3/9/11 11:42 AM, Vinicius Assef wrote: Let us know when new version will be a

Re: [web2py] Re: python tutorial video

2011-03-09 Thread Vinicius Assef
Let us know when new version will be available, ok? On Wed, Mar 9, 2011 at 9:43 AM, Massimo Di Pierro wrote: > will fix typos, change music and redo it. > > On Mar 8, 4:10 pm, Stefaan Himpe wrote: >>   My suggestion ->  Konstantin Scherbakov, maybe >> >> >> Liszt's transcriptions of Beethoven s

[web2py] From and action disambiguation

2011-03-09 Thread StUStD
I have two selection forms in one html page (see below), each with two submit buttons, one to "update" a selected database item, and another to select the item (i.e. store it in a session database) -- the code for "multiple submit buttons" in one form was found in a web2py thread. The first form wo

Re: [web2py] Re: redirection to /default/user/profile

2011-03-09 Thread Jonathan Lundell
On Mar 9, 2011, at 5:00 AM, DenesL wrote: > > I did use -I but it did not show any redirects. > Anyway, I still don't know why it gets redirected to profile when it > is not properly defined. What was the minimum you needed to do to get the redirection? Just the double-form version of user?

[web2py] Re: Multiple form flash problem.

2011-03-09 Thread villas
Glad to help and sounds like an interesting project. > I am building this web application for a psychologist > and he insisted on implementing it this way for > cognitive ergonomic reasons. Hmm, I thought 'cognitive ergonomic reasons' was just an excuse for lying on the couch! :-) D

[web2py] Re: about SQLFORM

2011-03-09 Thread DenesL
Can you show us your current code?. On Mar 9, 9:03 am, cyber wrote: > Hi > > How can I update new (just created) record in the table? > Table consists of several fields but in the form page user have to > enter only one value for one row. > So, I need insert in the current row not only this value

[web2py] character special in DAL

2011-03-09 Thread cabildocl
I need create a field in DAL, what include a character special "-". How i can do this? Greetings

[web2py] about SQLFORM

2011-03-09 Thread cyber
Hi How can I update new (just created) record in the table? Table consists of several fields but in the form page user have to enter only one value for one row. So, I need insert in the current row not only this value but user name and datetime. I can insert first value but I have no idea of how t

[web2py] Re: redirection to /default/user/profile

2011-03-09 Thread DenesL
I did use -I but it did not show any redirects. Anyway, I still don't know why it gets redirected to profile when it is not properly defined. On Mar 8, 5:25 pm, Jonathan Lundell wrote: > On Mar 8, 2011, at 2:20 PM, Jonathan Lundell wrote: > > > > > On Mar 8, 2011, at 2:00 PM, DenesL wrote: > >

[web2py] Re: Update_record and validator conflict.

2011-03-09 Thread DenesL
Or better yet, store the validator object in a variable and use that: isnotindb=IS_NOT_IN_DB(...) db.company.CoC_number.requires=isnotindb and in the action: isnotindb.set_self_id(company[0].id) then it does not matter if the field uses more validators, since you could for example do: db.comp

[web2py] Re: python tutorial video

2011-03-09 Thread Massimo Di Pierro
will fix typos, change music and redo it. On Mar 8, 4:10 pm, Stefaan Himpe wrote: >   My suggestion ->  Konstantin Scherbakov, maybe > > >> Liszt's transcriptions of Beethoven symphonies for the Piano > > His Lyapunov etudes are well worth listening to as well :)

[web2py] Re: Web2py license question

2011-03-09 Thread Massimo Di Pierro
Yes, your license must say that you did so. On Mar 8, 4:46 pm, kverdecia wrote: > Hi, > > Can I include the web2py template module in my desktop application > without affecting the license of my application?

[web2py] Cron not running/starting on windows

2011-03-09 Thread Andrew Buchan
Hello, I have web2py running as a service on Windows Server 2003 from source at version 1.93.2. I'm trying to get cron to work but nothing seems to be happening. I can't figure out if its running and failing, or not running at all, so it would be really useful if someone could answer the following

[web2py] Re: Update_record and validator conflict.

2011-03-09 Thread DenesL
Hi Annet, the requires for the field is now a list of validators for some reason. You have to use the set_self_id only on the IS_NOT_IN_DB portion of the requires. Did you change the requires?. If not, then it is probably just a one member list so you can do db.company.CoC_number.requires[0].set

[web2py] Re: Multiple form flash problem.

2011-03-09 Thread annet
Hi David, > Sorry if anything here is impractical, but here's a couple of > thoughts... I very much appreciate you sharing your thoughts with me, they are helpful and they add to range of possible solutions to implement things. The reason I implemented things the way I did is that I am building

[web2py] Re: Update_record and validator conflict.

2011-03-09 Thread annet
Hi Denes, Thanks for your reply. I tried: >           # this is undocumented >           db.company.CoC_number.requires.set_self_id(company[0].id) > > >         form.vars.name=company[0].name > >         form.vars.CoC_number=company[0].CoC_number > >         form.vars.subdossiernumber=company[0].

[web2py] Re: No login possible in Firefox, but in chrome

2011-03-09 Thread Norbert Klamann
Javascript works in the firefox in principle . I tried this one http://www.javascripter.net/faq/alert.htm and it shows the alert box.

[web2py] No login possible in Firefox, but in chrome

2011-03-09 Thread Norbert Klamann
Hello all, i cannot log in or register to my web2py applications in firefox but in chrome it works fine. In Firefox I get noe feedback whatever about failed or successful login. I have the webdevolper extensions installed, but javascript is not disabled, cookies are allowed too and they are vi

[web2py] For interest: Regressive enhancement with Modernizr and yepnope.js

2011-03-09 Thread Tom Atkins
how to only load JavaScript as a fall-back when browsers don't support an HTML5 feature - i.e. *regressive* enhancement: http://blogs.sitepoint.com/2011/03/08/regressive-enhancement-with-modernizr-and-yepnope/