[web2py] Re: row.update_record(effectiveSize-=1)

2013-03-24 Thread Annet
Thanks for your reply and explanation, I'll use: db(db.groups.id ==session.groupID).update(effectiveSize=db.groups.effectiveSize-1) Kind regards, Annet -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and

[web2py] style input class=upload the Boostrap way

2013-03-24 Thread Annet
I am looking for a way to style this: input type=file name=file id=heroUnitFile_file class=upload more in line with the Bootstrap styling of the input and button style, as described in the buttons instead of text section of http://twitter.github.com/bootstrap/base-css.html#forms Kind

[web2py] Re: How to get selective update rows from SQLFROM.grid

2013-03-24 Thread 黄祥
yes, i'm sorry, i forgot to show the requires too for field gender (because i set the type as list string) please add this code below in models/db.py : custom_auth_table=db[auth.settings.table_user_name] custom_auth_table.gender.requires=IS_IN_SET(['Male', 'Female'])

[web2py] retrieve data from table and then input it to another table using sqlform grid onvalidation

2013-03-24 Thread 黄祥
hi, is it possible to retrieve data from table and then input it to another table using sqlform grid? my goal is when i submit the check out form, it will retrieve room and guest data from table check in and then insert it to table check out. below is the code that not work (no error occured,

[web2py] Re: insert many rows using a single form

2013-03-24 Thread 黄祥
please check discussion on : https://groups.google.com/forum/?fromgroups=#!topic/web2py/6wU3AtkwtA0 there are 2 example apps on that. hope this can help. -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and

[web2py] Re: No CMS for Web2Py?

2013-03-24 Thread Loïc
Niphlod, I would be pleased to contribute. What should I do? Le dimanche 24 mars 2013 00:08:40 UTC+1, Niphlod a écrit : candidate for submission on the poweredby ? or appliances ? On Saturday, March 23, 2013 8:34:39 PM UTC+1, Loïc wrote: Hi Marcel For my personal use I developed a basic

[web2py] Re: How to get selective update rows from SQLFROM.grid

2013-03-24 Thread Sarbjit singh
@黄祥, *Its still giving error: *Table has no attribute 'gender' and '* *'custom_auth_table' not defined. Db.py # -*- coding: utf-8 -*- from gluon.tools import Auth db = DAL(sqlite://storage.sqlite) auth = Auth(db) auth.settings.create_user_groups=True auth.define_tables(username=False,

[web2py] Free host for blog with domain?

2013-03-24 Thread Mika Sjöman
Hi I wonder if anyone knows where I can put my we2py based blog up where they I also can use myOwnDomain.com for free? Not too much traffic, maybe a 100 a day And... I just build a community from scratch in two weeks from scratch with web2py, coming from django - I must say I LOVE web2py!

[web2py] update existing project model without breaking backward compatibility...

2013-03-24 Thread Loïc
Hello all, let's imagine I have an app with the following model : db.define_table('contact', Field('name'), Field('phone_number') ) I have already deployed my app, and I have several contacts with a name and a phone number. Then I realise that a contact can have multiple phone

[web2py] Re: Sitemap Plugin or Sitemap Generator

2013-03-24 Thread BlueShadow
This Sitemap generator is great! But I got a couple questions about it.can you remove all entries which require authorisation? I tried it for one of my applications and it shows an entry for a long deleted function(the view has been deleted too). why is that happening? -- --- You received

[web2py] Re: How to get selective update rows from SQLFROM.grid

2013-03-24 Thread 黄祥
did you use the whole db.py default? something like this (in this example i also use the company table that is related with auth user table): *db.py* # -*- coding: utf-8 -*- # ## This scaffolding model makes your app work on

[web2py] Re: No CMS for Web2Py?

2013-03-24 Thread greaneym
Loic, this is a beautiful cms package. Thank you. The only question I would have is how to make the total size smaller? I really like the visual design. Congratulations on your app! Margaret -- --- You received this message because you are subscribed to the Google Groups web2py-users

[web2py] Re: No CMS for Web2Py?

2013-03-24 Thread Loïc
Hi Margaret, The total size of the app is about 9MB To populate the default data, I added some pictures, and a PDF file to download. You will find pics in : *static/images/photo_gallery* and a PDF file in *static/uploaded_files* If you remove the content of these two folders, you will save

[web2py] Re: update existing project model without breaking backward compatibility...

2013-03-24 Thread Mika Sjöman
Hi Maybe you could dump it to a phone numbers to a csv file or a python dict with dump_data = { phone_number : contact.id,} Then when you created the second table, just run a for loop to populate that table with the dumped data with contact_id as a reference to the old table. Thats what

[web2py] Compute fields are not computed on insert

2013-03-24 Thread memo
Hi, I have added computed fields to db model, but they are not computed on insert. Code is supplied below. Thanks db.define_table('t_invoices', Field http://127.0.0.1:8000/examples/global/vars/Field('f_customer', type='reference t_customers', label=T

[web2py] SQLFORM.factory - is it possible to add multiple child objects to one parent in one view?

2013-03-24 Thread memo
Hi, Here the codes. Is there a quick way add multiple child objects to a parent in one page? db.define_table('t_invoices', Field http://127.0.0.1:8000/examples/global/vars/Field('f_customer', type='reference t_customers', label=T

[web2py] Re: No CMS for Web2Py?

2013-03-24 Thread mjm
Hi Loïc, This looks very promising! Thx for the tip. Marcel -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For

[web2py] Re: No CMS for Web2Py?

2013-03-24 Thread mjm
Hi Derek Web2Py might be backward compatible but neither Movuca nor InstantPress work out of the box. That does not inspire others to contribute ;-) Marcel On Wednesday, March 13, 2013 1:58:24 AM UTC+1, Derek wrote: Well, the thing about web2py is that it's been backwards compatible from

[web2py] Re: SQLFORM.factory - is it possible to add multiple child objects to one parent in one view?

2013-03-24 Thread Alan Etkin
Hi, Here the codes. Is there a quick way add multiple child objects to a parent in one page? Which are the children and which are the parets?. It seems that you want to add many invoice details without requesting new form pages (within the same invoice page). I think that it's possible

[web2py] Re: Compute fields are not computed on insert

2013-03-24 Thread Alan Etkin
Hi, I have added computed fields to db model, but they are not computed on insert. Code is supplied below. Thanks Maybe the computation order is failing, since you have three linked computed fields. It could be that you need a custom callback for updating all the vars in the proper

[web2py] Re: Free host for blog with domain?

2013-03-24 Thread Alan Etkin
I wonder if anyone knows where I can put my we2py based blog up where they I also can use myOwnDomain.com for free? Not too much traffic, maybe a 100 a day IIRC there was a list of web2py aware hostings in this group. Did you try a group search? Otherwise you can use this list instead

Re: [web2py] Free host for blog with domain?

2013-03-24 Thread Relsi Hur Maron
- OpenShift - Amazon Web Services (1 year free) 2013/3/24 Mika Sjöman mikasjo...@gmail.com Hi I wonder if anyone knows where I can put my we2py based blog up where they I also can use myOwnDomain.com for free? Not too much traffic, maybe a 100 a day And... I just build a community from

[web2py] Re: Error when listing newly created database tables from appadmin

2013-03-24 Thread Alan Etkin
Hi there, I've created 7 tables from my app and 2 of them cause error when to be listed from Appadmin (/appadmin/select/db?query=db.t_leads.id0). Don't see anything particular in the table definition that may cause the problem. Any help would be apprecicated. I think the problem may

[web2py] Re: No CMS for Web2Py?

2013-03-24 Thread Niphlod
it's just to keep track of projects running on web2py if they are open-source even better I'll notice Anthony or Massimo to get this repo included... On Sunday, March 24, 2013 10:55:32 AM UTC+1, Loïc wrote: Niphlod, I would be pleased to contribute. What should I do? Le dimanche

[web2py] Re: style input class=upload the Boostrap way

2013-03-24 Thread Niphlod
create your own widget http://web2py.com/books/default/chapter/29/07#Widgets On Sunday, March 24, 2013 9:17:04 AM UTC+1, Annet wrote: I am looking for a way to style this: input type=file name=file id=heroUnitFile_file class=upload more in line with the Bootstrap styling of the input and

[web2py] Re: style input class=upload the Boostrap way

2013-03-24 Thread Anthony
Are you using SQLFORM? Note, you can do SQLFORM(..., formstyle='bootstrap'). If that doesn't yield what you're looking for, you can do SQLFORM(..., formstyle=custom_function). See https://code.google.com/p/web2py/source/browse/gluon/sqlhtml.py#773 for an example of such a function. Anthony

[web2py] problems with import in 2.4.4 and 2.4.5

2013-03-24 Thread puercoespin
With the same packaged app, in 2.3 works well, but in 2.4.4 and 2.4.5 raise an import error: ImportError: cannot import name haversine_distance2 And refers to this sentence : from geo_utils import haversine_distance2 geo_utils is in the modules folder, with his _init_.py files and

[web2py] Re: How can I store upload original filename using smartgrid?

2013-03-24 Thread Massimo Di Pierro
that works for a form but not for smartgrid. you can try this (a hack): if request.vars.file != None: db.client.filename.default = request.vars.file.filename form = SQLFORM.smartgrid(db.client, fields=fields, linked_tables=['file' ]) On Friday, 22 March 2013 16:14:58 UTC-5, James

Re: [web2py] Re: SQLFORM.factory - is it possible to add multiple child objects to one parent in one view?

2013-03-24 Thread Ergun Pekuysal
Thank you. Can u pls provide a sample code for this? Sent from my iPhone On 24 Mar 2013, at 19:37, Alan Etkin spame...@gmail.com wrote: Hi, Here the codes. Is there a quick way add multiple child objects to a parent in one page? Which are the children and which are the parets?. It seems

[web2py] Re: How can I store upload original filename using smartgrid?

2013-03-24 Thread James Burke
Found exactly what I was after here: http://stackoverflow.com/questions/8008213/web2py-upload-with-original-filename/8185933#8185933 -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails

Re: [web2py] Re: SQLFORM.factory - is it possible to add multiple child objects to one parent in one view?

2013-03-24 Thread Alan Etkin
Thank you. Can u pls provide a sample code for this? Derived from the book example (at the end of the Chapter 7, in the smartgrid section) @auth.requires_login(): def invoice(): constraints=dict(invoice=db.invoice.id==the invoice id,

Re: [web2py] Re: SQLFORM.factory - is it possible to add multiple child objects to one parent in one view?

2013-03-24 Thread Ergun Pekuysal
Thank you so much. Is it possible to create the invoice and the details on the same page? Sent from my iPhone On 24 Mar 2013, at 22:02, Alan Etkin spame...@gmail.com wrote: Thank you. Can u pls provide a sample code for this? Derived from the book example (at the end of the Chapter 7, in the

[web2py] second controller file not found

2013-03-24 Thread BlueShadow
Hi, I added a second controller to my app to seperate admin functions to a diffrent controller. but my problem is that I can't even get the index.html to work with the second controller I always get a file not found. I suspect it has something todo with my routes.py: because I don't have to

[web2py] Re: Error when listing newly created database tables from appadmin

2013-03-24 Thread Spring
Hello Alan, Thanks for the reply. I noticed the common thing of the two error tables is that they're both referenced by some other tables while do not reference to any. Showing one of referencing table: db.define_table('t_clients_in', Field('f_account_id', type='reference t_accounts',

[web2py] Re: Error when listing newly created database tables from appadmin

2013-03-24 Thread Spring
I think I kinda figured out the problem. The order of defining tables seems matter. Tables to be referenced need to be defined before the referencing tables. Guess it's a rookie mistake. Spring 在 2013年3月25日星期一UTC+8上午9时13分56秒,Spring写道: Hello Alan, Thanks for the reply. I noticed the common

[web2py] Re: Query Not Supported: (1054, Unknown column 'daily_counts.add_date' in 'order clause') No records f

2013-03-24 Thread Shawn Wheatley
I am seeing a similar issue using smartgrid for a master-detail invoice view. When clicking on the link for my detail child records, I get an error saying the column I'm ordering by in the master doesn't exist. Has this been resolved yet? Dan, did you open a ticket for this? Shawn On Monday,

[web2py] Re: Query Not Supported: (1054, Unknown column 'daily_counts.add_date' in 'order clause') No records f

2013-03-24 Thread Shawn Wheatley
Hmmm... I also just discovered that specifying fields on the smartgrid causes issues with the child tables. Is there a way to pass another list of fields for the child table? On Sunday, March 24, 2013 11:17:24 PM UTC-4, Shawn Wheatley wrote: I am seeing a similar issue using smartgrid for a

[web2py] Re: Query Not Supported: (1054, Unknown column 'daily_counts.add_date' in 'order clause') No records f

2013-03-24 Thread Shawn Wheatley
I figured it out. I didn't read the section of the docs on smartgrid well enough. I now see you *can* pass multiple values to orderby and fields as a dictionary, with the table names as the keys. Shawn On Sunday, March 24, 2013 11:21:29 PM UTC-4, Shawn Wheatley wrote: Hmmm... I also just

[web2py] Re: How to get selective update rows from SQLFROM.grid

2013-03-24 Thread Sarbjit singh
Well, I was able to run the code. Problem with this is that in this case if user is Manager, then all the rows are editable and if it is other user including Admin, then rows are read only. My requirement is let's say I have a database where each user can insert some data and at the same time

[web2py] Re: How to get selective update rows from SQLFROM.grid

2013-03-24 Thread 黄祥
please use query : *db.person.created_by == db.auth.user.id* in your grid. e.g. @auth.requires_login() def person(): created_by_user=db.person.created_by == db.auth.user.id grid=SQLFORM.grid(db.person, user_signature=False, editable=created_by_user,