Re: [web2py] Issues with python in the menu.py

2011-04-03 Thread Kenneth Lundström
Oh shit, no I undestand why you created the list, it was a submenu you tried to create and my was for creating the main menu. Why yours is failing I have no idea. Sorry. Kenneth So I have been playing with the idea of having some dynamic menus and I am a bit stuck... If a user is logged in a

Re: [web2py] web2py/poweredby problem

2011-04-05 Thread Kenneth Lundström
Why is there no link to poweredby page on the frontpage or did I miss it? That sounds strange that you have to login, I don´t know why. But if you click on the name below the screencapture of the site you don´t have to login. Kenneth I've been looking around http://www.web2py.com/poweredby

[web2py] Import HTML file

2011-04-10 Thread Kenneth Lundström
Hello list, instead on paying the bank to get a bankaccount abstract in a machine readable format I thought I´d write a small application that imports a HTML page (the source of a page viewing all that has happened on the bankaccount), parses the file and write all happenings into a database.

Re: [web2py] Re: Import HTML file

2011-04-11 Thread Kenneth Lundström
On 11.4.2011 11:18, stefaan wrote: I know how to import CSV files, but how do I import a textfile and parse all lines. I don t want to all, and rest of tags in my source page to be used, I just want to parse the whole file line by line. It's not entirely clear to me what you want to accomplish

Re: [web2py] Re: Check if a user has already rated

2011-04-11 Thread Kenneth Lundström
On 11.4.2011 18:59, Drise wrote: How would I go by doing that? On Apr 11, 10:42 am, pbreit wrote: I wasn't aware that validators could be used like that. Perhaps just query the db? Hello, as pbreit commented validators can´t be used like that. They are used when you are using forms, to val

[web2py] contains in selecting rows

2011-04-12 Thread Kenneth Lundström
I´d like to create a form with a list of members in a select/option tag and have the user select one or more of the members. In form.accepts I´d like to pull all rows of the selected members. In request.vars.members I have a list of selected members but what should the query look like? Kenn

[web2py] list or value

2011-04-14 Thread Kenneth Lundström
Hello, I have a very stupid problem. I created a list of users with a SELECT/OPTION tag and I have multiple as true. I can select as many members I like and with belongs I can fetch all members like selected = db(db.members.id.belongs(request.vars.receivers)).select() Every option has a valu

[web2py] Re: list or value

2011-04-14 Thread Kenneth Lundström
Well, to answer my own question, if isinstance(request.vars.receivers, list): db(db.members.id.belongs(request.vars.receivers)).select() else: db(db.members.id==request.vars.receivers)).select() Probably there is a nicer solution but this works. Kenneth Hello, I have a very stupid p

[web2py] Open a new window and continue

2011-04-16 Thread Kenneth Lundström
Hello, how would you do something like this. I´d like to have a link that generates an PDF report and opens that one in a new window. At the main window it continues to a new page. I know have to make a link open in a new windows. How would you do something like this? Kenneth

Re: [web2py] Re: Open a new window and continue

2011-04-18 Thread Kenneth Lundström
r 16, 5:26 pm, Kenneth Lundström wrote: Hello, how would you do something like this. I d like to have a link that generates an PDF report and opens that one in a new window. At the main window it continues to a new page. I know have to make a link open in a new windows. How would you do some

Re: [web2py] web2py and freelancing services

2011-04-21 Thread Kenneth Lundström
Hello Jim, have you looked at www.experts4solutions.com? Kenneth We are looking for experienced developers to work on a web2py project. We are considering using a freelancing service like vworker.com (formerly rent-a-coder) or elance. Does anyone have any experience with these companies? Jim

Re: [web2py] Re: Open a new window and continue

2011-04-22 Thread Kenneth Lundström
Thank you for all your suggestions, the problem is that the PDF is created on the fly, so when I click on a link I need to run a function and that function creates the PDF and updates the database. After that I can reload the page and open the PDF file in a new window. I guess the right order i

Re: [web2py] Some Advice for a Novice

2011-04-24 Thread Kenneth Lundström
Hi Josh, I´d say, read the book (www.web2py.com/book), there is a lot of things you don´t need, but as you don´t know exactly what you need it´s hard to tell read that chapter or that chapter. While reading I think you´ll get many thoughts on how to do things. At some point you´ll start withou

Re: [web2py] web2py 1.95.1 and open issues

2011-04-25 Thread Kenneth Lundström
> - importved pyfpdf Is there any more info about the improved pyfpdf? Kenneth - domain check in email_auth.py, thanks Gyuris - added change_password_onvalidation and change_password_onaccept - DAL(...,migrate_enabled=True) - login_methods/loginza.py, thanks Vladimir - bpython shell support,

[web2py] pyfpdf question, maybe

2011-04-25 Thread Kenneth Lundström
I´m using pyfpdf to create bills and would like to include a barcode. The barcode should be in Code 128C and the Interleaved 2of5 NT that pyfpdf is using does not work. I found this site http://barcode128.blogspot.com/ that let you create Code 128 barcodes with PIL. I succeeded in printing a

[web2py] SQLFORM question

2011-04-27 Thread Kenneth Lundström
I have a table that I´d like to update. Let´s say the table has eight different columns but at the time I´d like to only update one of them via a form. in controller: form = SQLFORM(db.t_bills, bill['id']) if form.accepts(request.vars, session, keepvalues=True): redirect() return dict

Re: [web2py] Re: SQLFORM question

2011-04-27 Thread Kenneth Lundström
way you only affect the listed fields. On Apr 27, 7:01 pm, Kenneth Lundström wrote: I have a table that I d like to update. Let s say the table has eight different columns but at the time I d like to only update one of them via a form. in controller: form = SQLFORM(db.t_bills, bill[&#x

Re: [web2py] Re: SQLFORM question

2011-04-29 Thread Kenneth Lundström
I tried putting field.writeable=False, now when using the update form that specific coloum is not changed. Sounds like a bug. I don´t won´t to have to put all to writeable=false. Kenneth On Apr 27, 9:40 pm, Kenneth Lundström wrote: I tried that soluttion but I think it didn t work as

Re: [web2py] Update application without deleting tables

2011-05-06 Thread Kenneth Lundström
Hello, why do you have to remove the tables? What kind of changes are you making to the code? Kenneth The problem I have is when I update an application, when loading the application with the changes I have to remove the tables auth_event, auth_group, auth_membership, auth_permission. My qu

[web2py] Conseptual programming problem

2011-06-13 Thread Kenneth Lundström
Hello list, This is not a web2py problem but as there is so many good programmers on the list I thought I´d start here. I´m extending out billing application that is made on webpy. The extension is to handle bills that should be billed periodically (usually once a year). So instead of having

Re: [web2py] prettyPhoto with web2py

2011-06-16 Thread Kenneth Lundström
Could somebody share some examples of how you have integrated prettyphoto into web2py? Kenneth I am using on http://CursoDePython.com.br , no problem -- Bruno Rocha [ About me: http://zerp.ly/rochacbruno ] [ Aprenda a programar: http://CursoDePython.com.br ] [ O seu aliado nos cuidados c

Re: [web2py] Web2py plus standard LAMP server functionality?

2011-06-22 Thread Kenneth Lundström
> Is there any way to run a standard PHP web app like vBulletin along side web2py? Yes > i.e. www.domain.com would load the web2py site and www.domain.com/vbulletin would load the separate web app without web2py being involved? If you are using Apache then the easiest solution is to use ww

[web2py] Error on upgrading to 1.96.4

2011-06-25 Thread Kenneth Lundström
Environment: Centos 5.5, Apache 2.something, mod_wsgi, MySQL Version 1.95.something worked nice [Sat Jun 25 21:51:17 2011] [error] [client 93.106.44.10] mod_wsgi (pid=23210): Target WSGI script '/data/domains/web2py/wsgihandler.py' cannot be loaded as Python module. [Sat Jun 25 21:51:17 2011]

Re: [web2py] vhosts - apache - multiple domains - virtual hosts

2011-06-26 Thread Kenneth Lundström
Hello, I think the best way is to let Apache take care of sort out web2py domains and non web2py domains. If you want to have a PHP site on one vhost and the rest are web2py then you need two vhost files. All web2py domains are pointed towards webpy. Web2py with routes.py takes care of which

Re: [web2py] DAL Query by Date on Datetime Field.

2011-06-27 Thread Kenneth Lundström
> How do I use DAL to query by exact date? db((db.events.created_on < datetime(date_of_day+1 0.00.00)&(db.events.created_on > datetime(date_of_day 0.00.00)).select() Or then you need to save even just the date of the event, not datetime as created_on saves. I might be totally wrong but this

[web2py] Many modal windows on one page

2011-07-11 Thread Kenneth Lundström
Hello everybody, I´m trying to create a page with a list of items. On every row a item is shown and every row has an Edit button. Instead of going to a new page to edit the record I´m trying to use modal window via AJAX to edit the record. Mmodal plugin gets me quite close to a solution, but

Re: [web2py] one form for multiple tables - updating record

2011-07-11 Thread Kenneth Lundström
def display(): record = db.person(request.args(0)) form=SQLFORM.factory(db.person, db.affiliation, db.address, db.card, record) if form.accepts(request.vars, session): record.update_record(**dict(form.vars)) return dict(form=form) The problem is that your are g

[web2py] Powertable and virtual columns

2011-07-12 Thread Kenneth Lundström
Hello list, I´m using Powertable to show a list of records. With virtual columns I create links to modify, copy and so on. To save space I´d like to add more links into one column. I´m using: @virtualsettings(label=T('Edit')) def edit(self): return A('Edit', _href=

Re: [web2py] Re: Powertable and virtual columns

2011-07-12 Thread Kenneth Lundström
ipt', 'create_receipt', args=[self.t_receipt.id <http://self.t_receipt.id>])), XML(' '), A('another link', _href=...)) or you could use DIVs, TABLE, UL/OL or CSS to have them stacked. Denes. On Jul 12, 9:47

Re: [web2py] Bookings with expiration date

2011-07-12 Thread Kenneth Lundström
Who is doing the checking? If you want to send an email when a room is empty you need to run web2py from command prompt with cron to check if the end_date has gone. When designing the database its maybe not a good idea to create a own tables for every buildning. Instead create a rooms table:

Re: [web2py] Re: Admin security: https vs localhost

2011-07-12 Thread Kenneth Lundström
Please don´t make a mandotary complexity. On my dev site I use a simple password and it doesn´t bother me if somebody breaks in. Delay sounds good. Kenneth we can make a delay default to 1 second and double it every failed attempt. we should add complexity. I would take a patch or add an iss

[web2py] Re: Many modal windows on one page

2011-07-12 Thread Kenneth Lundström
Is this impossible? Should I instead try something with a form in a DIV. I got some hints from Branko but could just not get it working. Javascript sounded a nice way but even their I only got close, not perfect. Kenneth Hello everybody, I´m trying to create a page with a list of items. On

Re: [web2py] Re: web2py - Best Practice

2011-07-13 Thread Kenneth Lundström
On 13.7.2011 10:23, cjrh wrote: On Wednesday, July 13, 2011 7:45:18 AM UTC+2, nic wrote: A Wiki / Blog / CMS / Forum An Online Store A Personal Accounting System A Media Center etc ... How about an issue tracker? We're currently using Redmine, and it's really clunky and

Re: [web2py] Help : SQLFORM.factory with multiple submit button ?

2011-07-13 Thread Kenneth Lundström
I think this is what you are looking for: http://labs.blouweb.com/powerformwizard Kenneth Hello, I have series of forms with in final validation. I would like that the user could go forward and backward between form

Re: [web2py] SQLFORM - crud.create in a popup

2011-07-13 Thread Kenneth Lundström
> hi! How could I put a SQLForm or a crud.create form in a modal and send it some url attributes? There is many different ways: http://easyframework.com/demo_popup.php A sure way is: http://www.web2py.com/plugins/static/web2py.plugin.*mmodal*.w2p

Re: [web2py] INSERT Error? or Bug?

2011-07-13 Thread Kenneth Lundström
> hi! I'm very confused, I'm trying to do a simple Insert, like this, db.person.insert(name = 'foo'), but It doesn't work (from a controller). What happens when you do it in a controller? Do you get an error? If not how do you know it does not work? Kenneth I tried trough appadmin in the

Re: [web2py] INSERT Error? or Bug?

2011-07-13 Thread Kenneth Lundström
.vez...@gmail.com>> wrote: Maybe you forgot : db.commit() Richard On Wed, Jul 13, 2011 at 1:59 PM, Ismael Alejandro mailto:ialejandr...@gmail.com>> wrote: well, nothing is inserted 2011/7/13

[web2py] auth_user.id == kenneth

2011-07-14 Thread Kenneth Lundström
Hello, why can´t I do this: user = db(db.auth_user.id == 'kenneth').select() I know that this should result in len(user) = 0 but I´m sending sometimes a text and sometimes a number and I´m trying to do this: user = db(db.auth_user.id == str(request.args[0])).select() if len(use

Re: [web2py] Re: auth_user.id == kenneth

2011-07-14 Thread Kenneth Lundström
ects integers and you're sending it a string, "kenneth". Quick fix: user = db(db.auth_user.id == request.args[0] if request.args[0].isdigit() else 0).select() That fixes the syntax error but not the logic error I pointed out earlier. On Jul 15, 5:06 am, Kenneth Lundströ

[web2py] Using T with IS_IN_DB

2011-07-15 Thread Kenneth Lundström
I have a requires with IS_IN_DB like this: IS_IN_DB(db(db.t_status.id > 0), 't_status.id', '%(f_status)s / %(f_name)s') I´d like to translate the f_name with T(). Is it possible? Kenneth

Re: [web2py] Problem with CRUD using fancybox dialog

2011-07-15 Thread Kenneth Lundström
Hello Jim, this is exactly the same thing that I have tried to achieve without much luck. Would it be possible to get a copy of how you have done it. I have no ideas to give you why it is not working, atleast not at the moment. Kenneth Hi I have a component on my page that lists a few r

Re: [web2py] Re: Getting a reproducible web2py internal error

2011-07-16 Thread Kenneth Lundström
On 17.7.2011 6:08, pbreit wrote: What sort of server are you on? Is it shared hosting or do you control your own server? Linux or Unix? In Garys first mail and last sentence Gary wrote: "The system I'm running on is a Microsoft Windows Server 2003 R2 On both a Linux/Ubuntu and a Windows XP mac

Re: [web2py] Re: Using T with IS_IN_DB

2011-07-17 Thread Kenneth Lundström
#x27;t_status.id', '%(f_status)s / %(f_name)s')) Kenneth On Jul 15, 9:27 pm, Kenneth Lundström wrote: I have a requires with IS_IN_DB like this: IS_IN_DB(db(db.t_status.id> 0), 't_status.id', '%(f_status)s / %(f_name)s') I d like to translate the f_name with T(). Is it possible? Kenneth

Re: [web2py] Re: request - mmodal examples

2011-07-19 Thread Kenneth Lundström
I have never used crud with mmodal, but I have used SQLFORM with it. I guess you have read: http://groups.google.com/group/web2py/browse_thread/thread/809bf7eb5072651f/90ecd2c59b3dacc6?lnk=gst&q=mmodal#90ecd2c59b3dacc6 Instead of: {{a=PluginMModal(title='Hello World',content='give this a try!',c

Re: [web2py] Re: request - mmodal examples

2011-07-19 Thread Kenneth Lundström
This works: {{for ticket in tickets:}} {{a=PluginMModal(title='Hello World',content=crud.update(db.t_ticket, ticket.id),close='close',width=40,height=80)}} {{=a}} {{=a.link(H1('SEE MODAL WINDOW'))}} {{pass}} Kenneth On 19.7.2011 11:21, Kenneth Lundström

Re: [web2py] blogs

2011-07-22 Thread Kenneth Lundström
Hello, have you read: http://web2py.com/book/default/chapter/07?search=upload#SQLFORM-and-Uploads Do you get any error messages when using the flash plugin? Kenneth hello guys , am trying to build a blogs website but i want to have a video and image upload in every post so its not just tex

Re: [web2py] How to use the new cpdb.py introduced in 1.97.1?

2011-07-23 Thread Kenneth Lundström
It sounds like web2py is not able to open either the sqlite file or postgres database. Have you tried to use both connection strings in a model file to test that both works? Kenneth I am having a hard time migrating data from sqlite to postgres This is the command that I use ./web2py.py -S

Re: [web2py] How to use Web2py with Postgres SQL or MySQL installed through XAMPP (Windows) ?

2011-07-23 Thread Kenneth Lundström
web2py doesn´t care where your Postgres is installed. If you can get Psycopg2 to work with your Postgres then web2py should work too. Kenneth I somehow manged to install to install Postgres into Xampp directory ( by following a tutorial i found on web ) to use it under xampp environment whic

Re: [web2py] Re: How to use the new cpdb.py introduced in 1.97.1?

2011-07-23 Thread Kenneth Lundström
I guess we have to wait for maybe Massimo to look into this. Kenneth Hi Kenneth, Yes both the connection strings work in db.py which I too find very puzzling. On Jul 23, 12:24 pm, Kenneth Lundström wrote: It sounds like web2py is not able to open either the sqlite file or postgres database

[web2py] FORM questions

2011-07-23 Thread Kenneth Lundström
I´m creating a form with SQLFORM that includes 6 fields. One field is f_customer with requires IS_IN_DB() Now I'd like to add a new field not taken directly from database. Lets call it f_extra. f_customer is a drop-down and f_extra would also be a drop-down. Now I have a list of question

[web2py] Re: FORM questions

2011-07-23 Thread Kenneth Lundström
As I guess Massimo wanted to post these answers to the list and not only to me, I´ll forward his answers here. On Jul 23, 10:19 am, Kenneth Lundström wrote: I m creating a form with SQLFORM that includes 6 fields. One field is f_customer with requires IS_IN_DB() Now I'd like to

Re: [web2py] DISCUSSION: Dual Desktop/Mobile Functionality

2011-07-23 Thread Kenneth Lundström
When I first read about subdirectories I saw this structure: views/default/index.html views/default/mobile/index.html views/default/tablet/index.html If no mobile/tablet directory or index.html is found it defaults to /views/default/index.html Kenneth On Jul 23, 2011, at 12:36 PM, Ross Peo

[web2py] Re: FORM questions

2011-07-23 Thread Kenneth Lundström
anted to post these answers to the list and not only to me, I´ll forward his answers here. On Jul 23, 10:19 am, Kenneth Lundström wrote: I m creating a form with SQLFORM that includes 6 fields. One field is f_customer with requires IS_IN_DB() Now I'd like to add a new field not taken

Re: [web2py] Re: FORM questions

2011-07-24 Thread Kenneth Lundström
Thanks Anthony, I changed it to: from decimal import Decimal and now it works. Kenneth That's an issue with your Python code. You should either move the import outside the function or only import specific objects from the Decimal module (which is probably a better idea -- "from module impor

Re: [web2py] Re: Ticket issued: unrecoverable

2011-07-25 Thread Kenneth Lundström
What kind of a problem was it? Kenneth Its working. Was a DNS problem. Sorry Em 25 de julho de 2011 13:51, António Ramos > escreveu: this is the link http://apps.cires.pt:10800/Lims/Default/index if you try http://194.65.91.152:10800/Lims/Default

Re: [web2py] web2py for freelance work

2011-07-25 Thread Kenneth Lundström
> I'm picking out a framework to use for freelance web development. Does anyone use web2py in that sort of situation? How does it fare? Do you find anything particularly limiting or particularly easy? How do clients respond when you tell them you're building the site in Python (not PHP), and th

Re: [web2py] The web2py grid/crud plugin you've always dreamed about!

2011-07-25 Thread Kenneth Lundström
Really awsome Bruno, I´m trying to implement it on our companys intranet and got one question and one suggestion. Is it possible to use T() on headers? Something like: headers=[['f_name',T('Name')]] Highlightning rows, sometimes it would be good to highlight some specific rows? Kenneth

Re: [web2py] The web2py grid/crud plugin you've always dreamed about!

2011-07-25 Thread Kenneth Lundström
I published my first new version of our intranet on our production server and now I´m getting: Traceback(most recent call last): File"/data/domains/web2py/gluon/restricted.py",line181,inrestricted execccodeinenvironment File"/data/domains/web2py/applications/economy/models/plugin_PowerGr

Re: [web2py] The web2py grid/crud plugin you've always dreamed about!

2011-07-25 Thread Kenneth Lundström
Sorry, I found the error already. A stupid error. Our production server was laging behind on updates, was using 1.95.1, but not anymore. And now Powergrid is working. Kenneth I published my first new version of our intranet on our production server and now I´m getting: Traceback(most rece

Re: [web2py] Re: export data to OOO and Excel

2011-07-26 Thread Kenneth Lundström
Please let us know which one you found to be better. I´m going to need to switch away from CSV to a "real" Excel format in a couple of months. Kenneth @selecta, thanks for directing to 'tablib'. It is also a good choice. I am assessing whether to use 'excel-python' or 'tablib'. :-| On Jul 2

Re: [web2py] The web2py book is broken

2011-07-26 Thread Kenneth Lundström
Hopefully it is fixed now because it works for me now. Kenneth A quick FYI. http://www.web2py.com/book is throwing errors right now. Matt

Re: [web2py] DAL - Multiple select for field

2011-07-27 Thread Kenneth Lundström
Field(' client_contacts ',requires=IS_IN_DB(db,'auth_user.id ','auth_user.email'), multiple=True) Kenneth this way in admin when i populate a record i can only select one user from auth_user. *What if i want to select multiple users at once?* thank you

Re: [web2py] DAL - Multiple select for field

2011-07-27 Thread Kenneth Lundström
Sorry my bad, pasted it on the wrong side of the ). Kenneth Sorry, it works now instead of Field(' client_contacts ',requires=IS_IN_DB(db,'auth_user.id ','auth_user.email'), multiple=True) i write this and works Field(' client_contacts ',requires=IS_IN_DB(db,'auth_user

Re: [web2py] Relationship help

2011-07-27 Thread Kenneth Lundström
> images=db().select( db.image.ALL, db.blogpost.ALL, left=db.image.on(db.blogpost.id==db.image.blog_id)) As I understand that row, you are selecting all images you have i database, shouldn´t it be something like: images=db(db.image.blog_id == request.args[0]).select(..

[web2py] form.vars not working on new form

2011-07-27 Thread Kenneth Lundström
I have this controller function (simplified to make it easier to read): def testing(): statuses = db(db.t_status.f_company==1).select(orderby=db.t_status.f_status) form = SQLFORM(db.t_ticket) form.vars.f_status = statuses[0].id if form.accepts(request.vars, session): res

Re: [web2py] DAL - Multiple select for field

2011-07-27 Thread Kenneth Lundström
ail') to show only some users base in some kind of criteria? 2011/7/27 Kenneth Lundström <mailto:kenneth.t.lundst...@gmail.com>> Sorry my bad, pasted it on the wrong side of the ). Kenneth Sorry, it works now instead of Field(' client_co

Re: [web2py] Re: form.vars not working on new form

2011-07-27 Thread Kenneth Lundström
you want to use default: db.t_status.f_status.default = statuses[0].id form = SQLFORM(db.t_ticket) ... On Jul 27, 10:38 am, Kenneth Lundström wrote: I have this controller function (simplified to make it easier to read): def testing(): statuses = db(db.t_status.f_company==1

Re: [web2py] form.vars not working on new form

2011-07-27 Thread Kenneth Lundström
tion. I am newbie as well. Lets say we have 2 functions that create forms on two different view pages or same page and in controller we have 2 functions returning form dictionary. how would web2py determines which form goes where? I am sorry for stupid questiona 2011/7/27 Kenneth

Re: [web2py] record id to 1!

2011-07-27 Thread Kenneth Lundström
This is a database "problem" not web2py. Depending on what database engine your are using there is different solutions. Google is your friend on this. Kenneth hello, i deleted all record from a table the id stil mantains the last id when i create the first record again. it is not important

[web2py] DAL/SQL question

2011-07-27 Thread Kenneth Lundström
Hello, what would be the easiest way to find out how many items there is in a table grouped by a field. I have a table where tickets are stored. Every ticket has an status, he number of statuses can change (only a reference to the t_status table). How do I find out how many tickets there i

[web2py] web2py/python question

2011-07-27 Thread Kenneth Lundström
Hello, is it so that if I query a table and ask to get all rows where a fields value is != True then all "None" rows are also exluded, only "False" rows are included? Kenneth

Re: [web2py] Re: web2py/python question

2011-07-28 Thread Kenneth Lundström
Boolean and MySQL. Kenneth What is the field type? None is NULL in SQL. This is an SQL issue. On Jul 28, 1:17 am, Kenneth Lundström wrote: Hello, is it so that if I query a table and ask to get all rows where a fields value is != True then all "None" rows are also exluded, o

Re: [web2py] Re: Problems with online book?

2011-07-28 Thread Kenneth Lundström
Book is giving tickets again. Kenneth I apologize. The server run out of disk space. Fortunately the database did not get corrupted. I did a lot of cleanup and now everything should be up and running as usual. Massimo On Jul 26, 2:34 pm, cjrh wrote: Book is working again.

Re: [web2py] Re: web2py/python question

2011-07-28 Thread Kenneth Lundström
s to avoid order of evaluation problems. On Jul 28, 2:17 am, Kenneth Lundström wrote: Hello, is it so that if I query a table and ask to get all rows where a fields value is != True then all "None" rows are also exluded, only "False" rows are included? Kenneth

Re: [web2py] MENUS ACL?

2011-07-28 Thread Kenneth Lundström
> can i restrict the menu.py items according to the user group? Definitly, I do it like this: response.menu = []#[(T('Frontpage'), False, URL('default', 'index'), []),] if (auth.has_membership('admin')): response.menu += [(T('Settings'), False, URL('default', 'settings'), []),] Kenn

Re: [web2py] Re: I keep getting "Invalid Circular Reference" using Project Wizard!

2011-07-28 Thread Kenneth Lundström
It should definitly not help that you Rufus prefix all fields by hand as web2pys wizard already does that automatically. But it could be that the wizard does not understand to prefix a reserved word. Maybe it helps to prefix by hand. But then your fields are problaly prefixed twice. Kenneth

Re: [web2py] Re: DISCUSSION: Dual Desktop/Mobile Functionality

2011-07-28 Thread Kenneth Lundström
I find it unfortunate that it was never implemented. Would it be possible to get a web2pyslice of how to do something like what was the orginal idea? Kenneth The end result of the discussion was to give the developers a way to detect the devices using request.user_agent() to get info from t

Re: [web2py] Re: web2py/python question

2011-07-29 Thread Kenneth Lundström
On 29.7.2011 2:05, pbreit wrote: Is it possible that you have the string "None" in the DB? No, I have NULL when looking from mysql client. Kenneth

Re: [web2py] Re: web2py/python question

2011-07-29 Thread Kenneth Lundström
slated into SQL, it's SQL semantics, not pythonic. Marin 2011/7/28 Kenneth Lundström: Default value could be a good solution, but I don't understand how I have never before run into this. Can't remember how many times I have used !=True to find all none True records. I have chosen n

Re: [web2py] web2py 1.98.1 is OUT

2011-07-31 Thread Kenneth Lundström
I tried from admin upgrade to 1.98.1 and got this ticket: web2py™ Version 1.98.1 (2011-07-31 10:15:50) Python Python 2.6.5: /usr/bin/python Traceback (most recent call last): File "/data/domains/web2py/gluon/main.py", line 513, in wsgibase session._try_store_on_disk(request, response) File "/da

[web2py] Upgrading from 1.91.4 to 1.98.1

2011-08-02 Thread Kenneth Lundström
I tried to upgrade a development server from 1.91.4 to 1.98.1 and now I get these tickets: Version web2py^(TM) Version 1.98.1 (2011-07-31 10:15:50) Traceback (most recent call last): File "/data/domains/gluon/restricted.py", line 192, in restricted exec ccode in environment File "/

Re: [web2py] Upgrading from 1.91.4 to 1.98.1

2011-08-02 Thread Kenneth Lundström
> That's a really odd model. Usually it would look like this: 462 db.define_table('returning_revision', 464 Field('returning', db.returning)) 2,5 years, but this is not the first revision definition, maybe 30:th. Kenneth

Re: [web2py] Re: Upgrading from 1.91.4 to 1.98.1

2011-08-02 Thread Kenneth Lundström
b.returning, db.Field('returning', db.returning, required=True), migrate=settings.migrate) I added db.Field("id","id"), and now it is working. Kenneth Can you show the definition of table "returning"? I think I know what is wrong. As a test, ca

Re: [web2py] Web2py traffic to web2py.com and twitter

2011-08-02 Thread Kenneth Lundström
Atleast admin get web2py version from web2py.com and get discussion from Twitter. Kenneth hello, my firewall detects that my we2py server is constantly connecting to twitter and web2py The connection is blocked by the firewall. is this normal? thank you

Re: [web2py] Fwd: Server slow

2011-08-02 Thread Kenneth Lundström
all records. Is there something I can do to reduce query time? 31.000 records just doesn't sound like that much yet. Kenneth -- Forwarded message -- From: Kenneth Lundström Date: Dec 27 2010, 9:14 am Subject: Server slow To: web2py-users So it rather fast notslow:=) Bu

Re: [web2py] Fwd: Server slow

2011-08-02 Thread Kenneth Lundström
> Can you run the query directly against the db to compare? Do you have the debug tool displaying at the bottom of the page that shows how long he query took? t3=time.time() testar = db(db.tracker_person_product.id).select() t4=time.time() logging.info('query

Re: [web2py] Fwd: Server slow

2011-08-02 Thread Kenneth Lundström
On 2.8.2011 15:54, Anthony wrote: On Tuesday, August 2, 2011 8:44:52 AM UTC-4, Kenneth wrote: > Can you run the query directly against the db to compare? Do you have the debug tool displaying at the bottom of the page that shows how long he query took? t3=time.t

Re: [web2py] About passwords security in web2py

2011-08-03 Thread Kenneth Lundström
> what do i tell in my company to convinve them to use web2py apps without fearing that i as administrator cannot discover their password? Sounds like you will have to lie to them as you can always as a developer change the code so that a copy of passwords is stored as clear text. At the mom

[web2py] socket.error

2011-08-04 Thread Kenneth Lundström
Version web2py™ Version 1.98.1 (2011-07-31 10:15:50) Traceback (most recent call last): File "/data/domains/gluon/main.py", line 506, in wsgibase BaseAdapter.close_all_instances('commit') File "/data/domains/gluon/dal.py", line 373, in close_all_instances getattr(instance,action)() File "/data/do

Re: [web2py] deploying few web2py sites

2011-08-07 Thread Kenneth Lundström
> I believe that we'll settle on Web2py (over Django) for our future web needs (moving from PHP to Python) and I'm not 100% clear how does deployment with Web2Py go...iow, does one install one instance of web2py and install specific app for each site, e.g. {app1,app2,app3} or it is required to

Re: [web2py] Where to put the .htaccess file

2011-08-07 Thread Kenneth Lundström
> I want to force "www" in front of the url and i modify the .htaccess file to do so and now I wonder where to put that file. I tried to put it in the "web2py/apps" directory, in the "web2py/apps/views" directory, in the "web2py/" directory but none of them works. I'm using apache as webserver.

Re: [web2py] Re: Where to put the .htaccess file

2011-08-07 Thread Kenneth Lundström
> Well I tried to put the same code in httpd.conf file but it doesn't work, I have a "Syntax Error" when restarting apache because the command "RewriteEngine " is not recognized. Do you have this line in the httpd.conf file: LoadModule rewrite_module modules/mod_rewrite.so Without it, it won'

Re: [web2py] Trying to do Massimo's Poll Django video tutorial but getting this traceback error. Please explain!

2011-08-09 Thread Kenneth Lundström
Please send the whole default.py as I don't think do problem is on that line you showed. Kenneth Can somebody please explain what the issue is. Its this video at 9.34: http://vimeo.com/6507384 TRACEBACK Traceback (most recent call last): File "gluon/restricted.py", line 192, in restrict

Re: [web2py] Opposite of "required..." for field?

2011-08-19 Thread Kenneth Lundström
> Is there a way to have a "required_not_to_be_specified" setting for a field? You can change the writable and readable atributes, either in the model or in controller. Kenneth

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-22 Thread Kenneth Lundström
+1 for modal option. Why not make it optional. Kenneth On Sunday, August 21, 2011 11:10:23 PM UTC-4, pbreit wrote: That seems unnecessary to me. Easy enough to command-click a link to open in a new tab/window. I think most users won't know/bother to command-click, so a modal might

[web2py] PyCon Finland 2011

2011-08-22 Thread Kenneth Lundström
Anyone planing to visit the European Capital of Culture a.k.a. Turku on 17-18.10 and maybe visiting PyCon Turku at the same time? Kenneth

[web2py] Re: PyCon Finland 2011

2011-08-22 Thread Kenneth Lundström
And the address is: http://fi.pycon.org/2011/ Anyone planing to visit the European Capital of Culture a.k.a. Turku on 17-18.10 and maybe visiting PyCon Turku at the same time? Kenneth

[web2py] routes.py

2011-08-25 Thread Kenneth Lundström
I'd like to have three types of routings: a) web2py.main_domain.comdefaults to init, but you can choose the application with web2py.main_domain.com b) testing.main_domain.com leads to application: testing c) development.main_domain.comleads to application: testing, controller:tic

Re: [web2py] routes.py

2011-08-25 Thread Kenneth Lundström
On 26.8.2011 5:21, Jonathan Lundell wrote: On Aug 25, 2011, at 4:48 PM, Kenneth Lundström wrote: I'd like to have three types of routings: a) web2py.main_domain.comdefaults to init, but you can choose the application with web2py.main_domain.com b) testing.main_domain.com lea

Re: [web2py] routes.py

2011-08-26 Thread Kenneth Lundström
On 26.8.2011 7:57, Jonathan Lundell wrote: On Aug 25, 2011, at 9:28 PM, Kenneth Lundström wrote: On 26.8.2011 5:21, Jonathan Lundell wrote: On Aug 25, 2011, at 4:48 PM, Kenneth Lundström wrote: I'd like to have three types of routings: a) web2py.main_domain.comdefaults to init, bu

<    1   2   3   4   5   >