[web2py:38335] Re: SQLFORM.factory or a better way for custom forms

2010-01-04 Thread K.R.Arun
You can see from my first post that my form gets custom rendered on another view. This LOAD thing will render my form as default, right? How can I get all those custom modification in the view? Arun On Jan 4, 1:36 pm, mdipierro wrote: > LOAD itself cannot go in the href/onclick of a button becau

[web2py:38334] Re: Which DB suit best with Web2py

2010-01-04 Thread K.R.Arun
On Jan 5, 1:26 am, Thadeus Burgess wrote: > You say that MSSQL and Oracle do not support pagination? In what ways does > the database support pagination? How would you take advantage of this for > say PostgreSQL on the database level instead of the query level? > > -Thadeus > I too loves to here

[web2py:38333] Wysiwig editor problems

2010-01-04 Thread mikech
Version 1.74.4 (2009-12-23 10:12:11) in IE8 insists on putting displaying < > signs with the < ≷ - sort of confusing, though it shows ok later. -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegro

[web2py:38332] Relaionships on GAE

2010-01-04 Thread yamandu
Google people recommend to use list properties to do many to many relationships. Since now, all GAE types are supported, I ask: Is or will be this supported in web2py? Or one must code it manually? Someone has a tip to design relationships in web2py on gae? I´ve been coding in web2py on GAE but so

[web2py:38331] Re: Delete Cascade

2010-01-04 Thread mdipierro
There is one problem though. The delete cascade cannot be done in a trasaction so there is the possibility that if many entities are deleted and takes time and the request timeout, you end up with partial deletion. We'll have to try it. On Jan 4, 9:53 pm, mdipierro wrote: > It will probably be tr

[web2py:38330] Re: Delete Cascade

2010-01-04 Thread mdipierro
It will probably be transparent. No special code. I will try implement this tomorrow. On Jan 4, 9:35 pm, yamandu wrote: > First, thanks so much again for quick answer Massimo! > > But I am not sure if I understood. Will be a there way to do so? > Will it be normally transparent or have to write s

Re: [web2py:38329] Re: DAL Question

2010-01-04 Thread Christopher Helck
How do I know which version of sqlite web2py is using? I have both sqlite 2.8.17 and 3.6.21 installed on my system. Do I need to set LIBPATH specifically? Thanks for the help, Christopher Helck On Mon, Jan 4, 2010 at 10:14 PM, mdipierro wrote: > I just tried it on mine: > >>> db=DAL('sqlite://

[web2py:38328] Re: UliPad as IDE for web2py

2010-01-04 Thread Jake
oo... OO That's slick! Thanks for the tip! Jake On Jan 4, 11:23 am, Oleg wrote: > Have you tried "It's All Text" Firefox > extension?https://addons.mozilla.org/en-US/firefox/addon/4125 > > On Jan 3, 5:03 pm, werner wrote: > > > > > I think the idea behind this is quit nice as the web based

[web2py:38327] Re: Delete Cascade

2010-01-04 Thread yamandu
First, thanks so much again for quick answer Massimo! But I am not sure if I understood. Will be a there way to do so? Will it be normally transparent or have to write special code to GAE? On Jan 4, 4:04 pm, mdipierro wrote: > I found a way to implement this db.delete(top.bottom_set) > I will ad

[web2py:38326] Re: DAL Question

2010-01-04 Thread mdipierro
I just tried it on mine: >>> db=DAL('sqlite://test.db') >>> db.define_table('foo', Field('name', unique=True)) >>> db.foo.truncate() >>> db.foo.insert(name='joe') 1 >>> db.foo.insert(name='sally') 2 >>> db.foo.insert(name='joe') Traceback (most recent call last): File "", line 1, in File "/Us

[web2py:38325] How to load my db.py into the online sql designer?

2010-01-04 Thread skip
I found the online sql designer to be quite helpful getting things started. I was able to dump the web2py code, edit it very lightly (do a little reordering and change from SQL to DAL names). Unfortunately, it appears my attempts to save my design failed and the only version of the database I have

Re: [web2py:38324] Re: DAL, transactions

2010-01-04 Thread Thadeus Burgess
Wow thank you for the description, that helps me clear up alot of confusion I was having :) -Thadeus On Mon, Jan 4, 2010 at 8:12 PM, mdipierro wrote: > This is a very point. I will add it to the manual. > > Massimo > > On Jan 4, 6:53 pm, Michael Toomim wrote: >> I just figured out why trans

[web2py:38323] DAL Question

2010-01-04 Thread Christopher Helck
My DB skills are not strong, so please forgive if this is a dumb question. Why does the following from my db.py not do what I want it to do? # db.define_table('foo', Field('name', unique=True)) db.foo.truncate() db.foo.insert(name='joe') db.foo.insert(name='sally') db.foo.insert(n

[web2py:38322] Re: DAL, transactions

2010-01-04 Thread mdipierro
This is a very point. I will add it to the manual. Massimo On Jan 4, 6:53 pm, Michael Toomim wrote: > I just figured out why transactions were confusing me and would like > to share. > > The default for postgresql makes every statement its own transaction > unless you issue "BEGIN TRANSACTION",

[web2py:38321] Re: DAL, transactions

2010-01-04 Thread Michael Toomim
I just figured out why transactions were confusing me and would like to share. The default for postgresql makes every statement its own transaction unless you issue "BEGIN TRANSACTION", in which case nothing commits until you issue "COMMIT". This is called "autocommit" mode in postgresql, because

[web2py:38320] Re: On Login failure

2010-01-04 Thread mdipierro
The first _next in request.get_vars is captured and it goes into a hidden form field therefore it is ok that it does not show in url. Anyway, I will test it more. On Jan 4, 4:14 pm, kbochert wrote: > Tried the mercurial download - It runs but for some reason does not > accept correct logins. > >

[web2py:38319] Re: UliPad as IDE for web2py

2010-01-04 Thread Christopher Steel
Ulipad used to require wxPython 2.6+ as well... C. On Jan 3, 4:23 pm, Vasile Ermicioi wrote: > Not on topic: Just took a look at uliweb project website and here are my >  impressions: > - is not easier to use than web2py (install, editing, project start-up) > - use sqlalchemy as his orm that me

[web2py:38318] dal.py

2010-01-04 Thread Thadeus Burgess
There are two statements for VERBATIM in the BaseAdapter of dal.py def VERBATIM(self,first): return first def VERBATIM(self,first): return str(first) -Thadeus -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this gro

[web2py:38317] Re: membership manager plugin

2010-01-04 Thread KMax
I get understand following things: I am too week with js GroupMembershipManager may be usual function from any controller with corresponding view. To use ajax features, I need make all get links as post (due to lack of js knowledge) OR Use http://code.google.com/p/jquery-hijack/ with Jquery UI

[web2py:38316] Re: On Login failure

2010-01-04 Thread kbochert
Tried the mercurial download - It runs but for some reason does not accept correct logins. I just copied my application into the new web2py's application folder, and copied my routes.py as well. Surfing to the protected page, I get the logon screen with a url that includes the "?_next=..." var.

[web2py:38315] Re: DAL, transactions

2010-01-04 Thread mdipierro
On Jan 4, 1:54 pm, Thadeus Burgess wrote: > Can you disable auto_commit so that you have to explicitly declare > db.commit() ? You can already expliticely db.commit() > Also, say I have the following > > db.table.insert(myfields=...) > > and then later in the same request, would a > > db.tabl

Re: [web2py:38314] Re: Which DB suit best with Web2py

2010-01-04 Thread Thadeus Burgess
You say that MSSQL and Oracle do not support pagination? In what ways does the database support pagination? How would you take advantage of this for say PostgreSQL on the database level instead of the query level? -Thadeus On Tue, Sep 29, 2009 at 4:06 PM, mdipierro wrote: > > In my view they

Re: [web2py:38313] Re: On database backups

2010-01-04 Thread Thadeus Burgess
For the moment, I am running two cron jobs. One will execute web2py and generate a CSV file of the database, tar it up. The other cron will run an hour later, and will use PGDUMP and tar the sql statements up. It then uses SSH to ship the data to our backup file server. For the moment this seems t

Re: [web2py:38312] Re: SQLFORM, no-table, with fieldsets.

2010-01-04 Thread Thadeus Burgess
I do not think this is about decoupling the presentation logic from the... tree structure.. I am saying that validation and presentation should be decoupled. A Form should be able to validate without needed to know what it tree looks like. All the form validation should care about is what the data

Re: [web2py:38311] Re: DAL, transactions

2010-01-04 Thread Thadeus Burgess
Can you disable auto_commit so that you have to explicitly declare db.commit() ? Also, say I have the following db.table.insert(myfields=...) and then later in the same request, would a db.table.select() pull in the newly inserted record, or does the record need to be committed first? If I ins

[web2py:38310] Re: Fail login doesn't return an errorm msg

2010-01-04 Thread Yannick
I just test back this issue using the latest version of web2py and still I have a double submission, I don't have any feedback message coming from the session... Here is my development environment: OS : Mac OS X Version 10.6.2 Python : 2.5.4 DB: PostgreSQL 8.4 Web2py : 1.74.

[web2py:38309] Re: Delete Cascade

2010-01-04 Thread mdipierro
I found a way to implement this db.delete(top.bottom_set) I will add it to the new DAL. On Jan 4, 12:00 pm, mdipierro wrote: > No it does not. Now that you bring this up, we could implement it as > we did for sqlite but because of GAE limitations in accessing no more > than 1000 records at the t

[web2py:38308] Re: Delete Cascade

2010-01-04 Thread mdipierro
No it does not. Now that you bring this up, we could implement it as we did for sqlite but because of GAE limitations in accessing no more than 1000 records at the time this may be very slow and inefficient. It may also fail if you have a lot of referencing records. I think on GAE you have to delet

[web2py:38307] Delete Cascade

2010-01-04 Thread yamandu
Maybe it´s another stupid question but I need to be sure. Does delete cascade work on GAE? If no there´s a recommended way to do this? Or a turn around? -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@

[web2py:38306] Re: UliPad as IDE for web2py

2010-01-04 Thread mdipierro
Works for me but I first have to [toggle editor] then the [edit] button appears. On Jan 4, 10:23 am, Oleg wrote: > Have you tried "It's All Text" Firefox > extension?https://addons.mozilla.org/en-US/firefox/addon/4125 > > On Jan 3, 5:03 pm, werner wrote: > > > I think the idea behind this is qu

[web2py:38305] Re: UliPad as IDE for web2py

2010-01-04 Thread Oleg
Have you tried "It's All Text" Firefox extension? https://addons.mozilla.org/en-US/firefox/addon/4125 On Jan 3, 5:03 pm, werner wrote: > I think the idea behind this is quit nice as the web based editing > is .. > > However I find the current support a bit limited/repetitive.  Is there > any

Re: [web2py:38304] UliPad as IDE for web2py

2010-01-04 Thread Thadeus Burgess
Currently I am trying out Wing IDE, and it is an awesome python development environment. I have also used web2py with Netbeans, Eclipse + PyDev, and recently I have just been using Gedit for all of my code. If I could afford Wing IDE I would use it explicitly. You can use any IDE or editor

Re: [web2py:38303] Re: Blogitizor

2010-01-04 Thread Thadeus Burgess
Hopefully I will have time to clean it up enough that I am confident in releasing the source. If anyone is interested in helping me with the project I could go ahead and post it to google code, otherwise it will just reside in my private repositories. -Thadeus On Mon, Jan 4, 2010 at 5:18 AM,

[web2py:38302] stack overflow question

2010-01-04 Thread mdipierro
What do you think? http://stackoverflow.com/questions/150/download-link-fails-in-ie Massimo -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send

[web2py:38301] Re: add onchange method into input

2010-01-04 Thread mdipierro
You can just do form.element(_id='member_email')['_onchange']="alert('hello world')" On Jan 4, 6:00 am, Neveen Adel wrote: > I want from controller to add onchange method to input text > > for example: > > form[0].element(_id='member_email__row')[1].element > (_id='member_email') // this line wi

[web2py:38300] Re: On Login failure

2010-01-04 Thread mdipierro
If you downoloaded it, just run it. python web2py.py On Jan 4, 5:07 am, kbochert wrote: > I'm assuming that by 'trunk' you mean the top mercurial version. > I downloaded it (via TortoiseHg' . Now what? > My file explorer (PowerDesk) blinks every 2 sec when it shows any part > of the repository.

Re: [web2py:38299] UliPad as IDE for web2py

2010-01-04 Thread Vasile Ermicioi
> > You are talking about changing w2py/admin/controllers/default.py method edit? yes as I understand you want a desktop editor, pressing edit in browser and opening a desktop app (editor), but web2py supports only web based editors -- You received this message because you are subscribed to th

Re: [web2py:38298] UliPad as IDE for web2py

2010-01-04 Thread Werner F. Bruhin
Vasile Ermicioi wrote: ... > Now about editing: on 'admin/default/edit/' I just added after 'path = > apath(filename, r=request)' > import os > os.system("notepad "+path) > and it worked > You are talking about changing w2py/admin/controllers/default.py method edit? There isn't a les

Re: [web2py:38297] Re: Inherit common columns

2010-01-04 Thread Werner F. Bruhin
Thanks Massimo, and Villas, Should be more patient and read up some more. Werner mdipierro wrote: > from gluon.sql import Table > > a=Table(None,'tmp',Field('xxx',..),Field(...)) > db.define_table('mytable1',a,Field(...)) > db.define_table('mytable2',a,Field(...)) > > you get db.mytable1.xxx a

[web2py:38296] add onchange method into input

2010-01-04 Thread Neveen Adel
I want from controller to add onchange method to input text for example: form[0].element(_id='member_email__row')[1].element (_id='member_email') // this line will produce the following output: How to add onchang method from controller to be Thanks -- You received this message because

[web2py:38295] Re: Blogitizor

2010-01-04 Thread Mengu
thadeus, gonna release the source? On Jan 4, 3:39 am, Thadeus Burgess wrote: > If a planetplanet like application is made for web2py, then I made an > RSS just for web2py category. > > http://thadeusb.com/weblog/feed.rss/category/Web2py > > -Thadeus > > > > On Sun, Jan 3, 2010 at 7:17 PM, Thadeu

[web2py:38294] Re: On Login failure

2010-01-04 Thread kbochert
P.S. I just remembered the cause of the explorer blinking. It happens when my ancient file explorer tries to display too many icon overlays. Karl On Jan 4, 3:07 am, kbochert wrote: > I'm assuming that by 'trunk' you mean the top mercurial version. > I downloaded it (via TortoiseHg' . Now what?

[web2py:38293] Re: On Login failure

2010-01-04 Thread kbochert
I'm assuming that by 'trunk' you mean the top mercurial version. I downloaded it (via TortoiseHg' . Now what? My file explorer (PowerDesk) blinks every 2 sec when it shows any part of the repository. I tried the obvious - "python setup_app.py" but it hung. Any hints for an amateur? Karl On Jan 3,

[web2py:38292] Re: Blogitizor

2010-01-04 Thread Leandro - ProfessionalIT
Thadeus, You're right, this is the best way to have a category web2py to insert the planetplanet. -- Leandro. -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from thi

[web2py:38291] Re: Complex Custom Validator

2010-01-04 Thread mdipierro
IS_MATCH('[0-9A-F]{2}(\s+[0-9A-F]{2})*') On Jan 4, 2:21 am, Jason Brower wrote: > Is there a way for me to create a custom form valuator that could > validate > "11 AA BB CC DD EE FF" > Basically a list of hex values with our without spaces.   It can be any > amount of hex values  (not length res

[web2py:38290] Re: membership manager plugin

2010-01-04 Thread mdipierro
Yes. If you want to capture links you would have to modify code in web2py_ajax.html. On Jan 4, 1:30 am, KMax wrote: > The issue is: links inside ajax loaded content on click does not > update ajax loaded data, but sent browser to /welcome/plugin_groups/ > index/1 > # correct and about this guess?

[web2py:38289] Re: SQLFORM.factory or a better way for custom forms

2010-01-04 Thread mdipierro
LOAD itself cannot go in the href/onclick of a button because it is a server-side function that generates JS you can try use it (with ajax=True), look at the generated JS and put that into the BUTTON onclick. You can do click me and when you click the button is calls /yourapp/default/callback,

[web2py:38288] Complex Custom Validator

2010-01-04 Thread Jason Brower
Is there a way for me to create a custom form valuator that could validate "11 AA BB CC DD EE FF" Basically a list of hex values with our without spaces. It can be any amount of hex values (not length restricted). --- Best Regards, Jason Brower -- You received this message because you are subs