[web2py] Re: Can not import copy_reg

2014-07-23 Thread Richard
ious distributions. It's a pretty well documented "issue" > with a large number of cases. > > On Wednesday, July 23, 2014 1:07:38 PM UTC+2, Richard wrote: >> >> The issue does not occur on my local development machine. >> I did an upgrade on the remote

[web2py] Re: Can not import copy_reg

2014-07-24 Thread Richard
#x27;s a pretty well documented "issue" >> with a large number of cases. >> >> On Wednesday, July 23, 2014 1:07:38 PM UTC+2, Richard wrote: >>> >>> The issue does not occur on my local development machine. >>> I did an upgrade on the remot

[web2py] Re: Can not import copy_reg

2014-07-25 Thread Richard
web server (running for example on localhost:8000)." I'll try this first. On Thursday, July 24, 2014 9:15:12 PM UTC+2, Richard wrote: > > I am hosted at JustHost, who has the option on installing Nginx. I'll try > that for a better infrastructure. > > > On Thursd

[web2py] Re: Can not import copy_reg

2014-07-26 Thread Richard
UTC+2, Richard wrote: > > nginx will need a VPS so i'll stick to CGI for prototyping and buy some > time for a new hosting service. > In the book an option for "Some web hosting services do not support > mod_wsgi. In this case, we must use Apache as a proxy and forward a

[web2py] Re: Can not import copy_reg

2014-07-29 Thread Richard
Web2py? Please assist me in diagnosing and testing so nobody else will run in this issue. Richard -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received

Re: [web2py] Re: Can not import copy_reg

2014-07-30 Thread Richard
I'll did delete the tables already because I did suspect the database because a backup before a database corruption was working and the version after the corruption (restored the tables from an other backup) was having this issue. I'll keep you informed. On Wednesday, July 30, 2014 7:33:18 PM U

[web2py] Re: Can not import copy_reg

2014-07-31 Thread Richard
My current situation is that I can move the software with no sqlite database to PA, fill the database, looks ok, not efficient though. Packing the app with no errors, no chache, but sqlite file, gives the import error. Zip instead of pack has the same result. But distribution using zip/unzip wit

[web2py] Re: Can not import copy_reg

2014-08-01 Thread Richard
Leonel, switching migrate to False works indeed perfect in my case. Thank you :) Richard -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received

[web2py] Re: response.js does not load div

2014-08-04 Thread Richard
Anthony, After solving some other issues, I continue with this challenge. Also in an other (I think similar) case the form acceptance does not work like I expect. In the controller: persons = db(db.sales).select(db.sales.person, distinct=True).as_list() sales_months = db(db.sales

[web2py] Re: response.js does not load div

2014-08-05 Thread Richard
Niphlod , Thank you for the support. It appeared that I did not make an ajax call; in the controller request.ajax was False. This was because a simple form in a view does not generate an ajax call. Is this correct? if form1.process(formname='form_one').accepted: response.js= "web2py_compone

[web2py] Dynamic menu update

2014-08-12 Thread Richard
% 'menu_identity' I think I am making the design to complicated and does not give the needed functionality. Any assist is welcome. Richard D -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google

[web2py] Random form field order

2014-08-12 Thread Richard
ble).id, orderby=eval('db.%s'%request.vars.lev_table).id) } db.define_table('form_%s'%request.vars.lev_table, *lev_fields_dict) form = SQLFORM(eval('db.form_%s

[web2py] Re: Random form field order

2014-08-12 Thread Richard
Anthony, Thank you, both hints work fine :) Richard D On Tuesday, August 12, 2014 12:16:57 PM UTC+2, Richard wrote: > > For updating a dynamically generated table I use a temporarily table and a > SQLFORM on that table. > This works fine except the sequence of the fields looks

[web2py] Re: Dynamic menu update

2014-08-13 Thread Richard
My conclusion is that the menu is becoming too large any performance improvement will have minimal user experience improvement. I'll create other menus's on locations where users are working at that time. Richard D On Tuesday, August 12, 2014 11:56:35 AM UTC+2, Richard wrote: > &

[web2py] Implementing A Large Scale Engineering Equations Calculator in web2py

2014-08-13 Thread Richard
based design. Web2py allows you to prototype with the database very fast. So start out testing the tips and your own ideas by building the app. When you have your equation frame work you can improve the layout and style. Richard D -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] Python upgrade

2014-08-14 Thread Richard
2py/python come with error : create_mgt_sys() takes exactly 2 arguments (0 given) Does anybody has a clu on the cause of this? Richard D -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web

[web2py] Re: Python upgrade

2014-08-14 Thread Richard
I did reboot, and recompiled the app. No success. On Thursday, August 14, 2014 9:03:44 PM UTC+2, dlypka wrote: > > Maybe just try rebooting you machine. > > On Thursday, August 14, 2014 10:44:21 AM UTC-7, Richard wrote: >> >> Good evening, >> >> I did upgra

[web2py] Re: Python upgrade

2014-08-14 Thread Richard
: return False I don't know what is wrong in this decorator. On Thursday, August 14, 2014 7:44:21 PM UTC+2, Richard wrote: > > Good evening, > > I did upgrade python from 2.7.4 to 2.7.8. on my development laptop and > encounter a 'basic' issu

[web2py] Re: Python upgrade

2014-08-15 Thread Richard
Leonel, Thank you, this works. So nothing to do with the upgrade to Python 2.7.8. Richard D On Thursday, August 14, 2014 7:44:21 PM UTC+2, Richard wrote: > > Good evening, > > I did upgrade python from 2.7.4 to 2.7.8. on my development laptop and > encounter a 'bas

[web2py] Re: How to import MySQL database of web2py app in pythonanywhrere

2014-08-22 Thread Richard
n the form user_name$database_name] Richard D On Friday, August 22, 2014 12:29:07 PM UTC+2, Nitin Shrivastav wrote: > > I want to host my web2py application on python anywhere with MySQL > database on my domain.how to import MySQL database ? -- Resources: - http://web2py.com - htt

[web2py] Re: bootstrap 3 - if you care help test trunk now

2014-08-28 Thread Richard
: .. .. .. Should this be possible with the bs3 version? Richard D On Saturday, August 9, 2014 9:13:38 AM UTC+2, Massimo Di Pierro wrote: > > Bootstrap 3 is in trunk now. Please help us test it. > Also help us test that existing apps are not broken. &g

[web2py] "Enter date as 1963-08-28" error

2014-08-30 Thread Richard
new_lev_def = db.local_ev_def[form_add_local_ev_def.vars.id] new_lev_def.update_record(recursion=db.recursion[target_rec.id].id, created_by=auth.user_id, ) What may cause this error? Richard D -- Resources: - http://web2py.co

[web2py] Re: "Enter date as 1963-08-28" error

2014-09-01 Thread Richard
ou trying to achieve ? > > On Saturday, August 30, 2014 9:13:09 PM UTC+2, Richard wrote: >> >> I have used an sql form for adding records with date fields. >> I added 2 date fields on a table like I did before, now I get only on >> this form the error " Enter

[web2py] Re: "Enter date as 1963-08-28" error

2014-09-01 Thread Richard
I did this not on purpose, it was copy-past issue. The error I got was quite misleading. May this could be improved bij the validation. On Saturday, August 30, 2014 9:13:09 PM UTC+2, Richard wrote: > > I have used an sql form for adding records with date fields. > I added 2 date fi

[web2py] self-reference table IS_IN_DB and set

2014-09-04 Thread Richard
.represent_field, _href=URL(...)) if id is not None else T( 'N/A'), ), Is there a way to filter up the content of a "not already" define table with IS_I

[web2py] Re: Beginner questions

2014-09-13 Thread Richard
Create a calculated field that must be possitive when you accept the form. Would this be a solution? Richard D On Wednesday, September 10, 2014 8:59:02 PM UTC+2, Pedro Henrique Correa Ferreira wrote: > Hi, lads! > > I'd like to know how can I validate a table Field after a

[web2py] Table creation error 139 using MySql

2014-09-23 Thread Richard
I am hosting my app on python anywhere and get the following error: (1005, "Can't create table 'richdijk$imanops03d.form_iv_9cf75329ccbc' (errno: 139)") when creating a new table using: issue_var_fields= [ Field( "d"+str(db[issue_var_table][date_row.id]['iv_date']).repl

[web2py] Re: Table creation error 139 using MySql

2014-09-23 Thread Richard
Leonel and Niphlod, I want to populate a table that is dynamically created have 2 colmuns and an unknown but limited amount of rows. Using SQLform as input was kind of a clever solution, I thought. This is apparently not the case. Any suggestion would be welcome. Richard D On Tuesday

[web2py] Re: Table creation error 139 using MySql

2014-09-23 Thread Richard
I'll explain, the app we are building is a generic management framework which will be used in many different domains because the theory it is based on is domain invariant. Part of the functionality is capturing dynamics through time sequences. These time sequences are stored in dynamically crea

[web2py] Re: Table creation error 139 using MySql

2014-09-23 Thread Richard
I have a table which contains the tablenames and table meta-data. This table is used for defining the table programmatically. A table per time sequence is needed because I want to have security levels on those table devided in view and edit. Sorry , but I do not understand your idea for the time

[web2py] Re: Table creation error 139 using MySql

2014-09-23 Thread Richard
with the meta data. regards, Richard D On Tuesday, September 23, 2014 4:54:56 PM UTC+2, Leonel Câmara wrote: > > table per time sequence is needed because I want to have security levels >> on those table devided in view and edit. > > > Why do you need a new table for tha

[web2py] Re: Table creation error 139 using MySql

2014-09-23 Thread Richard
xed > number of columns ^_^' > > On Tuesday, September 23, 2014 5:09:56 PM UTC+2, Richard wrote: >> >> Leonel, >> >> You are right, the most important message you and Niphlod give me is the >> bad design of the dynamic tables and the need for migration=True. >

[web2py] Pythonic coding

2014-10-09 Thread Richard
software quality and coding speed. Richard D -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the

[web2py] Re: Pythonic coding

2014-10-09 Thread Richard
Thank you, I'll continue the way I was started. On Thursday, October 9, 2014 10:17:48 AM UTC+2, Richard wrote: > > Good morning, > > I am developing a large app and have doubt about proper coding using > web2py. > > Variables may have different web2py types e.g. int,

[web2py] Re: create web2py application with 2 database

2014-10-09 Thread Richard
Maybe 2 apps and 1 DB will deliver your requirements. On Thursday, October 9, 2014 2:00:24 AM UTC+2, 黄祥 wrote: > > hi, > > is it possible to create web2py application with 2 database? 1 for real > data and 1 for fake data (tax reporting to government) > if possible how can i achieve it using web

[web2py] Access DAL from outside script

2014-10-22 Thread Richard
Hi, I want to access an existing database from an outside web2py app script because the database must be input to Orange for data mining. I tried the following defining but dot not get access top the data: import os import sys import datetime import calendar from datetime import date, time

[web2py] Re: Access DAL from outside script

2014-10-22 Thread Richard
ls import Crud, Service, PluginManager, prettydate db.define_table('langu', Field('langu', 'string'), format='%(langu)s' ) print db.tables i = db(db.langu.id>0).select() Gives an error : OperationalError: no such table: langu While the table is see

[web2py] Re: Access DAL from outside script

2014-10-22 Thread Richard
C+2, Richard wrote: > > Hi, > > I want to access an existing database from an outside web2py app script > because the database must be input to Orange for data mining. > > I tried the following defining but dot not get access top the data: > > import os > > impor

[web2py] Re: Access DAL from outside script

2014-10-23 Thread Richard
Solved :) Mistake was the missing closing \\ in the database folder. The working version is module_path = os.path.abspath(os.path.dirname('C:\\web2py\\applications\\wemanops_test\\databases\\')) Thank you On Wednesday, October 22, 2014 4:58:59 PM UTC+2, Richard wrote: > > H

[web2py] Ractive example

2014-10-29 Thread Richard
imports in ractive.js? Thank you, Richard D -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the

[web2py] Re: Ractive example

2014-10-29 Thread Richard
Leonel, Adding this to the layout.html and index.html I get the following error: missing "pass" in view Versionweb2py™Version 2.9.11-stable+timestamp.2014.09.15.23.35.11PythonPython 2.7.8: c:\python27\python.exe (prefix: c:\python27)Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. Traceback (most

[web2py][recipe] Unique constraint over 2+ fields for form validation of SQL UNIQUE (f1, f2,...);

2015-01-15 Thread Richard
could help some and if I need that again in the future I may found this email quickly... :) Richard -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- Yo

[web2py] version 2.9.5 and is 2.9.11 = 2.9.10

2015-01-23 Thread Richard
. But it seems that the web2py tagged version is 2.9.11... So, are 2.9.11 and 2.9.10 the same version and change log on web2py.com is just not up to date?? Thanks Richard -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code

[web2py] how may I get programmatically postgres field type from web2py model definition?

2015-02-05 Thread Richard
Hello, I am in the process of refactoring model definition and merging multiple table into one table with multiple columns (denormalisation) and I would like to extract programmatically the time of each of the multiple tables fields... Thanks Richard -- Resources: - http://web2py.com

[web2py] Deep linking with components

2015-02-19 Thread Richard
n updated components with the disired data. It works great though, we can't share the the selected data page by cut/paste the url since it stays the same... Is there a way to workaround that except embed an link of the updated component (which I already do sometimes)? Thanks Richard

[web2py] web2py menu and CTRL+Click redirect both actual and new tab

2015-02-25 Thread Richard
submenu entry new tab still get create and pointing over the proper location, but the actual page also get redirecting... Any idea? I will open a issue on github if you think that actually a regression issue? Thanks Richard -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] Could we start web2py form python shell

2015-02-26 Thread Richard
is related to Antonio question here : https://groups.google.com/d/msg/web2py/-sprzyOTi1w/V2z2V_4Upl4J Richard -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues

Re: [web2py] pycharm python console

2015-02-26 Thread Richard
We may have more input here too : https://groups.google.com/d/msg/web2py/69ji7YH6Ufw/xRaFTBO9W0IJ :) Richard Le jeudi 26 février 2015 10:57:49 UTC-5, Richard a écrit : > > Though I don't think environnement is defined... > > On Thu, Feb 26, 2015 at 10:56 AM, Richard Vézina &

[web2py] dbio=False proper way to update every fields not only the one that had changed

2015-03-04 Thread Richard
)).update(f1=None, f2=None, **{f: v for f, v in form.vars.iteritems() if f not in ('f1', 'f2')}) Maybe I should do a db.commit() before my second "blank" update() though it seems to me that it should be a better way and I am concern in reducing db hit. Thanks

[web2py] cost of importing into models vs define functions

2015-03-27 Thread Richard
gain would lead to the same performance penalty?? Thanks Richard -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are

[web2py] LOAD component inside component

2015-04-13 Thread Richard
this inserted value (something like SELECT_OR_ADD() would do). The problem is that my form embeded in the modal which the widget append to the page with LOAD() don't load... It hang on "loading..." Any idea? Is it even possible to trigger a LOAD inside a LOAD? Thanks Richard

[web2py] Re: Ractive example

2015-04-15 Thread Richard
... Thanks Richard Le samedi 28 mars 2015 12:17:35 UTC-4, Massimo Di Pierro a écrit : > > yes it is orthogonal. In fact it uses very little of web2py, almost > exclusively the DAL and marginally the web2py template language. > > On Thursday, 26 March 2015 02:48:05 UTC-5, Tim R

[web2py] Re: Ractive example

2015-04-15 Thread Richard
If I understand to style and create a semantic ui form style I would have to create new layout and form template? forms.bs3.html -> forms.semntaic-ui.html ? Richard Le mercredi 15 avril 2015 15:30:40 UTC-4, Richard a écrit : > > Hello Massimo, > > I am looking at w3 right now

[web2py] limitby question

2017-03-06 Thread Richard
offset = int(offset) min = offset - 10 max = offset else: offset = None min = 0 max = 10 rows = db((db.table.id > 0) ).select(db.table.id, db.table.represent_field, orderby=~db.table.id, limitby=(min, max)) Richa

[web2py] lazy_tables + 'reference tablename' = referenced table not lazy

2017-03-13 Thread Richard
e not lazy... There is no insight about that in the book, or I didn't find any... Is referenced tables can be lazy? I use web2py 2.14.6 build... There is old issue in pyDAL repo about reference and lazyness but they are closed. Thanks Richard -- Resources: - http://web2py.com - http://

[web2py] db().select() and db.executesql() quetstion

2017-03-30 Thread Richard
I am loop 2-3 differents times over the same query var does that trigger backend query each time? Thanks Richard -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report

[web2py] In the past DAL was accepting comma and replace by point before insert decimal result

2017-08-04 Thread Richard
e that the fact that inputing a comma instead of a point shouldn't be triggering such error as this input comma should be escape (at least) and not failed without return a validator error message to the end user... Richard -- Resources: - http://web2py.com - http://web2py.com/book (Documentation)

Re: [web2py] pycharm and web2py - setup project

2017-08-11 Thread Richard
not their major source of revenue... But they have a really good reputation and their product are wonderful. Richard Le jeudi 10 août 2017 16:32:51 UTC-4, Kirill Shatalaev a écrit : > > I created an issue, but I m afraid web2py is not their main stream... > > четверг, 10 августа 2017

[web2py] Problem with -L or --config= of command line

2018-01-24 Thread Richard
er it works, but I don't want to web2py environnement all the time just for some cron job... I thought I could pass the logging.conf at launch of the web2py instance... Thanks Richard -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2

[web2py] anyone had developed something related to electronic signature in web2py app

2015-04-27 Thread Richard
Hello, I would like to know if anyone had developed any kind of electronic signature involving some record signature or encryption inside a web2py app? Thanks Richard -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code

[web2py] how to passing query or db set through url securily

2015-04-28 Thread Richard
something more flexible than that... But I am concern about security if I passing query as an URL vars... Is this a bad/good idea? Thanks Richard -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2

[web2py] familiar '==' operator from db_set.query.first.op

2015-04-28 Thread Richard
Hello, Si there a way to get back to familiar "==" or "!=" form db_set.query.first.op?? Thanks Richard -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues

[web2py] parenthesis in SQLFORM.grid search

2015-04-29 Thread Richard
Hello, It seems that SQLFORM.grid search tool not accept parenthesis? Ex.: Not possible (table.input_comment = "" or table.input_comment != None) and ... Richard -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (S

[web2py] how to run tests over pydal locally?

2015-04-29 Thread Richard
Hello, To run web2py tests we do : python web2py.py --run_system_tests How to run tests over pydal?? Thanks Richard -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

[web2py] downloading old web2py version from github

2015-05-06 Thread Richard
Hello, I was wanting to get an old version of web2py for some tests purposes and discover that even the old version of web2py downloaded from github lead to the issue related to new modulized dal (aka pydal)... Is this normal, I mean that the old version get affected ? How some one supposed to

[web2py] issue with select with yearfield.year == YEAR

2015-05-15 Thread Richard
have the issue with postgres and psycopg and web2py 2.9.5 I don't have time to check in recent version... So posted here before open a ticket to pydal if issue is still there... Richard -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/w

[web2py][OT] time for kickstarter

2015-06-09 Thread Richard
Have you seen this : https://www.kickstarter.com/projects/nickjj/build-a-saas-app-with-flask-and-deploy-it-with-doc?ref=category web2py has almost everything out of the box... :) Richard -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py

[web2py] Refresh page with "user/login?_next=" in URL ask for email even if user is logged in

2015-08-19 Thread Richard
some redirection to the next URL component on page reload and how this could cause overhead of doing so... But it could make this repetitive task a memory if it could be implement easilly... Richard -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.

Re: [web2py] Refresh page with "user/login?_next=" in URL ask for credentials even if user is logged in

2015-08-19 Thread Richard
d_in():* *redirect(self.get_vars_next())* table_user = self.table_user() settings = self.settings Le mercredi 19 août 2015 14:01:40 UTC-4, Richard a écrit : > > Nop it only cas_login related... > > On Wed, Aug 19, 2015 at 2:00 PM, Richard Vézina < > ml.richard.ve

Re: [web2py] Refresh page with "user/login?_next=" in URL ask for credentials even if user is logged in

2015-08-19 Thread Richard
else: redirect('default', 'index') So, maybe this could be rewrite like so : if self.get_vars_next() is not None and self.get_vars_next() != '' and self.is_logged_in(): redirect(self.get_vars_next()) Richard Le mercredi 19 août 2015

Re: [web2py] Refresh page with "user/login?_next=" in URL ask for credentials even if user is logged in

2015-08-20 Thread Richard
connected... The part where request, response, and session get defined is correct to be above, but I would put the rest below the bloc " ### use session for federated login" What do you think? Richard Le mercredi 19 août 2015 17:48:16 UTC-4, Anthony a écrit : > > M

[web2py] .last() don't return last table id and first() also not returning the first record id

2015-09-09 Thread Richard
ormal? Richard -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users&

[web2py][OT] Workflow

2015-09-14 Thread Richard
Hello, We have been discussed long time ago about workflow engine inside web2py... I just fall on Lugigi : https://github.com/spotify/luigi (from spotify as it seems) and there is Pyrus (pyrus.com) but not free... Richard -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] issue with conditional columns in select with web2py dal query

2015-10-21 Thread Richard
olumns = [(db[table].date - db.other_table.date.date()).avg().with_alias('avg_date')] # This one works db(...).select(*columns) Is there a way to make aggregate lazy somehow? Thanks a lot Richard -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com

[web2py][share] usefull snippet for enhance list of tags to be displayed in a table cell (or TD)

2015-10-22 Thread Richard
#x27;item1_represent', _href=URL('controller', 'function', args='agrs', vars= dict(record_id=1)), CAT(', '), A('item2_represent', _href=URL('controller', 'function', args='agrs', vars=dict(record_id=2)), ...]

[web2py] Manage session.VARS best practices

2015-11-03 Thread Richard
el(session.var1) Which I would need to executed at every request (can't be put in model file for that purpose)... But I am curious what is consider the best practices regarding session variables ? Thanks Richard -- Resources: - http://web2py.com - http://web2py.com/book (Documentation)

Re: [web2py] Re: how to generate barcode label ?

2010-06-01 Thread Richard Shebora
This works fine for me offline... http://zbar.sourceforge.net/ Thanks, Richard Shebora On Tue, Jun 1, 2010 at 1:18 PM, ceriox wrote: > i generate barcode with this workaround > > 1) i install the barcode font > 2) i generate the code and with the view i show the code with ba

Re: [web2py] Re: sequence name issue postgresql

2010-07-01 Thread Richard Vézina
I will look at it... Do we need to be on launchpad for accessing the bazaar trunk (can't find the download able package) since the mercurial seems to be out dated?? Maybe I have to import it with bazaar? Richard 2010/7/1 mdipierro > Hi Richard, > > I am not convinced this is a

Re: [web2py] Re: sequence name issue postgresql

2010-07-07 Thread Richard Vézina
I don't understand how I can download the trunk build of web2py... Maybe I am not getting it, do I have to copy only the files (sql.py and dal.py) with the mods you had made??? Richard 2010/7/1 mdipierro > Actually the mercurial one should be in sync with bazaar one. > I have

Re: [web2py] Re: sequence name issue postgresql

2010-07-07 Thread Richard Vézina
% self._sequence_name) File "/nigthly_build/web2py/gluon/sql.py", line 960, in self._execute = lambda *a, **b: self._cursor.execute(*a, **b) ProgrammingError: ERREUR: la relation « test_test_id_seq » n'existe pas LINE 1: select currval('test_test_id_Seq') Here is the

Re: [web2py] Re: sequence name issue postgresql

2010-07-07 Thread Richard Vézina
('test_test', Field('test_id','id'), Field('field1'), Field('field2'),migrate=False) Sequence name are generated automatically by Postgresql : test_test_test_id_seq test_test_test_id_seq table name : test_test table id name : test_id I crea

Re: [web2py] Re: sequence name issue postgresql

2010-07-08 Thread Richard Vézina
Hello, Did I sent enough information? Richard 2010/7/7 Richard Vézina > There is a different version number for the windows build : web2py Version > 1.79.2 (2010-07-05 23:18:02) > > I download the src build since I am under linux. Maybe the problem is still > ther

Re: [web2py] Re: sequence name issue postgresql

2010-07-08 Thread Richard Vézina
Right on! It works! Can you point me where the mods you made are so I can copy theme on the stable version 1.79.2 for deployment? Thanks a lot Massimo. Richard 2010/7/8 mdipierro > Did you try? > > db.define_table('test_test', >Field('test_id','

Re: [web2py] Re: sequence name issue postgresql [CLOSED]

2010-07-08 Thread Richard Vézina
THKs Richard 2010/7/8 mdipierro > just get the nightly build from the download page. I will post 1.94.1 > next week. > > On 8 Lug, 10:53, Richard Vézina wrote: > > Right on! > > > > It works! > > > > Can you point me where the mods you made are so

Re: [web2py] iptables

2010-02-16 Thread Richard Shebora
You might look at http://www.shorewall.net/ for the iptables portion, and it comes with great example config files. I think you need something else to block requests or connections per minute like http://www.fail2ban.org, it has worked well for me. Hope this helps, Richard Shebora On Tue, Feb

Re: [web2py] web2py.com is down !!?!

2010-03-09 Thread Richard Shebora
no problem seeing it here. Thanks, Richard Shebora On Tue, Mar 9, 2010 at 9:57 AM, Thadeus Burgess wrote: > Has been working for me. > > -Thadeus > > > > > > On Tue, Mar 9, 2010 at 3:47 AM, Jason Brower wrote: >> Works for me (: >> On Tue, 2010-03-09

[web2py] currval psycopg2.OperationalError

2010-08-19 Thread Richard Vézina
e in my model that way sequence_name='table1_table1_id_seq' for the field : Field('table1_id','id'), I try to clean my app without succes, try to restart, etc. Thanks for any suggestion! Richard PS.: There is a problem on importation of exported csv file from the a

[web2py] Re: currval psycopg2.OperationalError

2010-08-19 Thread Richard Vézina
Ok, the problem is not coming from the postgresql manipulation as I thought it was... I did the manipulation on an other table and got no problem. The problem seems to be presente since some time, but I didn't detected it.. Richard 2010/8/19 Richard Vézina > Hello, > > I am stuc

[web2py] Re: currval psycopg2.OperationalError

2010-08-19 Thread Richard Vézina
exported csv is : table1.table1_id that correct, but the importation fail if I am not changing the *table1.table1_id * header for *table1.id* 2010/8/19 Richard Vézina > Ok, the problem is not coming from the postgresql manipulation as I thought > it > was... > > I did the man

Re: [web2py] Re: currval psycopg2.OperationalError

2010-08-19 Thread Richard Vézina
Web2py admin interface exported csv file... Try to import the exact exported csv file it fails. Richard 2010/8/19 mdipierro > Does table1 have a column called "table1_id"? Seems strange. Who > created the csv file? > > On Aug 19, 2:06 pm, Richard Vézina > wrote: &g

Re: [web2py] My editor ...

2010-08-19 Thread Richard Vézina
Nice! 2010/8/19 Stef Mientki > hello, > > I made a movie about the most important features of the editor I'm using, > you can see it here: > > http://mientki.ruhosting.nl/movies/web2py_1.html > > If there's enough interest, I'll make the application available under BSD > license. > At this mome

Re: [web2py] Re: currval psycopg2.OperationalError

2010-08-19 Thread Richard Vézina
NOT NULL, field1 character varying, CONSTRAINT table1_id PRIMARY KEY (table1_id) ) WITH ( OIDS=FALSE I just test it, the importation with table1.table1_id in SQLite works... I mean I don't exactly know what is in sqlite... But it not workin with postgresql except if you change tabl

[web2py] strange problem

2010-08-20 Thread Richard Vézina
For example UPDATE mytab SET othertab_id='|529|' I hope I am clear. Thanks Richard

Re: [web2py] Re: currval psycopg2.OperationalError

2010-08-20 Thread Richard Vézina
I will have a look at it and coming back to close the thread. Thanks Richard 2010/8/19 mdipierro > It is a bug. Now fixed in trunk. Please give it a try. > > On Aug 19, 4:38 pm, Richard Vézina > wrote: > > Here the w2p model : > > > > db.define_table('tab

Re: [web2py] Re: currval psycopg2.OperationalError CLOSED

2010-08-20 Thread Richard Vézina
I just test the trunk, the problem it gone! Thank a lot. Regard Richard 2010/8/20 Richard Vézina > I will have a look at it and coming back to close the thread. > > Thanks > > Richard > > 2010/8/19 mdipierro > > It is a bug. Now fixed in trunk. Please give it a tr

[web2py] Re: strange problem

2010-08-20 Thread Richard Vézina
p or the web2py update... I look further. Richard 2010/8/20 Richard Vézina > Hello Massimo, > > I face a new problem. I have a postgresql text field that serves to store > a > multiple referenced id. I don't use jquery plugin or anything else in my > form to make the sele

[web2py] Re: strange problem

2010-08-20 Thread Richard Vézina
Ok, I made a few more check and I am pretty sure it coming from web2py version... Do we lost this cause of list:integer, list:reference, etc.?? Richard 2010/8/20 Richard Vézina > Wrong report... I made some other test and I don't get anymore the > highlighted multiselection with

[web2py] Fwd: strange problem

2010-08-21 Thread Richard Vézina
Don't see my mail in the list!! -- Forwarded message -- From: Richard Vézina Date: 2010/8/20 Subject: strange problem To: web2py@googlegroups.com Hello Massimo, I face a new problem. I have a postgresql text field that serves to store a multiple referenced id. I don&

[web2py] Fwd: strange problem

2010-08-21 Thread Richard Vézina
-- Forwarded message -- From: Richard Vézina Date: 2010/8/20 Subject: Re: strange problem To: web2py@googlegroups.com Wrong report... I made some other test and I don't get anymore the highlighted multiselection with crud.update... I change of version recently (1.81.4 ->

[web2py] Fwd: strange problem

2010-08-21 Thread Richard Vézina
-- Forwarded message -- From: Richard Vézina Date: 2010/8/20 Subject: Re: strange problem To: web2py@googlegroups.com Ok, I made a few more check and I am pretty sure it coming from web2py version... Do we lost this cause of list:integer, list:reference, etc.?? Richard 2010/8

<    5   6   7   8   9   10   11   12   13   14   >