Can somebody please explain to me what this sentence from the book is
trying to tell me?
['mygroup','mygroup']. Tasks will be distributed taking into consideration
that a worker with group_names ['mygroup','mygroup'] is able to process the
double of the tasks a worker with group_names ['mygroup']
It was a year ago that I have tried for 4 days to get the scheduler
working. In the end I gave up and decided to use the operating systems's
cron to handle scheduled jobs.
I am trying again and so far I have no success.
Running web2py with D0 I get the message
Use the admin interface to browse the auth tables and see what is in them.
Regards
Johann
On 6 November 2013 14:29, 黄祥 steve.van.chris...@gmail.com wrote:
thank you so much for your hints, Johann, when i test it not work no error
occured. i can achieve it by define another table called role,
On 6 November 2013 15:33, 黄祥 steve.van.chris...@gmail.com wrote:
btw, i modified the code that you give before into :
models/db_wizard_4_registration.py
if auth.user:
roles = [x.role for x in db((db.registration.doctor ==
db.auth_membership.user_id) (db.auth_membership.group_id ==
so that they are cached as Storage objects. This is faster
but invalidates sessions.
On Wednesday, 6 November 2013 00:35:27 UTC-6, Johann Spies wrote:
On 5 November 2013 22:12, Massimo Di Pierro massimo@gmail.comwrote:
Can you clean the session files and re-try?
Thanks.
Yes that seems
Welcome app works, but in my app I see this (reverting to yesterday's
backup made this problem go away):
web2py™
Version 2.7.4-stable+timestamp.2013.11.03.22.45.08 Traceback
1.
2.
3.
4.
5.
6.
Traceback (most recent call last):
File /home/js/web2py.20131105/gluon/restricted.py, line 217, in
On 4 November 2013 16:47, Richard Vézina ml.richard.vez...@gmail.comwrote:
What the if 'auth' in globals(): for??
If you have it to make sure user it logged you can use the and/or tricks :
if auth.user and auth.has_membership('managers'):
Yes, that is a better way of doing it. My
15:18, Leonel Câmara leonelcam...@gmail.com wrote:
My best guess is that you are doing a response.menu = something, after the
response.menu += documentation_menu. Try using append instead of += and see
if you find it.
Segunda-feira, 4 de Novembro de 2013 13:18:39 UTC, Johann Spies escreveu
On 5 November 2013 22:12, Massimo Di Pierro massimo.dipie...@gmail.comwrote:
Can you clean the session files and re-try?
Thanks.
Yes that seems to solve the problem. Why?
Regards
Johann
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
-
On 31 October 2013 19:00, Niphlod niph...@gmail.com wrote:
it's not a forgotten piece of codeit's there for a reason.
What is the version referring to in admin/0.py/? It if it supposed to be
the current web2py version then it is a piece of forgotten code because in
Web2py 2.7.4. it 0.py
The following configuration stopped working (I suspect with the upgrade to
2.7.4):
I have this in auth_membership:
10 https://crest2.sun.ac.za/nkb/appadmin/update/db/auth_membership/10
johann.spies
https://crest2.sun.ac.za/nkb/appadmin/update/db/auth_user/2managers
(4)
Thanks Richard and LightDot for helping me to understand this.
I misinterpreted the documentation including the part about the apache
configuration. It is now working as it should.
Regards
Johann
--
Because experiencing your loyal love is better than life itself,
my lips will praise you.
I don't know whether it is the best way but I use mercurial for my apps.
That helps to go back to an earlier version of a file when something go
wrong.
Regards
Johann
On 5 November 2013 07:34, Jayadevan M maymala.jayade...@gmail.com wrote:
Let me try rephrasing the question. What is the
Untested:
Something like
roles = [x.role for x in db((db.registration.doctor
==db.auth_membership.user)
db.auth.membership.user == db.group.id
)
).select(db.group.role)]
That should give yo a list of roles for
Thanks Tim and Anthony. I have installed CKeditor and it works very nicely.
Regards
Johann
On 18 October 2013 16:59, Anthony abasta...@gmail.com wrote:
This (advanced_editor) is not documented in the book as far as I can see.
See the end of this
Investing why admin on the server does not use CSS (at least for the
initial view and the 'design' view) I found (using Firebug) that the
references to the static files look like this:
script type=text/javascript src=/admin/static/_2.7.3/js/jquery.js
!DOCTYPE HTML PUBLIC -//IETF//DTD HTML 2.0//EN
not exist
LINE 1: select currval('si.tmp_ut_id_seq')
Regards
Johann
On 22 October 2013 14:28, Niphlod niph...@gmail.com wrote:
ehm... what ? are you searching for the word schema in the code ? :D
see the new rname attribute
On Tuesday, October 22, 2013 2:05:57 PM UTC+2, Johann Spies wrote
On 21 October 2013 21:28, Massimo Di Pierro massimo.dipie...@gmail.comwrote:
I do not understand. You have
r'^\db\.py$',
shouldn't this be?
r'^db\.py$',
Yes it should be. Thanks.
But that does not make any difference to the result:
python web2py.py -M -S nkb/akb
web2py Web
Thanks Anthony and Massimo for *Revision:* *5a3f2701b077 *in the trunk a
few hours ago.
That fixed the problem for me. Both admin and the app works as expected.
Regards
Johann
On 22 October 2013 08:26, Johann Spies johann.sp...@gmail.com wrote:
On 21 October 2013 21:28, Massimo Di Pierro
The only context I can see 'schema' being used in DAL is in connection with
GEO field types.
Regards
Johann
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
+1
--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report
Hallo Massimo,
There is a problem with sorting of model subfolders in 2.7.2. We made some
changes in trunk.
After this morning's updates from the trunk I got problems for the first
time which reflected a sorting problem:
Traceback (most recent call last):
File
On 21 October 2013 11:20, Johann Spies johann.sp...@gmail.com wrote:
In the end I go the app working again by doing:
hg rename db.py 0db.py
hg rename dbcommon.py 0dbcommon.py
I have talked too soon. The admin interface works with this setup but
still not the app itself.
I will have
since the earlier update.
Regards
Johann
On 21 October 2013 11:48, Johann Spies johann.sp...@gmail.com wrote:
On 21 October 2013 11:20, Johann Spies johann.sp...@gmail.com wrote:
In the end I go the app working again by doing:
hg rename db.py 0db.py
hg rename dbcommon.py 0dbcommon.py
Thanks Tim and Anthony. I will first try Anthony's suggestion.
This (advanced_editor) is not documented in the book as far as I can see.
Regards
Johann
On 18 October 2013 05:28, Anthony abasta...@gmail.com wrote:
db.email_prefs.email_order_**received.widget = advanced_editor
Now, this
I suspect it is possible to use a markmin javascript editor (like the one
in the web2py's builtin wiki) to edit forms and save those fields as
containing markmin syntax.
I want to enable users to use stuff like bold/italic words/phrases in text
fields. How do I go about achieving that?
Regards
There is a print statement in gluon/sqlhtml.py at line 2373 if I am
remember correctly. Just comment it out or remove the line.
This was already done in the trunk.
Regards
Johann
On 16 October 2013 06:26, Hadi Sunyoto hadisuny...@gmail.com wrote:
I just check the newest version 2.7.4 in
Thanks!
Regards
Johann
On 10 October 2013 16:28, Vinicius Assef vinicius...@gmail.com wrote:
You can use the onvalidation argument:
http://web2py.com/books/default/chapter/29/07/forms-and-validators#onvalidation
On Thu, Oct 10, 2013 at 10:51 AM, Johann Spies johann.sp...@gmail.com
wrote
When using this form, how can I build a validator (or use some other way)
that ensure that the form will not be accepted if the combination of
survey_id and question_number is not already in the table?
form = SQLFORM.factory(
Field('survey_id', db.survey, default =
On 8 October 2013 15:24, Niphlod niph...@gmail.com wrote:
the smartest thing to do would be to avoid orderby when there are less
records than paginate.
...
What we should orderby to then? The only assured field that has an implicit
index is the id (being a PK). Orderby(ing) a PK should
On 7 October 2013 14:45, Tim Richardson t...@growthpath.com.au wrote:
I'll put this in the book.
Thanks!
Johann
--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)
--
Resources:
- http://web2py.com
- http://web2py.com/book
On 7 October 2013 08:30, Mirko mscavaz...@gmail.com wrote:
Hi,
Is it this one ? https://github.com/mdipierro/web2py-book
Yes.
Regards
Johann
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
-
This code in web2py:
fields = [db.rissue.so, db.rissue.sn, db.rsubject.subject]
query = ((db.rissue.id 0)
(db.rsc_joern_link.rj_id == db.rissue.uuid)
(db.rsc_joern_link.sc_id == db.rsubject.uuid)
)
data = SQLFORM.grid(query,
).
Anthony
On Monday, October 7, 2013 6:41:54 AM UTC-4, Johann Spies wrote:
This code in web2py:
fields = [db.rissue.so, db.rissue.sn, db.rsubject.subject]
query = ((db.rissue.id 0)
(db.rsc_joern_link.rj_id == db.rissue.uuid)
(db.rsc_joern_link.sc_id
On 4 October 2013 12:39, TYRANISTAR makisthegr...@gmail.com wrote:
Thank you for your reply. Do you have an example on how to do that? Sorry
for asking but I am still a newbie at web2py.
Create a view in the backend or use db.executesql(your query creating the
VIEW containing the 'UNION').
On 13 September 2013 18:12, nils n...@olofsson.tv wrote:
I had a problem along the same lines, it turned out that uwsgi was compile
with python 3.3 support.
This was Ubuntu 13.04 and I installed it via apt-get , check the entire
uwsgi logs for the python version.
Thanks for this. I only
Thanks for sharing.
On 23 September 2013 03:03, tomt tom_tren...@yahoo.com wrote:
I thought I'd post the solution I came up with.
It turned out to be easier than I thought it would be. Just read the page
number from request.vars.page, and pass it in the redirect after the
form.accepts.
The type of the field should be 'datetime'.
A timestamp can be done with the following syntax according to the book
(search for 'request.now') :
Field('created_on', 'datetime',
default=request.now, update=request.now, writable=False),
I suspect the timesone-thing can be done with
I think a browser that can utilise the microphone or other devices on a
computer might be a serious security risk.
Regards
Johann
--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)
--
Resources:
- http://web2py.com
-
On 12 September 2013 03:52, Massimo Di Pierro massimo.dipie...@gmail.comwrote:
In both cases print the sys.path.
On 'spyker' where the problem is:
$ python web2py.py -M -S alterit
web2py Web Framework
Created by Massimo Di Pierro, Copyright 2007-2013
Version
I have (as far as I can see) identical configurations on two debian
computers. On one nginx with uwsgi works. On the other, however, I get
the following uwsgi-error in the logs:
Wed Sep 11 22:36:40 2013 - *** Operational MODE: preforking ***
Wed Sep 11 22:36:40 2013 - added
Thanks Anthony. That explains some of the delays when I am using the
grid. As a result of this experience I will try to avoid using it for
queries involving large tables and look at alternatives like Solidtable.
Fortunately with the possibility (probably (co)created by you) to get a
result of
Postgresql would not allow root as a database user. It is also not safe to
work with 'postgres' as your normal user for normal day-to-day usage as
postgres is the superuser for Postgresql. So you have to create a user in
postgresql, create the correct database with the user you created as owner,
On 6 September 2013 20:23, SimonD drennansi...@gmail.com wrote:
I have a complex table, where I want to expose just some of the fields in
a custom form, and am using SQLFORM with a custom form.
I would not use SQLFORM in this case but SQLFORM.factory. In that way you
can handle the updates
On 9 September 2013 14:43, Niphlod niph...@gmail.com wrote:
if you don't need the grid to search through the table, the moment you
turn off the search widget you won't get the performance penalty of
creating the dropbox for the IS_IN_DB requirement you have in your models.
Of cause yes.
On 4 September 2013 15:34, Massimo Di Pierro massimo.dipie...@gmail.comwrote:
Please check with the response.toolbar to see if there is are hidden
recursive queries.
Thanks! I did not use the 'db stats' function before when debugging and
it seems a useful tool!
Interestingly the difference
On my development database I have a table with 115831 records and was
frustrated that a query to show the information in a grid, took a long
time. So I wrote an alternative function not using SQLFORM.grid as a
comparison.
The alternative function took about 2 seconds to show the result on the
On 3 September 2013 11:42, Bassem Bouguerra bougue...@gmail.com wrote:
I am sorry. I am trying to groupby and not orderby.
I want to select from 2 tables and groupby the id of one table. This works
fine in sqllight but throws an error on postgresql.
You cannot do that in Postgresql. If you
On 29 August 2013 15:28, Massimo Di Pierro massimo.dipie...@gmail.comwrote:
Thanks.
Regards
Johann
--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)
--
---
You received this message because you are subscribed to the Google Groups
For weeks I saw 'Failed to setup thread-interuupt handler. This is usually
not critical' but today after updating from the trunk I got the following:
*ERROR:web2py:Traceback (most recent call last):
File /home/js/web2py/gluon/main.py, line 467, in wsgibase
On 13 August 2013 19:29, Evan Caldwell dawg...@gmail.com wrote:
Johann,
I didn't realize you had responded. I am using MySQL
Are you sure?
and getting the error :
class 'sqlite3.OperationalError' no such table: auth_user
The error comes from sqlite!
Anyhow your problem is that you have
I use it as data manager of a research institution to manage several
bibliometric databases. The one I am building at the moment (busy
importing raw data for the past three months) contains information about
more than 43 million pubications. One of the tables (many to many cross
references) has
I am trying to help a friend to get web2py installed on his Windows 2.7
Professional. I do not know Windows very well as I do not use it.
We have tried the following:
Install the Windows version of Web2py and run it. Then we got the error
that the Rocket server started a listener when not
Johann
--
Johann SpiesTelefoon: 021-808 4699
Databestuurder / Data manager Faks: 021-883 3691
Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie
Centre for Research on Evaluation, Science and Technology
Universiteit Stellenbosch.
Rest
Yes, I think the documentation is not correct. It is nonsensical anyhow to
do a groupby when you select all the fields including the primary key id.
Groupby groups similar values and if you do select.ALL there cannot be two
similar records.
Regards
Johann
On 7 August 2013 13:15, Simon Carr
if you use Massimo's suggested code:
db.TaxonomyDetail.objectID.represent = lambda id, record:A(record.objectID,
_target = _blank, _href = URL('manage_object_super_type',id))
Then in ' manage_object_super_type' do something like this:
def manage_object_super_type(): ##
data =
Hallo Alex,
On 30 July 2013 19:25, Alex Glaros alexgla...@gmail.com wrote:
Okay...I have this so far
db.TaxonomyDetail.objectID.represent = lambda ObjectSuperType,record
: A(db.TaxonomyDetail.objectID, _target = _blank, _href =
'manage_object_super_type')
But
1. record:
Here is an example of what I did yesterday. Maybe that will give you a hint:
Field(url, represent = lambda x, record: A('click here for website',
_target = _blank,
_href = x)) ,
In the grid the url column shows a link.
Regards
Johann
--
Because experiencing your loyal
Postgresql has powerful full text indexing and searching capabilities which
you can use.
Here are a few links:
http://es.scribd.com/doc/92440874/Schatten-SQL2012
http://www.espace.com.eg/blog/2009/03/15/postgresql-an-ultimate-strategy-for-full-text-search/
Thanks Richard and Paolo.
Regards
Johann
---
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 options, visit
...@gmail.com wrote:
Johann don't forget to update the other files too...
https://groups.google.com/d/msg/web2py/tVyL7z7WHkw/mce13Vh-k3UJ
Richard
On Wed, Jul 24, 2013 at 4:46 AM, Johann Spies johann.sp...@gmail.comwrote:
On Wednesday, 24 July 2013 09:54:28 UTC+2, Johann Spies wrote:
I have
On Wednesday, 24 July 2013 09:54:28 UTC+2, Johann Spies wrote:
I have not been able to determine the exact course of the problem.
It seems that static/js/jquery.js is the problem. Replacing the file in
the working app with the one from the Welcome app, breaks things.
Regards
Johann
widget. For this reason the issue has been raised.
Il giorno giovedì 18 luglio 2013 10:12:20 UTC+2, Johann Spies ha
scritto:
I took the welcome app (trunk version), added the following model:
db.define_table(toets_radio,
Field('yesno', requires=IS_IN_SET([(0, 'No'), (1,
'Yes
I took the welcome app (trunk version), added the following model:
db.define_table(toets_radio,
Field('yesno', requires=IS_IN_SET([(0, 'No'), (1, 'Yes')]),
widget = SQLFORM.widgets.radio.widget))
And it produced this view there the radio button and the label are
I want to replace the use of the SQLFORM.widgets.radio.widget with a
button-group from bootstrap.
I have never created a custom widget before.
So my question is twofold:
1. How can I use the button group created in the view inside a custom form
in such a way that the result of the button
I would create the three tables with the first one containing the fields as
in the csv file. Then import the csv-file into that table, populate the
other two using SQL with constraints in tables 2 and 3 not to contain
duplicates.
When sucessful, alter the definition of table one dropping the
On 28 June 2013 01:08, Alex mrauc...@gmail.com wrote:
I'd also appreciate schema support for web2py.
+1
--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)
--
---
You received this message because you are subscribed to the Google
On 24 June 2013 14:58, Michael Hall pix...@gmail.com wrote:
Was there ever a fully working solution proposed or discovered for using
executesql with grid and smartgrid?
I don't know of any. What I sometimes do is to use create views or tables
containing the results of complicated SQL-queries
I get a 404 error (Not found) when I try to access web2pyslices.com
Regards
Johann
--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)
--
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
Please help me to understand why the following code works (the link works
without a problem) but not if I enable the view/edit/delete buttons?
fields = [db.sabinet_l1_journal.title,
db.sabinet_l1_journal.issn,
db.sabinet_l1_journal.eissn,
Try changing the third line in to
(T('Login'), False, URL('default', 'user'), []),
and see whether it makes a difference.
Do you still have a 'def user():' function in your default controller?
Regards
Johann
Do
On 12 June 2013 09:28, Sundar Nadimpalli sun...@signumsol.com wrote:
Hi
On 12 June 2013 11:33, Sundar Nadimpalli sun...@signumsol.com wrote:
Thanks for the reply. I did what you suggested but I get an error:
list index out of rangeThe def user(): function is there in the default
controller. If I manually change the URL to:
just saw error in the log and
skipped over the group to tell web2py was not working ? ^_^
On Thursday, June 6, 2013 3:36:40 PM UTC+2, Johann Spies wrote:
On 6 June 2013 12:57, Niphlod nip...@gmail.com wrote:
that just seems to be the version check that admin does when you load
the main page
from the commandline?
Regards
Johann
--
Johann SpiesTelefoon: 021-808 4699
Databestuurder / Data manager Faks: 021-883 3691
Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie
Centre for Research on Evaluation, Science and Technology
Universiteit
On 6 June 2013 12:57, Niphlod niph...@gmail.com wrote:
that just seems to be the version check that admin does when you load the
main page. are you sure that is an error you WANT to patch?
[Tue Jun 04 07:43:49 2013] [error] File
/usr/lib/python2.7/socket.py, line 571, in create_connection
')
|
|The brackets are unbalanced.|
||
|Regards|
|Johann|
||
--
Johann SpiesTelefoon: 021-808 4699
Databestuurder / Data manager Faks: 021-883 3691
Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie
Centre for Research on Evaluation, Science
I never succeeded in getging nginx + wsgi to work properly on Debian. I
went back to Apache and it is just working.
The Ubuntu script is not suitable for Debian.
Regards
Johann
On 28 May 2013 15:04, Fernando Vieira fndia...@gmail.com wrote:
I solved my problem with apache and wsgi, worked
On 20/05/2013 12:53, Niphlod wrote:
if it doens't say query not supported we'll know that the failing
part is in fact the bit that tries to count the records.
Are there any plans to correct this problem or should I create a ticket?
Regards
Johann
--
Johann Spies
The following code results in an error: Query not supported:
query = db.akb_l1_journal.jnl_id ==db.akb_journals_mentioned_in_sa_list.
jnl_id
fields = [db.akb_l1_journal.title, db.akb_l1_journal.abbreviation,
db.akb_l1_journal.issn]
form = SQLFORM.grid(query, fields = fields,
On 20/05/2013 12:53, Niphlod wrote:
probably the bit that tries to count how many records are in it.
Just to try it out, in trunk there's a new cache_count argument to the
grid. can you try adding
||
cache_count=100
Spot-on. Thanks.
Regards
Johann
--
Johann Spies
On 20/05/2013 14:17, Niphlod wrote:
recently the code to count the records changed... did you try trunk
without the cache_count argument ?
Yes. I am working on the trunk as updated about 7 or 8 hours ago.
Regards
Johann
--
Johann SpiesTelefoon: 021-808 4699
On 14/05/2013 07:29, Pawan Jha wrote:
page = request.args(0)
What is the type of this 'page'?
Regards
Johann
--
Johann SpiesTelefoon: 021-808 4699
Databestuurder / Data manager Faks: 021-883 3691
Sentrum vir Navorsing oor Evaluasie, Wetenskap en
In such cases I would use Type01, Type02 in stead of Type1, Type2
Regards
Johann
On 13 May 2013 02:07, rppowell rppow...@hotmail.com wrote:
Here is example code to show what I am doing.
The following is in model/db.py:
db.define_table('item_type',
Field('name'),
On 11 May 2013 09:34, Pawan Jha pawan.pan...@agnicient.com wrote:
def clubCall(ids):
# in this function i want to get all the Checked value of grid
return Working
You have them there: a list of id's. Do something with it :)
Regards
Johann
--
Because experiencing your loyal
Web2py is using Bootstrap. Look at the tutorial at
http://www.w3resource.com/twitter-bootstrap/modals-tutorial.php
Regards
Johann
On 13 May 2013 10:31, Pawan Jha pawan.pan...@agnicient.com wrote:
Hi all
How to open a model pop up in Web2py . please provide me the code
because i am
Thanks!
Shouldn't there be something like this explanation in the book?
Regards
Johann
--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)
--
---
You received this message because you are subscribed to the Google Groups
web2py-users
I do not understand the following in the book:
*The fields argument is a list of DAL Field objects that match the fields
returned from the DB. The Field objects should be part of one or more Table
objects defined on the DAL object. The fields list can include one or more
DAL Table objects in
I get the following error in the book app since the day before yesterday (I
have just updated it with 'git pull'):
File /home/js/web2py/applications/boek/controllers/default.py
http://localhost:8000/admin/default/edit/boek/controllers/default.py,
line 101, in chapter
filename =
Thanks Alan.
Regards
Johann
--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)
--
---
You received this message because you are subscribed to the Google Groups
web2py-users group.
To unsubscribe from this group and stop receiving
After running into a 'integer out of range' problem in Postgresql I was
expecting this addition to my table definition to change the postgresql
definition of the id-field to 'bigint' but it did not happen:
db.define_table('rkeywords',
Field('id', type = 'big-id'),
but this did
On Tuesday, 30 April 2013 11:19:53 UTC+2, Niphlod wrote:
the recommended way to use big-something is DAL(bigint_ID=True), however,
I'm not sure it will trigger a migration.
I'd certainly avoid migrating the PK to another type while the table is
full of zillions rows.
Are you trying to
On Tuesday, 30 April 2013 11:19:53 UTC+2, Niphlod wrote:
the recommended way to use big-something is DAL(bigint_ID=True), however,
I'm not sure it will trigger a migration.
I have tested it on another database and it does not migrate. So I will
have 'ALTER TABLE ALTER COLUMN' in the
What about using the keepvalues option:
From the book:
form.accepts(vars, session=None, formname='default',
keepvalues=False, onvalidation=None,
dbio=True, hideerror=False):
Change keepvalues to True
Regards
Johann
On 24 April 2013 18:23, Niphlod niph...@gmail.com
to convert it to .mobi.
The table of Contents is not what it should be. I used Sigil's
automatic index generation. That can be improved.
Regards
Johann
--
Johann SpiesTelefoon: 021-808 4699
Databestuurder / Data manager Faks: 021-883 3691
Sentrum vir
I have created a .mobi and .epub from the Web2py Book App as it was
this morning SAST.
It is available at Dropbox
https://www.dropbox.com/sh/cb4vu3568oqtezn/UMoEt2AElG for those who
would like to have it in e-book format.
Regards
Johann
--
Johann SpiesTelefoon
On 18/04/2013 15:13, Anthony wrote:
In your other examples, one or more fields are passed to the
.select(), so the DAL has a way to know which table is being queried.
When you pass only a string as the query and no fields to .select(),
the DAL has no way to know which table is involved (it
I have the following in models/0.py:
settings.title =CENTER(IMG(_src=URL('static','images/us_crest_comb.png'),
_style=height:120px; width:auto;,
_alt=T('US-Crest-logo')))
and in menu.py:
response.title = settings.title
Read the file
Apologies, I misread your mail. Niphlod's answer is the correct one for
your purposes.
On 18 April 2013 11:11, Johann Spies johann.sp...@gmail.com wrote:
I have the following in models/0.py:
settings.title =CENTER(IMG(_src=URL('static','images/us_crest_comb.png
Thanks.
I will test your suggestions.
I am currently working with Postgresql 9.1 and it takes nearly 5 minutes to
count a table 42 000 000 records.
It will if we can have the option in the grid to not do a count of the
result as it is part of the problem in my case. If for instance the query
In psql I can do:
select * from isi.rauthor A
where
A.addressfulltext@@'south africa'
but the following
l = db(rauthor.addressfulltext@@'south africa').select()
results in
TypeError: %d format: a number is required, not NoneType
Why?
Model:
from gluon.dal import SQLCustomType
tsv =
201 - 300 of 1172 matches
Mail list logo