I see -- you're right.
The request.args structure is a List() object which web2py defines to
retrieve values without the exception if it doesn't exist. It has some
additional interesting capabilities... You can define a default value,
such as this:
request.args(0,default='Both')
This
Sorry, I had a typo in the line. Now it is working - put
auth.messages.label_password= 'Password ' with space in the model.
Thank you very much Niphlod
On 06/11/12 23:53, Niphlod wrote:
did you put that between
auth = Auth(...)
and
auth.define_tables() ?
On Tuesday, November 6, 2012
were you seriously thinking about transferring 1.9gb of files through an
upload form ?
transfer the app using other methods such as ssh or ftp.
On Wednesday, November 7, 2012 8:08:20 AM UTC+1, Kimmo wrote:
Hi,
I have a packed a Web2py application that is about 1.9Gb (lots of upload
Does the share button work properly for anyone when using google+? If it
works for you, is there any tip that you have. If it does not work for
anyone, can this bug be fixed.
Thanks
Peter
On Sunday, 4 November 2012 11:08:47 UTC, peter wrote:
I just tried filling in this bit in db.py
##
uhm, good point on if you want the entire table, just remove the filters.
how to handle something that is impossible to handle (export a table with
so many rows that you can't export without timeouts or consuming
memory). just timeout ?
On Wednesday, November 7, 2012 2:17:02 AM UTC+1,
On Saturday, 1 October 2011 09:40:26 UTC+2, seongjoo wrote:
I figured out what the problem was but forgot to come back to the
forum.
The problem was that the keys of the dictionary was encoded as
unicode, for example u'keyname'. It was in unicode because the dict is
loaded from json.
I have the following code:
form = SQLFORM.factory(
Field('relatie_id', writable=False, readable=False),
Field('relatie_nummer', writable=False, readable=False),
Field('direction', writable=False, readable=False),
Field('protocol', writable=False,
woking on 1.
for 2, how do you foresee how much time and RAM the present query will
take to be serialized ?
On Wednesday, November 7, 2012 11:25:29 AM UTC+1, Johann Spies wrote:
On 7 November 2012 10:56, Niphlod nip...@gmail.com javascript: wrote:
uhm, good point on if you want the entire
On 7 November 2012 12:16, Johann Spies johann.sp...@gmail.com wrote:
The result:
{'ui': '0002851186', 'py': '2010', 'vl': '24', 'ris': '4', 'pd': 'NOV'}
Traceback (most recent call last):
File /home/js/web2py/gluon/shell.py, line 223, in run
execfile(startfile, _env)
File
Version 2.2.1 (2012-11-06 14:26:21) stable
It's just me or it doesn't work anymore?
--
Massimiliano
--
something else is wrong in your app, that piece of code works perfectly
fine (the fact that you're declaring 5 fields to let display only one is
quite not understandable but hey, it works nonetheless)
On Wednesday, November 7, 2012 11:32:39 AM UTC+1, Wouter Pronk wrote:
I have the following
Dear Joe ,
What i want to do is to have a query like this :
db( (db.table.Field1 == value) (db.table.Field2 == value or value))
i tried it i get no errors but its now working
Regards
On Wed, Nov 7, 2012 at 10:10 AM, Joe Barnhart joe.barnh...@gmail.comwrote:
I see -- you're right.
The
and i even tried :
items =[]
items.append(request.args(0))
items.append('Both')
db( (db.table.Field1 == value) (db.table.Field2 in items))
regards,
On Wed, Nov 7, 2012 at 12:56 PM, hasan alnator
halna...@gardeniatelco.comwrote:
Dear Joe ,
What i want to do is to have a query like this
Hello Niphlod,
this is the traceback:
Traceback (most recent call last):
File /home/wouter/Web2py/web2py/gluon/restricted.py, line 212, in restricted
exec ccode in environment
File
/home/wouter/Web2py/web2py/applications/edirelaties/controllers/default.py
create a fresh app and paste your code in it. It shouldn't go in exception
form = SQLFORM.factory(
Field('relatie_id', writable=False, readable=False),
Field('relatie_nummer', writable=False, readable=False),
Field('direction', writable=False, readable=False),
field in something is NOT supported (Man, you should check both the web2py
book and general python syntax, or you'll loose a lot of time)
Your prototype in python pointed to have something ORed, i.e. if
request.args(0) is None, then slip it in 'Both'.
What instead you're trying to achieve is
far too magic to check for something that basically isn't trustable: even
if you code something like that and you check that there's x mb available,
another user can ask for another huge set of data and your previoulsy
free RAM is not free anymore.
On Wednesday, November 7, 2012 11:59:18 AM
hello plz i need help i need t write web2py code into javascript ike the
following my code plz any help with the this:
$.fn.fancybox = function(options) {
$(this).data('fancybox', $.extend({}, options));
$(this).unbind('click.fb').bind('click.fb', function(e) {
There is a Field function called contains() which would be useful here.
It is described in the online book here:
http://www.web2py.com/books/default/chapter/29/06#like,-regexp,-startswith,-contains,-upper,-lower
Your query would be something like:
db.table.Field2.contains( [ 'value1',
I just did and it did go in exception. Is my web2py corrupt?
Op woensdag 7 november 2012 12:17:32 UTC+1 schreef Niphlod het volgende:
create a fresh app and paste your code in it. It shouldn't go in exception
form = SQLFORM.factory(
Field('relatie_id', writable=False,
did you try with trunk ?
On Wednesday, November 7, 2012 12:38:40 PM UTC+1, Wouter Pronk wrote:
I just did and it did go in exception. Is my web2py corrupt?
Op woensdag 7 november 2012 12:17:32 UTC+1 schreef Niphlod het volgende:
create a fresh app and paste your code in it. It shouldn't go
if your set doesn't fit into memory, saving it to a temp file won't get you
out of troubles. One of DAL problems is that a Rows object does not return
an iterator from the cursor, it's fetched all into memory first.
On Wednesday, November 7, 2012 12:45:46 PM UTC+1, Johann Spies wrote:
On 7
Having the problem with this as well. Sometimes its works for 5-10 reloads
and then stops until I restart web2py server.
Dne středa, 7. listopadu 2012 11:47:13 UTC+1 Massimiliano napsal(a):
Version 2.2.1 (2012-11-06 14:26:21) stable
It's just me or it doesn't work anymore?
--
Hmmm ,
unsure of how to determine the different table , i tried using
forms.vars.net - as this field is unique to my parent table in the same
oncreate function. So basically , I have forms.vars.xyz from my child table
and able to use it to do what i need. But forms.vars.net is
The record was there.
That's the problem. The shortcut was erroneously reporting that it was
gone.
On Tuesday, November 6, 2012 2:40:38 PM UTC-5, Niphlod wrote:
del db.sometable[something] requires that the id == something exists.
db(db.sometable.id == something).delete() instead returns
On 7 November 2012 14:05, Niphlod niph...@gmail.com wrote:
if your set doesn't fit into memory, saving it to a temp file won't get
you out of troubles. One of DAL problems is that a Rows object does not
return an iterator from the cursor, it's fetched all into memory first.
In that case I
On 7 November 2012 15:01, Johann Spies johann.sp...@gmail.com wrote:
In that case I would be inclined to use bypass DAL and db.executesql and
use the backend to export to a file. That should be more efficient.
Sorry. That should read
... inclined to bypass DAL and use db.executesql ...
--
How does the parametric router handle extensions?When I do a doctest
using app/controller/function.extension, it returns app/controller/index
['function.ext'] instead of app/controller/function as I would have
expected. What am I doing wrong?
--
You're already doing it.
What is your doubt, actually?
On Wed, Nov 7, 2012 at 7:39 AM, Ali Alroomi aro...@gardeniatelco.com wrote:
hello plz i need help i need t write web2py code into javascript ike the
following my code plz any help with the this:
$.fn.fancybox = function(options) {
simpatiCA makes the client certificates already with needed fields.
Since you use openssl directly you can set all the fields you need in the
certificates by changing openssl.cnf in your openssl installation.
There is plenty of documentation on that.
OR you can extend the class X509Auth to fit
Amit,
in your model call the derived class
auth.settings.login_form = MyX509Auth()
2012/11/7 Michele Comitini michele.comit...@gmail.com
simpatiCA makes the client certificates already with needed fields.
Since you use openssl directly you can set all the fields you need in the
Amit,
A self was missing this should work:
class MyX509Auth(X509Auth):
def get_user(self):
self.subject.surname = put something here
X509Auth.get_user(self)
auth.settings.login_form = MyX509Auth()
2012/11/7 Michele Comitini michele.comit...@gmail.com
Amit,
in
at that point you miss formatting fields and references. In addition,
db.executesql() doesn't return an iterator either. You should code your own
exporter using db._adapter.execute() and a yielding fetchone()s.
On Wednesday, November 7, 2012 2:01:45 PM UTC+1, Johann Spies wrote:
On 7 November
From me it works never.
I'm on osx.
Massimiliano
Il giorno 07/nov/2012, alle ore 13:38, David Marko dma...@tiscali.cz ha
scritto:
Having the problem with this as well. Sometimes its works for 5-10 reloads
and then stops until I restart web2py server.
Dne středa, 7. listopadu 2012
but I tried in a shell and it doesn't raise an exception if the record
exists (and it gets correctly deleted too)
On Wednesday, November 7, 2012 1:59:48 PM UTC+1, Cliff Kachinske wrote:
The record was there.
That's the problem. The shortcut was erroneously reporting that it was
gone.
On
2012/11/7 peter peterchutchin...@gmail.com
Does the share button work properly for anyone when using google+? If it
works for you, is there any tip that you have. If it does not work for
anyone, can this bug be fixed.
Thanks
Peter
Yes, for me it's working fine (I've just shared a test
Did some other testing and found simular error on this controler:
def add_relatie():
adres = db.executesql('SELECT adressen.relatie_nummer, | ,
adressen.relatie_code, | , adressen.relatie_naam FROM adressen left join
edirelaties on adressen.relatie_nummer = edirelaties.relatie_nummer WHERE
did you try removing one Field at a time inside SQLFORM.factory and see
where the errors pops up ?
On Wednesday, November 7, 2012 2:58:10 PM UTC+1, Wouter Pronk wrote:
Did some other testing and found simular error on this controler:
def add_relatie():
adres = db.executesql('SELECT
Where is the pass to close the for cycle?
Anyway you seem to be doing it wrong. web2py code runs on the server,
javascript runs on the client (browser), if you want python code to be
executed you need to call a controller, for instance using ajax. Otherwise
all you can put in the javascript
(2, 0, 9, datetime.datetime(2012, 9, 13, 23, 51, 30), 'stable') Python Python
2.7.3: /usr/bin/python Traceback
1.
2.
3.
4.
5.
6.
7.
8.
Traceback (most recent call last):
File /home/www-data/web2py/gluon/restricted.py, line 209, in restricted
exec ccode in environment
File
patch to apply to trunk. Please test it extensively with all the possible
combinations.
On Wednesday, November 7, 2012 2:23:35 PM UTC+1, Niphlod wrote:
at that point you miss formatting fields and references. In addition,
db.executesql() doesn't return an iterator either. You should code
Hi All,
I have these 3 tables among others
db.define_table('workbook',
Field('path',requires=[IS_NOT_EMPTY(),IS_NOT_IN_DB(db,'workbook.path')]),
Field('title',requires=IS_NOT_EMPTY()),
format=%(title)s,
)
db.define_table('chart',
Field('chartName'),
Field('id_workbook',db.workbook),
I noticed that you do not add auth.signature to your table definition. Does
it not work for you?
If is_my_chart was somthing I needed often like I'd be tempted to change:
(full discloser: my track record is not good lately)
db.define_table('chart',
Field('chartName'),
english logic: a chart named 'abc' is mine if there is a record in the
'user_chart' table whose id_user is my user_id and has a chart_id equal to
the id of the 'chart' table whose chartName is 'abc'
DAL syntax:
db(
(db.user_chart.id_user == auth.user_id) ##all charts of the user
Thanks for the reply Bill, but I don't need to know who uploaded the
charts. They are more of a data warehouse. Users subscribe to them and a
reference is created in user_chart.
The bit of my web site I am working on at the moment is where the user
subscribes. I am showing a list of all the
Thanks Batman,
I will give this a try now.
Simon
On Wednesday, 7 November 2012 17:24:34 UTC, Niphlod wrote:
english logic: a chart named 'abc' is mine if there is a record in the
'user_chart' table whose id_user is my user_id and has a chart_id equal to
the id of the 'chart' table whose
Has there been progress in integrating LoginRadius yet? They seem to have
attractive rates compared to Janrain, which might be to costly for
noncommercial projects with a huge user base above 10 or 20k.
On Thursday, July 12, 2012 8:56:25 PM UTC+2, Massimo Di Pierro wrote:
Thank you Sakesh for
Problem here to, I reboot web2py instead of trying if track_change true
work each time I make change to my module.
Richard
On Wed, Nov 7, 2012 at 8:26 AM, Massimiliano Belletti
mbelle...@gmail.comwrote:
From me it works never.
I'm on osx.
Massimiliano
Il giorno 07/nov/2012, alle ore
LOL Thanks,
On my re-design my previous table had
requires=lambda v,r:
IS_INTEGER_IN_RANGE(0, int((r.pstop-r.pstart)*1)),
but that no longer works so I changed it and applied typecasting when I
forgot forgot my order of ops.
Thanks a bunch.
--
Greetings...
I have a bash script that uses cURL to send a json packet of data in order
to save it in sqlite DB.
#!/bin/bash
message=$1
uid=$2
url=https://somehost;
curl -v -k -X POST -H Content-Type: application/json --data
{\message\: \This will prbbly be my lst post.\, \uid\:
I'm certainly no expert, but I'm also on webfaction and you may want to
consider using nginx/uwsgi. At least in my case, there was very little I
needed to worry about in terms of configuration/memory management. Just two
tricks:
- no need to install nginx, as you can just use webfaction's
I have this piece of code that calls a function in my controller when
clicked.
{{=A('Add to My Charts',callback=URL('subscribe_form',vars={'chartname':
chart.chartName}),target=str(chart.chartName).replace('.','_'))}}
The subscribe_form function looks like this
def subscribe_form():
Why would you need to create an action for the form? Are you not using self
submit?
On Wednesday, November 7, 2012 12:22:03 PM UTC-7, Simon Carr wrote:
I have this piece of code that calls a function in my controller when
clicked.
{{=A('Add to My
table is there, curl is there, but how about something you coded in the
controller ? Without that we can't help you .
On Wednesday, November 7, 2012 7:48:28 PM UTC+1, Mike Anson wrote:
Greetings...
I have a bash script that uses cURL to send a json packet of data in order
to save it in
The URL with the form in is web2py_xlchart_dashboard/charts/user_charts so
without an action it will submit to *user_charts*, but I need it to submit
to* subscribe_form *which is the function that was called by AJAX to
generate the Form.
or am I not understanding something?
Simon
On
Hi Niphlod,
It's a super simple controller below:
def call():
exposes services. for example:
http:///[app]/default/call/jsonrpc
decorate with @services.jsonrpc the functions to expose
supports xml, json, xmlrpc, jsonrpc, amfrpc, rss, csv
return service()
Wait a sec. callback and target are meant to load a fragment via ajax, but
that doesn't fire all the logic needed to intercept FORMs etc.
_callback and _target are meant roughly as an onclick under steroids.
(under the hood it translates to an onclick=ajax(url, target))
What you're trying to
Yes, but without that I wouldn't have been able to tell you: Follow the
protocol, Mike! :P
You are publishing a service behind the jsonrpc protocol, but you surely
missed on how to interact with them ^_^
Every request per the spec has to carry an id , a method and a params value
in the json
Hi,
Did you have the time to check it up ?
On Tuesday, November 6, 2012 1:40:39 PM UTC, Massimo Di Pierro wrote:
This is not normal and it is scary. It could be a ldap issue of a
ldap_login issue. I will check it asap today.
Massimo
On Tuesday, 6 November 2012 05:24:26 UTC-6, apinho
Thanks very much Niphlod. I am much closer now..
However I am getting this response:
{version: 1.1, id: 1, error: {message: method \save_message\
does not exist, code: 100, name: JSONRPCError}}
from this script:
url=https://domain.net:8000/ircmessage/rpc/call/jsonrpc;
curl -v -k -X POST -H
Thank you, but how do I implement this in my view so that it loads the form
into a div when the link is clicked?
On Wednesday, 7 November 2012 20:00:52 UTC, Niphlod wrote:
Wait a sec. callback and target are meant to load a fragment via ajax, but
that doesn't fire all the logic needed to
supposedly you have call() and save_message() in default.py
The url to call the webservice would then be /appname/default/call/jsonrpc .
On Wednesday, November 7, 2012 9:31:51 PM UTC+1, Mike Anson wrote:
Thanks very much Niphlod. I am much closer now..
However I am getting this response:
doesn't it already (provided that there is a div id='whatever'/div in
the page) ?
On Wednesday, November 7, 2012 9:36:27 PM UTC+1, Simon Carr wrote:
Thank you, but how do I implement this in my view so that it loads the
form into a div when the link is clicked?
On Wednesday, 7 November
I prefer using built in uwsgi webserver - very fast and low memory usage
--
PS: I also have websites on webfaction
--
Your right. Thanks mate. I was getting confused over cid. But anyway it
works great for creating the form.
I notice that the form also submits via AJAX. How do I make it submit
normally so that I can have the page refreshed? I need the users list of
subscribed Charts and some other details to
I'm loosing you (too much asked, too little information).
- you have a page --done
- you want a form loaded into a page -- done
- you want it to be submitted to the url that is loaded from -- done (if
it's loaded through ajax, that means that you don't want to reload the main
page, so it can't
So the same code above is now throwing an error and when I even visit
http://127.0.0.1:8000/PROD/default/index. I know I don't feel right using
request variable in my model file so I changed
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
Traceback (most recent call last):
File
I had to remove the underscore in the method name too.
from:
save_message()
to:
savemessage()
#!/bin/bash
message=$1
uid=$2
url=https://host.com/ircmessage/rpc/call/jsonrpc;
curl -v -k -X POST -H Content-Type: application/json -d {\id\: 1,
\method\: \savemessage\, \params\: { \${message}\:
I want it to be loaded with AJAX and submitted normally. The reason is two
fold.
1. The page needs to be refreshed after the form is submitted.
2. By loading the form by AJAX and Submitting normally I am at least
cutting full page loads down by 50%
On Wednesday, 7 November 2012 21:41:23 UTC,
sounds like premature optimization / I don't want to use a LOAD :P
did you try redirecting after the form with type='auto' ? (I think that
that's a feature available in the last few releases...)
On Wednesday, November 7, 2012 11:31:09 PM UTC+1, Simon Carr wrote:
I want it to be loaded with
whoops, actually, the book needs a fix on that.
now it's redirect with client_side=True
On Wednesday, November 7, 2012 11:40:47 PM UTC+1, Niphlod wrote:
sounds like premature optimization / I don't want to use a LOAD :P
did you try redirecting after the form with type='auto' ? (I think that
Thank you. I am grateful for all your help.
Simon
On Wednesday, 7 November 2012 22:43:32 UTC, Niphlod wrote:
whoops, actually, the book needs a fix on that.
now it's redirect with client_side=True
On Wednesday, November 7, 2012 11:40:47 PM UTC+1, Niphlod wrote:
sounds like premature
Thank you, Villas.
--
Thanks Michele, I resolved the issue by overriding class X509Auth :), one
more clarification:
using openssl, i created CA certificates, private key then client and
server certificates with their private key signed by CA certificate,
everything is working fine except:
when I access My application
Version 2.0.9, Postgres 9.X, Psycopg2
I don't know what else to tell you, except I know the record was there
after the failed delete attempt.
Today the same syntax failed in another location in my code, with the same
result. I thought I caught them all, but apparently not.
On Wednesday,
Dear Joe ,
I tried this :
values = []
values.append(request.args(0))
values.append('Both')
sup = db((db.Supplements.Category ==
(request.args(1)).replace('_',' '))
(db.Supplements.Users.contains(values))).select(db.Supplements.ALL)
And it didnt do anything !!! i dont
Yes, I did but no difference. I copied all the files in my app to a new app
and now everthing is fine. Very strange! Thanks for you help Niphlod!
Op woensdag 7 november 2012 15:04:01 UTC+1 schreef Niphlod het volgende:
did you try removing one Field at a time inside SQLFORM.factory and see
78 matches
Mail list logo