[web2py] Re: Select table in drop down import the file and edit

2013-07-04 Thread Rohitraj Sharma
http://127.0.0.1:8000/appname/default/form http://127.0.0.1:8000/admin/default/design/child On Tuesday, 2 July 2013 12:01:54 UTC+5:30, Anthony wrote: Your code includes: web2py_component({{=URL('default', 'form.load')}} + / + jQuery(this).val(), target='form') That will issue an ajax

[web2py] Re: SQLFORM.grid custom applications

2013-07-04 Thread Massimo Di Pierro
I would do: db.define_table('city', Field('city_name'), format = '%(city_name)s' ) db.define_table('shop', Field('shop_name'), Field('city_id', 'reference city') ) On Wednesday, 3 July 2013 17:56:56 UTC-5, Kamil wrote: Hello guys, I tried SQLFORM.grid for a while and couldn't

[web2py] Re: Can Sql (sqlite) injections occur if normal html forms are used?

2013-07-04 Thread Massimo Di Pierro
Forms do not affect SQL injections as long as you use the DAL to communicate to the database. If you use row SQL you may be vulnerable to SQL injections. On Thursday, 4 July 2013 00:43:23 UTC-5, qwer qwer wrote: I have used normal html forms instead of web2py forms at many places.Does this

[web2py] Re: SQLFORM.grid custom applications

2013-07-04 Thread Kamil
Thanks, adding format='%('city_name)s' solves the first problem. That's obviously in the book... But the line db.children.city.requires = IS_IN_DB(db, db.parent.id,'%(name)s') doesn't work actually. I get: type 'exceptions.AttributeError' 'DAL' object has no attribute 'parent' -- --- You

[web2py] Re: Select table in drop down import the file and edit

2013-07-04 Thread Rohitraj Sharma
On Tuesday, 2 July 2013 12:01:54 UTC+5:30, Anthony wrote: Your code includes: web2py_component({{=URL('default', 'form.load')}} + / + jQuery(this).val(), target='form') That will issue an ajax request. I was asking what URL ends up getting requested by the browser. Anthony On

[web2py] Re: websocket_messaging.py example: browser WebSocket connection error

2013-07-04 Thread Jurgis Pralgauskis
any ideas why? and how could I debug in more detail? I'm on Ubuntu 12.04.2 LTS 2013 m. liepa 2 d., antradienis 15:33:06 UTC+3, Jurgis Pralgauskis rašė: Chrome error log says: WebSocket connection to 'ws://127.0.0.1:/realtime/mygroup' failed: Unexpected response code: 426 the mesagges

[web2py] Re: SQLFORM.grid custom applications

2013-07-04 Thread Rohitraj Sharma
sorry bro in place of parentther should be table name db.children.city.requires = IS_IN_DB(db, db.tablename.idhttp://db.parent.id/ ,'%(name)s') On Thursday, 4 July 2013 14:02:52 UTC+5:30, Kamil wrote: Thanks, adding format='%('city_name)s' solves the first problem. That's obviously in the

[web2py] csv split

2013-07-04 Thread Rohitraj Sharma
I need a little help of you. I have three table county which contains ID and country name 2nd table is State table which contain state id, state name country id 3rd table is city table city id, city name, state id and county id. i have one master csv file of city table which contains name of

[web2py] Crowdsourcing platform in Web2Py?

2013-07-04 Thread D.P.
Hello, it is my first post in this group, and it is a pleasure to be in, as I really think that web2py is a great tool. I am trying to see if there is any opensource crowdsoucing platform made in web2py? Does any know any of any code example? Regards, D. -- --- You received this message

Re: [web2py] Re: Example for JqGrid

2013-07-04 Thread Rohitraj Sharma
links are not working On Tuesday, 8 June 2010 06:06:42 UTC+5:30, JayLotz wrote: Sorry, I have not used the plug-in with inline editing. On 06/07/2010 11:53 PM, Tomy wrote: Thanks Jason. I have already this plug-in(inline edit) used, but validation(for Date and Time) is not working

[web2py] form ajax

2013-07-04 Thread Dmitri Husti
Hi, I cant figure out how to use FORMS with ajax. Howto refresh the FORM in frontend if you dont pass the validation. And howto renew the data in frontend if the validation was passed and a new row is in the database. The whole thing with ajax. A small example would be nice. Best regards Dmitri

[web2py] Re: OT: Python Tools for Visual Studio

2013-07-04 Thread villas
Interesting! Thanks for posting this, I didn't know about it. I wonder whether anyone here has used this for web2py? Along with pyCharm's recent announcement for web2py support, we are seeing some interesting IDE options. I occasionally use Wing and find it very useful. On Wednesday,

[web2py] Re: websocket_messaging.py example: browser WebSocket connection error

2013-07-04 Thread Jurgis Pralgauskis
in tornado.websockets.py I find line: HTTP/1.1 426 Upgrade Required\r\n what could it mean? https://github.com/facebook/tornado/blob/60693e011cc0602d83a29ac37fa7263eda107f61/tornado/websocket.py#L151 2013 m. liepa 4 d., ketvirtadienis 11:57:16 UTC+3, Jurgis Pralgauskis rašė: any ideas why?

[web2py] Re: websocket_messaging.py example: browser WebSocket connection error

2013-07-04 Thread Jurgis Pralgauskis
ps.: how to use newer module of tornado? as in system install I have python-tornado 2.1.0-2ubuntu0.1 2013 m. liepa 4 d., ketvirtadienis 15:24:04 UTC+3, Jurgis Pralgauskis rašė: in tornado.websockets.py I find line: HTTP/1.1 426 Upgrade Required\r\n what could it mean?

[web2py] programmatically processing a form

2013-07-04 Thread Vikas Gupta
The client I am using is android, hence cant use web based forms. e.g. currently i am working on the request reset password. The client will capture the email id and call a controller function with email id as an argument. That function basically should send an email to the user with a link

[web2py] Re: Can view, but can't edit files

2013-07-04 Thread Niphlod
I don't think anyone ever reported an issue with a slow connection, except of course for longer loading times. AFAIK there is no stop-sign in any code in admin that prevents a resource from loading if it is not fetched within N seconds. On Wednesday, July 3, 2013 6:36:38 PM UTC+2, Woody wrote:

Re: [web2py] Crowdsourcing platform in Web2Py?

2013-07-04 Thread Relsi Hur Maron
What features you need? I'm developing a project of crowdsourcing here, is commercial but I'll release a part of the application opensource, with the following features: - add/listing of jobs - add/listing workers and portfolios - signup employee and company - submission of Proposals - internal

[web2py] Re: programmatically processing a form

2013-07-04 Thread Anthony
Maybe something like this: def reset_password(): user = db.auth_user(email=request.vars.email) if user: return 'success' if auth.email_reset_password(user) else 'failure' else: return 'invalid email address' You would send a request like

[web2py] Re: form ajax

2013-07-04 Thread Anthony
The easiest method is to put the form in an ajax component: {{=LOAD('mycontroller', 'myform.load', ajax=True)}} What do you mean by renew the data in frontend? Are you showing a grid on the same page as the form? If so, you can load the grid in a separate Ajax component, and add some

[web2py] Re: websocket_messaging.py example: browser WebSocket connection error

2013-07-04 Thread Jurgis Pralgauskis
partially resolved - with pip installed tornado 3.1 and now example works: but in console I see Tornado exception: ERROR:tornado.application:Uncaught exception POST / (127.0.0.1) HTTPRequest(protocol='http', host='127.0.0.1:', method='POST', uri='/', version='HTTP/1.0',

[web2py] Re: form ajax

2013-07-04 Thread Dmitri Husti
Hi, thanks Anthony that was it. Am Donnerstag, 4. Juli 2013 13:55:45 UTC+2 schrieb Dmitri Husti: Hi, I cant figure out how to use FORMS with ajax. Howto refresh the FORM in frontend if you dont pass the validation. And howto renew the data in frontend if the validation was passed and a new

[web2py] Re: Select table in drop down import the file and edit

2013-07-04 Thread Anthony
On Thursday, July 4, 2013 2:59:17 AM UTC-4, Rohitraj Sharma wrote: http://127.0.0.1:8000/appname/default/formhttp://127.0.0.1:8000/admin/default/design/child That can't be the URL requested by the browser via ajax -- it would be of the form /appname/default/form.load/table_name. Is that the

[web2py] Re: SQLFORM.grid custom applications

2013-07-04 Thread Anthony
Though there is no reason to define the requires in this case, as you get that exact validator by default simply by defining it as a reference field (and specifying the format argument of the parent table). Anthony On Thursday, July 4, 2013 5:50:14 AM UTC-4, Rohitraj Sharma wrote: sorry bro

[web2py] Re: SQLFORM.grid custom applications

2013-07-04 Thread Anthony
Also, in this case it would be '%(city_name)s' rather than '%(name)s'. On Thursday, July 4, 2013 11:31:18 AM UTC-4, Anthony wrote: Though there is no reason to define the requires in this case, as you get that exact validator by default simply by defining it as a reference field (and

[web2py] web2py on the BeagleBone Black up and running!!

2013-07-04 Thread Simon Carr
Just wanted to say thanks for the ubuntu deployment script on the recipes page at http://web2py.com/book/default/chapter/13#Linux-and-Unix I now have web2py running on ubuntu/Apache with my BeagleBone Black and it seems very fast. Here is a link http://www.lancslad.co.uk/welcome/default/index

[web2py] Controller dos not “call” view

2013-07-04 Thread ricgama
Hello, I hope you can help me with this. I have a javascript function call inside my index.html page. function callback1(response, status) { if (status != google.maps.DistanceMatrixStatus.OK) { alert('Error was: ' + status); } else { var distArrayjs = new Array();

[web2py] importing csv file into DAL db outside web2py

2013-07-04 Thread shailaja
Hi, I'm trying to import a csv file into a dal database outside web2py and I'm not able to import values into the referring columns of the database. In my code there are 4 tables created and I'm fetching data from the single csv file into the tables, but when a column of a table is

[web2py] Re: jquery 2.0

2013-07-04 Thread JoeCodeswell
+1 for requirejs. My dyslexia :) *requires* :) i keep things modular, which is why i love web2py. On Monday, April 22, 2013 1:17:30 PM UTC-7, Niphlod wrote: and ship 2 jquery.js AND require.js, and require that every plugin is made requirejs compatible (and that every jquery plugin needs to

Re: [web2py] web2py on the BeagleBone Black up and running!!

2013-07-04 Thread António Ramos
nice! I had web2py working on raspberry pi also. 2013/7/4 Simon Carr simonjc...@gmail.com Just wanted to say thanks for the ubuntu deployment script on the recipes page at http://web2py.com/book/default/chapter/13#Linux-and-Unix I now have web2py running on ubuntu/Apache with my

[web2py] Re: Query with count not returning value with zeros

2013-07-04 Thread villas
Try SQL outer join: http://www.web2py.com/books/default/chapter/29/06#Left-outer-join On Tuesday, 2 July 2013 02:09:19 UTC+1, Francisco wrote: Hi everyone. I'm trying to show how many logins every user has done in the last 7 days in a view. I have the following query:

[web2py] LOAD does not work after upgrading to last GIT

2013-07-04 Thread André Kablu
Hi, I just updated my web2py to last GIT version, and all my LOAD functions stopped working... I did not replaced files, just created a pack and installed on new web2py. All I can see in the LOAD placeholder is loading {{=LOAD('controller', 'second_frame', ajax=True)}}

[web2py] Re: LOAD does not work after upgrading to last GIT

2013-07-04 Thread André Kablu
Ok just got it... I replaced static folder and it worked... Something that was changed in there will not accept backward compatibility. Em quinta-feira, 4 de julho de 2013 16h22min10s UTC-3, André Kablu escreveu: Hi, I just updated my web2py to last GIT version, and all my LOAD functions

[web2py] Re: LOAD does not work after upgrading to last GIT

2013-07-04 Thread LightDot
Hm. This is probably a good example of things to come when web2py 2.6.x gets released :/ Anyway: https://groups.google.com/d/msg/web2py/UEaJD2osfY0/iN-khcMfrkgJ Perhaps this thread (linked) should be pinned to the top. Regards, Ales On Thursday, July 4, 2013 9:32:33 PM UTC+2, André Kablu

[web2py] Solve the error when creating a self signed certificate on Ubuntu server?

2013-07-04 Thread ebseknib
Hi, The script https://web2py.googlecode.com/hg/scripts/setup-web2py-ubuntu.sh running almost good, Just got error at the echo creating a self signed certificate openssl genrsa 1024 /etc/apache2/ssl/self_signed.key and it shows the error: -bash: /etc/apache2/ssl/self_signed.key:

[web2py] Got error when create SSL for VPS Ubuntu 12.04

2013-07-04 Thread ebseknib
Hi, The script https://web2py.googlecode.com/hg/scripts/setup-web2py-ubuntu.sh running almost good, Just got error at the echo creating a self signed certificate openssl genrsa 1024 /etc/apache2/ssl/self_signed.key and it shows the error: -bash: /etc/apache2/ssl/self_signed.key:

[web2py] Firebird Embedded URI errors

2013-07-04 Thread Cornelius L
I get invalid uri errors connecting to db with Firebird embedded. Whenever I do: db = DAL('firebird_embedded://sysdba:masterkey@c:\\tests\\test1.fdb') I get error: raise SyntaxError(Invalid URI string in DAL: %s % self.uri). I tried other variations of the URI e.g back slashes, single slashes

[web2py] Re: Firebird Embedded URI errors

2013-07-04 Thread villas
Maybe something like this would work ... ? 'firebird_embedded://SYSDBA:masterkey@localhost:3050/C:/tests/test1.fdb' On Thursday, 4 July 2013 22:45:07 UTC+1, Cornelius L wrote: I get invalid uri errors connecting to db with Firebird embedded. Whenever I do: db =

[web2py] Re: Firebird Embedded URI errors

2013-07-04 Thread villas
Yes, I think your uri string is probably ok. It appears to be a bug in DAL.py This line: 'firebird_embedded': FireBirdAdapter, Should probably be: 'firebird_embedded': FireBirdEmbeddedAdapter, Maybe you could try it (if you are running web2py source). Don't forget to restart the

[web2py] Re: SQLFORM.grid custom applications

2013-07-04 Thread Kamil
Right... Any ideas about other problems? Thanks guys... -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more

[web2py] Re: Use model in another app

2013-07-04 Thread tomt
Occasionally I have written a web2py app that makes use of a model/db from another app. Basically, all that I do is define additional database connections in models/db.py to the old app, and redeclare all the table definitions. I attempt to prevent accidental structure changes to the external

[web2py] Re: Select table in drop down import the file and edit

2013-07-04 Thread Rohitraj Sharma
Thanks Anthony On Thursday, 4 July 2013 20:59:46 UTC+5:30, Anthony wrote: On Thursday, July 4, 2013 2:59:17 AM UTC-4, Rohitraj Sharma wrote: http://127.0.0.1:8000/appname/default/formhttp://127.0.0.1:8000/admin/default/design/child That can't be the URL requested by the browser via ajax