[web2py] Re: SELECT .... IN

2011-08-07 Thread guruyaya
Oh... That simple... Well, I feel stupid now. I'll just go write my code, and hope my wife won't see it. On Aug 7, 5:37 pm, Marin Pranjic wrote: > Hi, > > you can do: > array = [1,3,6] > db(db.tablename.fieldname.belongs(array)).select(db.tablename.ALL) > > > > > > > > On Sun, Aug 7, 2011 at 3:0

Re: [web2py] Re: Where to put the .htaccess file

2011-08-07 Thread Kenneth Lundström
> Well I tried to put the same code in httpd.conf file but it doesn't work, I have a "Syntax Error" when restarting apache because the command "RewriteEngine " is not recognized. Do you have this line in the httpd.conf file: LoadModule rewrite_module modules/mod_rewrite.so Without it, it won'

[web2py] Insert not working on Keyed Table

2011-08-07 Thread Andrew
Hello, I'm doing the most simple form to test out Keyed Table Functionality. I've followed some examples from the examples app and some code from the web2py book. My DBMS is MS SQL. When I enter some data on my basic entry form and press submit, nothing happens. In order to debug I added the f

[web2py] My search Engine with ÄÖÅ doesn't work, what is my best approach?

2011-08-07 Thread encompass
I have something like this as a search engine parameter: http://interestid.com/search.json/theSearch And that returns the result for the search for "theSearch" Sadly however, I forgot about foreign characters like ÖÄÅ. What is my best solution for doing a search system like this? Best Regards, Jas

Re: [web2py] Re: Comet Server

2011-08-07 Thread Re Fabro
Dudes, I never use, but sounds interesting. And one of the key issues ... crossbrowser http://www.ape-project.org/ * Obrigado, Renato Fabro* C2C Balloon - Humanizing Technology +55 (19) 3289-9610 http://www.c2cballoon.com 2011/8/7 Anthony > On Sunday, August 7, 2011 1:27:08 PM UTC-4, Francisc

[web2py] Re: Comet Server

2011-08-07 Thread Anthony
On Sunday, August 7, 2011 1:27:08 PM UTC-4, Francisco Costa wrote: > > On Jul 16, 5:16 pm, Anthony wrote: > > Maybe check out this three part tutorial: > http://greg.thehellings.com/2011/04/web2py-websockets-and-socket-io-p > > The third part ( > http://greg.thehellings.com/2011/05/web2py-we

[web2py] Re: Why is_active?

2011-08-07 Thread pbreit
I think the idea is to never delete a record but instead set is_active to False. I think setting readable=writable=False should get it out of your way. Maybe that should be the default?

[web2py] Re: using sum with left join

2011-08-07 Thread Cliff
Google for COALESCE in your database engine of choice. You can use it to force (coalesce) null values to zero or 'None.' I don't know if the DAL knows about COALESCE, though. You may have to make some native SQL. On Aug 6, 6:54 pm, Tim Korb wrote: > I have a table ("log") of points awarded to

[web2py] Re: Where to put the .htaccess file

2011-08-07 Thread yannick Tchatchoua
Actually I don't want Web2py to handle .htaccess file permission. What I want is to force the url to use "www" and I modify .htaccess file, my problem is I don't know where to put the file ? Can you point me out where I can put that file. If no can you tell me how I can resolve that issue ? Thanks

Re: [web2py] Re: New Plugin: plugin_ckeditor

2011-08-07 Thread Tito Garrido
Is it stable? Is that patch mentioned before already applied? Regards, Tito On Sun, Aug 7, 2011 at 7:17 AM, Marin Pranjic wrote: > https://bitbucket.org/PhreeStyle/web2py_ckeditor > > 2011/8/7 António Ramos : > > Where can i download this pluging from? > > > > It is not in the plugin area of we

[web2py] Re: Where to put the .htaccess file

2011-08-07 Thread Massimo Di Pierro
Why? Do you want the web2py app to handle htaccess permissions? Before you do that try look into this instead scripts/access.wsgi Massimo On Aug 7, 2011, at 1:18 PM, Yannick wrote: > Hello mate, > I want to force "www" in front of the url and i modify the .htaccess > file to do so and now I won

[web2py] Why is_active?

2011-08-07 Thread guruyaya
Let me start by saying I love auth.signature. But as you can see from the title, it comes with a price, I find hard to accept. The is_active record, is kinda irritating. I don't need it most of the time, if I do need to use it - I'll never call is "Is Active" in a form I'm showing to my users, and

[web2py] Re: Postgres quoted identifiers

2011-08-07 Thread Álvaro J . Iradier
Hi Massimo, any progress on this? I need to migrato from MySql to Postgres and this issue is stopping me (I'd like to avoid making changes on the database right now). If you think it might be good to include this, I can start working on it and provide patches. I don't like the idea of keeping my o

[web2py] Re: Generic View is not loading...

2011-08-07 Thread encompass
And just to be a bit precise: def allow_generic(*types): def _(f,types=types) : for t in types: response.generic_patterns.append(f.__name__+'.'+t) return f return _ It was missing a colon.

[web2py] Re: Generic View is not loading...

2011-08-07 Thread encompass
Fancy! Now that is a nice feature. I will be implementing this in many of my sites. BR, J

[web2py] Re: Where to put the .htaccess file

2011-08-07 Thread Yannick
Thanks for the reply. Here is the code I use to force "www" in the .htaccess file: RewriteEngine on RewriteCond %{HTTP_HOST} !^www.mywebsite.com RewriteRule (.*) http://www.mywebsite.com/$1 [R=301,L] Well I tried to put the same code in httpd.conf file but it doesn't work, I have a "Syntax Error"

[web2py] Re: plugin_wiki & PowerPack

2011-08-07 Thread Gour-Gadadhara Dasa
On Sun, 7 Aug 2011 11:01:53 -0700 (PDT) Massimo Di Pierro wrote: > No but there should be. :-( Let's hope there will be. Sincerely, Gour -- “In the material world, conceptions of good and bad are all mental speculations…” (Sri Caitanya Mahaprabhu) http://atmarama.net | Hlapicina (Croatia)

[web2py] Re: deploying few web2py sites

2011-08-07 Thread Gour-Gadadhara Dasa
On Sun, 7 Aug 2011 11:01:34 -0700 (PDT) Massimo Di Pierro wrote: > You can install one web2py and have as many apps under it as you like. > By default they have separate dbs and separate appadmins. They will > have one admin. Did I tell you that web2py is great!!! > I never run more than one we

Re: [web2py] Where to put the .htaccess file

2011-08-07 Thread Kenneth Lundström
> I want to force "www" in front of the url and i modify the .htaccess file to do so and now I wonder where to put that file. I tried to put it in the "web2py/apps" directory, in the "web2py/apps/views" directory, in the "web2py/" directory but none of them works. I'm using apache as webserver.

[web2py] Re: deploying few web2py sites

2011-08-07 Thread Gour-Gadadhara Dasa
On Sun, 07 Aug 2011 20:56:45 +0300 Kenneth Lundström wrote: > I think the usual way is to have one instance of web2py installed and > every application is in it's own folder in the applications folder. Good. > If you want to have a own domain name or sub domain name for each > application you

[web2py] Where to put the .htaccess file

2011-08-07 Thread Yannick
Hello mate, I want to force "www" in front of the url and i modify the .htaccess file to do so and now I wonder where to put that file. I tried to put it in the "web2py/apps" directory, in the "web2py/apps/views" directory, in the "web2py/" directory but none of them works. I'm using apache as web

[web2py] Where to put the .htaccess file

2011-08-07 Thread Yannick
Hello mate, I want to force "www" in front of the url and i modify the .htaccess file to do so and now I wonder where to put that file. I tried to put it in the "web2py/apps" directory, in the "web2py/apps/views" directory, in the "web2py/" directory but none of them works. I'm using apache as web

[web2py] Re: Generic View is not loading...

2011-08-07 Thread Massimo Di Pierro
def allow_generic(*types): def _(f,types=types) for t in types: response.generic_patterns.append(f.__name__+'.'+t) return f return _ @allow_generic('html','json') def index(): On Aug 7, 11:36 am, encompass wrote: > It's too bad we couldn't do it as

[web2py] Re: XHTML markup validation nits

2011-08-07 Thread Massimo Di Pierro
Can you please open an issue in google code and post specific example? On Aug 7, 11:28 am, weheh wrote: > I am cleaning my XHTML through the W3C validation service and I'm > turning up a bunch of web2py XHTML that doesn't pass validation. > Mostly nit-picky stuff like

[web2py] Re: plugin_wiki & PowerPack

2011-08-07 Thread Massimo Di Pierro
No but there should be. :-( On Aug 7, 11:21 am, Gour-Gadadhara Dasa wrote: > Hello! > > I saw on devel list that the author is working on new PowerPack version and > wonder what is the relationship between plugin_wiki & PowerPack? > > Are they supposed to complement each other, make one obsolete

[web2py] Re: deploying few web2py sites

2011-08-07 Thread Massimo Di Pierro
You can install one web2py and have as many apps under it as you like. By default they have separate dbs and separate appadmins. They will have one admin. I never run more than one web2py instance on the same machine. I do not see any reason for it. For example http://web2py.com http://web2py.com

[web2py] Re: mongoDBAdapter test ......

2011-08-07 Thread Francisco Costa
On Aug 6, 6:34 pm, joseph simpson wrote: > It is my understanding that some people are interested but they do not have > the time to create the adapter. > > May or may not have time to test but would put it on the priority list. > > Have fun I would fully test the adapter

Re: [web2py] deploying few web2py sites

2011-08-07 Thread Kenneth Lundström
> I believe that we'll settle on Web2py (over Django) for our future web needs (moving from PHP to Python) and I'm not 100% clear how does deployment with Web2Py go...iow, does one install one instance of web2py and install specific app for each site, e.g. {app1,app2,app3} or it is required to

[web2py] Re: MongoDB supported by DAL

2011-08-07 Thread Francisco Costa
Is anyone working on the MongoDBAdapter? On Aug 5, 11:25 am, David Marko wrote: > > Mongo over couch? > > Why? > > Adhoc Queries ...

[web2py] Re: Comet Server

2011-08-07 Thread Francisco Costa
On Jul 16, 5:16 pm, Anthony wrote: > Maybe check out this three part > tutorial:http://greg.thehellings.com/2011/04/web2py-websockets-and-socket-io-p > The third part > (http://greg.thehellings.com/2011/05/web2py-websockets-and-socket-io-p...) > discusses > usage of Socket.IO to handle meth

[web2py] Import: a chicken-and-egg problem

2011-08-07 Thread Michael Ellis
I'm using the web2py shell mode to run a background process, let's call it toplevel.py, that waits on pipe for incoming data, processes, and stores it in the db. Works beautifully. Even supports forking a child process that monitors the db and sends periodic reports and alerts by email to a syst

[web2py] Re: Generic View is not loading...

2011-08-07 Thread encompass
It's too bad we couldn't do it as a decorator or similar. That way we could know which pages have the exceptions directly rather than opening (or searching) for another file with the correct line. On Aug 7, 10:13 am, Massimo Di Pierro wrote: > in models or controllers > > response.generic_patter

[web2py] Re: Crud.select creates a table in textarea

2011-08-07 Thread Hybride
db.select did the same, and so I checked the documentation, and SQLForm also converts into a table. So I did something more cleverish (I think?): for those who need to do the same, the result will only work with db.select (maybe SQLForm, but haven't tested). I created a for loop to grab just the r

[web2py] XHTML markup validation nits

2011-08-07 Thread weheh
I am cleaning my XHTML through the W3C validation service and I'm turning up a bunch of web2py XHTML that doesn't pass validation. Mostly nit-picky stuff like

[web2py] plugin_wiki & PowerPack

2011-08-07 Thread Gour-Gadadhara Dasa
Hello! I saw on devel list that the author is working on new PowerPack version and wonder what is the relationship between plugin_wiki & PowerPack? Are they supposed to complement each other, make one obsolete or redundant? Sincerely, Gour -- “In the material world, conceptions of good and

[web2py] deploying few web2py sites

2011-08-07 Thread Gour-Gadadhara Dasa
Hello, I believe that we'll settle on Web2py (over Django) for our future web needs (moving from PHP to Python) and I'm not 100% clear how does deployment with Web2Py go...iow, does one install one instance of web2py and install specific app for each site, e.g. {app1,app2,app3} or it is required t

[web2py] Re: Deployment Confusion

2011-08-07 Thread Gour-Gadadhara Dasa
On Sun, 30 Jan 2011 14:46:02 -0200 Bruno Rocha wrote: > AS I said,I know only two host options where you can simply put the > files there and everything runs without the need of configuration. > ['Google App Engine', 'webfaction'] I use djangohosting.ch (djangoeurope.com) for PHP sites, but soon

Re: [web2py] SELECT .... IN

2011-08-07 Thread Marin Pranjic
Hi, you can do: array = [1,3,6] db(db.tablename.fieldname.belongs(array)).select(db.tablename.ALL) On Sun, Aug 7, 2011 at 3:05 PM, guruyaya wrote: > Hi guys. > Is there a way to use a SELECT... IN... syntax in dal? Something like > "SELECT * FROM auth_user WHERE id IN (1,3,6) > If not, I'll expl

[web2py] SELECT .... IN

2011-08-07 Thread guruyaya
Hi guys. Is there a way to use a SELECT... IN... syntax in dal? Something like "SELECT * FROM auth_user WHERE id IN (1,3,6) If not, I'll explain my use case, and hope to get your best answer. I have 2 dbs, one holds auth_user, the other holds some data (projects in this case), with the id of the u

Re: [web2py] Re: New Plugin: plugin_ckeditor

2011-08-07 Thread Marin Pranjic
https://bitbucket.org/PhreeStyle/web2py_ckeditor 2011/8/7 António Ramos : > Where can i download this pluging from? > > It is not in the plugin area of web2py > Thank you > António > 2011/8/6 tomt >> >> Hi, >> >> I was having trouble editing existing data with web2py_ckeditor until >> I applied B

Re: [web2py] Re: New Plugin: plugin_ckeditor

2011-08-07 Thread António Ramos
Where can i download this pluging from? It is not in the plugin area of web2py Thank you António 2011/8/6 tomt > Hi, > > I was having trouble editing existing data with web2py_ckeditor until > I applied Bruno's patch. > > Before applying this patch, the plugin could save new data, but it > wo

[web2py] Re: Generic View is not loading...

2011-08-07 Thread Massimo Di Pierro
in models or controllers response.generic_patterns=['*'] will enable them all. They have been disabled because there are some security issues. You may want to be more selective: response.generic_patterns=['myactions.json', '.html'] On Aug 7, 2:06 am, Jason Brower wrote: > I just realised my g

[web2py] Generic View is not loading...

2011-08-07 Thread Jason Brower
I just realised my generic view is not loading. I get: invalid view (default/events.html) When I get rid of events.html in the default folder. I do have the original generic.html but it still doesn't work. Any reasons why this would happen? BR, Jason Brower