[web2py] Re: web2py beautification

2010-03-06 Thread mdipierro
I think there are two different issues. 1) have a better looking admin 2) give more options for scaffolding app (this include a choice of layout) 1) So far using a wordpress-like css would be my preferred choice. 2) The problems is that we cannot package too many files with the scaffolding app bec

[web2py] Re: Drag and drop

2010-03-06 Thread mr.freeze
jQueryUI has built-in support for drag and drop: http://jqueryui.com/demos/droppable/ On Mar 7, 1:34 am, weheh wrote: > Has anyone done a drag and drop plugin for web2py? Or can anyone > recommend a drag and drop jQuery that works well? -- You received this message because you are subscribed t

[web2py] Drag and drop

2010-03-06 Thread weheh
Has anyone done a drag and drop plugin for web2py? Or can anyone recommend a drag and drop jQuery that works well? -- 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

Re: [web2py] Re: dal.py "password is invalid keyword for this function" error

2010-03-06 Thread Thadeus Burgess
The checking is off by default, you have to explicitly enable it. Therefore unless he is using it, it is not causing a problem. And the error message looks nothing like the one that the check emits anyways :) It would help if we had a stack-trace to see where the error is being triggered. -Thadeu

Re: [web2py] Re: Dream Host Deployment

2010-03-06 Thread Jason Brower
I wonder if this could be something that could be added to the web2py book as dreamhost is a big company. Maybe dreamhost would be willing to pay a little to have it done. :P BR, Jason On Sat, 2010-03-06 at 19:05 -0800, Jesse wrote: > I put the update on: > > http://wiki.dreamhost.com/Web2py >

[web2py] Interesting project....

2010-03-06 Thread Jason Brower
https://launchpad.net/drizzle I wonder how useful it actually is and if it would be something web2py would support. (Perhaps as a plugin as I doubt it will be in python any time soon.) BR, Jason -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To

[web2py] Multiselect plugin

2010-03-06 Thread weheh
I'm building an admin interface to auth_membership. With auth_membership, a user can belong to multiple groups. The standard form made by crud.update from the auth_membership table is a 2 pulldown affair. This is cumbersome to use when there are many users and many groups. It takes too many user se

[web2py] Re: Dream Host Deployment

2010-03-06 Thread Jesse
I put the update on: http://wiki.dreamhost.com/Web2py For anyone that is interested. Also, I can migrate the info to another location if someone has a suggestion as to where. Cheers, Jesse On Mar 6, 10:33 pm, Jesse wrote: > Fabulous, > > That seemed to do the tricked. > > Dreamhost seems to

[web2py] Re: Dream Host Deployment

2010-03-06 Thread Jesse
Fabulous, That seemed to do the tricked. Dreamhost seems to be a bit touchy on which ports you I can use to run web2py on. (ie none of 8000, 8001, 8080, 8081, etc seemed to work) But I just picked a random number and it seems to work like a charm. I'll have to add this to Dreamhost's wiki. Than

[web2py] Re: * web2py's Brand *

2010-03-06 Thread villas
> Maybe you have a relevant coherent point. But damned if I know what it is. Suffice it to say, I am surprised you would be so rude and indignant about your difficulty in understanding plain English and recognising the extraordinary capabilities of your free 'prototyping' tool, and I wish you ever

[web2py] alwaysdata deployment

2010-03-06 Thread pistachio
Hi guys, I know there is a wiki page on this one but I have come across a few problems and wondered if some kind soul could point me in the right direction... I am trying to deploy a web2py application as described here: http://translate.google.com/translate?u=http%3A%2F%2Fwiki.alwaysdata.com%2Fw

[web2py] Re: dal.py "password is invalid keyword for this function" error

2010-03-06 Thread villas
It's probably due to SQL Reserved Keywords: web2py.com/book/default/ section/6/2 Password didn't previously seem to cause a problem in MySql itself, but it should still be avoided so that your app is more transportable across DBs. I am not sure how to turn off the checking, but I imagine it will

[web2py] Re: DAL problems on Firebird 2.1 (DROP COLUMN DOES NOT WORK)

2010-03-06 Thread salbefe
Thank you. Regards Salva On 6 mar, 19:17, Jose wrote: > On 6 mar, 15:36, salbefe wrote: > > > I'm using the latest version from mercurial repository. > > I sent a patch to Massimo. > > Jose -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To

Re: [web2py] Re: Dream Host Deployment

2010-03-06 Thread Kuba Kucharski
let's get you through it. for development I use two instances of web2py. one: python web2py.py -i public_ip -p 80 -a "" two: python web2py.py -i public_ip -p 8001 -a "password" one instance serves my beta testers and users, the second on runs just for me then I do: ssh -L 8001:127.0.0.1:800

[web2py] Re: Dream Host Deployment

2010-03-06 Thread Jesse
Yeah, that either of those sound like what I'll have to do. I tried the ssh tunnel, but it didn't seem to have much effect: ssh -L 80:web2py.mydomain.com:8080 lo...@dreamhost.com ssh -L 8080:localhost:80 lo...@dreamhost.com [and various other permutations] I then tried going to localhost:8080 and

[web2py] Re: Book 6.8. Exporting and Importing Data ( CSV and remote Database Synchronization )

2010-03-06 Thread raven
The above changes get the code in the book to work. However, the default name for the downloaded csv file is rather awkward. If you add this line response.headers["Content-Disposition"] = "attachment;filename=myfname.csv" just after response.headers['Content-Type'] = 'text/csv' then you

Re: [web2py] Re: * web2py's Brand *

2010-03-06 Thread Thadeus Burgess
John, What do you constitute as a "Big Money Making Project"? I work for a fairly large company, we use web2py for internal uses. These internal applications generate the company millions of dollars a year in savings by automating aspects of the business. You don't think web2py is used in "Seriou

[web2py] Re: Multiple validators with IS_IN_DB

2010-03-06 Thread FaustCoder
>From the way it looks to me is that if it requires it to be in the database then of course it can not be empty. You've already solved your own problem? On Mar 6, 11:44 am, raven wrote: > I have a field that references another table > > Field('material', db.material) > > I can get SQLFORM to give

[web2py] Re: web2py beautification

2010-03-06 Thread FaustCoder
+2 On Mar 6, 8:55 am, "mr.freeze" wrote: > They are under the Creative Commons Attribution 2.5 license - free for > use commercially or non-commercially provided you put a link somewhere > in the template back to freecsstemplates.org. Even this can be > bypassed with the author's permission. They

[web2py] Re: html e-mail newsletter

2010-03-06 Thread Nico de Groot
Hi Annet, I made a simple function to send HTML mail, put it on in a slice just now. You can find it here http://www.web2pyslices.com/main/slices/take_slice/69 it uses a few python modules. Maybe it helps... Thanks for the reference to the e-mail newsletter article. Nico de Groot On 6 mr

[web2py] Re: Multiple validators with IS_IN_DB

2010-03-06 Thread raven
So it does! That solves my problem. Thank you. On Mar 6, 1:56 pm, "mr.freeze" wrote: > Unless you have a material entry with an empty material.name in your > database, IS_IN_DB should prevent an empty submission. > > On Mar 6, 11:44 am, raven wrote: > > > I have a field that references another

[web2py] Re: Multiple validators with IS_IN_DB

2010-03-06 Thread mr.freeze
Unless you have a material entry with an empty material.name in your database, IS_IN_DB should prevent an empty submission. On Mar 6, 11:44 am, raven wrote: > I have a field that references another table > > Field('material', db.material) > > I can get SQLFORM to give me a drop down list of avail

[web2py] Re: DAL problems on Firebird 2.1 (DROP COLUMN DOES NOT WORK)

2010-03-06 Thread Jose
On 6 mar, 15:36, salbefe wrote: > I'm using the latest version from mercurial repository. > I sent a patch to Massimo. Jose -- 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 uns

[web2py] Multiple validators with IS_IN_DB

2010-03-06 Thread raven
I have a field that references another table Field('material', db.material) I can get SQLFORM to give me a drop down list of available material names Field('material', db.material, requires=IS_IN_DB(db,'material.id','material.name')) I can get SQLFORM to insist on filling the

[web2py] Re: web2py beautification

2010-03-06 Thread John
There's also http://www.blueprintcss.org/ which appears to be fairly open in its licensing. I think it might be GPL though so it would possibly "taint" the application template. It may still be a nice option for admin. On Mar 6, 9:55 am, "mr.freeze" wrote: > They are under the Creative Commons

[web2py] Re: Retrieving latest update record from DB ???

2010-03-06 Thread Massimo Di Pierro
db (db .table.id>0).select(orderby=~db.table.recordtiime,limitby=(0,1)).first() On Mar 6, 2010, at 9:59 AM, Yannick wrote: Hello mate, I was wondering if any one of you knows how to retrieve the latest UPDATE record in Web2py ??? Like for example how to do this using DAL of Web2py: - Select to

[web2py] Retrieving latest update record from DB ???

2010-03-06 Thread Yannick
Hello mate, I was wondering if any one of you knows how to retrieve the latest UPDATE record in Web2py ??? Like for example how to do this using DAL of Web2py: - Select top 1 from order by RecordTime desc OR this one: - Select from order by RecordTime asc LIMIT 1 Anyway please let me know

[web2py] Re: DAL problems on Firebird 2.1 (DROP COLUMN DOES NOT WORK)

2010-03-06 Thread salbefe
I'm using the latest version from mercurial repository. On 6 mar, 13:53, Jose wrote: > On 6 mar, 09:14, salbefe wrote: > > > The output from sql.log is as follows: > > > > ALTER TABLE node_details DROP COLUMN teaser; > > > The problems is that for dropping a column, firebird and interbase >

[web2py] Re: Ladies and Gentelmen... the web2py book is online

2010-03-06 Thread mdipierro
On Mar 6, 4:28 am, Nico de Groot wrote: > The online book/Wiki need a small fix: the % character needs to be > escaped. I added in the Errata an example from the > Internationalisation chapter: the code using the T("text % > (name)s",dict(name='Nico")) is not displayed correctly. Adding the > wi

[web2py] Re: Custom 404 pages

2010-03-06 Thread mdipierro
On Mar 5, 9:48 pm, Abhishek Mishra wrote: > Hi I'm trying to implement a decorator for custom error pages in > web2py into sahanapy. > Ref -http://web2py.com/AlterEgo/default/show/75 > > I'm trying to keep it as a module in /modules directory so that I can > import it into the controllers and plac

[web2py] Re: web2py beautification

2010-03-06 Thread mr.freeze
They are under the Creative Commons Attribution 2.5 license - free for use commercially or non-commercially provided you put a link somewhere in the template back to freecsstemplates.org. Even this can be bypassed with the author's permission. They can be modified and redistributed. That doesn't se

[web2py] Re: DAL problems on Firebird 2.1 (DROP COLUMN DOES NOT WORK)

2010-03-06 Thread Jose
On 6 mar, 09:14, salbefe wrote: > The output from sql.log is as follows: > > ALTER TABLE node_details DROP COLUMN teaser; > > The problems is that for dropping a column, firebird and interbase > doesn't accept the COLUMN  keywork, you should write ALTER TABLE tbl > DROP col instead of  ALT

[web2py] More Questions About Compatibility

2010-03-06 Thread Magnitus
>From the fact that they stuck with MSVC++ 6.0 for so long (despite 2002, 2003, 2005 and 2008 coming along) and that MSVC++ 6.0 doesn't support the 64 bits format, I will take a wild guess and presume that Apache won't support Win64 anytime soon. So, what this means is that I'll have to run the Ap

[web2py] Re: date fieds layout problem

2010-03-06 Thread parroit
I'm using Internet Explorer 8, Python version 2.6.2 and Web2py 1.75.2. Same problem happens on our production server, with Python 2.5 and web2py 1.72.3 I didn't try it with IE6 On 6 Mar, 02:28, DenesL wrote: > Works fine on IE6, > which version are you using?. > > On Mar 5, 4:27 pm, Andrea Parodi

[web2py] Re: Ladies and Gentelmen... the web2py book is online

2010-03-06 Thread Nico de Groot
The online book/Wiki need a small fix: the % character needs to be escaped. I added in the Errata an example from the Internationalisation chapter: the code using the T("text % (name)s",dict(name='Nico")) is not displayed correctly. Adding the wikipage I was bitten by the same bug, escaping % with

[web2py] DAL problems on Firebird 2.1 (DROP COLUMN DOES NOT WORK)

2010-03-06 Thread salbefe
Hello, After successfully connecting to the database I tried altering the definition of a table from this: db.define_table('node_details', Field('uid', 'integer', notnull=True), Field('title', length='255'), Field('body', 'text'), Fi

[web2py] html e-mail newsletter

2010-03-06 Thread annet
>From this article I learned how to code an html e-mail newsletter: http://articles.sitepoint.com/article/code-html-email-newsletters Now I would like to send this newsletter from within a Web2py CRM application. I searched the group for how to instructions but I didn't find anything useful. I tr

[web2py] Custom 404 pages

2010-03-06 Thread Abhishek Mishra
Hi I'm trying to implement a decorator for custom error pages in web2py into sahanapy. Ref - http://web2py.com/AlterEgo/default/show/75 I'm trying to keep it as a module in /modules directory so that I can import it into the controllers and place the decorator appropriately. I have kept error han

[web2py] Re: web2py beautification

2010-03-06 Thread mdipierro
The problem here is legal. We cannot distributed with the scaffolding app, page templates that have a restrictive license. The current template is not great but is made of images and css that are public domain so no problem is you build on those. I proposed wordpress theme for admin (and admin onl