[web2py:32857] Google Login not on GAE?

2009-10-14 Thread Thadeus Burgess
Can google_login authentication be used outisde of the google app engine? -Thadeus --~--~-~--~~~---~--~~ 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

[web2py:32858] Re: Eclipse, json and reaching breaking point

2009-10-14 Thread Carl
I've replied to this message as the original (while in my browser history) is not listed by Google Groups. On Oct 13, 10:47 pm, Carl wrote: > hi, > > I'm using XP, Eclipse, Web2py/json/pyjs and running dev_appserver > > When I place breakpoints on code in functions in controllers/ > default.py a

[web2py:32859] Eclipse, json and reaching breaking point (posting again)

2009-10-14 Thread Carl
hi, I'm using XP, Eclipse, Web2py/json/pyjs and running dev_appserver When I place breakpoints on code in functions in controllers/ default.py and in methods in modules/subscriptions.py only the latter are tripped. Any idea what might be going on? When I run web2py.py both sets of breakpoints

[web2py:32860] Re: hg and google

2009-10-14 Thread Kacper Krupa
I would also prefer bitbucket (or even github) instead of Google Code. But the own trac (with hg/git/svn whatever) is the best idea i think. On 14 Paź, 06:09, Thadeus Burgess wrote: > What about hgwebdir or roll our own app > usinghttp://mercurial.selenic.com/wiki/MercurialApiwith our own custo

[web2py:32861] Re: Eclipse, json and reaching breaking point

2009-10-14 Thread Carl
replying to this post myself to kick Google Groups to list it! On Oct 13, 10:47 pm, Carl wrote: > hi, > > I'm using XP, Eclipse, Web2py/json/pyjs and running dev_appserver > > When I place breakpoints on code in functions in controllers/ > default.py and in methods in modules/subscriptions.py on

[web2py:32862] Re: "Add" button next to "combo box"

2009-10-14 Thread Markus Schmitz
Hi Renato, after this long and painfull journey could you post in a single comprehensive way, what you need to do to get the Add-Button working? I am sure, several of us need something quite similar. Maybe Massimo could even turn this into an howto on the FAQ? Regards Markus --~--~-~--~

[web2py:32863] Re: "Add" button next to "combo box"

2009-10-14 Thread Renato-ES-Brazil
Hi Markus! I'm still working in some details for this functionality in my 'available times': - I need to reload the "select" object to show the new option registered. - I would like to improve the structure of the code and files where possible in order to be easy to implement. Currently has a m

[web2py:32864] Extjs2web2py

2009-10-14 Thread luz
Hi, just for a matter of fun and to get some practice, I would like to write a small plugin for Web2py that should make Extjs development easier. My main goals are: - keep it simple - keep it generic so that the same structure may be reused in the future for other JS framework (Extjs is not free

[web2py:32865] How web2py manage threads?

2009-10-14 Thread draco
i've notice if i block one method in a controller, all of request for current session is blocked. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@goog

[web2py:32866] Re: suggection to sqlform

2009-10-14 Thread mdipierro
This may be seen as breaking backward compatibility for people using CSS/jQuery but it would just affect estethic not functionality. I would be in favor but I'd like to hear if anybody opposes. Massimo On Oct 13, 10:18 pm, hywang wrote: > when sqlform is rendered as a table, the label of a fiel

[web2py:32867] Re: web2py responding to Ajax.Request from Prototype

2009-10-14 Thread mdipierro
OK, got the link by email. I will take a look. On Oct 13, 10:49 pm, pharkle wrote: > Ok, forget the response code 0, this is just a Prototype default when > the response status is undefined... > > >>  getStatus: function() { > >     try { >       return this.transport.status || 0; >     } catch

[web2py:32868] Re: Field functions

2009-10-14 Thread mdipierro
Why not implement it as the others? db.test.number.average() On Oct 13, 11:59 pm, "mr.freeze" wrote: > What about a generic sql function for Field? Here is a proof of > concept: > - > def sql(self, name, data_type, *args): >     out = '' >     if args: >         out = ",

[web2py:32869] Re: Google Login not on GAE?

2009-10-14 Thread mdipierro
gae_google_account.py NO email_auth.py can be used to authentication with Gail outside GAE. the example is in the code. Massimo On Oct 14, 2:07 am, Thadeus Burgess wrote: > Can google_login authentication be used outisde of the google app engine? > > -Thadeus --~--~-~--~~---

[web2py:32870] Re: How web2py manage threads?

2009-10-14 Thread mdipierro
The problem is not threading. The issue is that 1) when using SQLite the database is locked when one thread access it and other threads cannot access it and must wait. This problem goes away if you use postgresql or other client/server database 2) when a user access a controller action, the sessio

[web2py:32871] Re: Field functions

2009-10-14 Thread mr.freeze
Sorry, bad example. I mean implement the common functions (avg and round) then add a generic function like this so that developers would have the option of using unsupported functions for their particular database: test = db(db.test.id > 0).select(db.test.number.sql ("FORMAT","date","-MM-DD"

[web2py:32872] Re: Interesting Javascript Project

2009-10-14 Thread Michael - afewtips.com
Secure is probably the wrong word - I mean handing over your work and allowing someone to steal it. I was thinking the entire point was to ONLY use Skulpt, not as you would javascript. That makes more sense. On Oct 12, 11:28 am, Thadeus Burgess wrote: > Personally, I have tried using pyjama

[web2py:32873] Re: Eclipse, json and reaching breaking point

2009-10-14 Thread Jonathan Lundell
On Oct 14, 2009, at 1:05 AM, Carl wrote: > > replying to this post myself to kick Google Groups to list it! FWIW, your first message showed up yesterday afternoon as web2py: 32811. No replies, though. > > On Oct 13, 10:47 pm, Carl wrote: >> hi, >> >> I'm using XP, Eclipse, Web2py/json/pyjs an

[web2py:32874] What about something like django debug_toolbar to web2py ?

2009-10-14 Thread Douglas Soares de Andrade
Hi all, During some django development, i came across this program: http://robhudson.github.com/django-debug-toolbar/ It is an app to django to make debug easier. Is it possible/needed to have something like this to web2py ? --~--~-~--~~~---~--~~ You received

[web2py:32875] Cron table deletion on GAE

2009-10-14 Thread Chris S
Setting up Cron jobs on GAE is simple enough. But I'm not understanding something with creating a cron that can delete table entries. I was attempting to make the cron remove all items in a selection with: db.delete(sqldb.item2) return 'Delete complete' The problem is it fetches the 1000 limit

[web2py:32876] Re: Cron table deletion on GAE

2009-10-14 Thread mdipierro
Not sure. Try this: myset=db(db.item2.id>0) while myset.delete(): pass Massimo On Oct 14, 9:29 am, Chris S wrote: > Setting up Cron jobs on GAE is simple enough.  But I'm not > understanding something with creating a cron that can delete table > entries. > > I was attempting to make the cron r

[web2py:32877] Re: web2py responding to Ajax.Request from Prototype

2009-10-14 Thread mdipierro
I suspect it is one of the following issues: 1) something to do with UTF8: http://forum.springsource.org/archive/index.php/t-39200.html 2) Prototype does not understand HTTP/1.1 chunked-encoding. I tried this: $ curl http://67.192.186.216:8000/spinup_v1_1/api/group_unassigned/2009/10/20/12/0

[web2py:32878] Re: Cron table deletion on GAE

2009-10-14 Thread Chris S
That was 'better' but same problem. With the change you've given it still errors out but 199 deletions were performed (previously nothing was deleted). It's not good but at least it's deleting something until there is a better solution. On Oct 14, 9:39 am, mdipierro wrote: > Not sure. Try th

[web2py:32879] Re: Cron table deletion on GAE

2009-10-14 Thread Chris S
Oh if it helps the exact error message: : Traceback (most recent call last): File "/base/data/home/apps/my-app/1.337029206592219112/ gaehandler.py", line 69, in main() File "/base/data/home/apps/my-app/1.337029206592219112/ gaehandler.py", line 65, in main wsgiref.handlers.CGIHandler

[web2py:32880] It is alive!!! (the new book is on sale)

2009-10-14 Thread Massimo Di Pierro
http://he-cda.wiley.com/WileyCDA/Section/id-321954.html --~--~-~--~~~---~--~~ 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 grou

[web2py:32881] web2py saves space to mssql during registration process

2009-10-14 Thread bm
There's a problem while registering a user when web2py is using mssql. Here are the pertinent pieces to reproduce the problem: - web2py version = 1.67.2 - web2py connected to mssql via pyodbc and freetds - registration_requires_verification = True - registration_requires_approval = False - email

[web2py:32882] Re: Cron table deletion on GAE

2009-10-14 Thread mdipierro
There is never going to e better solution they limit how many records you can access per request. You have to hit the page many times until all records are deleted, or do it from outside the web app but I do not know how. Massimo On Oct 14, 9:53 am, Chris S wrote: > That was 'better' but same p

[web2py:32883] Re: Cron table deletion on GAE

2009-10-14 Thread Chris S
I'm fine with having to Cron the job. I would just like to manually limit the number deleted in a single cron. That way I won't get an error message on every cron for the next two days while I'm deleting 30,000 enteries 200 at a time. Just doesn't sit right with me executing a command and letti

[web2py:32884] db rollback on GAE

2009-10-14 Thread Carl
hi, is web2py's db rollback() implemented on GAE? and is anyone using it on their projects? my project is getting to the multi-write stage and this is a check to see what's around the corner :) cheers --~--~-~--~~~---~--~~ You received this message because you ar

[web2py:32885] Re: web2py saves space to mssql during registration process

2009-10-14 Thread bm
One minor correction to the data below, web2py is not saving a space from mssql but, is instead, saving the empty string to mssql and *reading* the empty string as a space from mssql and then the if test evaluates to true. On Oct 14, 10:59 am, bm wrote: > There's a problem while registering a us

[web2py:32886] Re: It is alive!!! (the new book is on sale)

2009-10-14 Thread Carl
super! it's not quite alive in Europe just yet... but when it's available you'll have at least one sale! On Oct 14, 3:57 pm, Massimo Di Pierro wrote: > http://he-cda.wiley.com/WileyCDA/Section/id-321954.html --~--~-~--~~~---~--~~ You received this message becau

[web2py:32888] GG search FAIL

2009-10-14 Thread Jonathan Lundell
On Oct 14, 2009, at 1:02 AM, Carl wrote: > I've replied to this message as the original (while in my browser > history) is not listed by Google Groups. I did a little checking on this, with the following results. 1. I received Carl's original message (yesterday) via email. 2. I found the messa

[web2py:32889] Re: web2py saves space to mssql during registration process

2009-10-14 Thread Dmitri Zagidulin
This same issue happens to me, too -- when reading in a field in the database that contains an empty string, the Linux/pyodbc/MSSQL stack reads it as a single space. I suspect it's a similar issue to that which is mentioned in http://pymssql.sourceforge.net/limitations.php (Search for SELECT ''"

[web2py:32887] Re: Unit testing Auth functions

2009-10-14 Thread Dmitri Zagidulin
The key you're missing there is instantiating the environment. Instead of self.controller.user('register'), you need to do something like: self.controller = env('myapp', True, c='default', f='myfunction') and then you can do assertions on the various objects bound to the controller (request, res

[web2py:32890] Re: hg and google

2009-10-14 Thread Thadeus Burgess
I will be taking a look at hgwebdir source tonight to see how mercurial could integrate further into web2py. This is for personal interest as well since I would like to include latest commits on my new homepage along with facebook status and whatnot. If it is a choice between 3rd party, I think we

[web2py:32891] Re: "Add" button next to "combo box"

2009-10-14 Thread Thadeus Burgess
Write a web2pyslice when you get it hashed out! -Thadeus On Wed, Oct 14, 2009 at 6:24 AM, Renato-ES-Brazil wrote: > xample, I wanted to put the link "add" next to the "Product" > combobox So, I informed the widget on this field, and furthermore I > had to declare two methods in the Product c

[web2py:32892] Re: suggection to sqlform

2009-10-14 Thread Thadeus Burgess
Backwards compatibility or correct, logical design the choices the choices No opposition. Perhaps we should consider a legacy.py? -Thadeus On Wed, Oct 14, 2009 at 7:39 AM, mdipierro wrote: > > This may be seen as breaking backward compatibility for people using > CSS/jQuery but it woul

[web2py:32893] Re: Google Login not on GAE?

2009-10-14 Thread Thadeus Burgess
>From what I understand, email_auth will return True if it can login to the SMTP server, in which a list of valid servers could be passed, to keep them from spoofing their own SMTP server. That is genius! Thanks Massimo. -Thadeus On Wed, Oct 14, 2009 at 7:43 AM, mdipierro wrote: > Gail --

[web2py:32894] Re: suggection to sqlform

2009-10-14 Thread Iceberg
No objection. IMHO, even my app might be affected due to css/jquery issue, but it is acceptable, because the modification is easy, and more importantly the new TH makes my app easier to use css/jquery to customize the table header. On Oct14, 8:39pm, mdipierro wrote: > This may be seen as breaki

[web2py:32895] Re: Field functions

2009-10-14 Thread Thadeus Burgess
Something that would work like .count() and .first() and .last() select_avg = db(db.star_ratings.post_date>"2009-10-01").select(db.star_ratings.score).avg(star_ratings.score) In rows, there will be a reference to the aggregator function. self.avg, self.sum, self.max... etc. These will be set, b

[web2py:32896] Re: suggection to sqlform

2009-10-14 Thread DenesL
hywang, can you expand on the convenience this change brings?. --~--~-~--~~~---~--~~ 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 t

[web2py:32897] Re: What about something like django debug_toolbar to web2py ?

2009-10-14 Thread Thadeus Burgess
That is awesome, I would love something like this for web2py. Adding variable dump to web2py tickets is something I have on my todo list. -Thadeus On Wed, Oct 14, 2009 at 5:50 AM, Douglas Soares de Andrade < dsandr...@gmail.com> wrote: > > Hi all, > > During some django development, i came a

[web2py:32898] Re: It is alive!!! (the new book is on sale)

2009-10-14 Thread Thadeus Burgess
This replaces the one on lulu and amazon? -Thadeus On Wed, Oct 14, 2009 at 10:23 AM, Carl wrote: > > super! > > it's not quite alive in Europe just yet... but when it's available > you'll have at least one sale! > > > > On Oct 14, 3:57 pm, Massimo Di Pierro wrote: > > http://he-cda.wiley.co

[web2py:32899] Re: It is alive!!! (the new book is on sale)

2009-10-14 Thread mdipierro
This is the paper version of the one on lulu. The one on Amazon is the old one and it should be replaced by this one soon. On Oct 14, 11:15 am, Thadeus Burgess wrote: > This replaces the one on lulu and amazon? > > -Thadeus > > On Wed, Oct 14, 2009 at 10:23 AM, Carl wrote: > > > super! > > > it

[web2py:32900] Re: It is alive!!! (the new book is on sale)

2009-10-14 Thread Zoom.Quiet
Up ! so great news... but that Chinese translation, set many tome for: http://www.zeuux.org/campaign/zeuux-summit-2009.cn.html after 091017 will rush for translation the web2py_manual_zh ;-) On Thu, Oct 15, 2009 at 00:15, Thadeus Burgess wrote: > This replaces the one on lulu and amazon? > > -Th

[web2py:32901] Re: Eclipse, json and reaching breaking point

2009-10-14 Thread Joe Barnhart
I have to admit, I don't find breakpoints all that useful when debugging web2py code. I like the interactive shell you can get by installing ipython and using the --shell=APNAME switch on web2py.py. Sometimes I use print statements to send stuff to the console, too. On Wed, Oct 14, 2009 at 6:45

[web2py:32902] Re: Eclipse, json and reaching breaking point

2009-10-14 Thread Carl
I'd be interested to hear why you don't find breakpoints useful.. I've been out of the coding scene for a number of years and am keen to hear about newer approaches to debugging. can you step thru code using ipython? 2009/10/14 Joe Barnhart : > I have to admit, I don't find breakpoints all tha

[web2py:32903] Re: db rollback on GAE

2009-10-14 Thread mdipierro
GAE has very limited transaction support and they basically allow single record transaction only. Web2py does not support transactions in GAE On Oct 14, 10:12 am, Carl wrote: > hi, > > is web2py's db rollback() implemented on GAE? > and is anyone using it on their projects? > > my project is get

[web2py:32904] Re: web2py saves space to mssql during registration process

2009-10-14 Thread mdipierro
Please send me the patch. I doubt I would be able to look into this until tomorrow night. When I will, if I cannot come up with a better solution, I will take the patch. The provided analysis of the problem will help a lot in fixing it. On Oct 14, 10:32 am, Dmitri Zagidulin wrote: > This same is

[web2py:/] Re: Snippets

2009-10-14 Thread Alex Fanjul
That is the point!! many of us have no time to make a complete slice... although is easy to search and do some slices in future using this simple keyword at the end of title. Alex F El 14/10/2009 5:33, Thadeus Burgess escribió: > I think posting to web2pyslices is a good idea, however, adding >

[web2py:/] Re: What about something like django debug_toolbar to web2py ?

2009-10-14 Thread mdipierro
This is not so much a technical issue. The issues are: 1) what if variables are large like contain an uploaded image? 2) what if variables contain protected information that should not be visible to the administrator, like credit card info or ssn? On Oct 14, 11:13 am, Thadeus Burgess wrote: > Th

[web2py:32907] Re: Snippets

2009-10-14 Thread mr.freeze
It takes less than a minute. They don't have to be fancy. For example: http://www.web2pyslices.com/main/slices/take_slice/6 On Oct 14, 1:25 pm, Alex Fanjul wrote: > That is the point!! many of us have no time to make a complete slice... > although is easy to search and do some slices in future u

[web2py:32908] Re: Eclipse, json and reaching breaking point

2009-10-14 Thread Thadeus Burgess
When I have them, I find breakpoints invaluable in determining logic bugs. This is the one thing that I miss languages such as Java/C#/C++, is not having a real debugger. Python debugging is a joke comparatively. I'm still learning web2py source, but the breakpoints probably are not being trigge

[web2py:32909] Re: [web2py:/] Re: What about something like django debug_toolbar to web2py ?

2009-10-14 Thread Thadeus Burgess
1) a str() or repr() of the object, which could be just a string that contains the relative or direct path to the file. 2) This goes back to the difference between tickets issued during development, and tickets issued on the live site. I agree, that information should not be available to any admin

[web2py:32910] Re: Eclipse, json and reaching breaking point

2009-10-14 Thread mr.freeze
I don't have any problems setting breakpoints, inspecting variables, stepping through code, etc with Eclipse/PyDev. Breakpoints are hit properly during requests including ajax callbacks. I use Visual Studio 2008 everyday at work and I would *not* call Eclipse/PyDev a joke comparatively. On Oct 1

[web2py:32911] Re: Eclipse, json and reaching breaking point

2009-10-14 Thread Dmitri Zagidulin
I likewise find the Eclipse python debugger to be invaluable. Quick question -- are you starting the dev_appserver from within Eclipse? On Tue, Oct 13, 2009 at 5:47 PM, Carl wrote: > > hi, > > I'm using XP, Eclipse, Web2py/json/pyjs and running dev_appserver > > When I place breakpoints on code

[web2py:32912] Re: Eclipse, json and reaching breaking point

2009-10-14 Thread Thadeus Burgess
I use Visual Studio 2008 every day as well. Eclipse/PyDev works, sorta, after configuration, maybe. It is not one of those things that you just load the software up, and it works. That is one thing I love about Visual Studio, and you miss out with open source. Just working, no configuration neede

[web2py:32913] Re: Eclipse, json and reaching breaking point

2009-10-14 Thread Carl
Yes I am. On Wednesday, October 14, 2009, Dmitri Zagidulin wrote: > > I likewise find the Eclipse python debugger to be invaluable. > Quick question -- are you starting the dev_appserver from within Eclipse? > > On Tue, Oct 13, 2009 at 5:47 PM, Carl wrote: >> >> hi, >> >> I'm using XP, Eclipse,

[web2py:32914] Re: Eclipse, json and reaching breaking point

2009-10-14 Thread weheh
I've used winpdb as well as print statements to debug web2py and python code. Winpdb lets you single step, which is very useful in certain debugging circumstances. Even though I'm relatively new to winpdb, it's still a keeper in my toolbox. (I only tried it 'cause it's free.) I know Yarko claims t

[web2py:32915] Recursive One2Many relation

2009-10-14 Thread Giedrius
How i can make recursive one to many relation? I want to have generalized categories like: Programing langauge / High level / Python, Programing langauge / Low level / C, Programing langauge / High level / PHP, Programing langauge / Low level / ASM and so on.. I tried to like this, but got an erro

[web2py:32916] Re: Recursive One2Many relation

2009-10-14 Thread Yarko Tymciurak
On Wed, Oct 14, 2009 at 4:44 PM, Giedrius wrote: > > How i can make recursive one to many relation? I want to have > generalized categories like: Programing langauge / High level / > Python, Programing langauge / Low level / C, Programing langauge / > High level / PHP, Programing langauge / Low l

[web2py:32917] Re: Error with Database (MySQL) when using latest release....

2009-10-14 Thread richard.ree
The sql that fails is: CREATE TABLE expedition( id INT AUTO_INCREMENT NOT NULL, name VARCHAR(512) UNIQUE, from_date DATE, to_date DATE, description LONGTEXT, PRIMARY KEY(id) ) ENGINE=InnoDB CHARACTER SET utf8; The table definition is: db.define_ta

[web2py:32918] Re: Error with Database (MySQL) when using latest release....

2009-10-14 Thread mdipierro
Do you have the error if unique=False? Massimo On Oct 14, 5:25 pm, "richard.ree" wrote: > The sql that fails is: > > CREATE TABLE expedition( >         id INT AUTO_INCREMENT NOT NULL, >         name VARCHAR(512) UNIQUE, >         from_date DATE, >         to_date DATE, >         description L

[web2py:32919] Re: Field functions

2009-10-14 Thread Richard
yeah I agree. Currently when I want functions like average I have to write it in Python anyway, so it would be good to use the database when possible. Richard On Oct 14, 2:34 pm, Thadeus Burgess wrote: > Could we write python wrappers around the functions that are not supported > for that parti

[web2py:32920] Re: FYI: Ext JS Designer Preview

2009-10-14 Thread Richard
does jquery ui have an IDE for drag and drop? That's what I'm after. On Oct 14, 1:15 pm, Thadeus Burgess wrote: > I would say query ui would be the closest thing as of right now. > > -Thadeus > > On Tue, Oct 13, 2009 at 6:29 PM, Richard wrote: > > > very promising. Looks like it has been inspi

[web2py:32921] Re: A simple patch to provide upload progress

2009-10-14 Thread Richard
hello, I noticed copystream_progress() in trunk. Is there an example how to use it? Richard On Oct 11, 6:43 am, mdipierro wrote: > @AndCycle > > I rearranged the code in trunk a bit. Could you check it still works? > Thanks again. > > Massimo > > On Oct 8, 5:14 am, AndCycle wrote: > > > thank

[web2py:32922] How can I set a view to a controller manually?

2009-10-14 Thread Renato-ES-Brazil
Can I manually choose which view (template file) I will use to render a controller? I don't want to create the specific file to the controller. I want to map to a generic view that I created. --~--~-~--~~~---~--~~ You received this message because you are subscribe

[web2py:32923] Re: .with_alias(..) not working (even in the dog.father, dog.mother example form slides)

2009-10-14 Thread mdipierro
I think you want father=db.dog.with_alias("father") mother=db.dog.with_alias("mother") rows = db().select(db.dog.name, father.name, mother.name, left=(father.on(father.id==db.dog.father_id), mother.on(mother.id==db.dog.mother_id))) On Oct 1

[web2py:32924] Re: A simple patch to provide upload progress

2009-10-14 Thread mdipierro
I remember the author of the patch posted an example but I cannot find it. I hope he will step in and point us to it. Massimo On Oct 14, 7:43 pm, Richard wrote: > hello, > > I noticed copystream_progress() in trunk. Is there an example how to > use it? > Richard > > On Oct 11, 6:43 am, mdipierr

[web2py:32925] Re: How can I set a view to a controller manually?

2009-10-14 Thread mdipierro
response.view='default/theview.html' On Oct 14, 7:47 pm, Renato-ES-Brazil wrote: > Can I manually choose which view (template file) I will use to render > a controller? > > I don't want to create the specific file to the controller. I want to > map to a generic view that I created. --~--~--

[web2py:32926] Re: Error with Database (MySQL) when using latest release....

2009-10-14 Thread mdipierro
I think the problem is the same described here: http://code.djangoproject.com/ticket/9431 You either set the length of the field to <=256 or you remove the unique constraint and use IS_NOT_IN_DB instead. On Oct 14, 5:25 pm, "richard.ree" wrote: > The sql that fails is: > > CREATE TABLE expedit

[web2py:32927] Re: Error with Database (MySQL) when using latest release....

2009-10-14 Thread richard.ree
No error if unique=False. The problem seems to be with the VARCHAR (512) UNIQUE. -Rick On Oct 14, 6:29 pm, mdipierro wrote: > Do you have the error if unique=False? > > Massimo > > On Oct 14, 5:25 pm, "richard.ree" wrote: > > > The sql that fails is: > > > CREATE TABLE expedition( > >        

[web2py:32928] Re: Error with Database (MySQL) when using latest release....

2009-10-14 Thread mdipierro
I would say this is one of the the many many mysql limitations, not a web2py issue. Massimo On Oct 14, 8:17 pm, "richard.ree" wrote: > No error if unique=False.  The problem seems to be with the VARCHAR > (512) UNIQUE. > > -Rick > > On Oct 14, 6:29 pm, mdipierro wrote: > > > Do you have the er

[web2py:32929] Re: Eclipse, json and reaching breaking point

2009-10-14 Thread mr.freeze
>>Eclipse/PyDev works, sorta, after configuration, maybe. If you have trouble setting it up, post it and we will help. >>It is not one of those things that you just load the software up, and it works. Again, let us know what specifically you're having trouble with and I'm sure someone can help.

[web2py:32930] tempory table and store procedure

2009-10-14 Thread wf321
in web2py is there anything like tempory table and store procedure ? people not suggest to use tempory table for DAL but what is the good solution to handle complex query? For example, there are tables A,B,C,D,E ... 1) result1 = join A,B,C 2) update some rows in result1 3) then base on r

[web2py:32931] Re: A simple patch to provide upload progress

2009-10-14 Thread Richard
is this it? http://pastebin.com/f69e7b008 On Oct 15, 11:55 am, mdipierro wrote: > I remember the author of the patch posted an example but I cannot find > it. I hope he will step in and point us to it. > > Massimo > > On Oct 14, 7:43 pm, Richard wrote: > > > hello, > > > I noticed copystream_p

[web2py:32932] Re: Recursive One2Many relation

2009-10-14 Thread Vasile Ermicioi
Hi, But what about a more efficient tree implementation (at least for retrieving ) like nested sets or materialized paths. PhpDoctrine has an implementation http://www.doctrine-project.org/documentation/manual/1_1/en/hierarchical-data#nested-set

[web2py:32933] web2py + matplotlib, is there a how-to posted

2009-10-14 Thread Vincent
I have been reading a bit about matplotlib plots into a web page. Mostly lots of googling and reading treads. My question is, Is there a nice how-to posted somewhere for using web2py + matplotlib. Same question for "PlotKitWrapper" Is there documentation? Thanks for your help Vincent --~--~-

[web2py:32934] Re: Recursive One2Many relation

2009-10-14 Thread Yarko Tymciurak
I'm not sure I understand your question: it seems from the link you provided, that this article (for example) gives you all you need to do this: http://articles.sitepoint.com/article/hierarchical-data-database/2 Actually, several of the links seem to be of similar usefulness... The php examples

[web2py:32935] Re: Recursive One2Many relation

2009-10-14 Thread Vasile Ermicioi
"php examples use classes (but we don't have an ORM, so data doesn't map that way"Thank you, now I understand... sqlalchemy has ability to map class <--> table, so I thought web2py could have this feature too, and I was wondering why web2py doesnt have a built in tree like table class On Thu, Oct

[web2py:32937] Re: A simple patch to provide upload progress

2009-10-14 Thread mdipierro
yes. Thank you! We should post a web2pyslice about this. On Oct 14, 11:50 pm, Richard wrote: > is this it?http://pastebin.com/f69e7b008 > > On Oct 15, 11:55 am, mdipierro wrote: > > > I remember the author of the patch posted an example but I cannot find > > it. I hope he will step in and point

[web2py:32936] Re: tempory table and store procedure

2009-10-14 Thread mdipierro
There is no mechanism for temporary tables. The options are 1) user db.executesql to define the temporary table then make it visible to web2py DAL using db.define_table ('yourtemptable',,migrate=False) 2) use a Rows object instead of a temporary table. If you show us an example of the raw SQL

[web2py:32938] Re: web2py + matplotlib, is there a how-to posted

2009-10-14 Thread mdipierro
I am giving a tutorial at supercomputing 2009 about this topic. You can find my slides and the code here: http://web2py.com/examples/static/supercomputing2009.zip Massimo On Oct 14, 10:42 pm, Vincent wrote: > I have been reading a bit about matplotlib plots into a web page. > Mostly lots

[web2py:32939] Re: Recursive One2Many relation

2009-10-14 Thread mdipierro
The best way to do it is discussed here with code examples in web2pyL http://www.mail-archive.com/web2py@googlegroups.com/msg06396.html On Oct 15, 12:44 am, Vasile Ermicioi wrote: > "php examples use classes (but we don't have an ORM, so data doesn't map > that way"Thank you, now I understand

[web2py:32940] Re: Recursive One2Many relation

2009-10-14 Thread Yarko Tymciurak
ah, yes - that is very clean... On Thu, Oct 15, 2009 at 1:17 AM, mdipierro wrote: > > The best way to do it is discussed here with code examples in web2pyL > > http://www.mail-archive.com/web2py@googlegroups.com/msg06396.html > > > > On Oct 15, 12:44 am, Vasile Ermicioi wrote: > > "php examples

[web2py:32941] Re: web2py wiki

2009-10-14 Thread CJSteel
Alvaro (and Massimo), Awesome work. It is great to know that we have such a great app and that it run on GAE. I was going to suggest meta data, but after thinking it over a bit I am really like the flexibility, power and simplicity of a straight up tagging system but that got me thinking... One

[web2py:32942] Returning rows as xml results in badly formed xml

2009-10-14 Thread Adi
Hi, I have an HTTPService which returns a result of a query as xml, which I need to display in Flex 3 frontend. Here's the simplified code snippet: @service.xml def records(): rows = db().select(db.videodata.id, db.videodata.title, db.videodata.thumbnail, \

[web2py:32943] SQLFORM.factory conditional Field in form

2009-10-14 Thread ed
Hi, In the example on conditional fields given in Web2py manual the convention is, every INPUT field have a name equal to "tablename_fieldname" and it contained in a called "tablename_fieldname_row". However, SQLFORM.factory doesn't have a table, it is all fields. Can someone tell me, what name is