[web2py:27081] Re: too many values to unpack

2009-07-21 Thread Hans Donner
Thanks. Pasted into a new db.py and ran appadmin. No issues here, can browse around. What DB are you using? Have you tried in a clean (db) environment? On Tue, Jul 21, 2009 at 21:14, hcvst wrote: > > http://pastebin.co.za/22355 > > On Jul 21, 8:37 pm, Hans Donner wrote: >> c

[web2py:27085] Re: OpenID for Web2Py

2009-07-21 Thread Hans Donner
I've used Massimo's code, installed it in a new app and executed it (using myopenid). I'd had to change #trust_root = 'http://127.0.0.1:8000/openid/client/startOpenID' trust_root = 'http://127.0.0.1:8000/openid/client' return_to = 'http://127.0.0.1:8000/openid/client/finishOpenID' to give me a p

[web2py:27086] Re: OpenID for Web2Py

2009-07-21 Thread Hans Donner
commenting out the return_to in finishOpenID did the trick (it will take the return to as defined in the constant. The URL only provides a path without the servername. So two minor changes made it work... On Tue, Jul 21, 2009 at 22:07, Hans Donner wrote: > I've used Massimo's code,

[web2py:27092] Re: OpenID for Web2Py

2009-07-21 Thread Hans Donner
next challenge - integrate it with auth On Tue, Jul 21, 2009 at 22:14, Hans Donner wrote: > commenting out the return_to in finishOpenID did the trick (it will > take the return to as defined in the constant. The URL only provides a > path without the servername. > > So tw

[web2py:27126] Re: missing cron folder results in ticket

2009-07-21 Thread Hans Donner
ld be some rights issue .. Will look further into this. On Wed, Jul 22, 2009 at 03:14, AchipA wrote: > > As Massimo said, it should be re-generated if it's missing. Are you > using an up to date version and does the web2py process have > sufficient privileges to make a cron dir ? &

[web2py:27152] Re: too many values to unpack

2009-07-22 Thread Hans Donner
web2py update (since you could have modified it); >> >> You might try to make a clean web2py installation, and move your app to it - >> see what results that yields. >> >> On Tue, Jul 21, 2009 at 2:21 PM, Hans Donner wrote: >> >> > Thanks. >> > Pasted

[web2py:27162] Re: too many values to unpack

2009-07-22 Thread Hans Donner
yes, I can. But would like to know what version this one is (and if unknown just receive a copy of it). I want to digg deeper into this issue. On Wed, Jul 22, 2009 at 17:34, DenesL wrote: > > You can download any version you want from SVN, can't you?. > > On Jul 22, 10:21 am, H

[web2py:27220] Re: temporary table

2009-07-22 Thread Hans Donner
That's why the question was asked: what do you need to do exactly? Perhaps a more elegant solution can be used. On Thu, Jul 23, 2009 at 03:10, Vidul Petrov wrote: > > The implementation of temporary tables is not MVC, but RDBMS specific. > > On Jul 23, 12:36 am, Fran wrote: >> On Jul 22, 9:41 pm

[web2py:27221] Re: temporary table

2009-07-22 Thread Hans Donner
That's why the question was asked: what do you need to do exactly? Perhaps a more elegant solution can be used. On Thu, Jul 23, 2009 at 03:10, Vidul Petrov wrote: > > The implementation of temporary tables is not MVC, but RDBMS specific. > > On Jul 23, 12:36 am, Fran wrote: >> On Jul 22, 9:41 pm

[web2py:27224] Re: Global setting for domain name?

2009-07-23 Thread Hans Donner
Be carefull with this. The same instance may serve on multiple domain names It's up to the developer to make these choices and decissions. On Thu, Jul 23, 2009 at 07:20, Bottiger wrote: > > Also a setting like this should be global to all applications while > stuffing it in a model will only

[web2py:27232] Re: problem access web2py site

2009-07-23 Thread Hans Donner
nope, here it also works fine On Thu, Jul 23, 2009 at 09:59, Yarko Tymciurak wrote: > > > On Thu, Jul 23, 2009 at 2:25 AM, gillengam wrote: >> >> Excuse me, I have some problems to access web2py site. For example I >> get "sec_error_expired_issuer_certificate" >> >> if I visit "https:// >> mdp.c

[web2py:27234] Re: Global setting for domain name?

2009-07-23 Thread Hans Donner
le copy of the web2py library > serves a single domain. It works for Django. > > Serving multiple domains on a single Web2Py installation is an > unreasonable configuration to support, and it should be split into 2 > different Web2Py installations imo. > > On Jul 23, 12:02 am, Ha

[web2py:27235] Re: problem access web2py site

2009-07-23 Thread Hans Donner
That is standard web2py behaviour. Accessing admin is secured, this can only be done via localhost or over a secure connection. In your case, what did you do to have a ticket generated? On Thu, Jul 23, 2009 at 10:09, gillengam wrote: > > Ok for https, but for FAQ I get this: > > Forbidden > You

[web2py:27258] Re: OpenID for Web2Py

2009-07-23 Thread Hans Donner
gt;> > is supposed to be a simple URL. >> >> > return_to = URL(r=request,f='finishOpenID') >> >> > 3. >> >> > change this at line 130. sreg_response was None for me. I believe sreg >> > is an optional argument that some Open

[web2py:27299] Re: import SQL Schemma Database into model.py

2009-07-23 Thread Hans Donner
I think this would be a perfect tool for a web2py toolkit (seperate from the main web2py). On Fri, Jul 24, 2009 at 05:38, Alexandre Andrade wrote: > Leandro, > > I announced some time ago start in a script/aplication in web2py to do that > with postgresql. But since them I have so many projects,

[web2py:27307] Re: Minimal Application

2009-07-24 Thread Hans Donner
So, what documentation are you missing? Please be specific. On Fri, Jul 24, 2009 at 11:00, BG wrote: > > Thanks for your comments. I forgot that web2py is backwards > compatible, so I can just use one of my old apps as a template. > > Anyway, as you said web2py is under a fast evolution...that's

[web2py:27309] Re: import SQL Schemma Database into model.py

2009-07-24 Thread Hans Donner
24, 2:03 am, Boriel wrote: >> The script I sent several days ago is about that, but at the moment it only >> accepts mysql databases. >> I'll be working on it the next week. >> >> Regards, >> Boriel >> >> >> >> On Fri, Jul 24, 2009 at

[web2py:27313] Re: Minimal Application

2009-07-24 Thread Hans Donner
good points On Fri, Jul 24, 2009 at 12:36, BG wrote: > > OK, I will try to be specific from a newbie perspective. > > How does the Javascript menu work? > > I assume that you build a structure with HTML and then set the class > or id to something that JQuery will turn into a menu. I can easily >

[web2py:34779] Better support for legacy databases

2009-11-07 Thread Hans Murx
t; / non integer primary keys. Regards Hans --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this gr

[web2py:34781] DAL: inserting rows that can't be selected

2009-11-07 Thread Hans Murx
ot;gluon/sql.py", line 1468, in __getitem__ File "gluon/sql.py", line 2883, in select File "gluon/sql.py", line 2927, in parse ValueError: invalid literal for int() with base 10: 'a' >>> Shows, that we can insert rows that can't be selected.

[web2py:34785] Re: Join web2py wave

2009-11-07 Thread Hans Murx
1 would be nice! On 7 Nov., 08:44, Nicolás de la Torre wrote: > i have sent invites to: > > vinc...@vincentdavis.com > thade...@thadeusb.com > szims...@gmail.com > boris.manojlo...@gmail.com > richard_gor...@verizon.net > chris.st...@gmail.com > m.grit...@gmail.com > lapcc...@gmail.com > obutov.

[web2py:34789] Re: Better support for legacy databases

2009-11-07 Thread Hans Murx
Running tests with informix (IDS 9.40) would be no problem for me. Please let me know, how I can start helping (some years of informixdb user experience available). Hans On 7 Nov., 13:25, DenesL wrote: > My fault. Working on it, I will post something soon. > > Unfortunately legacy

[web2py:35547] DAL/sql.py: patch for informix limitby

2009-11-18 Thread Hans Murx
# Requires Informix 9.0+ > sql_s += ' FIRST %d ' % (fetch_amt, ) Massimo, can you apply this patch? Regards, Hans --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "we

[web2py:35613] DAL: inconsistent behavior with constraint violation errors

2009-11-19 Thread Hans Murx
ll - although the same constraint violation occurs!? Why is there no IntegrityError exception raised in this case? Same strange behavior with appadmin: you can 'insert' new rows with appadmin that violate constraints and therefore are not really inserted into the table without even get

[web2py:35622] Re: DAL: inconsistent behavior with constraint violation errors

2009-11-19 Thread Hans Murx
151_174) violated. 100: ISAM error: duplicate value for a record with unique key. Regards, Hans ~ On 19 Nov., 14:50, mdipierro wrote: > I agree this is strange but this seems a database problem to me. > > On Nov 19, 6:49 am, Hans Murx wrote: > >

[web2py:35736] IS_NOT_IN_DB validator raises exception with legacy tables and does not work with informix://

2009-11-21 Thread Hans Murx
may not have a field named 'id'. Will raise an exception then. - line 403: limitby is not correctly implemented for informix in current web2py. Therefore a select with limitby does not return any rows for informix (Massimo, do you remember my suggested patch for that iss

[web2py:35742] DAL: decoding/encoding problem when talking to legacy DBs that are not utf-8 encoded

2009-11-21 Thread Hans Murx
rows were updated although 1 row should have been updated. I think the cause of this problem is that the values in our database are not utf-8 but iso-8859-1encoded and web2py explicitly encodes values to uft-8 in funtion 'sql_represent' (gluon/sql.py) when creating sql-statemens

[web2py:35758] Re: IS_NOT_IN_DB validator raises exception with legacy tables and does not work with informix://

2009-11-21 Thread Hans Murx
elif str(rows[0].id) != str(self.record_id): > return (value, self.error_message) Ok? Regards, Hans ~ On 21 Nov., 16:33, mdipierro wrote: > Hi Hans, I have your patch and I will be applying it tomorrow. > > Unfortunately the added experimental support for leg

[web2py:35761] Re: DAL: decoding/encoding problem when talking to legacy DBs that are not utf-8 encoded

2009-11-21 Thread Hans Murx
d correctly in web-pages with charset=UTF-8) and then in function gluon/sql.py:sql_represent() we can easily say (provided that sql_represent gets an optional extra argument 'db_codec' too): if isinstance(obj, unicode): obj = obj.encode(db_codec) elif isinstance(obj, str): obj = obj.decode('u

[web2py:22165] running examples on gae

2009-05-19 Thread Hans Donner
Trying to make the web2py examples run out of the box on google apps engine (sdk). It now runs almost all examples, only the purchase part of the database not yet, anyone a suggestion for this? The fixing might be a bit quick&dirty, but I was after the results. Index: applications/examples/cont

[web2py:22971] Re: patch sql / sqlhtml

2009-05-31 Thread Hans Donner
Ok, not yet encountered that but I can imagine it. Needs a bit of work than and I keep it for my own projects than for now. On Sun, May 31, 2009 at 5:50 PM, mdipierro wrote: > > this would break the dal because table headers can be aggregates and > are not necessarily table fields. That is why i

[web2py] How do I get last n rows from table?

2013-01-07 Thread Hans Cr
I want my controller to return the last ('updated') n rows given de definition below given a certain 'gid' and 'sid'. Can anyone help me? Thanks a lot in advance! Hans db.define_table('value', Field('gid', 'string'), Field(&

[web2py] Re: How do I get last n rows from table?

2013-01-07 Thread Hans Cr
Thanks! Works great! On Monday, January 7, 2013 12:33:19 PM UTC+1, Niphlod wrote: > > tb = db.value > db((tb.gid == 'something') & (tb.sid == 'othersomething')).select(orderby > =~tb.updated, limitby=(0, 10)) > > will give you the last 10 > > On Mo

[web2py] How do I get last row for each type from table?

2013-01-07 Thread Hans Cr
I want my controller to return the last ('updated') row for each 'sid', given a specified 'gid'. 'sid' is multiple times in the table, but I want to have the last row. Can anyone help me? Thanks a lot in advance! Hans db.define_table('value

Re: [web2py] How do I get last row for each type from table?

2013-01-07 Thread Hans Cr
Thanks, indeed this was the way. This works great: tb = db.value values = db((tb.gid == 'something')).select(groupby=tb.value, orderby=~tb.updated) On Monday, January 7, 2013 1:28:39 PM UTC+1, viniciusban wrote: > > Try using groupby clause. > > On Mon, Jan 7,

[web2py] Handling a POST

2012-02-08 Thread Hans Crijns
ks in advance, Hans

[web2py] extra_fields to be shown in the view

2016-06-22 Thread Hans Soflao
Hi, this maybe a simple question, but I couldn't find any answer for it: Is it possible to show the extra fields created in the view? What I mean is that when I use auth.settings.extra_fields, this creates new fields for auth_user in the database but it does not show it in the view. If I want to

[web2py] Re: extra_fields to be shown in the view

2016-06-22 Thread Hans Soflao
gt; Anthony > > On Wednesday, June 22, 2016 at 7:58:45 PM UTC-4, Hans Soflao wrote: >> >> Hi, this maybe a simple question, but I couldn't find any answer for it: >> Is it possible to show the extra fields created in the view? >> What I mean is that when I use auth.s

[web2py] Re: Write in database from modules

2015-12-07 Thread Hans Soflao
Thank you, I used the method Anthony mentioned and it worked. Now a follow up question, in order to have access to database in this module to assign var1 (defined in the database) to var2 (defined in the module) what is the best method? For instance to have access to the latest row of data in th

Re: [web2py] Re: Write in database from modules

2015-12-07 Thread Hans Soflao
Thanks Anthony and Richard. Yes, my variable was inside the module and was not a global one. Thanks for the link, I am running the variable inside the function and it is local. I tested the code and it worked. On Monday, December 7, 2015 at 12:44:40 PM UTC-5, Richard wrote: > > @Hans, w

[web2py] trouble with embeding youtube

2016-01-14 Thread Hans Soflao
I am trying to embed a youtube video into the view; I do not know why it does not work at all; I thought it is as simple as just the following code: http://www.youtube.com/blabla";> What is my error? It looks like the view gets the fram but does not show the video

[web2py] Help with web2py on webfaction

2014-11-08 Thread Hans Soflao
Can somebody help me with getting web2py app to work with webfaction? This is a very simple question I imagine. The way my folders are structured are like this: home/user/webapps/appname. Inside appname folder, there are these folders: apache2, htdocs and web2py. These get created when an app

<    1   2   3