[web2py] optgroup support

2010-02-15 Thread hamdy.a.farag
Hi I read this post http://groups.google.com/group/web2py/browse_thread/thread/f9967ef7151c5ae8/d0c47ff7a40e0dfc?lnk=gst&q=OPTGROUP#d0c47ff7a40e0dfc and I didn't find optgroup in html.py either so why not adding it since from time to time people may need it? -- You received this message beca

[web2py] Re: how to deploy web2py for a single app?

2010-02-15 Thread pistacchio
hi, massimo, thanks. it worked. is this info somewhere in the new online book? i think that from now on those kind of questions and answer should point to the documentation. if it is documented, maybe it is in a part i haven't read with enough attention, and i'd like to re-read it. or it is not cl

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

2010-02-15 Thread pistacchio
hi, just a quick question, maybe already discussed and i missed it. the wiki pages connected with the book are for additional examples and use cases. what are the comments for? for example, i wanted to point out that on this page http://web2py.com/book/default/section/6/5, in the "and operator" se

[web2py] Re: one cool website

2010-02-15 Thread Benigno
Thank you all, Indeed the intro does not load well on all browsers. We are getting rid of it though, as we need a better landing page for SEO purposes. In fact, designers are changing the whole thing, and moving a little bit away from flash. So, as we know that we are changing it in the very ne

[web2py] problem with file upload in LOAD

2010-02-15 Thread selecta
my view: {{=LOAD('default','upload_doc',ajax=True,)}} my controller: def upload_doc(): print 'vars ',request.vars.keys() form = form_factory(Field('sbmlfile','upload', requires=IS_NOT_EMPTY(), label='SBML file')) if form.accepts(request.vars, session): if not request.vars.sbmlf

[web2py] Re: problem with file upload in LOAD

2010-02-15 Thread selecta
ok already fixed it by using http://jquery.malsup.com/form/ in web2py_ajax.html at the top i added response.files.insert(3,URL(r=request,c='static',f='jquery.form.js')) and replaced form.serialize() in web2py_trap_form with web2py_ajax_page('post',action,form.formSerialize(),target); maybe this

[web2py] Re: problem with file upload in LOAD

2010-02-15 Thread selecta
guess i should wait till i really tested it, file content is not submitted, just the file name :( On Feb 15, 10:56 am, selecta wrote: > ok already fixed it by usinghttp://jquery.malsup.com/form/ > > in web2py_ajax.html at the top i added > response.files.insert(3,URL(r=request,c='static',f='jquer

[web2py] Issue with jquery datepicker calendar not returning the date

2010-02-15 Thread Throngly
I have an issue with the jquery datepicker calendar pop-up that's built into web2py. Basically it appears OK when I click in the date edit box and I can navigate it fine too, but when I select a date nothing happens. The date does not get written to the text field. The time picker works perfectly

[web2py] Re: how to deploy web2py for a single app?

2010-02-15 Thread DenesL
See book, section 4.14 On 15 feb, 04:19, pistacchio wrote: > hi, massimo, thanks. it worked. > > is this info somewhere in the new online book? i think that from now > on those kind of questions and answer should point to the > documentation. if it is documented, maybe it is in a part i haven't >

[web2py] Re: web2py 1.75.1 is Out

2010-02-15 Thread Beerc
I suggest semantic versioning (http://semver.org/). On febr. 13, 05:02, mdipierro wrote: > Feel free > to make a proposal. -- 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 unsubsc

[web2py] Re: web2py site problem ?!

2010-02-15 Thread mdipierro
I just tried this. I have to say vps.net is much easier to use than amazon. They seem to be a little sloppy on security (amazon gave me no pem file, vps emailed back to the very same password I used to register). Here it is for a test: http://68.169.39.35/book Hos fast/slow is it? Massimo On F

[web2py] Re: Execute file in web2py environment fails with cron

2010-02-15 Thread mdipierro
looking again at this: */1 * * * * /usr/bin/python /web2py/web2py.py -S MYAPP -M -R /web2py/applications/MYAPP/cron/update_records.py >> /web2py/applications/MYAPP/cron/cron.log where does it say it should be run by www-data? */1 * * * * www-data /usr/bin/python /web2py/web2py.py -S MYAPP -M -R

[web2py] Re: DAL integer length

2010-02-15 Thread mdipierro
No. You have to store them into a string. On Feb 15, 1:29 am, Kevin Bowling wrote: > How can I force the DAL to use a 64-bit integer length (BIGINT) per > facebook requirements for storing UIDs? -- You received this message because you are subscribed to the Google Groups "web2py-users" group.

[web2py] Re: optgroup support

2010-02-15 Thread mdipierro
Please let' snot proliferate these. Use TAG.optgroup On Feb 15, 3:19 am, "hamdy.a.farag" wrote: > Hi > > I read this post >  http://groups.google.com/group/web2py/browse_thread/thread/f9967ef715... > > and I didn't find optgroup in html.py either > > so why not adding it since from time to time

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

2010-02-15 Thread mdipierro
Create a wiki page under preface called errata. It would be nice if somebody where to move over errata from wiki.web2py.com. As people fix these problems, we'll mark the errata entries as fixed. On Feb 15, 3:28 am, pistacchio wrote: > hi, > just a quick question, maybe already discussed and i mis

[web2py] Re: why use the admin interface, at all?

2010-02-15 Thread Christopher Steel
LOL! I for one love the built in web2py editor. I am even starting to become fond of it's little refresh requirement quirk. It turns web2py into an awesome little sketch pad right out of the box and it is available no matter what system I am on and requires ZERO configuration. The other great thin

[web2py] Re: problem with file upload in LOAD

2010-02-15 Thread mdipierro
would you pst a web2pyslice about this? On Feb 15, 3:56 am, selecta wrote: > ok already fixed it by usinghttp://jquery.malsup.com/form/ > > in web2py_ajax.html at the top i added > response.files.insert(3,URL(r=request,c='static',f='jquery.form.js')) > > and replaced form.serialize() in web2py_tr

[web2py] Re: Issue with jquery datepicker calendar not returning the date

2010-02-15 Thread mdipierro
which browser? I never heard of this issue before. On Feb 15, 6:50 am, Throngly wrote: > I have an issue with the jquery datepicker calendar pop-up that's > built into web2py. > > Basically it appears OK when I click in the date edit box and I can > navigate it fine too, but when I select a date

Re: [web2py] Re: Execute file in web2py environment fails with cron

2010-02-15 Thread Thadeus Burgess
Why should it be ran by www-data ? All of the web2py files are owned by the user that is executing cron. thadeusb:www-data 775 I guess I could always try executing a .sh file from cron and then execute the command from that. However, I don't really know how to narrow down this problem unless I s

[web2py] Re: why use the admin interface, at all?

2010-02-15 Thread mdipierro
I can't wait to see it running on the ipad, although we may want to make it a little more user friendly for that. On Feb 15, 9:20 am, Christopher Steel wrote: > LOL! > > I for one love the built in web2py editor. I am even starting to > become fond of it's little refresh requirement quirk. It tur

[web2py] Displaying a gantt like chart...

2010-02-15 Thread Jason Brower
I am making a scheduling application and am getting fairly close. I have it displaying a charts relative to the size of screen. The data configured in the controller and built on the screen with only html and css. But I have a few issues. I need to create a date that I can add one day to another ov

Re: [web2py] Re: web2py site problem ?!

2010-02-15 Thread Thadeus Burgess
I would say a negligible difference. How does vps.net compare to slicehost.com ? -Thadeus On Mon, Feb 15, 2010 at 8:46 AM, mdipierro wrote: > I just tried this. I have to say vps.net is much easier to use than > amazon. They seem to be a little sloppy on security (amazon gave me no > pem fi

Re: [web2py] Re: Issue with jquery datepicker calendar not returning the date

2010-02-15 Thread Thadeus Burgess
Try installing firebug and seeing if anything is logging to the console that could be causing the issue ? -Thadeus On Mon, Feb 15, 2010 at 9:22 AM, mdipierro wrote: > which browser? I never heard of this issue before. > > On Feb 15, 6:50 am, Throngly wrote: >> I have an issue with the jquer

[web2py] Re: WSGI, Apache2, and web2py NOT at root

2010-02-15 Thread Christopher Steel
This is a "reprint" from web2pyslice located here -> http://www.web2pyslices.com/main/slices/take_slice/29 and a comment I left. Some of the other comments look like they could be helpful as well, I notice at least one about an updated ubuntu install script. Here is my comment regarding the Ubuntu

[web2py] Re: Example of apache2 configuration where web2py exists along other sites

2010-02-15 Thread Christopher Steel
http://groups.google.com/group/web2py/browse_thread/thread/17dc10f50b69868c On Feb 13, 5:11 pm, Johann Spies wrote: > I am becoming desperate about this problem.  I could so far not > succeed to get web2py working behind apache where web2py is not root > (e.g. the setup of the ubuntu-setup script

[web2py] Re: web2py 1.75.1 is Out

2010-02-15 Thread mdipierro
I think the intent was to follow that already. The only issue is that sometimes a new feature is added but we want to wait that people test it until the version number is incremented. People do not really seem to test code in trunk. On Feb 15, 8:19 am, Beerc wrote: > I suggest semantic versioning

[web2py] Re: Issue with jquery datepicker calendar not returning the date

2010-02-15 Thread Throngly
It's Firefox 3.5 running on Ubuntu 9.10 On Feb 15, 3:22 pm, mdipierro wrote: > which browser? I never heard of this issue before. > > On Feb 15, 6:50 am, Throngly wrote: > > > I have an issue with the jquery datepicker calendar pop-up that's > > built into web2py. > > > Basically it appears OK w

[web2py] Re: Issue with jquery datepicker calendar not returning the date

2010-02-15 Thread Throngly
Yes, I've been running firebug and could see nothing untoward. I have read that mistakenly having two copies of jquery running can have strange side effects. Is there any way that could happen under web2py? On Feb 15, 3:29 pm, Thadeus Burgess wrote: > Try installing firebug and seeing if anythi

Re: [web2py] Re: web2py 1.75.1 is Out

2010-02-15 Thread Thadeus Burgess
I test code in trunk with my development, I always pull changes at the start of my day. On the server however... I havn't upgraded those things in forever, and I won't until I find a version I am happy with :) -Thadeus On Mon, Feb 15, 2010 at 9:33 AM, mdipierro wrote: > I think the intent w

Re: [web2py] Re: Issue with jquery datepicker calendar not returning the date

2010-02-15 Thread Thadeus Burgess
One of two things "could" be happening. If you put your own version of jquery and did not comment out web2py's version, then yes that will cause problems. Also I have noticed that jquery included in web2py is older, so sometimes certain jquery plugins will break things. -Thadeus On Mon, Feb

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

2010-02-15 Thread Thadeus Burgess
The markdown, it converts single qoutes and drops them sometimes. So most code if it includes a string will not be copy/pastable. Is there a way to have the markdown ignore anything that is code ? -Thadeus On Mon, Feb 15, 2010 at 9:20 AM, mdipierro wrote: > Create a wiki page under preface

[web2py] Re: Displaying a gantt like chart...

2010-02-15 Thread mdipierro
Not sure I understand. You can do {{import datetime}} {{today=request.now}} {{for i in range(days):}} {{today = today+ datetime.timedelta(days=1)}} {{=today}} {{pass}} On Feb 15, 9:25 am, Jason Brower wrote: > I am making a scheduling application and am getting fairly close. > I have it dis

[web2py] Looking for web2py Programmers !

2010-02-15 Thread Benigno
Hello, I am looking for a developer for a Home Automation Project. The application is a user interface to allow the user to data mine the user's home automation system data. Basically view historicals filtered by a number of variables, and to visualize them in charts (different variables at the

[web2py] Re: web2py site problem ?!

2010-02-15 Thread mdipierro
I have not tried slicehost. memorywise it is on the low side but the management interface is very intuitive. You can scale up the number of server by moving a slider. You have to setup your own load balancer but they have an howto. The vps are preconfigured to share a folder (so I am told, did not

[web2py] Re: WSGI, Apache2, and web2py NOT at root

2010-02-15 Thread mdipierro
I am changing this in trunk. I run into the same problem. The new script also prompts you for the admin password. On Feb 15, 9:31 am, Christopher Steel wrote: > This is a "reprint" from web2pyslice located here > ->http://www.web2pyslices.com/main/slices/take_slice/29and a comment I > left. Some

[web2py] Re: Example of apache2 configuration where web2py exists along other sites

2010-02-15 Thread mdipierro
somebody should make a web2pyslice about this. or a wiki page in the book. On Feb 15, 9:32 am, Christopher Steel wrote: > http://groups.google.com/group/web2py/browse_thread/thread/17dc10f50b... > > On Feb 13, 5:11 pm, Johann Spies wrote: > > > I am becoming desperate about this problem.  I coul

[web2py] Re: web2py 1.75.1 is Out

2010-02-15 Thread mdipierro
Good to know. Yet people who run windows for example, they usually wait for the executable. On Feb 15, 9:49 am, Thadeus Burgess wrote: > I test code in trunk with my development, I always pull changes at the > start of my day. > > On the server however... I havn't upgraded those things in forever

[web2py] Re: Issue with jquery datepicker calendar not returning the date

2010-02-15 Thread mdipierro
web2py includes: jQuery JavaScript Library v1.4.1 the latet. On Feb 15, 9:52 am, Thadeus Burgess wrote: > One of two things "could" be happening. If you put your own version of > jquery and did not comment out web2py's version, then yes that will > cause problems. > > Also I have noticed that jq

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

2010-02-15 Thread mdipierro
`this is code` On Feb 15, 9:59 am, Thadeus Burgess wrote: > The markdown, it converts single qoutes and drops them sometimes. > > So most code if it includes a string will not be copy/pastable. > > Is there a way to have the markdown ignore anything that is code ? > > -Thadeus > > On Mon, Feb 1

[web2py] Re: web2py vs. customizing existing e-commerce app

2010-02-15 Thread snfctech
Thanks for the good tips. @David: I've considered precisely the points your making. I've already designed my "dream schema", which is another argument for not using an existing product and getting locked into it's schema. As for the ongoing maintenance - I'm hopeful that the combination of read

[web2py] Re: web2py vs. customizing existing e-commerce app

2010-02-15 Thread mdipierro
Mind that there is a new google checkout plugin under development. It needs testing. If you want to help with that it can make everybody's life easier. Let me know. On Feb 15, 11:05 am, snfctech wrote: > Thanks for the good tips. > > @David: > > I've considered precisely the points your making.  

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

2010-02-15 Thread Anthon
Very nice. I already got the PDF, but with the online version you can actually cut and paste the code sections without getting the line-numbers in between. For me that means: rm ~/bin/strip_web2py_linenumbers ;-) On Feb 12, 2:30 am, mdipierro wrote: > http://web2py.com/book > > This is only for

[web2py] Re: Duplicate session keys / uuids

2010-02-15 Thread mdipierro
The web2py in trunk has a new uuid function that combines uuid4 (it is random) and uuid1 (takes into account mac address and time). It should void uuid conflicts when running multiple vps instances clones of each other. You may want to give it a try. Massimo On Feb 10, 2:51 pm, Dmitri Zagidulin

[web2py] Re: problem with file upload in LOAD

2010-02-15 Thread selecta
aren't slices for things that work? this does not work, you may have missed my third comment anyway I got it to work with a different jquery plugin, and I will post that as a slice On Feb 15, 4:21 pm, mdipierro wrote: > would you pst a web2pyslice about this? > > On Feb 15, 3:56 am, selecta wro

[web2py] Re: problem with file upload in LOAD

2010-02-15 Thread mdipierro
right. I thought the jquery plugin fixed it. On Feb 15, 12:08 pm, selecta wrote: > aren't slices for things that work? this does not work, you may have > missed my third comment > anyway I got it to work with a different jquery plugin, and I will > post that as a slice > > On Feb 15, 4:21 pm, mdi

[web2py] Sessions table warning for column 'locked'

2010-02-15 Thread Dmitri Zagidulin
I've started seeing the following warning on the logging console: /gluon/sql.py:739: Warning: Out of range value adjusted for column 'locked' at row 1 self._execute = lambda *a, **b: self._cursor.execute(*a, **b) I'm assuming it's related to the sessions table (since I'm keeping my sessions in

[web2py] Re: Duplicate session keys / uuids

2010-02-15 Thread Dmitri Zagidulin
Do I have to make code changes, to use the new function, or just update to trunk? (Also, do you by any chance have any insight into the question above, on how could either cache control or changing the redirect destination after login, cause session crossovers and bleed?) On Feb 15, 1:07 pm, mdip

[web2py] Re: Sessions table warning for column 'locked'

2010-02-15 Thread mdipierro
This is not a web2py error. It may be a db error. What db? Can we see complete traceback? The locked variable is currently not used so in any case should not be of concern. The idea was to lock the db record when the session is accessed by a client. This function is currently disabled. On Feb 15,

[web2py] Re: Duplicate session keys / uuids

2010-02-15 Thread mdipierro
> Why would changing the browser cache-control headers, or redirecting > to an http url instead of https, cause one user to get another user's > session (and see the other user's account, etc)? this is impossible. What may have caused the problem is that switching form http to https cased the clie

[web2py] csv import

2010-02-15 Thread weheh
During csv import via the admin interface, do I need to have all the fields from the db table present in the csv input file, or can I have just a few of the columns? Also, do validators get run during import? I'm trying to import a csv file from a legacy database but it's not being read in and I'm

[web2py] Re: Sessions table warning for column 'locked'

2010-02-15 Thread Dmitri Zagidulin
The db used for sessions is MySQL. That is the entirety of the traceback -- it appears not in the error tickets, but just as a single line of warning in the web2py console (the shell window where I start web2py for dev purposes). To be specific: web2py Enterprise Web Framework Created by Massimo

[web2py] Re: csv import

2010-02-15 Thread mdipierro
On Feb 15, 2:05 pm, weheh wrote: > During csv import via the admin interface, do I need to have all the > fields from the db table present in the csv input file, or can I have > just a few of the columns? as long as the other fields have default values or are not "required=True" you can miss th

[web2py] Re: Sessions table warning for column 'locked'

2010-02-15 Thread mdipierro
That is a mysql error, not a web2py error. Does this help? http://forums.kayako.com/f56/steps-fix-sql-error-out-range-value-adjusted-column-mysql-5-a-7604/ On Feb 15, 2:12 pm, Dmitri Zagidulin wrote: > The db used for sessions is MySQL. > > That is the entirety of the traceback -- it appears not

[web2py] unix admin app

2010-02-15 Thread mdipierro
Has anybody built any app to manage (create/delete/set permission) a postgresql database on unix? 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 gro

[web2py] Re: web2py site problem ?!

2010-02-15 Thread villas
I also find your test site to be very responsive from here in Europe. >>memorywise it is on the low side Low side? I think you need to have another chat with John Heenan, I'll bet he's working off a floppy disk right now! (Only kidding John). Anyhow each host (or instance) you set up has it *o

[web2py] Re: csv import

2010-02-15 Thread Russell
My experience with CSV import suggests that you need to delete the id column. Also the lack of validation is a bit of a trap...once I edited an exported CSV with MS Excel, which silently reformatted all the dates to something like 1/2/2010. The edited file was 'successfully' imported into SQLite

[web2py] Re: Sessions table warning for column 'locked'

2010-02-15 Thread Dmitri Zagidulin
Thanks! I'll investigate why it's throwing the warning; the link helps. On Feb 15, 3:35 pm, mdipierro wrote: > That is a mysql error, not a web2py error. Does this help? > > http://forums.kayako.com/f56/steps-fix-sql-error-out-range-value-adju... > > On Feb 15, 2:12 pm, Dmitri Zagidulin wrote:

Re: [web2py] Re: Issue with jquery datepicker calendar not returning the date

2010-02-15 Thread Jonathan Lundell
On Feb 15, 2010, at 8:13 AM, mdipierro wrote: > web2py includes: > jQuery JavaScript Library v1.4.1 > the latet. In my non-web2py applications, I've been picking jQuery up from the Google ajax site. Much faster than my servers. > > > On Feb 15, 9:52 am, Thadeus Burgess wrote: >> One of two t

[web2py] Re: Form Dropdown - have value different from displayed text

2010-02-15 Thread Donald Hughes
This worked perfectly. Thank you, sir. Also, thanks to the other guys for pointing out the pages in the book - that lead me to discover the book in the first place. On Feb 11, 1:36 pm, Thadeus Burgess wrote: > is this integrated into sqlform? > > Field(..., requires=IS_IN_SET((1, 2, 3), ("Car

[web2py] Re: Issue with jquery datepicker calendar not returning the date

2010-02-15 Thread Throngly
Problem solved! After experimenting with different CSS layouts I was accidentally including jquery.js in both the head and body. Everything working correctly now. Many thanks for the suggestions. On Feb 15, 3:52 pm, Thadeus Burgess wrote: > One of two things "could" be happening. If you put your

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

2010-02-15 Thread Thadeus Burgess
Look at http://web2py.com/book/default/section/6/8 under the code samples. and here http://web2py.com/book/default/section/6/10 Are they typos then ? -Thadeus On Mon, Feb 15, 2010 at 11:38 AM, Anthon wrote: > Very nice. > > I already got the PDF, but with the online version you can actually

Re: [web2py] Re: csv import

2010-02-15 Thread Thadeus Burgess
Appadmin has a nasty except: clause that will catch any potential errors that could be happening :) -Thadeus On Mon, Feb 15, 2010 at 3:31 PM, Russell wrote: > o the lack of validation is a bit of a trap...once I edited an > exported CSV with MS Excel, which silently reformatted all the

[web2py] Re: web2py vs. customizing existing e-commerce app

2010-02-15 Thread snfctech
@Massimo: The first phase of our project is only going to generate invoices with bar-codes that are taken to our registers for payment, due to the complexity of our discount system and how it ties into our member data (not to mention accounting/ reconciliation). So no on-line payment at this time

[web2py] Re: one cool website

2010-02-15 Thread snfctech
@Benigno: You've probably already noticed, but your Blog is full of spam. On Feb 15, 1:39 am, Benigno wrote: > Thank you all, > >    Indeed the intro does not load well on all browsers. We are getting > rid of it though, as we need a better landing page for SEO purposes. > In fact, designers are

[web2py] Re: how to NOT IN with DAL?

2010-02-15 Thread baloan
Now I'm trying to do SELECT MAX(DAY) FROM T WHERE DAY < '2007-12-04' and I fail to find an operator for "MAX" in the web2py book. Is it supported? Regards, Andreas PS: The online book is splendid. I like it. Much easier to work with. Now web2py is a truly "free" application. Note: In section

[web2py] Re: Issue with jquery datepicker calendar not returning the date

2010-02-15 Thread Throngly
Problem solved! After experimenting with different CSS layouts I was accidentally including jquery.js in both the head and body. Everything working correctly now. Many thanks for the suggestions. On Feb 15, 3:52 pm, Thadeus Burgess wrote: > One of two things "could" be happening. If you put your

Re: [web2py] Re: how to NOT IN with DAL?

2010-02-15 Thread Tiago Almeida
Can't you sort by day and get the first? I don't know if max exists. Regards, Tiago On Mon, Feb 15, 2010 at 10:49 PM, baloan wrote: > Now I'm trying to do > > SELECT MAX(DAY) FROM T WHERE DAY < '2007-12-04' > > and I fail to find an operator for "MAX" in the web2py book. Is it > supported? > >

Re: [web2py] Re: how to NOT IN with DAL?

2010-02-15 Thread Thadeus Burgess
The issue here is that MAX is not a single record, it could be 5 records with the same date, it could be 5000 records with the same date. -Thadeus On Mon, Feb 15, 2010 at 5:08 PM, Tiago Almeida wrote: > Can't you sort by day and get the first? > I don't know if max exists. > Regards, > Tiago

[web2py] Re: web2py site problem ?!

2010-02-15 Thread mdipierro
There are some vps services that offer 350MB ram and 20GB for the same price. Nevertheless vps.net interface is hard to beat and so far they have been very prompt in responding to may emails. I am making a web2py-ready instance so that people can just pay - click and access everything (including co

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

2010-02-15 Thread mdipierro
errors in conversion from latex On Feb 15, 4:25 pm, Thadeus Burgess wrote: > Look athttp://web2py.com/book/default/section/6/8under the code samples. > and herehttp://web2py.com/book/default/section/6/10 > > Are they typos then ? > > -Thadeus > > On Mon, Feb 15, 2010 at 11:38 AM, Anthon > > wrot

[web2py] Re: how to display date and time nicely?

2010-02-15 Thread Richard
added a few more cases: def prettydate(d): try: dt = datetime.now() - d except: return '' if dt.days >= 2*365: return '%d years ago' % int(dt.days / 365) elif dt.days >= 365: return '1 year ago' elif dt.days >= 60: return '%d months ago'

[web2py] Re: csv import

2010-02-15 Thread mdipierro
true. bad. look again in trunk. On Feb 15, 4:29 pm, Thadeus Burgess wrote: > Appadmin has a nasty > >    except: > > clause that will catch any potential errors that could be happening :) > > -Thadeus > > On Mon, Feb 15, 2010 at 3:31 PM, Russell wrote: > > o the lack of validation is a bit of a

[web2py] Re: how to NOT IN with DAL?

2010-02-15 Thread mdipierro
print db(db.t.day wrote: > Now I'm trying to do > > SELECT MAX(DAY) FROM T WHERE DAY < '2007-12-04' > > and I fail to find an operator for "MAX" in the web2py book. Is it > supported? > > Regards, Andreas > > PS: The online book is splendid. I like it. Much easier to work with. > Now web2py is a tr

[web2py] Re: how to display date and time nicely?

2010-02-15 Thread mdipierro
for lack of a better option I put it in tools for now. On Feb 15, 5:56 pm, Richard wrote: > added a few more cases: > > def prettydate(d): >     try: >         dt = datetime.now() - d >     except: >         return '' >     if dt.days >= 2*365: >         return '%d years ago' % int(dt.days / 365)

Re: [web2py] unix admin app

2010-02-15 Thread Kuba Kucharski
http://www.pgadmin.org/index.php http://phppgadmin.sourceforge.net/ Is it what you are looking for? -- Kuba -- 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

[web2py] Error in the trunk

2010-02-15 Thread Jose
Massimo, After updating the following error occurs: File "/usr/home/jose/w2p/gluon/tools.py", line 2970 elif dt.days > 21: ^ SyntaxError: invalid syntax Jose -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, s

[web2py] Re: unix admin app

2010-02-15 Thread mdipierro
Not quite. I am looking for a web2py app that allows me something simpler: create and delete databases. For everything we can use appadmin already. On Feb 15, 6:27 pm, Kuba Kucharski wrote: > http://www.pgadmin.org/index.phphttp://phppgadmin.sourceforge.net/ > > Is it what you are looking for? >

[web2py] Re: Error in the trunk

2010-02-15 Thread mdipierro
oops. fixed. On Feb 15, 7:20 pm, Jose wrote: > Massimo, > > After updating the following error occurs: > > File "/usr/home/jose/w2p/gluon/tools.py", line 2970 >     elif dt.days > 21: >        ^ > SyntaxError: invalid syntax > > Jose -- You received this message because you are subscribed to th

[web2py] Re: Error in the trunk

2010-02-15 Thread Jose
On 16 feb, 01:20, Jose wrote: > Massimo, > > After updating the following error occurs: > > File "/usr/home/jose/w2p/gluon/tools.py", line 2970 >     elif dt.days > 21: >        ^ > SyntaxError: invalid syntax > > Jose Missing parenthesis in T('%d months ago' % int(dt.days / 30) elif dt.da

[web2py] help with password and admin

2010-02-15 Thread mdipierro
Currently in admin you login using a password stored in the file parameters_443.py (443 is the post number). I would like the option that if parameters_443.py contains password='posix:root' then web2py admin authenticates the visitor using the 'root' password. I do not know how to do it but it w

[web2py] Re: Error in the trunk

2010-02-15 Thread mdipierro
now to use this you can do: from gluon.tools import prettydate {{=prettydate(request.now,T)}} The T used to internationalize. T is optional. On Feb 15, 7:30 pm, mdipierro wrote: > oops. fixed. > > On Feb 15, 7:20 pm, Jose wrote: > > > Massimo, > > > After updating the following error occurs:

[web2py] any suggestions for managing DB schema with visual ERD tool?

2010-02-15 Thread snfctech
Before I decided on moving forward with web2py for prototyping my current project, I built a complicated, visually appealing entity relationship diagram in MySQL Workbench. I like having this ERD to keep my brain straight, but I'm wondering how to keep using this as I move forward with web2py. It

[web2py] Re: web2py site problem ?!

2010-02-15 Thread villas
On Feb 15, 11:41 pm, mdipierro wrote: > There are some vps services that offer 350MB ram and 20GB for the same > price. I'm sure you are right. I found a $3 host the other day! Anyhow, those on a really tight budget will work a little harder to shoehorn their app into GAE. Wishlist: The first

[web2py] An enhanced BEAUTIFY class

2010-02-15 Thread John Heenan
I have just put up a new web2slice that includes a manual patch for the BEAUTIFY class. The entry is at http://www.web2pyslices.com/main/slices/take_slice/58 I would like to propose that the patch or an equivalent one makes it way into the web2py trunk. If it does then I can change the web2py sli

[web2py] Re: web2py vs. customizing existing e-commerce app

2010-02-15 Thread villas
Reports: With web apps, so much info can now be gleaned from the screen by 'drilling-down' that the need for nicely formatted, printable reports is diminishing somewhat. However, there's still no limit to the information that staff would potentially like to have, and to deny them would reduce t

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

2010-02-15 Thread Thadeus Burgess
dope. I forgot you had to do all of that conversion stuff :) -Thadeus On Mon, Feb 15, 2010 at 5:42 PM, mdipierro wrote: > errors in conversion from latex > > On Feb 15, 4:25 pm, Thadeus Burgess wrote: >> Look athttp://web2py.com/book/default/section/6/8under the code samples. >> and hereht

Re: [web2py] help with password and admin

2010-02-15 Thread Thadeus Burgess
Potential security risk validating against root. but a user account definitely. -Thadeus On Mon, Feb 15, 2010 at 7:46 PM, mdipierro wrote: > Currently in admin you login using a password stored in the file > parameters_443.py (443 is the post number). > > I would like the option that if para

[web2py] Auth class and login time

2010-02-15 Thread reyelts
Does the auth class squirrel away the login time (assuming auth.is_logged_in()==True? If so, how does one retrieve it? -- 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 f

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

2010-02-15 Thread mdipierro
Please do not make change in the next 24hrs. I am plying with the dns. On Feb 15, 9:17 pm, Thadeus Burgess wrote: > dope. > > I forgot you had to do all of that conversion stuff :) > > -Thadeus > > On Mon, Feb 15, 2010 at 5:42 PM, mdipierro wrote: > > errors in conversion from latex > > > On Feb

[web2py] Re: help with password and admin

2010-02-15 Thread mdipierro
I am not suggesting that as a general solution. What I have in mind is an appliance with a single account (root or whatever). The root password is the only parameter set by the hosting provider and communicated to the user. The user never ssh into the vps. He instead uses the provided password to l

[web2py] Re: Auth class and login time

2010-02-15 Thread mdipierro
session.auth.last_visit On Feb 15, 10:06 pm, reyelts wrote: > Does the auth class squirrel away the login time (assuming > auth.is_logged_in()==True? If so, how does one retrieve it? -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to

Re: [web2py] Re: help with password and admin

2010-02-15 Thread Thadeus Burgess
what if i want my server to host ssh mercurial repositories ? -Thadeus On Mon, Feb 15, 2010 at 10:32 PM, mdipierro wrote: > I am not suggesting that as a general solution. What I have in mind is > an appliance with a single account (root or whatever). The root > password is the only paramet

[web2py] IS_NULL_OR vs IS_IN_DB with brackets

2010-02-15 Thread reyelts
I have a field that I want validated in an SQLFORM, but I don't want a dropbox. The book directs us to use brackets as follows: If you want the field validated, but you do not want a dropbox, you must put the validator in a list. db.dog.owner.requires = [IS_IN_DB(db, 'person.id', ')] I als

[web2py] they are copying us....

2010-02-15 Thread mdipierro
http://haineault.com/blog/125/ P.S. Of course we have 3 years of head start and the web2py architecture was designed for this, theirs isn't. -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroup

Re: [web2py] Re: how to display date and time nicely?

2010-02-15 Thread Jason Brower
These examples would be a very good edition to the book -- J On Mon, 2010-02-15 at 16:19 -0800, mdipierro wrote: > for lack of a better option I put it in tools for now. > > On Feb 15, 5:56 pm, Richard wrote: > > added a few more cases: > > > > def prettydate(d): > > try: > > dt = da

[web2py] extend login method of Auth class

2010-02-15 Thread reyelts
I'd like to extend the login method of the Auth class to do a couple of initialization things based on the login. Based on what I've been reading, it looks like I *should* be able to do something like this: from gluon.tools import * class MyAuth(Auth): def login( self,

[web2py] Re: extend login method of Auth class

2010-02-15 Thread mdipierro
It is simpler that that def mystuff(form): do_something_with(form.vars) auth.settings.login_onaccept=mystuff On Feb 15, 11:37 pm, reyelts wrote: > I'd like to extend the login method of the Auth class to do a couple > of initialization things based on the login. Based on what I've been > read

[web2py] Re: IS_NULL_OR vs IS_IN_DB with brackets

2010-02-15 Thread mdipierro
close db.dog.owner.requires = [IS_NULL_OR(IS_IN_DB(db, 'person.id', '))] On Feb 15, 10:53 pm, reyelts wrote: > I have a field that I want validated in an SQLFORM, but I don't want a > dropbox. The book directs us to use brackets as follows: > >    If you want the field validated, but you do not

[web2py] Re: help with password and admin

2010-02-15 Thread mdipierro
explain more please On Feb 15, 10:35 pm, Thadeus Burgess wrote: > what if i want my server to host ssh mercurial repositories ? > > -Thadeus > > On Mon, Feb 15, 2010 at 10:32 PM, mdipierro wrote: > > I am not suggesting that as a general solution. What I have in mind is > > an appliance with a s

[web2py] web2py 1.75.2 is Out

2010-02-15 Thread mdipierro
- no more cron with -S option - ability to override/upgrade and app - gluon.tools.prettydate - crud.archive - better uuid avoids conflicts on replicated servers in the cloud We moved from EC2 to VPS.net. Much cheaper and easier to manage (automatic nightly, weekly and monthly backups for example).

  1   2   >