[web2py] hello~

2010-01-13 Thread JD Erickson
Hi,One of my friends introduce a very good website to me: http://www.flsso.com/. All their products are new and original. They have many brands, such as Sony, HP, Apple, Nokia and so on. Now , they are promoting their products for the coustomers. So their prices are very competitive. By the way, th

[web2py] Mercurial menu item missing

2010-01-13 Thread Anand Vaidya
web2py version 1.74.5 OS = kubuntu 9.10 x86_64 (intel linux), python =2.6.4 x64 easy_install mercurial got me mercurial ver 1.4.2 I have exported the path correctly export PYTHONPATH=/usr/local/lib/python2.6/dist-packages/ mercurial-1.4.2-py2.6-linux-x86_64.egg/mercurial:$PYTHONPATH; export PA

Re: [web2py] Re: error

2010-01-13 Thread Alexandre Andrade
The error was caused by trying to redefine auth tables (I think especially auth_event), so I get back to a backup and will try to redefine only auth_user, as in the book. 2010/1/12 mdipierro > cannot say without looking at models and controller > > On Jan 12, 6:59 am, Alexandre Andrade > wrot

[web2py] Re: Error UnicodeDecodeError in sql.py

2010-01-13 Thread Jose
On 12 ene, 17:01, mdipierro wrote: > The problem is not so much with this code but with the fact that there > seems to be non-unicode characters in one of your records. It comes up > because of the fields in the SQLFORM as an IS_IN_DB validator. > > I have made a modification in  trunk that will

[web2py] Re: choose a value

2010-01-13 Thread Jose
On 13 ene, 05:44, Iceberg wrote: > I also notice this change. > > I suggest to change its default value back to None, so that old apps > behave in the same way. +1 -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send em

[web2py] Re: plugin static files

2010-01-13 Thread selecta
hey there, sry had no time y-day but I tested it now and it does not work properly yet in http://127.0.0.1:8001/admin/default/plugin/test/test i created a file text.txt the file was created: test/static/test/test.txt instead of test/static/plugin_test/test.txt also creating "plugin_test/test.t

[web2py] the length of the string field in the model ...

2010-01-13 Thread pyparser
I am creating an interface where I want the input fields to reflect the length of the string fields in the model. How do I find the length of the string field as defined in the model? pyparser -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To

[web2py] Re: Share some wisdom

2010-01-13 Thread selecta
on version control Usually I check-in at the end of each day, each file separately (documenting the changes in each module). If you work together with other people you will have to see that your check-in does not break things. Because of that you might not check-in one or the other thing at the en

[web2py] Re: Possible bug in Auth.retrieve_password()

2010-01-13 Thread mdipierro
You found a bug. Thanks Rowdy. I am fixing it in trunk. This is a major security issue so I will post a new web2py version later today. On Jan 13, 12:37 am, Rowdy wrote: > I am using web2py 1.74.5. > > In Auth.retrieve_password() after form.accepts(...), there is a check > that the email address

[web2py] Re: best approach to populating a form input type select

2010-01-13 Thread Miguel Lopes
On Wed, Jan 6, 2010 at 5:50 PM, Miguel Lopes wrote: > I have a form to create related records with an input type select > element that should display a list of records that are also related to > the parent record. What would be the best approach to populate this > form. I'm trying to stick with SQ

[web2py] Re: the length of the string field in the model ...

2010-01-13 Thread DenesL
db.table.field.length On Jan 13, 8:30 am, pyparser wrote: > I am creating an interface where I want the input fields to reflect > the length of the string fields in the model. How do I find the length > of the string field as defined in the model? > > pyparser -- You received this message becau

[web2py] Re: Error UnicodeDecodeError in sql.py

2010-01-13 Thread mdipierro
If it is a legacy database try use DAL('mssql2://...') instead of DAL('mssql://...') On Jan 13, 7:12 am, Jose wrote: > On 12 ene, 17:01, mdipierro wrote: > > > The problem is not so much with this code but with the fact that there > > seems to be non-unicode characters in one of your records. I

[web2py] Re: choose a value

2010-01-13 Thread mdipierro
There is no way to make everybody happy. Ok to make zero='' not to go back to zero=None. On Jan 12, 11:44 pm, Iceberg wrote: > I also notice this change. > > I suggest to change its default value back to None, so that old apps > behave in the same way. > > Or at least, let the default value be

Re: [web2py] Re: Why double braces in view

2010-01-13 Thread Timothy Farrell
What situation are you in such that your app depends on neatly indented HTML? -tim On 1/12/2010 11:52 PM, Iceberg wrote: I knew this, but I still avoid writing such long paragraph of code in view file. Because I am nervous that maybe someday some developer (other than me) modifies this my_view

[web2py] Re: plugin static files

2010-01-13 Thread mdipierro
I will check. On Jan 13, 7:20 am, selecta wrote: > hey there, sry had no time y-day but I tested it now and it does not > work properly yet > > inhttp://127.0.0.1:8001/admin/default/plugin/test/test > i created a file text.txt > > the file was created: test/static/test/test.txt > > instead of  te

[web2py] How to get last_insert_id

2010-01-13 Thread Alexandre Andrade
When I submit a form, DAL creates a new 'id' for the row of table. How I retrieve it with form, to show it again or redirect to another page? form=SQLFORM(db.processo, submit_button = "Cadastrar Processo") if form.accepts(request.vars, session): redirect (URL(r=request, f='process

[web2py] Re: Why double braces in view

2010-01-13 Thread mdipierro
To be clear you can do things like {{ for i in range(3): for j in range(3): for j in range(3): }} hello {{=i+i+j}} {{ pass pass pass }} Indentation is never relevant in views. On Jan 13, 7:51 am, Timothy Farrell wrote: > What situation are you in such that your app depends on neatly indented >

[web2py] Re: Why double braces in view

2010-01-13 Thread mdipierro
ERRATA: To be clear you can do things like {{ for i in range(3): for j in range(3): for k in range(3): }} hello {{=i+j+k}} {{ pass pass pass }} Indentation is never relevant in views. On Jan 13, 7:59 am, mdipierro wrote: > To be clear you can do things like > > {{ > for i in range(3): > for j

[web2py] Getting representation from two levels deep relation

2010-01-13 Thread Miguel Lopes
I have the following tables: task, opportunity, and oppty_main With the following relations: * task.opportunity_id->opportunity.id * opportunity.oppty_main_id->oppty_main.id When updating a task I have a SELECT for the related opportunities: db.task.opportunity_id.requires=IS_NULL_OR( IS_

Re: [web2py] Re: choose a value

2010-01-13 Thread Alexandre Andrade
I always remember web2py needs to be more easier to internacionalize. as example, delete_label in forms always have to be set to be able to localize. All strings 'under the hood' need to be T('string'). 2010/1/13 mdipierro > There is no way to make everybody happy. > > Ok to make zero='' not t

[web2py] Re: Importing a file and can't get some characters...

2010-01-13 Thread Brian M
Jason, Can you look at the data in the database itself - not through the web2py admin, but through something like the sqlite manager add-on available for FireFox. If it's showing up funny in the *view* it seems that it may be that your computer/web browser isn't displaying things correctly on scre

Re: [web2py] Getting representation from two levels deep relation

2010-01-13 Thread Alexandre Andrade
this works for me: db.plano_aplicacao.codigo.represent= lambda codigo: db.natureza_despesa[codigo].codigo + ' - ' + db.natureza_despesa[codigo].especificacao ), 2010/1/13 Miguel Lopes > I have the following tables: task, opportunity, and oppty_main > With the following relations: > * task.oppor

[web2py] Re: How to get last_insert_id

2010-01-13 Thread Alexandre Andrade
Found: form.vars.id 2010/1/13 Alexandre Andrade > When I submit a form, DAL creates a new 'id' for the row of table. > > How I retrieve it with form, to show it again or redirect to another page? > > form=SQLFORM(db.processo, submit_button = "Cadastrar Processo") > if form.accepts(requ

Re: [web2py] Getting representation from two levels deep relation

2010-01-13 Thread Miguel Lopes
On Wed, Jan 13, 2010 at 2:07 PM, Alexandre Andrade wrote: > this works for me: > > db.plano_aplicacao.codigo.represent= lambda codigo: > db.natureza_despesa[codigo].codigo + ' - ' + > db.natureza_despesa[codigo].especificacao ), ("Olá Alexandre" == "Hello Alexandre") I'm not trying to get to a re

[web2py] Re: Error UnicodeDecodeError in sql.py

2010-01-13 Thread Jose
On 13 ene, 13:46, mdipierro wrote: > > Does it mean you can read the data? Yes, but it shows strange characters. I do not know how to change the charset, and the administrator of the database does not know (or not want) to tell me what charset it uses. the connection is as follows: SQLServer <

[web2py] Re: choose a value

2010-01-13 Thread mdipierro
On Jan 13, 8:02 am, Alexandre Andrade wrote: > I always remember web2py needs to be more easier to internacionalize. > > as example, delete_label in forms always have to be set to be able to > localize. > > All strings 'under the hood' need to be T('string'). Yes but technically, how would you do

[web2py] Re: Error UnicodeDecodeError in sql.py

2010-01-13 Thread mdipierro
Look into gluon/sql.py/SQLDB/__init__ and the different between DAL('mssql2://...') and DAL('mssql://...') the difference is in the charset On Jan 13, 8:46 am, Jose wrote: > On 13 ene, 13:46, mdipierro wrote: > > > > > Does it mean you can read the data? > > Yes, but it shows strange character

Re: [web2py] Re: Share some wisdom

2010-01-13 Thread Thadeus Burgess
To clarify your second paragraph... Did you mean """ > The release/build/production version of the software should not be kept up to date by using version control, it should be updated by using rsync or copy/paste? """ Currently, whenever I have a stable version that I am ready to use on product

Re: [web2py] Re: Why double braces in view

2010-01-13 Thread Thadeus Burgess
score 1 for web2py's freaking awesome template system! -Thadeus On Wed, Jan 13, 2010 at 8:00 AM, mdipierro wrote: > ERRATA: > > To be clear you can do things like > > {{ > for i in range(3): > for j in range(3): > for k in range(3): > }} > hello {{=i+j+k}} > {{ > pass > pass > pass > > }} >

[web2py] Re: Error UnicodeDecodeError in sql.py

2010-01-13 Thread Jose
change to: db = DAL("mssql://..., db_codec='latin1') now it looks all right. With mssql2 fails. -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send

[web2py] Re: Error UnicodeDecodeError in sql.py [solved]

2010-01-13 Thread mdipierro
yes because mssql2 forces utf8. Good! On Jan 13, 11:00 am, Jose wrote: > change to: > > db = DAL("mssql://..., db_codec='latin1') > > now it looks all right. With mssql2  fails. -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this gr

[web2py] web2py 1.74.6 is OUT

2010-01-13 Thread mdipierro
Mostly bug fixes and two main security issues fixed: - deals with misconfiguration of postgresql that may cause SQL Injection vulnerability - blocked accounts were not really blocked Please give it a try and report any bug as usual. Massimo -- You received this message because you are subscribe

[web2py] Validating Remote Data (from Flex)

2010-01-13 Thread Dane
Hello, I've been learning Web2Py and liking it a lot. Thanks for your hard work Mossimo. I want to use it as a backend for a site that will mostly be in Flex. I've gotten the RPC working smoothly, and now I'm onto validation. I'll be doing client-side validation on forms, but I know serverside is

[web2py] Re: Validating Remote Data (from Flex)

2010-01-13 Thread mdipierro
Try form.accepts(flexItem,formname=None) On Jan 13, 12:06 pm, Dane wrote: > Hello, > > I've been learning Web2Py and liking it a lot. Thanks for your hard > work Mossimo. I want to use it as a backend for a site that will > mostly be in Flex. I've gotten the RPC working smoothly, and now I'm > o

[web2py] widget and its form

2010-01-13 Thread leone
How a widget can know the name and id of the form in which it resides? Is it possible to use javascript function on submit? Thanks leone -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com.

[web2py] Re: widget and its form

2010-01-13 Thread mdipierro
> How a widget can know the name and id of the form in which it resides? The built-in widgets do not know. You can make your own widget and pass the information to it. What do you have in mind? On Jan 13, 12:13 pm, leone wrote: > Is it possible to use javascript function on submit? yes. Look in

[web2py] donations

2010-01-13 Thread mdipierro
As you know we have not yet set up a mechanism for accepting donations. So if you have made some money from web2py and feel about giving back, consider instead giving to those who need the most: http://doctorswithoutborders.org/donate/ https://american.redcross.org/site/Donation2?4306.donation=f

[web2py] customizing web2py form widgets

2010-01-13 Thread vwong2...@gmail.com
Hi, I know that web2py can display form widgets simply by adding db.post.permission.widget = SQLFORM.widgets.radio.widget to the db.py file. However, I would like to customize the HTML generated from public to public This way, the user can click the label for the radio button to select th

[web2py] Re: customizing web2py form widgets

2010-01-13 Thread mdipierro
You have three options: 1) You can make your own widget. 2) in controller or view form.element(_name='permission')['_id']='public' 3) in view jQuery('input[name="permission"]').attr('id','public') On Jan 13, 1:28 pm, "vwong2...@gmail.com" wrote: > Hi, > > I know that web2py can display form

Re: [web2py] Getting representation from two levels deep relation

2010-01-13 Thread Alexandre Andrade
Let's make it clear: db.task -> child db.opportunity -> parent db.oppty_main_id -> grandparent db.task.opportunity_id.represent=lambda opportunity_id: db.oppty_main_id[db.opportunity[opportunity_id].id].name should work db.task.opportunity_id.represent=lambda opportunity_id: db.opportunity[oppo

Re: [web2py] Getting representation from two levels deep relation

2010-01-13 Thread Alexandre Andrade
better db.task -> child table | parent field db.opportunity -> parent table db.oppty_main_id -> grandparent table should work: db.task.opportunity_id.represent=lambda opportunity_id: db.oppty_main_id[db.opportunity[opportunity_id].oppty_main_id].name 2010/1/13 Alexandre Andrade > Let's mak

Re: [web2py] Re: choose a value

2010-01-13 Thread Thadeus Burgess
*the inherit problem of always keeping backwards compatibility* However, aside from this, there is a bug with the new "choose a value" that is unacceptable. http://static.thadeusb.com/choosevaluebug.png -Thadeus On Wed, Jan 13, 2010 at 9:32 AM, mdipierro wrote: > On Jan 13, 8:02 am, Alexan

[web2py] Re: Getting representation from two levels deep relation

2010-01-13 Thread mdipierro
If this works: db.task.opportunity_id.represent=lambda opportunity_id: db.oppty_main_id[db.opportunity[opportunity_id].oppty_main_id].name this should work too db.task.opportunity_id.represent=lambda opportunity_id: opportunity_id.oppy_main_id.name On Jan 13, 2:22 pm, Alexandre Andrade wrote:

Re: [web2py] Re: Share some wisdom

2010-01-13 Thread Thadeus Burgess
Howesc: What are the plugins that you use for Trac ? Do they auto link with commits or do you need to set the post-commit-hooks ? Have you used anything for tracking multiple projects? -Thadeus On Wed, Jan 13, 2010 at 10:35 AM, Thadeus Burgess wrote: > To clarify your second paragraph... >

[web2py] Re: choose a value

2010-01-13 Thread mdipierro
Good point. Please check trunk and I will post 1.74.7 On Jan 13, 2:25 pm, Thadeus Burgess wrote: > *the inherit problem of always keeping backwards compatibility* > > However, aside from this, there is a bug with the new "choose a value" that > is unacceptable. > > http://static.thadeusb.com/choo

[web2py] Re: choose a value

2010-01-13 Thread mdipierro
On Jan 13, 2:25 pm, Thadeus Burgess wrote: > *the inherit problem of always keeping backwards compatibility* backward compatibility aside. How would you do it? -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email

[web2py] change of behavior in crud and auth

2010-01-13 Thread mdipierro
right now crud and auth use accepts(request.vars) I have changed it in trunk to accept(request.post_vars) It solves a very subtle rare problem and it is more logical to me. Can any of you think of a problem? Massimo -- You received this message because you are subscribed to the Google G

Re: [web2py] Re: choose a value

2010-01-13 Thread Thadeus Burgess
I'm not sure there is a good solution with the current design. At the moment, I am compiling a document with problem with the current form system. Along with the document I am also including topics that come up in the google groups and specific issues that continue to arise where the solution does

[web2py] Re: choose a value

2010-01-13 Thread mdipierro
As fare as I can tell the problems arise from SQLFORM. Nothing prevents us from creating an alternative (as opposed to a replacement) to SQLFORM. There is a reason you have to call SQLFORM explicitly (or call crud which calls SQLFORM) and it is not implicit. The reason that one may not want to use

[web2py] Re: Validating Remote Data (from Flex)

2010-01-13 Thread Dane
Thank you. That worked like a charm. On Jan 13, 1:10 pm, mdipierro wrote: > Try > > form.accepts(flexItem,formname=None) > > On Jan 13, 12:06 pm, Dane wrote: > > > Hello, > > > I've been learning Web2Py and liking it a lot. Thanks for your hard > > work Mossimo. I want to use it as a backend for

Re: [web2py] change of behavior in crud and auth

2010-01-13 Thread Álvaro Justen [Turicas]
On Wed, Jan 13, 2010 at 18:49, mdipierro wrote: > right now crud and auth use > >   accepts(request.vars) > > I have changed it in trunk to > >   accept(request.post_vars) > > It solves a very subtle rare problem and it is more logical to me. Can > any of you think of a problem? As generally the

Re: [web2py] Re: Validating Remote Data (from Flex)

2010-01-13 Thread Vasile Ermicioi
awesome: the response, the web2py, and you, Massimo -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com.

[web2py] Re: change of behavior in crud and auth

2010-01-13 Thread mdipierro
I agree. On Jan 13, 5:14 pm, Álvaro Justen [Turicas] wrote: > On Wed, Jan 13, 2010 at 18:49, mdipierro wrote: > > right now crud and auth use > > >   accepts(request.vars) > > > I have changed it in trunk to > > >   accept(request.post_vars) > > > It solves a very subtle rare problem and it is m

[web2py] Several File Upload Using Ajax... Any Example available by any chance ?

2010-01-13 Thread Yannick
Hello mate, I just wonder if there is an example of several upload file (all at once a little bit like gmail attachment files) with Web2py ? If you know some example... Please let me know... Cheers, Yannick P. -- You received this message because you are subscribed to the Google Groups "web2py-u

[web2py] Re: Why double braces in view

2010-01-13 Thread Anand Vaidya
@Thaddeus: I re-read Ch5 (Views) in the Official Manual and it does mention "never should use response.write()" Pg129 regards Anand On Jan 14, 12:48 am, Thadeus Burgess wrote: > score 1 for web2py's freaking awesome template system! > > -Thadeus > > On Wed, Jan 13, 2010 at 8:00 AM, mdipierro

Re: [web2py] Anybody going to PyCon?

2010-01-13 Thread Jeff Bauer
If work will let up long enough, I hope to attend ... the reason I couldn't take advantage of pre-registration discount. Assuming I'll be there (60%+), I'd like to see what other people are doing with web2py. -Jeff On 01/12/2010 06:20 PM, mdipierro wrote: Anybody going to PyCon? -- You receiv

[web2py] Re: force login and register over https on GAE

2010-01-13 Thread Robin B
You don't need a route, you need a redirect. Check the path and scheme each request, and redirect to what you want. Robin On Jan 11, 2:44 am, JimK wrote: > Is it possible to setup a route that redirects all attempts to access > the login and register pages to https?  In other words, userA goes

[web2py] Re: Validating Unique Database Entries Using GAE

2010-01-13 Thread Robin B
As a warning, querying before inserting does not guarantee uniqueness in the transactional sense. If 2 users try to add the same name at the same time, they will both insert and you will not have uniqueness. The only way to get transactional uniqueness on GAE is using a keyname and a transactiona

[web2py] Re: Why double braces in view

2010-01-13 Thread mdipierro
The manual says: "You never need to (and never should) call the response.write method explicitly." It is more of a style suggestion than a technical suggestion. There is no reason not to use it except that, in a distant future, in case we should rewrite the template engine using a parser instead

Re: [web2py] Re: choose a value

2010-01-13 Thread Jeff Bauer
Thadeus, Please consider some blog posts toward an immediate goal of redesign suggestions. As a new entrant into web2py, it would be handy for me (and others) to understand where the edge cases lay. In the early days of Django, I wrote a lot of forms code (pre-newforms) and I understand it's a

Re: [web2py] Several File Upload Using Ajax... Any Example available by any chance ?

2010-01-13 Thread Thadeus Burgess
Gmail attachment files uses a flash solution :) It is even noted about the fact flash is required in the settings tab. -Thadeus On Wed, Jan 13, 2010 at 8:33 PM, Yannick wrote: > Hello mate, > I just wonder if there is an example of several upload file (all at > once a little bit like gmail

Re: [web2py] Re: choose a value

2010-01-13 Thread Thadeus Burgess
I have shared my thoughts on these forums and have elected no response from the community. Recently other software projects have taken my focus away from web2py, however I will be diving back into web2py projects in a week or two, when I do this is one of the first tasks I will be working on. I w

[web2py] Is there a better way of doing this in GAE?

2010-01-13 Thread Miguel
Hi Advertisements can be published in different magazines. I represent this with the following tables: db.define_table("magazine", SQLField("owner",db.auth_user, writable=False, readable=False)) db.define_table("advertisement", SQLField("owner",db.auth_user,writable=False, readable=False),