[web2py:22933] Re: new DAL

2009-05-29 Thread annet . vermeer
Massimo, Will it be possible to have a foreign key on a non id field, in case of a look-up table? In my model I have: db.define_table('rechtsvorm', SQLField('rechtsvorm',label='Rechtsvorm * ',length=42,default='',notnull=True,unique=True), migrate=False) db.define_table('bedrijf',

[web2py:22932] Re: Auto_complete widget.

2009-05-29 Thread annet . vermeer
Iceberg, Good guess. value=str(value) solved the problem. Thanks for your help. Annet. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@goo

[web2py:22931] Re: new DAL

2009-05-29 Thread annet . vermeer
Massimo, Will it be possible to have a foreign key on a non id field, in case of a look-up table? In my model I have: db.define_table('rechtsvorm', SQLField('rechtsvorm',label='Rechtsvorm * ',length=42,default='',notnull=True,unique=True), migrate=False) db.define_table('bedrijf',

[web2py:22930] Re: new DAL

2009-05-29 Thread mdipierro
Yes, it will be backward compatible unless you used internal and undocumented features of the DAL (like importing SQLSet or subclassing SQLRows). it will also expose a new alternative cleaner syntax (for example you will be asked to use Field instead of SQLField but SQLField works too as alias of

[web2py:22929] web2py2po/po2web2py

2009-05-29 Thread suiato
I'm translating an appliance eStore as an example in learning how to localize web2py appliances, and found web2py2po/po2web2py programs useful because I usually work on po format in traslation. Has anyone here worked on these? --~--~-~--~~~---~--~~ You received this

[web2py:22928] Re: new DAL

2009-05-29 Thread cesmiga
Massimo, Will the new DAL be backwards compatible with the existing DAL? The reason I ask is because I have been using "WWW SQL Designer" and hope to continue using it with the new DAL. Thank you, Christopher mdipierro wrote: > I am finishing a rewrite of the new DAL. It may be done in one we

[web2py:22927] Re: Authentication for services

2009-05-29 Thread Dan
Reviving this thread from before... I would like to have a shell script use wget to authenticate itself and access the data in a web2py application, but I haven't been able to get the web2py app to accept the post'ed email and password information, which I sent to the user/ login URL. Is this the

[web2py:22926] unable to read uploaded file

2009-05-29 Thread vwong2...@gmail.com
Hi guys, I tried using the above code but ran into some problems. I am able to upload the file but unable to access the contents of the file. The file is uploaded - I know because the line "print request.vars.import_csv" shows the file contents. However, "request.vars.import_csv.file.read()" appe

[web2py:22925] multiple=True usage

2009-05-29 Thread Fran
I'm trying out using simple multiple=True tagging-style for Many<>Many relationships (simpler than developing custom Forms & works on GAE). Currently my way to get the data out of such a field seems rather unwieldy - is there a better way? e.g. if hiding menu options when users don't have access.

[web2py:22924] Re: jQuery noCoflict

2009-05-29 Thread mdipierro
yes and no. this would break backward compatibility. we can rewrite the provided jquery so that they use jQuery instead of $ and leave the it to the user to call jQuery.noConflict() if needed. I would probably take a patch for the welcome app in this direction, assuming it does not break anything

[web2py:22923] jQuery noCoflict

2009-05-29 Thread Robert Marklund
Would it be possible to use jQuery in noConflict mode internally so that you can use other javascript engines as well ? See this for more info: http://docs.jquery.com/Using_jQuery_with_Other_Libraries /Robert -- __ Robert Marklund Phone: +46 (0)46 19

[web2py:22922] Re: Spatial???

2009-05-29 Thread JohnMc
Well I suggested this before. Facilitate the BETWEEN SQL operator in the DAL. Maybe something like drange(low value, high value). When you mention the DAL extensible, your thoughts on how? I have seen it attempted by either user defined functions of a blob-like type or as a real custom defined typ

[web2py:22921] Re: new DAL

2009-05-29 Thread HansD
likewise On May 29, 8:24 pm, DenesL wrote: > On May 29, 1:59 pm, mdipierro wrote: > > > I am finishing a rewrite of the new DAL. It may be done in one week or > > two but I could use some help. > > I can explain exactly what to do. I need people to write and run tests > > for the supported back

[web2py:22920] Re: mediawiki markup in web2py wiki?

2009-05-29 Thread mdipierro
I am looking fro somebody to be a mainter of the wiki app and even fork it as necessary. Do you want to do it? On May 29, 1:51 pm, Evgeny wrote: > sorry for multiple posting on this, but I do want to point out that > key in wiki success > is adoption by contributors. Beautiful markup is less im

[web2py:22919] Re: sending info to form using URL

2009-05-29 Thread mdipierro
I cannot reproduce the error but this may be a browser issue again and the way it handles the "email=...@s.com" in the URL below. @ should be encoded as it is not allowed in URL. http://127.0.0.1:8000/my_app/input_data/form2?admin=False&email=...@s.com&name=j&profile=something&sure=yes On May 29

[web2py:22918] Re: from google.appengine.api import users

2009-05-29 Thread Bill
Wow! Thanks so much. On May 29, 10:52 am, mdipierro wrote: > I have a patch to add this feature to Auth. I will be in within one > week. > > On May 29, 11:35 am, Bill wrote: > > > Hi.  Thanks for your previous help. > > > New Question(s): > > > 1.  How do I utilize "Google Users Service" with

[web2py:22917] Re: mediawiki markup in web2py wiki?

2009-05-29 Thread Evgeny
sorry for multiple posting on this, but I do want to point out that key in wiki success is adoption by contributors. Beautiful markup is less important (and probably won't be important in the future at all) MW is ahead in adoption of all other wiki engines by a manyfold margin. It's markup has ev

[web2py:22916] Re: new DAL

2009-05-29 Thread DenesL
On May 29, 1:59 pm, mdipierro wrote: > I am finishing a rewrite of the new DAL. It may be done in one week or > two but I could use some help. > I can explain exactly what to do. I need people to write and run tests > for the supported backends. > > It will be beackward compatible and have some n

[web2py:22915] Re: true or false?

2009-05-29 Thread Keith Edmunds
I think you could get some good exposure from LWN - it's one of the more professional Linux sites (imo, the /most/ professional). Keith aka BackSeat --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framew

[web2py:22914] Re: sending info to form using URL

2009-05-29 Thread Dan
Thanks Massimo- I'm starting to understand the http flow better now... but the code you sent returned the same error I was seeing in my code when I clicked on the submit button on the form. Here are the snippets from the traceback: ... if form.accepts(request.vars,session): ... File ".../we

[web2py:22913] new DAL

2009-05-29 Thread mdipierro
I am finishing a rewrite of the new DAL. It may be done in one week or two but I could use some help. I can explain exactly what to do. I need people to write and run tests for the supported backends. It will be beackward compatible and have some new features including dealing with tables that do

[web2py:22912] Re: Auto_complete widget.

2009-05-29 Thread Iceberg
On May30, 1:30am, annet.verm...@gmail.com wrote: > Iceberg, > > > Did not look carefully in your code but, if you are expecting some > > default value to be showed up in your widget, you need to define > > _value=blah for your widget. > > Could you please be a bit more specific about 'blah' > > I

[web2py:22911] Re: Architecture question: can I use Web2py template engine to generate emails?

2009-05-29 Thread mdipierro
becaue message= response.render('default/example.html',context=dict(one="1", two="2")) would have passed dict(context=dict(one="1", two="2"))) and {{=one}} would have had to be {{=context['one']}}. easier to change the argument passing the the view. On May 29, 12:26 pm, Carl wrote: > super

[web2py:22910] Re: Auto_complete widget.

2009-05-29 Thread annet . vermeer
Iceberg, > Did not look carefully in your code but, if you are expecting some > default value to be showed up in your widget, you need to define > _value=blah for your widget. Could you please be a bit more specific about 'blah' I tried: _value=record.plaats derived from: records=db(db.adres

[web2py:22909] Re: Architecture question: can I use Web2py template engine to generate emails?

2009-05-29 Thread Carl
super! Always satisfying when a solution requires less code (and nice to get it working on a Friday too) Would you mind explaining the reasoning behind the final solution and the previous suggestion? I'm learning both Python and Web2py and it'd help yell this in my head have a good weekend C O

[web2py:22908] Re: db.tablename.fieldname.comment

2009-05-29 Thread annet . vermeer
Iceberg, Thanks for the reference to the thread, very informative. Kind regards, Annet. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@goo

[web2py:22907] Re: SyntaxError: Object exists and cannot be redefined

2009-05-29 Thread mdipierro
I am sorry, I need you to email the complete app for two reasons: 1) the indentation is messed up 2) I still do not understand the logic. You tell me error is triggered by the call to action "customupdate" but the ticket says view "list_all.html". That is inconsistent. Massimo On May 29, 12:02 p

[web2py:22906] true or false?

2009-05-29 Thread mdipierro
http://lwn.net/Articles/335172/rss --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email

[web2py:22905] Re: SyntaxError: Object exists and cannot be redefined

2009-05-29 Thread Rui Gomes
This is the full view, ## View list_all.html # {{extend 'layout.html'}} {{=form}} {{if query:}} You are checking Store{{=request.vars.store_id}} in {{=request.vars.date}} Options Order Numer Store Number Reason Total Amount Total Credit Total

[web2py:22904] Re: sending info to form using URL

2009-05-29 Thread mdipierro
You want: ## receive info using URL params, and show the form ## receive info using form when URL params present ## show empty form when no URL params present ## receive info using form when no URL params present Do not do it this way because your point 2 is outsite the http specs

[web2py:22903] Re: from google.appengine.api import users

2009-05-29 Thread mdipierro
I have a patch to add this feature to Auth. I will be in within one week. On May 29, 11:35 am, Bill wrote: > Hi. Thanks for your previous help. > > New Question(s): > > 1. How do I utilize "Google Users Service" with "from > gluon.contrib.login_methods.email_auth import email_auth" to obtain >

[web2py:22902] Re: db.tablename.fieldname.comment

2009-05-29 Thread Iceberg
On May30, 0:24am, annet.verm...@gmail.com wrote: > > > SQLField(...) is basically same to db.Field(...). And you can "define > > validators (and others) beneath the table definition" rather than my > > "validators into the field definition". That is equivalent too. > > I based my SQLField definiti

[web2py:22901] Re: SyntaxError: Object exists and cannot be redefined

2009-05-29 Thread mdipierro
I cannot reproduce this problem. I have idea of what may cause it but I cannot find the incrimiating line. Can you post the content of the filed: h:\python\web2py_win\web2py_source\svn\applications\Dominos_Times/ views/default/list_all.html and its associated action On May 29, 10:30 am, NewBe

[web2py:22900] Re: Architecture question: can I use Web2py template engine to generate emails?

2009-05-29 Thread mdipierro
Please use message= response.render('default/example.html',context) or message= response.render('default/example.html',one="1", two="2") Massimo On May 28, 9:22 am, mdipierro wrote: > Please try this: > > def example(): > context= dict(one="1", two="2") > message= response.render('de

[web2py:22899] from google.appengine.api import users

2009-05-29 Thread Bill
Hi. Thanks for your previous help. New Question(s): 1. How do I utilize "Google Users Service" with "from gluon.contrib.login_methods.email_auth import email_auth" to obtain gmail user "nickname()"? 2. Is it possible to mix Google Authentication with local authentication which would auto-mag

[web2py:22898] Re: sending info to form using URL

2009-05-29 Thread Dan
> 2) you are using > > form.accepts(request.vars,session): > > Which is desigend to prevent double submissions and various types of > attacks by hiding hidden one time tokens in the form and preventing > validation if the form if the token is not returned. > You can disable this by using > > f

[web2py:22897] Re: db.tablename.fieldname.comment

2009-05-29 Thread annet . vermeer
Iceberg, > Well, sorry for confusing you. :-) That's all right. > SQLField(...) is basically same to db.Field(...). And you can "define > validators (and others) beneath the table definition" rather than my > "validators into the field definition". That is equivalent too. I based my SQLField

[web2py:22896] Re: db.tablename.fieldname.comment

2009-05-29 Thread Iceberg
Well, sorry for confusing you. :-) SQLField(...) is basically same to db.Field(...). And you can "define validators (and others) beneath the table definition" rather than my "validators into the field definition". That is equivalent too. My point is just telling you to try label='blah (*)'. :-)

[web2py:22895] Re: SyntaxError: Object exists and cannot be redefined

2009-05-29 Thread NewBeen
the output i get is Traceback (most recent call last): File "H:\python\web2py_win\web2py_source\svn\gluon\restricted.py", line 107, in restricted exec ccode in environment File "h:\python\web2py_win\web2py_source\svn\applications \Dominos_Times/views/default/list_all.html", line 62, in

[web2py:22894] Re: db.tablename.fieldname.comment

2009-05-29 Thread annet . vermeer
Iceberg, >How about just manually append an "(*)" at the end of your > label like this? > db.Field('rechtsvorm', label='Blah (*)', requires=IS_NOT_EMPTY()) One of my table definition reads like: db.define_table('rechtsvorm', SQLField ('rechtsvorm',length=42,default='',notnull=True,unique=T

[web2py:22893] Re: SyntaxError: Object exists and cannot be redefined

2009-05-29 Thread mdipierro
I agree, a change in a different controller cannot break the update controller. In file gluon/sql.py please replace line raise SyntaxError, 'Object exists and cannot be redefined' with raise SyntaxError, 'Object %s exists and cannot be redefined' % key and let me know what the error looks li

[web2py:22892] Re: SyntaxError: Object exists and cannot be redefined

2009-05-29 Thread NewBeen
Sorry im testing with version 1.62 and don´t work to, i don't get why this just stop to work. exactly the some code been working nice before!!! the only thing i change is this. @auth.requires_login() def customcreate(): try: if session.create: pass except: se

[web2py:22891] Re: SyntaxError: Object exists and cannot be redefined

2009-05-29 Thread mdipierro
Just so that I understand, this works fine with 1.63 stable but not 1.63 intrunk? Seems like an odd error, can you email me your code so that I can do some debugging? Massimo On May 29, 9:21 am, NewBeen wrote: > This is working fine but when i update to the last version in the svn > start give

[web2py:22890] Re: Suggestion to widget

2009-05-29 Thread Iceberg
Jquery itself is definitely great. However in some cases I just think those _onchange thing does not belong to View of MVC, it could be kind of necessary Control of MVC. Besides, I prefer to write all relevant things in the same place like this: db.Field('foo', label='My label', require

[web2py:22889] SyntaxError: Object exists and cannot be redefined

2009-05-29 Thread NewBeen
This is working fine but when i update to the last version in the svn start give this error Error traceback # Traceback (most recent call last): File "H:\python\web2py_win\web2py_source\svn\gluon\restricted.py", line 107, in restricted exec ccode in environment File

[web2py:22888] Re: import custom module from controller

2009-05-29 Thread mika
Ok, now it seems to work. But I don't exactly know where was the problem ;) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To

[web2py:22887] Re: Spatial???

2009-05-29 Thread AchipA
Well, it would be good to know in which direction you are moving... :) Spatial databases have spatial columns and spatial functions. So, how would we go about making the following postgis examples into a DAL- able form without slipping to _execute ? How do we insert a geometry ? How do we use vali

[web2py:22886] Re: complex sql query: combining left outer join and count

2009-05-29 Thread mdipierro
On May 29, 3:41 am, eddie wrote: > Hi all, > > I've been getting stuck in to web2py for a few weeks now, and really > enjoying it. I've hit a bit of a road block with this issue and though > I would post it here to get ideas on the cleanest solution. > > Basically I am trying to combine a left

[web2py:22885] complex sql query: combining left outer join and count

2009-05-29 Thread eddie
Hi all, I've been getting stuck in to web2py for a few weeks now, and really enjoying it. I've hit a bit of a road block with this issue and though I would post it here to get ideas on the cleanest solution. Basically I am trying to combine a left outer join with a count in a sql query. I can't

[web2py:22884] Re: db.tablename.fieldname.comment

2009-05-29 Thread Iceberg
On May29, 3:32pm, annet wrote: > I use the comment attribute to mark fields that are required: > > db.rechtsvorm.rechtsvorm.comment=SPAN('*',_class='required') > > The * displays to the right of the input field. However, when I have a > table that contains an SQLField of type text, all the * move

[web2py:22883] Re: Suggestion to widget

2009-05-29 Thread mdipierro
I have no major objction to changing the widget but it much easier to handle this via jquery. Massimo On May 29, 7:54 am, Iceberg wrote: > Thanks for the reply. But title and label are different things. Title > here refers to the pop-up yellow tooltip when your mouse hovers above > the input ar

[web2py:22882] Re: Spatial???

2009-05-29 Thread mdipierro
I am rewriting the DAL so any suggestion in this direction is welcome. I think we do not need a geoweb2py fork, I think we should be able to make the DAL extensible so that it can be subclassed. On May 29, 5:01 am, haftish21 wrote: > Right - you need to pay USD 10 for it:http://www.lulu.com/co

[web2py:22881] Re: Suggestion to widget

2009-05-29 Thread Iceberg
Thanks for the reply. But title and label are different things. Title here refers to the pop-up yellow tooltip when your mouse hovers above the input area. Sometimes the app needs them both like this: My label The proposal not only settles the need for _title, but also _onclick, _onchange, etc.

[web2py:22880] Re: how to send xml data to client

2009-05-29 Thread Iceberg
Just a sideshow. The latest "action.xml" trick can give almost same effect as your example. :-) def mycontroller(): return {'hello':'World'} then visit http://.../mycontroller.xml then you can get: World On May29, 1:48pm, durga moganty wrote: > first one. > def mycontroller(): >    xml="W

[web2py:22879] Re: Foreign key notnull constraint

2009-05-29 Thread vihang
Thanks again. I will be revising my models to include the default for the foreign key. On May 28, 6:26 pm, annet.verm...@gmail.com wrote: > Vihang, > > > I would prefer an error is raised if the value is not provided... > > Defining a validator IS_NOT_EMPTY() or IS_IN_DB(...) solves this > probl

[web2py:22878] Re: import custom module from controller

2009-05-29 Thread Iceberg
On May29, 5:38pm, mika wrote: > As in topic, I have a problem with importing. I saw similar posts, but > they don't help me to solve it. > I have a file called addons.py in modules/ directory. > In controller, i'm trying to import like this: > > import applications.sara.modules.addons as addons >

[web2py:22877] Re: Multiple Form Best Practise

2009-05-29 Thread dlypka
yw. Dave Lypka www.futurelogic.com On May 27, 8:58 pm, Yannick wrote: > Thanks a lot Dlypka... I tried so many things except that one... IT IS > WORKING... > > Thanks Massimo, please don't waste your precious time looking to my > code... > > Thanks to you guys for your hints... > > Yannick P.

[web2py:22876] Re: Spatial???

2009-05-29 Thread haftish21
Right - you need to pay USD 10 for it: http://www.lulu.com/content/4968879 >>'ll get as soon as possible, full version is what I need. It's not a fully-qualified domain, won't ever work outside your campus... >>Then let me get another help from u to broaden it, take it out of my campus. >>Ho

[web2py:22875] Re: One question about version 1.63

2009-05-29 Thread plato
Internal error Ticket issued: welcome/127.0.0.1.2009-05-29.17-56-17.aaf663d1- b19d-4e48-9f34-704c6a8bdd54 and then click it and write admin passwd i see this " Error ticket for "welcome" Ticket 127.0.0.1.2009-05-29.17-59-18.3cb8d10a-6de0-48f9- a4d9-727fed360d39 Error traceback 1. 2. 3. 4.

[web2py:22874] import custom module from controller

2009-05-29 Thread mika
As in topic, I have a problem with importing. I saw similar posts, but they don't help me to solve it. I have a file called addons.py in modules/ directory. In controller, i'm trying to import like this: import applications.sara.modules.addons as addons (sara is the name of my app) What I'm doin

[web2py:22873] Re: One question about version 1.63

2009-05-29 Thread NikG
Now it's working. I did $ python web2py.py --upgrade yes On May 29, 5:26 pm, Nik Go wrote: > I'm not sure if it's the same error but I got the same problem. > > I unpacked the 1.63 to an existing web2py (v1.62.3) directory. > > Once I get to the default index. Clicking on administrative inte

[web2py:22872] Re: One question about version 1.63

2009-05-29 Thread Nik Go
I'm not sure if it's the same error but I got the same problem. I unpacked the 1.63 to an existing web2py (v1.62.3) directory. Once I get to the default index. Clicking on administrative interface generates an error ticket but clicking on the ticket only causes it to generate another ticket. ad

[web2py:22871] Re: web2py and Debian

2009-05-29 Thread AchipA
Wow, lengthy discussion, let me sum up some of my thoughts: 1) I already have Ubuntu packages in a private PPA. I'll clean those up and make public if there is such interest. 2) Jason, if you know a DD, it'd be great to ask for mentorship. I have packaged python deb stuff before (I'm a Maemo con

[web2py:22870] db.tablename.fieldname.comment

2009-05-29 Thread annet
I use the comment attribute to mark fields that are required: db.rechtsvorm.rechtsvorm.comment=SPAN('*',_class='required') The * displays to the right of the input field. However, when I have a table that contains an SQLField of type text, all the * move too far away from the input field. I wond