[web2py] Re: installing mssql drivers

2012-07-26 Thread Derek
It should work just fine if you are using the source build. Don't use the win32 version of web2py. On Thursday, July 26, 2012 12:32:37 PM UTC-7, jcrowe wrote: Are there any docs on how to install pyodbc to work with web2py. I have it installed in my windows python installation, but that

[web2py] Re: Select Distinct for more than 1 distinct value

2012-07-26 Thread Derek
Usually, when you are asking these kind of questions, you come to realize you are asking the wrong question. On Monday, July 23, 2012 3:15:14 PM UTC-7, Mark Li wrote: I have a database setup with id and 'dogname.' I would like to retrieve distinct values of dogname, but allow for 2 of each

Re: [web2py] BR()

2012-07-25 Thread Derek
Ok, how about {{=(BR()*5).XML()}} On Wednesday, July 25, 2012 11:53:05 AM UTC-7, viniciusban wrote: They don't work. Output is escaped. Try it out. -- Vinicius Assef On 07/25/2012 03:40 PM, Anthony wrote: Though you can do: | {{=BR().xml()*5}} | or |

Re: [web2py] BR()

2012-07-25 Thread Derek
nope... type 'exceptions.TypeError' unsupported operand type(s) for *: 'BR' and 'int' and also... type 'exceptions.AttributeError' 'BR' object has no attribute 'XML' On Wednesday, July 25, 2012 12:09:24 PM UTC-7, Derek wrote: Ok, how about {{=(BR()*5).XML()}} On Wednesday, July 25, 2012 11

Re: [web2py] BR()

2012-07-25 Thread Derek
Better way is this: {{=XML(BR/*5)}} But only because you have a ton less brackets. On Wednesday, July 25, 2012 12:14:09 PM UTC-7, viniciusban wrote: You cannot, too. I've tested. The correct way is: {{=XML(str(BR())*5)}} On 07/25/2012 04:09 PM, Derek wrote: Ok, how about {{=(BR()*5

[web2py] Re: Inconsistent behavior with SqlGrid and referenced tables

2012-07-25 Thread Derek
created_by works because it references db.auth_user and db.auth_user has a format attribute which specifies how it is to be represented. So, your argument '%(name)s' gives it a label, but not a representation. Add a format attribute to those other tables. On Saturday, July 21, 2012 7:13:08 AM

[web2py] Re: Inconsistent behavior with SqlGrid and referenced tables

2012-07-25 Thread Derek
I'll quote Massimo here... http://permalink.gmane.org/gmane.comp.python.web2py/79516 A field has two attributes, requires and represent. If web2py finds a 'reference auth_user but no requires, it assumes db.report.person.requires=IS_IN_DB(db, db.auth_user.id, db.auth_user._format)

Re: [web2py] how to use cache decorator within modules?

2012-07-25 Thread Derek
because this one is really lazy. On Wednesday, July 25, 2012 7:44:20 AM UTC-7, Anthony wrote: Why is it called lazy_lazy_cache, as opposed to just lazy_cache? On Wednesday, July 25, 2012 10:36:50 AM UTC-4, villas wrote: Hi All, For anyone who was interested in this thread, Massimo did

[web2py] Re: how to achieve public/private key authentication for web service in web2py?

2012-07-24 Thread Derek
Might want to try this... https://code.google.com/p/simpatica/ from this post: https://groups.google.com/forum/?fromgroups#!topic/web2py/0kzJf5Kk62Q On Tuesday, July 24, 2012 1:33:48 AM UTC-7, Amit wrote: Hi, I have to provide public/private key authentication for accessing web service

[web2py] Re: Suggestion - a pickled DAL field

2012-07-24 Thread Derek
Make it a computed field? On Tuesday, July 24, 2012 5:34:07 AM UTC-7, Omri Har-Shemesh wrote: Hi web2pyers, very often, I have a field in the table which has to hold a complicated value (most often numpy arrays). The way I implement it is that I use text as the type of field, and then

[web2py] Re: Question about an xml file in use with a JS(jquery) Mappicker in web2py ...

2012-07-20 Thread Derek
As far as I know, web2py does not work directly with XML. It can output to xml automatically, and serializes, but as far as working with xml as data, I don't think it has anything like that. You should be able to use the python standard libraries for that. I prefer xml.dom.minidom, but I've

Re: [web2py] web2py.com offline

2012-07-20 Thread Derek
What, you removed the book? On Friday, July 20, 2012 11:48:09 AM UTC-7, Massimo Di Pierro wrote: By removing the online book, there are no more confidential information on web2py.com This will make it easier to move it and to create mirrors. I will move it next week. After that we will

[web2py] Re: Question about an xml file in use with a JS(jquery) Mappicker in web2py ...

2012-07-20 Thread Derek
Yes, don... XML drive means it takes an XML file as source for the map. It appears the XML is handled client side via javascript. There are no arguments passed to the XML so it is a static file. You would put it in your STATIC folder. On Friday, July 20, 2012 10:58:13 AM UTC-7, Don_X wrote:

[web2py] Re: x509 authentication

2012-07-19 Thread Derek
1. Take a look at x509_auth.py for information on how to do that. It's only 102 lines, so don't be daunted. 2. Yes. On Tuesday, July 17, 2012 4:12:50 PM UTC-7, tiadobatima wrote: Hi guys, After reading the docs, searching through old posts, and scouring the net, I'm hoping someone can

[web2py] Re: Create popular today query

2012-07-19 Thread Derek
You wouldn't be able to do that if you just have a counter which counts the totals. There are several ways to do it. You can log each visit in a table, then query based on time, grouped by table and ordered by count... You could also create a 'daily summary' table that logs page visits to it,

[web2py] Re: Responsive tables

2012-07-19 Thread Derek
Pretty neat, first cell length isn't scrollable on desktop web browser sized too small. On Wednesday, July 18, 2012 4:31:06 PM UTC-7, rochacbruno wrote: http://www.zurb.com/playground/responsive-tables *Bruno Cezar Rocha* http://www.CursoDePython.com.br --

Re: [web2py] Re: CSRF consideration for running web2py with pure JS interface

2012-07-19 Thread Derek
I suppose then that it would make sense to bake his own at this point - create a formkey in the session variables, on submit check the formkey returned. On Tuesday, July 17, 2012 10:15:14 PM UTC-7, Anthony wrote: I am presuming this is the mechanism you use for preventing CSRF attacks -

[web2py] Re: hi

2012-07-17 Thread Derek
Excellent reply. Yes, learning web2py will help you learn the concepts of MVC, SQL, OWASP, Javascript, HTML, JSON, CSS, Python. It's really nice to put those on your resumee. On Sunday, July 15, 2012 2:45:19 AM UTC-7, mart wrote: in my experience brand names do not sell as much as bare bone

Re: [web2py] Re: Recommendations on model file size (database tables)

2012-07-17 Thread Derek
raw maple syrup, well, it flows out of the tree easily enough, and buckets of it seem almost like water, it's not very viscous. Only when you heat it and cook it for a while does it become the thick maple syrup you see on your kitchen table. On Monday, July 16, 2012 5:14:22 PM UTC-7, wdtatenh

[web2py] Re: response.JSON Decimal problem

2012-07-16 Thread Derek
Jsondecoder does not accept Decimal objects. Take a look at serializers.py. You could try converting to float. See here for workarounds... http://stackoverflow.com/questions/1960516/python-json-serialize-a-decimal-object On Monday, July 16, 2012 7:34:25 AM UTC-7, Vineet wrote: Hi ! From a

Re: [web2py] KeyError on pyfpdf

2012-07-16 Thread Derek
Try to use em, see if you still get the same problem. 1em = 12pt http://www.getallfix.com/2011/11/convert-empxpt-and-in-css/ On Monday, July 16, 2012 1:08:13 PM UTC-7, thinkwell wrote: Well, me again. I decided that I wanted to use points as measurements instead of percentages, so now it

[web2py] Re: pg8000 '%' not supported in quoted string

2012-07-16 Thread Derek
So escape it. In Python, % usually refers to a variable that follows the string. If you want a literal percent sign, then you need to double it. %%. Seems like gluon is not escaping it properly. If you can post your whole traceback, I could help you to find out what file you need to add the

Re: [web2py] How to update the cached value?

2012-07-16 Thread Derek
Right. My point was that you shouldn't concern yourself with getting stale values from the database because you cached them, and they changed short of the refresh interval. I have a website that caches things for 15 minutes, and I just tell my users that they won't see changes (on certain

[web2py] Re: Recommendations on model file size (database tables)

2012-07-16 Thread Derek
There should be no benefit to moving them to multiple model files. It would have the same performance (or perhaps slower). The models file is processed on every page load, so it can get expensive if you have a lot of tables defined in it. I'm sure Bruno can chime in here, but here is his recipe

[web2py] Re: hi

2012-07-13 Thread Derek
Alright, nobody has come out and said it - no, there are not a lot of employers posting job offers for Web2py. It seems in the python frameworks space, I see most of them wanting Django. On Thursday, July 12, 2012 2:52:26 AM UTC-7, ahmad wrote: please anyone can tell me about the web2py and

Re: [web2py] How to update the cached value?

2012-07-13 Thread Derek
Right, you are using a ram cache, so you would have to explicitly invalidate the cached items if you want to update them. I would not rely on the time_expire to handle that for you, unless you are really not too concerned about it. The idea of caching is so that expensively computable objects,

[web2py] Re: Any jquery gurus out there?

2012-07-12 Thread Derek
You know, with IE, I have had problems if my script tags didn't have type='text/javascript. On Tuesday, July 10, 2012 3:54:14 PM UTC-7, RKS wrote: I know this is probably not the right place to ask, but I am using w2p and post here pretty frequently so I figured what the heck. I'm also in a

[web2py] web2py - pypy 1.9

2012-07-10 Thread Derek
Just an FYI - I tested running web2py on pypy 1.9... No handlers could be found for logger web2py web2py Web Framework Created by Massimo Di Pierro, Copyright 2007-2011 Version 1.99.7 (2012-03-04 22:12:08) stable Database drivers available: SQLite3, pymysql, pg8000, IMAP Starting hardcron...

[web2py] Re: web2py - pypy 1.9

2012-07-10 Thread Derek
this will disable cron and the cron error message. 2) python the pypy shell (without web2py) try import pymysql (it is in web2py/gluon/contrib). On Tuesday, 10 July 2012 13:12:11 UTC-5, Derek wrote: Just an FYI - I tested running web2py on pypy 1.9... No handlers could be found for logger web2py

[web2py] Re: web2py - pypy 1.9

2012-07-10 Thread Derek
and FYI, using the command line option -N does in fact remove the error message about cron. On Tuesday, July 10, 2012 11:38:38 AM UTC-7, Derek wrote: C:\Temp\web2pycd gluon C:\Temp\web2py\gluoncd contrib C:\Temp\web2py\gluon\contribc:\pypy-1.9\pypy.exe Python 2.7.2 (341e1e3821ff, Jun 07

[web2py] Re: is this a bug in editor?

2012-07-09 Thread Derek
I've seen that happen before. If you have selected text, and you scroll, you get that. I switched to Amy editor, and now I just have issues when I paste... if you go into /admin/default/peek/admin/models/0.py and change TEXT_EDITOR='amy' it seems to work better. Of course, if you scroll with

[web2py] Re: Upload file into DB without SQLFORM

2012-07-09 Thread Derek
That is correct, that's how it's documented as well. On Monday, July 9, 2012 10:48:07 AM UTC-7, Athelionas wrote: Alright, finally I got it working by manually assigning file content to uploaded_data field. Looks like store() function does not actually store data if files are to be placed

Re: [web2py] Re: Thinking of building a bug tracker...

2012-07-05 Thread Derek
It's got a lot more issues than that. It's pretty unusable at the moment. After you get it working, then you have to assign projects to people via ID number, and vice versa. You have to edit the database to get all new people loaded into the system (ie - there is no custom admin module to

Re: [web2py] Re: How much python is needed to learn web2py

2012-07-03 Thread Derek
See, the thing with web2py is because it is such a good design, it is very easy to reason about it, because it is logical and consistent. So, I think it takes a short time to become an expert on it. However, as with anything, mastering takes work. On Tuesday, July 3, 2012 10:36:43 AM UTC-7,

[web2py] Re: Server side rendering requiring js library. Svg to png. D3.js

2012-07-02 Thread Derek
://www.nihilogic.dk/labs/canvas2image/ Thanks, Derek On Monday, July 2, 2012 3:48:04 AM UTC-7, Martin Felder wrote: Hi Andrew, I'm currently looking for a good data vis toolkit for web2py. Currently we are plotting things with matplotlib in the background and display the generated PNGs

[web2py] Re: Web2py hanging with no errors in the log

2012-06-22 Thread Derek
You should look in the error logs. http://127.0.0.1:8000/admin/default/errors/exampleshttp://10.11.58.128:8000/admin/default/errors/examples where examples is the name of your app that was crashing. On Friday, June 22, 2012 1:34:35 PM UTC-7, magoo wrote: Hi all, I have a web2py

[web2py] Re: Error importing ldap_auth module

2012-06-21 Thread Derek
It looks like error 89 is being thrown by your ldap server, not from python. See here: http://www-01.ibm.com/support/docview.wss?uid=swg1IO13737 On Thursday, June 21, 2012 8:34:45 AM UTC-7, ehgonzalez wrote: You rigth, python version is 2.6.6. I copied ldap_auth.py from trunk but it's

[web2py] Re: Auto-generate PUT and DELETE methods

2012-06-21 Thread Derek
Looks like you have Get, Post, and PUT and PUT. Where's Delete? On Wednesday, June 20, 2012 4:39:33 PM UTC-7, Massimo Di Pierro wrote: You can do @request.restful() def api(): response.view = 'generic.'+request.extension def GET(*args,**vars): patterns = 'auto'

Re: [web2py] Re: recognizing web2py restart

2012-06-19 Thread Derek
Look in main.py for the httpserver class. you could handle the cleanup in the stop function, or you could look at widget.py and add a line after the start server function to do the cleanup. On Friday, June 8, 2012 2:04:17 PM UTC-7, Jonathan Lundell wrote: On Jun 8, 2012, at 12:49 PM, Derek

[web2py] Re: I am planning to re-develope my windows applications in python

2012-06-18 Thread Derek
If that's what your application is - define the table in your model, and add a smartgrid and you're done. It has crud (create, read, update, delete) functionality builtin, and sane defaults. a default smartgrid has 'add', 'query', sorting, paging, everything shown in your screenshots. It's so

[web2py] Re: New Google Groups features

2012-06-15 Thread Derek
I think that's great, and one thing that helps me sort out this list and follow what I've commented on are the filters. Just go to filters and select 'all of these' then 'are my discussions' then 'all' and 'apply filter'. That gives me all discussions that I started or replied to. Then to go

Re: [web2py] Re: session in cookies

2012-06-12 Thread Derek
Yeah, if it's AES, it would take at the least 100 years to crack (with 20,000 modern computers), and that's most likely longer than your web application is going to be running. On Tuesday, June 12, 2012 6:07:06 AM UTC-7, Anthony wrote: True. There is an important difference in that the

[web2py] Re: upload - exceptions.MemoryError

2012-06-12 Thread Derek
line 1189, in navbar Can you turn off the 'navbar' and try again? It's trying to urlquote that whole file that you uploaded. On Tuesday, June 12, 2012 1:47:44 PM UTC-7, Janath wrote: Further: I run source on python 2.5. I have this issue when I run source and the executable. On

Re: [web2py] Re: session in cookies

2012-06-11 Thread Derek
On Monday, June 11, 2012 1:31:47 PM UTC-7, mcm wrote: 2012/6/11 Anthony abasta...@gmail.com: Does it make sense if we impose that the in cookie session can be enabled only on SSL session? I assume the cookie is cryptographically signed so it can't be modified, so SSL

Re: [web2py] Re: recognizing web2py restart

2012-06-08 Thread Derek
, 2012 3:48:00 PM UTC-4, Derek wrote: Ah, it seemed to me this is just a development environment and thus you wouldn't need this feature in production? On Thursday, May 31, 2012 2:47:51 PM UTC-7, Jonathan Lundell wrote: On May 31, 2012, at 2:32 PM, Derek wrote: If you're blowing away your

Re: [web2py] Re: recognizing web2py restart

2012-06-07 Thread Derek
Ah, it seemed to me this is just a development environment and thus you wouldn't need this feature in production? On Thursday, May 31, 2012 2:47:51 PM UTC-7, Jonathan Lundell wrote: On May 31, 2012, at 2:32 PM, Derek wrote: If you're blowing away your database, why don't you clear memcached

[web2py] Re: Errors creating/reading tickets

2012-06-07 Thread Derek
The issue has been fixed in trunk. If you want the fix, you'll have to use the source version or wait for the next release. On Thursday, June 7, 2012 4:40:28 AM UTC-7, Chris wrote: Following up on some of the clues others have suggested -- I have this problem when running web2py version

[web2py] Re: default foreign key

2012-06-07 Thread Derek
Have you tried this: db.define_table('dog', Field('name','string'),Field('owner',db.owner,default=db(db.owner.isdefault=True).select().first())) On Thursday, June 7, 2012 2:20:30 PM UTC-7, Vincent wrote: Hi, I'm looking for a way to define a default foreign key dynamically. For example

Re: [web2py] Re: what do you think about waitress webserver

2012-06-07 Thread Derek
Yeah, that whole large files get corrupted when downloading is a big issue... On Tuesday, June 5, 2012 1:14:14 PM UTC-7, Massimo Di Pierro wrote: Good reason to be busy. Anyway, if can assemble a team a people who can reproduce the problem, I can help fix it over IRC chat. Next week. On

[web2py] Re: String EOF error

2012-06-06 Thread Derek
He just said there is a hotfix in trunk - that means you'd want to get the nightly release to fix it, or wait for an official release. He said it's a corrupted ticket, and that's your workaround. So, go to the file system - applications - your application - errors- and delete the tickets there.

[web2py] Re: Anyone using BootSwatch with new web2py layout

2012-05-31 Thread Derek
I don't get why Javascript would be needed for nested menus. http://www.grc.com/menudemo.htm GRC's pure CSS menus work great without javascripts. On Friday, May 25, 2012 1:06:38 PM UTC-7, Massimo Di Pierro wrote: I managed to fix it. Now the carets and class are added automatically via JS

[web2py] Re: recognizing web2py restart

2012-05-31 Thread Derek
If you're blowing away your database, why don't you clear memcached when you blow away your database? I don't see how this is a web2py issue. On Wednesday, May 30, 2012 7:10:13 PM UTC-7, Jonathan Lundell wrote: I've got an application that uses memcached. I'd like to recognize when web2py

[web2py] Re: Get and Post the value from Chrome extension in our database

2012-05-31 Thread Derek
Is there a question? On Tuesday, May 29, 2012 2:06:52 AM UTC-7, Sanjeet Roy wrote: I created the one chrome extension by using manifest.json which is used to pop-up the html page where i want the value in drop-down from our database when the user will be login and they can also submit some

[web2py] Re: hot to Run Python 2.5 scripts from python (for automating PSSE)

2012-05-23 Thread Derek
Then it is an unhandled exception. Which one? Run it in debug mode and see if you can get the stack trace. On Wednesday, May 23, 2012 10:50:41 AM UTC-7, Janath wrote: when following runs at the initialisation, even the web2py server goes down. the line in the bold face, tries to initialise

Re: [web2py] Re: Google Translate

2012-05-23 Thread Derek
Well, if you are using Google Chrome, it will offer to translate sites that are in a language that you don't understand. That works well enough for most websites. I don't bother to offer a translate this site to your language because if they want to do that, they can. If you care about people

Re: [web2py] json2excel

2012-05-23 Thread Derek
All you have to do to export to excel is return a html table and set the headers content-type to -- application/vnd.ms-excel Excel might complain that it's not properly an excel file, but it will open anyway, and display correctly. On Tuesday, May 22, 2012 1:49:11 PM UTC-7, Richard wrote:

Re: [web2py] json2excel

2012-05-23 Thread Derek
That's a java application anyway, not python - that website will not help at all. On Wednesday, May 23, 2012 2:28:06 PM UTC-7, Derek wrote: All you have to do to export to excel is return a html table and set the headers content-type to -- application/vnd.ms-excel Excel might complain

[web2py] Re: Unable to connect to mssql database

2012-05-21 Thread Derek
I've always setup a sql server login specific to my app. The active directory integrated mode doesn't seem to sit too well with Web2Py and MSSQL. On Monday, May 21, 2012 1:08:59 PM UTC-7, Random wrote: I am also getting the same error when I try to setup a DB connection in Django. It is

[web2py] Re: Windows binaries version of Python

2012-05-17 Thread Derek
1. Use Pack All. It creates a W2P file that you can send. The production site would use the upload and install packed... 2. I believe it's developed on 2.7.x - when it says it supports 2.5.x that means it is backwards compatible to that version. No idea what the binary version is - I prefer to

[web2py] Re: modules

2012-05-17 Thread Derek
It should be created automatically. I see it when I go through the wizard and when I create a new simple app. On Thursday, May 17, 2012 2:19:27 PM UTC-7, Aurigadl wrote: the problem was caused because the file is not created __ init__ in the first folder of the project. / myapp /

[web2py] Re: RFC: web2py-based workflow engine

2012-05-17 Thread Derek
I think you are just using abstract examples, though workflows are more than just creating a widget or approving invoices. The standard for workflow support is here: http://www.workflowpatterns.com/ (look here for a tidy list of workflow types...

[web2py] Re: Javascript file in static folder not refreshed

2012-05-10 Thread Derek
/mysnippet.js or /static/js/mysnippet.js?ver=1.2.3 vs /static/js/mysnippet.js?ver=1.2.4 Il giorno martedì 8 maggio 2012 21:25:26 UTC+2, Derek ha scritto: That would fix it for the one system - but if you have site that is used by many, are you going to have everyone empty their cache? Isn't

[web2py] Re: too many redirect message when using login

2012-05-10 Thread Derek
from admin, click 'clean'. On Thursday, May 10, 2012 9:10:58 AM UTC-7, man24 wrote: Yes, I will open a ticket. Is there a simpler way of deleting sessions that does not involve command line action and is automated? I am on mac and using the compiled web2py. Also, by mistake, I have

[web2py] Re: Javascript file in static folder not refreshed

2012-05-08 Thread Derek
That would fix it for the one system - but if you have site that is used by many, are you going to have everyone empty their cache? Isn't there a way to set the cache headers? On Tuesday, May 8, 2012 10:34:30 AM UTC-7, Anthony wrote: It's probably being cached by the browser, so you may need

[web2py] error updating table with notnull=true

2012-05-08 Thread Derek
class 'pyodbc.ProgrammingError' ('42000', [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE only allows columns to be added that can contain nulls, or have a DEFAULT definition specified, or the column being added is an identity or timestamp column, or alternatively if none of

[web2py] Re: error updating table with notnull=true

2012-05-08 Thread Derek
Looks like the workaround is adding a requires=IS_NOT_EMPTY() so the field definition. On Tuesday, May 8, 2012 3:39:36 PM UTC-7, Derek wrote: class 'pyodbc.ProgrammingError' ('42000', [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE only allows columns to be added

[web2py] Re: error updating table with notnull=true

2012-05-08 Thread Derek
it. However, even adding a default didn't seem to help, as I think the 'default' is not set at the database level. On Tuesday, May 8, 2012 3:56:28 PM UTC-7, Derek wrote: Looks like the workaround is adding a requires=IS_NOT_EMPTY() so the field definition. On Tuesday, May 8, 2012 3:39:36 PM UTC

[web2py] override smartgrid 'add' button

2012-05-08 Thread Derek
I'd like to change the link 'Add' in the smartgrid to use my 'register' instead of the default 'new' function. So, to explain, I created a 'register' as shown here: http://web2py.com/books/default/chapter/29/7#One-form-for-multiple-tables it's not actually a registration link, more like a

[web2py] Re: Amazon EC2 discussion: pros/cons, etc.

2012-05-01 Thread Derek
EC2 is good, but why would you use that when you can use GAE? What's the advantage? On Monday, April 30, 2012 2:59:21 AM UTC-7, lucas wrote: hello one and all, i am curious about using a cloud, like Amazon EC2. i don't know anything about it. but i am curious and interested. i have

Re: [web2py] Cookies and Sessions

2012-04-27 Thread Derek
Session cookies would be deleted after browser close, so you'd be assigned a new session. The files are not deleted because the server has no way of knowing if the person has restarted their browser or not. On Friday, April 27, 2012 7:40:55 AM UTC-7, Yago wrote: That makes it all really

Re: [web2py] Cookies and Sessions

2012-04-27 Thread Derek
Oh, one more thing - if you want to delete the sessions, errors, and caches, click the 'clean' button in admin. On Friday, April 27, 2012 7:40:55 AM UTC-7, Yago wrote: That makes it all really clear, thank you so much Anthony. The browser deletes the session cookie when you close it, but

[web2py] Re: How to make an AJAX crawlable app

2012-04-27 Thread Derek
Read the instructions provided by google? On Friday, April 27, 2012 2:11:32 PM UTC-7, Alexander Cabezas wrote: Hi, How can I make a AJAX crawlable app with web2py? https://developers.google.com/webmasters/ajax-crawling/?hl=es-ES

[web2py] Re: welcome application calls lockerz.com ?

2012-04-25 Thread Derek
What Anthony said... Just look for this in your layout.html !-- AddToAny BEGIN -- and remove until this: !-- AddToAny END -- On Wednesday, April 25, 2012 12:45:06 PM UTC-7, sebastian wrote: Hi All, I've just noticed that web2py welcome application is doing calls like this

[web2py] Re: Time to move from Google Groups to a web2py or python??

2012-04-24 Thread Derek
. On Monday, April 23, 2012 2:37:47 PM UTC-7, Derek wrote: That issue tracking app is quite broken, having tried it myself. though from what I hear the forum is solid. I don't know why we aren't using pyforum. On Monday, April 23, 2012 1:33:13 PM UTC-7, Anthony wrote: Back to the original

[web2py] Re: Time to move from Google Groups to a web2py or python??

2012-04-23 Thread Derek
Back to the original topic though - Why doesn't web2py do more dogfooding? I know that using code.google.com is good since it's free, but come one, let's show the world that Massimo puts his money where his mouth is... On Saturday, April 21, 2012 9:24:32 AM UTC-7, JoeCodeswell wrote: This new

[web2py] Re: Time to move from Google Groups to a web2py or python??

2012-04-23 Thread Derek
That issue tracking app is quite broken, having tried it myself. though from what I hear the forum is solid. I don't know why we aren't using pyforum. On Monday, April 23, 2012 1:33:13 PM UTC-7, Anthony wrote: Back to the original topic though - Why doesn't web2py do more dogfooding? I

Re: [web2py] Re: web2py: encrypt uploaded files

2012-04-12 Thread Derek
You put it on the 'accept' or else you make it a job in cron. On Thursday, April 12, 2012 2:35:36 PM UTC-7, naveed wrote: I wasn’t asking as how to encrypt the file itself, but how to incorporate it in to web2py’s existing excellent form upload and download system. Assuming that we have

[web2py] issue tracker application CSC438

2012-04-11 Thread Derek
I downloaded the issue tracker since I have a need to track issues in software that I write. it seems usable, though when I go to app admin, and go to database administration, those queries don't seem to automatically populate. I don't know what's up with that. Also, when creating a new

[web2py] Re: issue tracker application CSC438

2012-04-11 Thread Derek
' is not defined On Wednesday, April 11, 2012 12:08:01 PM UTC-7, Derek wrote: I downloaded the issue tracker since I have a need to track issues in software that I write. it seems usable, though when I go to app admin, and go to database administration, those queries don't seem to automatically

[web2py] Re: Meteor web framework

2012-04-11 Thread Derek
It seems to be the antithesis of web2py - it's made without any considerations into security - those come after the basic functionality. If you are interested in meteor, I suggest you have a look at http://www.wakanda.org/ It's more mature, and a lot better documented. On Wednesday, April 11,

[web2py] Re: process args

2012-04-11 Thread Derek
Correct. You'd need to url encode those characters... http://docs.python.org/library/urllib.html#urllib.urlencode and then use the 'unquote' to get back the original characters. On Monday, April 9, 2012 8:29:43 PM UTC-7, pbreit wrote: I don't think you can have those characters in a URL. And

[web2py] Re: Browser back button: Reloading database results

2012-04-11 Thread Derek
Cache the results? On Wednesday, April 11, 2012 2:07:50 PM UTC-7, DJ wrote: Hello W2People, This may be a simple setting that I am unaware of - how does one retain the database search results when you click the Back Button on the browser without having to refresh the page and confirming?

[web2py] Re: Browser back button: Reloading database results

2012-04-11 Thread Derek
Although one does wonder if Web2Py shouldn't default to the Post/Redirect/Get design pattern... http://en.wikipedia.org/wiki/Post/Redirect/Get On Wednesday, April 11, 2012 2:29:46 PM UTC-7, Derek wrote: Cache the results? On Wednesday, April 11, 2012 2:07:50 PM UTC-7, DJ wrote: Hello

[web2py] Re: Design question. Opinions please

2012-04-09 Thread Derek
I'd put a warning saying you have unsaved changes. or perhaps only allow switching after saving. You could also make your own form, and handle saving all changes with your controller. Web2py has good defaults, and the helpers are good for getting a website up and running quickly, but when you

[web2py] Re: regarding record fetching from database

2012-04-05 Thread Derek
Seems to me he's writing a 'test' type app - you are presented the questions in the random order, and you don't want to be presented the same question again. I think you'd want to store in the session object a list of questions already taken, and make sure your random select excludes that list.

[web2py] Re: LDAP Query for more details

2012-04-02 Thread Derek
And this one specifically for Active Directory... http://www.web2pyslices.com/slice/show/1484/ldap-with-groups-yes-another-recipe On Monday, April 2, 2012 9:39:06 AM UTC-7, Shiv wrote: Hi Team I am doing ldap authentication in my application. Now, i want to get more information from the

Re: [web2py] Re: data source configuration

2012-04-02 Thread Derek
@cache('key', 5000, cache.ram) that's how you cache it... On Monday, April 2, 2012 1:53:15 AM UTC-7, Carlos Correia wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Em 31-03-2012 07:17, Alex escreveu: ok, I think now I understand how the request_tenant works. So there would be

Re: [web2py] Tracking/Tracing actions

2012-03-30 Thread Derek
to that. Thank you. On Mar 30, 2012, at 1:43 AM, Derek wrote: From the documentation: http://web2py.com/books/default/chapter/29/7 A SQLFORM object also deals automatically with upload fields by saving uploaded files in the uploads folder (after having them renamed safely to avoid

[web2py] Re: How to Represent a Foreign Key Using Foreign Keys in Primary Table

2012-03-30 Thread Derek
Just curious as to why you chose list:reference. I'd just do it like this: Field('table_ones', db.table_one ), On Friday, March 30, 2012 12:38:23 PM UTC-7, pjryan126 wrote: I have the following two tables: db.define_table('table_one', Field('first', db.first, '%(name)s'),

[web2py] Re: issue with multi-select widget

2012-03-30 Thread Derek
I'd say the most efficient is: if type(mylist).__name__='string': else etc etc.. On Friday, March 30, 2012 3:36:01 AM UTC-7, weheh wrote: I have a grouping function based on what items are selected in a multi-select widget. When the user presses a button, an ajax call is made to a callback

[web2py] Re: Broken application after upgrade.

2012-03-30 Thread Derek
If you deleted a .table file, fake_migrate will recreate it for you. On Tuesday, March 27, 2012 6:34:58 PM UTC-7, web-dev-m wrote: Just continues trying to connect to any application. The application is still under development. After your suggestion, I dumped my db and deleted everything

[web2py] Re: Python Negative Popularity

2012-03-29 Thread Derek
I can't agree with you more here, Python 3.0 was a major flop, forcing internationalization down everyone's throats, and screwing up string operations for everyone else. On Thursday, March 29, 2012 9:26:48 AM UTC-7, Massimo Di Pierro wrote: I believe the non-backward compatibility of Python

[web2py] Re: Python Negative Popularity

2012-03-29 Thread Derek
I don't think it's quite a fall just that the pot is bigger and they added JS to the JavaScript so it's rankings boosted a bit. On Thursday, March 29, 2012 6:42:08 AM UTC-7, Ovidio Marinho wrote: The fall of the python's fault Django and Python 3.0?

[web2py] Re: Versions earlier than 1.77.1?

2012-03-29 Thread Derek
That's one thing about web2py is that it's stated backwards compatible throughout the documentation. The error you're having is being thrown by the sql server. If your view is comprised of multiple base tables, your update statement needs to only affect one of those tables at a time. So if

[web2py] Re: Smarttable SQLFORM.grid

2012-03-29 Thread Derek
I get what you are saying. I wrote a function (not on web2py, but it's javascript...) // this will capture the 'enter' key when pressed inside the text box, so searching works better. function IEKeyCap(e) { if (e.keyCode == 13) {dsCustomers.filter(myFilterFunc)}; } function

[web2py] Re: Primary Key tables in MSSQL. Cannot get them to work

2012-03-29 Thread Derek
Yes, I don't think you can use SQLFORM crud unless you have an 'id' column, or another primary key column that is an INT. On Wednesday, March 28, 2012 5:28:44 PM UTC-7, Andrew wrote: Thankyou Derek, I will give it a try , but this was only a simple, cut down, test case to get it to work

[web2py] Re: Tracking/Tracing actions

2012-03-29 Thread Derek
Are you getting any error messages? What do you mean by this is not yet working. On Thursday, March 29, 2012 8:10:38 AM UTC-7, blackthorne wrote: Hello, I am working on a secure documentation system that should support file uploads but also to give the ability to trace user actions like

[web2py] Re: help with IS_IN_DB?

2012-03-29 Thread Derek
What does your view look like? On Wednesday, March 28, 2012 5:41:43 PM UTC-7, drayco wrote: I can try to show in form of input and output a dbset, but i want to modify prices, because it depends of store In model if store.store_id7: armazones = db((db.eyewear.observaciones==

[web2py] Re: pop-up verification

2012-03-29 Thread Derek
Take a look at this: http://web2py.com/books/default/chapter/29/7#FORM Specifically this example: db.define_table('numbers', Field('a', 'integer'), Field('b', 'integer'), Field('c', 'integer', readable=False, writable=False)) def my_form_processing(form): c = form.vars.a *

[web2py] Re: Date field mask or another value

2012-03-29 Thread Derek
is certainly a valid year. 99 could be a valid calendar month, depending on your calendar. You should probably specify what the valid range of values are. Try the IS_MATCH with a regex. On Tuesday, March 27, 2012 8:05:11 AM UTC-7, Adriano Almeida wrote: Hi, I want a field (may be

<    3   4   5   6   7   8   9   >