[web2py] index error -GAE

2010-09-17 Thread b vivek
Hii am trying to upload a site to GAE , after the site is uploaded , when I go to app admin and try to insert a new membership, I get this errors:- *NeedIndexError**: **The index **for **this query **is not **ready to serve**. **See the Datastore Indexes page **in **the Admin Console**. **This

[web2py] Re: index error -GAE

2010-09-17 Thread b vivek
I have attached the screenshot of the admin console in the datastore indexes. Does this mean it is still building the indexes! On Fri, Sep 17, 2010 at 12:36 PM, b vivek bvivek1...@gmail.com wrote: Hii am trying to upload a site to GAE , after the site is uploaded , when I go to app admin and

[web2py] Re: index error -GAE

2010-09-17 Thread b vivek
Also please note that the index.yaml after running it throu dev_appserver looks like this:- indexes: # AUTOGENERATED # This index.yaml is automatically updated whenever the dev_appserver # detects that a new type of query is run. If you want to manage the # index.yaml file manually, remove the

[web2py] Re: Getting Data of uploaded File from DB downloading text as file?

2010-09-17 Thread till
cheers! do you have yet another solution for the string to file dl idea? thanks :-) On Sep 16, 5:51 pm, mdipierro mdipie...@cs.depaul.edu wrote: filename,stream=db.dogs.image.retrieve(doggies[0].image) data=stream.read() On Sep 16, 10:11 am, till till.salzge...@gmail.com wrote: hi all,

[web2py] Forms with hidden fields

2010-09-17 Thread Fabio Alessandro Locati
Hi, I'm trying to make a form with a hidden field, but I haven't found the way to do it :(. I have a table: db.define_table('partners', Field('name','string'), Field('out','boolean')) I want to ask to the user the name of the partner and, based on the name of the page, the value of

[web2py] Re: index error -GAE

2010-09-17 Thread b vivek
Solved!.. looks like App Engine just needed a few hours for this! On Fri, Sep 17, 2010 at 12:36 PM, b vivek bvivek1...@gmail.com wrote: Hii am trying to upload a site to GAE , after the site is uploaded , when I go to app admin and try to insert a new membership, I get this errors:-

[web2py] Re: Forms with hidden fields

2010-09-17 Thread Martin.Mulone
To hide a field: Field('out','boolean',writable=False,readable=False) And computed fields in book: http://web2py.com/book/default/chapter/06#Computed-Fields On 17 sep, 05:58, Fabio Alessandro Locati floc...@grimp.eu wrote: Hi, I'm trying to make a form with a hidden field, but I haven't found

[web2py] Re: response.render

2010-09-17 Thread JC11
Thanks, :) On Sep 16, 6:04 pm, mdipierro mdipie...@cs.depaul.edu wrote: from gluon.template import render def index():     return render() look at the source code of that function it has lots of options. On Sep 16, 11:47 am, JC11 john.c...@gmail.com wrote: Is it possible to call

[web2py] Re: plugin legacy mysql: generates web2py code to access your mysql legacy db

2010-09-17 Thread ron_m
The size of the data in the database shouldn't matter, it runs mysql to get the table list and then mysqldump on each table using the first output. This script needs some testing but the only way to test is pass more databases through it. It works well on my particular DB but yours has a new case

[web2py] Re: Getting Data of uploaded File from DB downloading text as file?

2010-09-17 Thread mdipierro
sorry I forgot. Imagine you have: db.define_table('mytable',Field('somedata','text')) you can define an action: def gimmefile(): # http:///gimmefile/id myrecord=db.mytable(request.args(0)) filename = %s.txt % myrecord.id

[web2py] Re: Forms with hidden fields

2010-09-17 Thread mdipierro
I like to define def HiddenField(*a,**b): a['writable']=b['readable']=False and use db.defiend_table('mytable',Field('name'),HiddenField('manager')) On Sep 17, 6:07 am, Martin.Mulone mulone.mar...@gmail.com wrote: To hide a field: Field('out','boolean',writable=False,readable=False)

[web2py] Validators with Dependencies

2010-09-17 Thread Omri
Hello, I'm writing a relatively big database application. A small part of it requires me to handle lists of values, where every list can only exist once, and where each item in the list can only exist once (but different lists can have items named the same way). A simplified model is:

[web2py] Re: plugin legacy mysql: generates web2py code to access your mysql legacy db

2010-09-17 Thread mdipierro
I see a problem here: Field('id','integer'), should be Field('id','id'), On Sep 9, 12:01 am, ron_m ron.mco...@gmail.com wrote: On Sep 8, 1:30 pm, mdipierro mdipie...@cs.depaul.edu wrote: So maybe tonight do you want me to go through the manual and find all the missing datatypes

[web2py] Re: Forms with hidden fields

2010-09-17 Thread mdipierro
ERRATA: I like to define def HiddenField(*a,**b): a['writable']=b['readable']=False return Field(*a,**b) and use db.defiend_table('mytable',Field('name'),HiddenField('manager')) On Sep 17, 8:22 am, mdipierro mdipie...@cs.depaul.edu wrote: I like to define def HiddenField(*a,**b):  

[web2py] Re: Simple search form

2010-09-17 Thread elfuego1
OK. Both parts are there in the view. The input fields are not evaluated against Database though. Even if I enter numbers that are there in DB, form responses with: There are no matching records in Database. If the numbers are matching they should be displayed in the result part of the search

[web2py] let user choose it membership

2010-09-17 Thread Richard Vézina
Hello, I need to let some of my user changing of membership into a plage of existing members number. Is there mechanism already existing in web2py or do I have to program it from scratch? Thanks Richard

[web2py] Re: Validators with Dependencies

2010-09-17 Thread mdipierro
Before we do this, I suggest you install plugin_wiki and do db.define_table('lists', Field('name')) def create_list(): return dict(form=crud.create(db.lists)) def edit_list(): mylist=db.lists(request.args(0)) or redirect(URL('create_list')) return

[web2py] Re: Simple search form

2010-09-17 Thread mdipierro
You need to help some bore with debugging. Looks to me there simply is no matching data. Try search by one single filed, Try print the values of form.vars. or send me the app and I will take a look. On Sep 17, 8:47 am, elfuego1 elfue...@gmail.com wrote: OK. Both parts are there in the view.

[web2py] Re: let user choose it membership

2010-09-17 Thread mdipierro
no and it is very much needed. Any takers? On Sep 17, 8:50 am, Richard Vézina ml.richard.vez...@gmail.com wrote: Hello, I need to let some of my user changing of membership into a plage of existing members number. Is there mechanism already existing in web2py or do I have to program it from

[web2py] CRUD.UPDATE

2010-09-17 Thread leone
Why crud.update(..) shows admin, request, session, request and response buttons at bottom page? How can I drop this? Thanks leone

[web2py] Re: Forms with hidden fields

2010-09-17 Thread weheh
+1 On Sep 17, 9:25 am, mdipierro mdipie...@cs.depaul.edu wrote: ERRATA: I like to define def HiddenField(*a,**b):     a['writable']=b['readable']=False     return Field(*a,**b) and use db.defiend_table('mytable',Field('name'),HiddenField('manager')) On Sep 17, 8:22 am, mdipierro

[web2py] crud.update

2010-09-17 Thread leone
Solved. I forgot to create the view. Sorry. leone

Re: [web2py] Re: let user choose it membership

2010-09-17 Thread Richard Vézina
Implement something is quite a bit over my skill... But I can post the solution I found with. As far as I can see we need : - a list of user authorized to change of group - per user a restricted plage of group that the user can pick - eventually the history of the membership change (that could

[web2py] Re: Getting Data of uploaded File from DB downloading text as file?

2010-09-17 Thread Martin.Mulone
I think you also need: response.headers['Content-Type']='text/plain' On Sep 17, 10:21 am, mdipierro mdipie...@cs.depaul.edu wrote: sorry I forgot. Imagine you have: db.define_table('mytable',Field('somedata','text')) you can define an action: def gimmefile():    

Re: [web2py] Re: let user choose it membership

2010-09-17 Thread Richard Vézina
If we add a field in the user table where we can put the group ID the user can pick? requires=IS_IN_SET(['group_ID1','group_ID2']) The user is already allowed to change it profile and he can only pick a restricted plage of group ID. Then we need a function to synchronise the value in the new

[web2py] Re: plugin legacy mysql: generates web2py code to access your mysql legacy db

2010-09-17 Thread ron_m
Program mysqldump produces a line like this for an id field `id` int(11) NOT NULL AUTO_INCREMENT, and because there is no special case processing int becomes integer. It looks like a possible solution would be to recognise AUTO_INCREMENT and for that case over ride the int translation to

Re: [web2py] Re: Forms with hidden fields

2010-09-17 Thread Jonathan Lundell
On Sep 17, 2010, at 6:25 AM, mdipierro wrote: ERRATA: I like to define def HiddenField(*a,**b): a['writable']=b['readable']=False return Field(*a,**b) I *think* you mean: b['writable']=b['readable']=False and use

[web2py] Hi guys.. reg:plugin_wiki select/read

2010-09-17 Thread bally boy
I am using plugin_wiki which looks awesome.Looks like you guys are soon going to get us developers out of jobs and send us to school to learn CSS/Javascript etc. Ok anyway so this is what I wanted to ask. I am at this url:- http://127.0.0.1/myapp/plugin_wiki/page_edit/tag/1 Now I am want to do

[web2py] Re: Getting Data of uploaded File from DB downloading text as file?

2010-09-17 Thread mdipierro
that would be automatic if you call the download url with .txt On Sep 17, 9:22 am, Martin.Mulone mulone.mar...@gmail.com wrote: I think you also need: response.headers['Content-Type']='text/plain' On Sep 17, 10:21 am, mdipierro mdipie...@cs.depaul.edu wrote: sorry I forgot. Imagine you

[web2py] Re: Redirect after login

2010-09-17 Thread mwolfe02
I'm not sure if this is the officially correct way to do this, but I implemented this functionality by making a change to layout.html: I replaced these lines: - {{=A(T('login'),_href=URL(r=request,c='default',f='user/login'))}} | -

[web2py] Re: Hi guys.. reg:plugin_wiki select/read

2010-09-17 Thread mdipierro
You cannot use veariables (yet). instead of `` name: select table: blog query_field: id query_value: request.args(1) fields: title ``:widget do: `` {{=plugin_wiki.widget('select',table='blog',query_field='id',query_value=request.args(1),fields='title')}} ``:template should do it. On Sep 17,

Re: [web2py] Re: Recent changes to rewrite.py break threaded environments

2010-09-17 Thread Jonathan Lundell
On Sep 16, 2010, at 10:44 PM, mdipierro wrote: Jonathan, I misunderstood your problem. You should not spawn threads from a web2py app. This is not just because the current routing mechanism does not support it. This is a very general with all web applications because threads are managed

[web2py] Re: Recent changes to rewrite.py break threaded environments

2010-09-17 Thread mdipierro
I will take the patch and you may be fine if your thread does not access db. On Sep 17, 10:20 am, Jonathan Lundell jlund...@pobox.com wrote: On Sep 16, 2010, at 10:44 PM, mdipierro wrote: Jonathan, I misunderstood your problem. You should not spawn threads from a web2py app. This is

[web2py] Re: Why the pattern return dict(form=form)?

2010-09-17 Thread Tom Campbell
Wow, huge help. Thanks a TON, Bruno and Jonathan. You're both awesome members of the community. I hope to be the same one day. Cheers, TC

Re: [web2py] Re: Recent changes to rewrite.py break threaded environments

2010-09-17 Thread Jonathan Lundell
On Sep 17, 2010, at 8:24 AM, mdipierro wrote: I will take the patch and you may be fine if your thread does not access db. Here's a slightly more complete patch. This should maintain backward compatibility with apps that don't use app-specific routing. One that does can call

[web2py] Re: StackExchange for web2py community

2010-09-17 Thread mwolfe02
My vote: - ask questions on StackOverflow using the existing web2py tag - follow the questions using this RSS feed: http://stackoverflow.com/feeds/tag/web2py I like StackOverflow a lot and I think it is a much better interface than Google Groups. I asked my first few questions about web2py on

[web2py] Re: Recent changes to rewrite.py break threaded environments

2010-09-17 Thread mdipierro
Can you please email the patch. the indentation is messed up. On Sep 17, 10:56 am, Jonathan Lundell jlund...@pobox.com wrote: On Sep 17, 2010, at 8:24 AM, mdipierro wrote: I will take the patch and you may be fine if your thread does not access db. Here's a slightly more complete patch.

[web2py] Re: StackExchange for web2py community

2010-09-17 Thread mdipierro
I oppose and here is why. A few people have asked web2py related questions on stack overflow. Almost all of them have at least one generic answer by somebody who knows nothing about web2py. On Stack overflow there is no sense of community (other than the stack overflow community) and people try to

[web2py] Ajax response is not complete

2010-09-17 Thread topher.baron
Hi web2py users, I'm encountering a strange issue. About half of every ajax response I get from web2py is not complete. For instance, I'm usually sending a json string from the server to the client. Upon trying to eval the json, I get an unterminated string literal error because the string is

[web2py] Re: Forms with hidden fields

2010-09-17 Thread mdipierro
ERRATA^3 I like to define def HiddenField(*a,**b): b['writable']=b['readable']=False return Field(*a,**b) and use db.define_table('mytable',Field('name'),HiddenField('manager')) On Sep 17, 11:53 am, Fabio Alessandro Locati floc...@grimp.eu wrote: thank you guys, it works perfectly

[web2py] Re: StackExchange for web2py community

2010-09-17 Thread spiffytech
StackExchange is designed such that people who don't know what they're talking about get voted down, while those who have quality answers get voted up to the top. When I'm reading StackOverflow, the reading the highest-voted questions first makes the poor quality of the lower- voted questions very

[web2py] 1.85 change log

2010-09-17 Thread Richard Vézina
Hello, There is a render problem with 1.85 version change log!! http://www.web2py.com/examples/default/changelog Richard

Re: [web2py] Re: StackExchange for web2py community

2010-09-17 Thread Michael Wolfe
I understand your concern, Massimo. However, I think the solution is not to ignore SO, but to try to get more knowledgeable web2py users answering questions there. You will still have general knowledge folks answering web2py questions, but the voting system should leave their answers at the

[web2py] How to create indexes on postgres if not exists

2010-09-17 Thread Michael Toomim
I wanted the equivalent of sqlite's create index if not exists on postgresql. Here's a solution for web2py. It is useful whenever you set up a new database, or migrate new tables to an existing database after a code update and want to ensure the right indexes are set up. def

[web2py] Re: Validators with Dependencies

2010-09-17 Thread mart
oh... good one! didn't realize you could do that! :) as part of the admin, would it be worth it to put that functionality as a pre-setup of apps? hum jquery + dragdrop in to a db design canvas for designing tables? or while we are on it, maybe a lot of app setup steps could be done this way

[web2py] fastcgi and suexec on Hetzner

2010-09-17 Thread Johann Spies
I am trying to deploy web2py on Hetzner (www.hetzner.co.za) which does not provide wsgi. I have followed http://web2pyslices.com/main/slices/take_slice/76 as example. Hetzner is using fastcgi with suexec. I get the following error: web2py/web2py.fcgi(10044)exit(communication error), terminated

[web2py] Re: Hi guys.. reg:plugin_wiki select/read

2010-09-17 Thread cjrh
On Sep 17, 5:00 pm, bally boy ballybo...@gmail.com wrote: I am at this url:-http://127.0.0.1/ There's no place like home :)

[web2py] Re: Simple search form

2010-09-17 Thread elfuego1
I did as you suggested. The mail should be in your mail box. On 17 Wrz, 15:55, mdipierro mdipie...@cs.depaul.edu wrote: You need to help some bore with debugging. Looks to me there simply is no matching data. Try search by one single filed, Try print the values of form.vars. or send me the

[web2py] forcing lowercase on auth email address

2010-09-17 Thread david.waldrop
is there an easy way to force email address in the basic auth mechanism to always be lower case. I am capturing emails in another form and am worried about explicit case matching. I know I can define a custom table, but was wondering if there was a simpler way.

[web2py] Re: forcing lowercase on auth email address

2010-09-17 Thread mdipierro
requires=IS_LOWER(),IS_EMAIL() On Sep 17, 4:40 pm, david.waldrop david.wald...@gmail.com wrote: is there an easy way to force email address in the basic auth mechanism to always be lower case.  I am capturing emails in another form and am worried about explicit case matching.  I know I can

[web2py] Accessing Janrain Data

2010-09-17 Thread Blake J Gideon
I'm trying to access records stored in the database created by Janrain. I have the following code: return dict(message='Hello' + str(db().auth_user.first_name)) I know this is obviously incorrect because I get an error ticket issued: File

[web2py] URL error in appadmin

2010-09-17 Thread Avik Basu
Hi, I get the following error in appadmin.py which I copied over from the welcome app in version 1.85.2: Traceback (most recent call last): File /Volumes/Data/avikbasu/web2py/gluon/restricted.py, line 188, in restricted exec ccode in environment File

Re: [web2py] URL error in appadmin

2010-09-17 Thread Jonathan Lundell
On Sep 17, 2010, at 4:06 PM, Avik Basu wrote: Hi, I get the following error in appadmin.py which I copied over from the welcome app in version 1.85.2: Are you running 1.85.2? It sounds like you might be running something earlier. Traceback (most recent call last): File

[web2py] Re: URL error in appadmin

2010-09-17 Thread Avik Basu
Yes, I'm sure I'm running 1.85.2. i copied over appadmin.py and the associated views to my applications. What is strange though is that I can run the welcome app without any problem (http://127.0.0.1:8000/ welcome/appadmin/index), but not the version I copied into my application

[web2py] Re: index error -GAE

2010-09-17 Thread howesc
yes. the app engine takes time to generate the indexes. sometimes it's just a few minutes, i've had some take over a day. you can check the index status by clicking on the datastore indexes link. it will show you which are serving and which are still building. On Sep 17, 3:28 am, b vivek

Re: [web2py] Re: URL error in appadmin

2010-09-17 Thread Jonathan Lundell
On Sep 17, 2010, at 4:44 PM, Avik Basu wrote: Yes, I'm sure I'm running 1.85.2. i copied over appadmin.py and the associated views to my applications. What is strange though is that I can run the welcome app without any problem (http://127.0.0.1:8000/ welcome/appadmin/index), but not the

[web2py] trying to understand plugin_wiki

2010-09-17 Thread bally boy
Hi I am just trying to get into terms with plugin_wiki. 1. Am using the tagging widget and see that all tags are stored in two tables:-plugin_wiki_tag and the related info in plugin_wiki_links.. Now as of now I am concerned with plugin_wiki_links. 2. I am using plugin_wiki_links to tag my blogs

[web2py] Re: Ajax response is not complete

2010-09-17 Thread Adi
It would help to see some code. On Sep 17, 9:40 pm, topher.baron topher.ba...@gmail.com wrote: Hi web2py users, I'm encountering a strange issue.  About half of every ajax response I get from web2py is not complete.  For instance, I'm usually sending a json string from the server to the

[web2py] Thinking of starting an interesting project.

2010-09-17 Thread Jason Brower
Most of use run web2py here. Many of use have some really fun skills with graphics, and some of use love role playing games. Have any of you played Wizardry? http://en.wikipedia.org/wiki/Wizardry_VII:_Crusaders_of_the_Dark_Savant I want to make a web base game that would basically be a multi

Re: [web2py] Re: StackExchange for web2py community

2010-09-17 Thread bally boy
I am with Massimo on one thing, not to scatter information all around.As a platform although both Stack Overflow and Stack exchange are great and better than google mailing lists but it does invite a lot of uninvited guests who actually know nothing. For eg: - let us say someone puts up a post

Re: [web2py] Re: StackExchange for web2py community

2010-09-17 Thread bally boy
And yeah on second thoughts about what Michael said, while it can be argued that sheer exclusivity, might stunt the growth of web2py(which even I was thinking), I guess there are other ways to spread the word too... On Sat, Sep 18, 2010 at 10:24 AM, bally boy ballybo...@gmail.com wrote: I am