Thanks Anthony.
First, take grid out of BEAUTIFY -- not necessary.
Thanks, done.
Does db.t_dogs happen to have a field called name? If so, change the
name of your extra input element to something other than name.
No, it doesn't.
Also, when typing in your input field, open the browser
Really helpful, thanks Anthony.
One suggestion: Chapter 11 of the book, heading The ajax function, has
exactly the code I used (that's where I got it from):
form
input name=name onkeyup=ajax('echo', ['name'], 'target') /
/form
May I suggest that your comment about URLs be included in that
Sorry to bump: can anyone give me a pointer on this?
Thanks.
On Sun, 27 Jan 2013 09:02:45 +, k...@midnighthax.com said:
On Sat, 26 Jan 2013 13:05:50 -0800 (PST), niph...@gmail.com said:
grid takes formargs={}, createargs={}, editargs={}
Thanks. I'm sorry if I'm being a bit slow
On Sat, 26 Jan 2013 13:05:50 -0800 (PST), niph...@gmail.com said:
grid takes formargs={}, createargs={}, editargs={}
Thanks. I'm sorry if I'm being a bit slow here, but I *still* can't get
what I want to work. I've tried:
On Sun, 27 Jan 2013 09:07:50 -0800 (PST), pythonn...@gmail.com said:
for learn more about web2py.
That appears to be the Web2py Cookbook, Copyright Packt Publishing.
Is this legitimate to share in this way? It would appear not, given that
the link on the Web2py pages is to purchase this
Thanks Massimo, but I'm struggling with how to apply this as I don't ever
process the form.
I'm doing:
grid = SQLFORM.grid(...)
return dict(grid=grid, ...)
How would I hook into the grid's process() function?
SQLFORM(...).process(...)
takes two callback functions
I have a SQLFORM.grid, and I hook into edits with 'onupdate'.
Is there an easy way to tell which field(s) have been edited? It seems
that by the time onupdate is called, the database has already been
updated, so comparing the form record with the db shows no differences.
Thanks.
--
We're
On Sun, 8 Jul 2012 23:31:31 -0700 (PDT), too...@gmail.com said:
+1 on removing it...
The internet is covered with too many meaningless share buttons already.
Surely the whole point of the 'welcome' application is to be a scaffolding
to be modified as required? It is much easier for someone new
On Tue, 3 Jul 2012 15:11:10 -0700, bruce.w...@gmail.com said:
So sorry if I find it a little humorous when you think it is still in
development mode
FWIW, I thought the same when I saw, We welcome all the new commers to
join this incredible site, Please full-fill the following form.
Maybe the
On Tue, 3 Jul 2012 15:17:59 -0700, bruce.w...@gmail.com said:
The good news is development is becoming a lot faster as we learned from
a lot of mistakes.
That's nice. I realise you won't have the time right now, but an article
summarising what you've learned would be good one day.
--
We're
What is the mechanism that 'keepvalues=True' uses?
I have a form that uses keepvalues=True, and it includes combo box.
Occasionally the values in the combo change, and the previous value is
missing. I want to check for that and reset the default value for the
combo box if it isn't valid.
Thanks,
I have a combo box on a form to select a company name. The list of valid
company names is derived from a query, q, and so I have:
t = db.t_tasks
c = db.t_companies
t.f_company.requires = IS_EMPTY_OR(IS_IN_DB(
db(q), c.id, '%(f_name)s', zero=All))
That works, but the query
Hi All
I'd like some advice on the best approach to building a search form. I
don't think crud.search is right, but I'm not sure whether I should
approach this using a SQLFORM or SQLFORM.factory or some other way.
The model includes an 'activities' table that has a date column. There's
also a
On Thu, 14 Jun 2012 13:41:18 -0500, j...@qlf.com said:
Here is a screen shot of what mine looks like. I'm using
SQLFORM.factory to generate my 'search' form.
Jim, that looks to be exactly what I'm trying to do.
Again, I'm buried with stuff this week thru Monday. I can help if
Tuesday is
Two questions re SQLFORM.grid sorting.
1. Is it possible to specify the initial sort order?
2. I'm displaying a table that includes a foreign field. When I click on
the header to sort by that field, it sorts by the field id rather than by
the (displayed) foreign field. Can I sort by the
Thanks Jim, I somehow missed the 'orderby' parameter to SQLFORM.grid
On Mon, 21 May 2012 13:11:31 -0700 (PDT), massimo.dipie...@gmail.com said:
foreign key. You can do a join.
Thanks Massimo; however, that's a little cryptic. Could you explain how a
join can be used to determine the sort order
I'm trying to copy a database from Sqlite to MySQL using the cpdb.py
script. In the manual, it states:
cd web2py
python scripts/cpdb.py \
-f applications/app/databases \
-y 'sqlite://storage.sqlite' \
-Y 'postgresql://username:password@hocalhost/mydb'
However, if I do that I get gluon
On Tue, 15 May 2012 14:28:04 -0700 (PDT), shortempe...@gmail.com said:
all I get is a page with elements placed on default location
I would start by looking in the browser at the page source, and see what
is wrong, and I'd check that the CSS file is being loaded. Once you know
how the HTML
On Sun, 13 May 2012 06:21:17 -0700 (PDT), abasta...@gmail.com said:
I suspect there wouldn't be much difference in performance
between the two frameworks (similarly and properly configured).
So long as this is broadly true (which I suspect it is), there are other
considerations to take into
I've just started using flake8 from within vim. Flake8 checks code for
PEP8 conformance and general errors, including undefined names. That means
that running it when editing, say, a web2py controller, lots of warnings
are given:
/path/to/file.py|16| W802 undefined name 'session'
There is an
In case anyone's interested, I've posted a quick and dirty hack to fix
this problem at
https://bitbucket.org/tarek/flake8/issue/14/flake8-fails-to-ignore-errors-warning-from#comment-1385353
--
You can have everything in life you want if you help enough other people
get what they want - Zig
On Sun, 29 Apr 2012 16:54:11 -0700 (PDT), massimo.dipie...@gmail.com said:
It also takes the optional parameter url_onerror which allows redirect
instead of raise HTTP(404).
I kept reading that as url one error, and struggled to understand the
logic. I realise now that it is me that is
In the database admin application, when editing a record from table with a
list:string field, the field is not pre-populated with the current value.
Test model:
db.define_table('t_colours',
Field('f_colour', type='list:string', label=T('Colour')))
db.t_colours.f_colour.requires =
I have a SQLFORM.grid, and I want to add a button to the form used to edit
records (as called from the grid). Is that possible?
--
You can have everything in life you want if you help enough other people
get what they want - Zig Ziglar.
Who did you help today?
On Wed, 25 Apr 2012 15:49:23 -0700 (PDT), varelay...@gmail.com said:
I'm quite new to web2py and a noob at it. I've been struggling with the
difference between cookies and sessions...But I have plenty of questions
about them and how to use them(in web2py)
I think you should approach them
On Thu, 26 Apr 2012 23:23:06 -0700 (PDT), vibhor.purand...@zero-group.com
said:
How to merge more than one template in web2py?
http://web2py.com/books/default/chapter/29/5#Page-layout
--
You can have everything in life you want if you help enough other people
get what they want - Zig Ziglar.
On Sun, 15 Apr 2012 07:36:19 +0100, doncoleon...@gmail.com said:
So you mean I should just click the 'configure' file?
You need to do this from the command line.
And how do I add
the parameters, are u saying
It's you, not u.
You need a open a terminal window and type in the commands you
On Fri, 13 Apr 2012 11:38:25 -0700 (PDT), sababa.sab...@gmail.com said:
But the function does not work, and I can't see what's wrong. Any idea?
You don't make it very easy for others to help. The function does not
work - which function doesn't work, and in what way does it not work?
What input,
On Fri, 13 Apr 2012 11:38:25 -0700 (PDT), sababa.sab...@gmail.com said:
The
function should only add periods that doesn't overlap any of the
already registered ones.
Let me try to help (I owe this group a lot of help). I've ignored your
code, and I don't know what schema you're using, but
On Sat, 14 Apr 2012 09:44:28 +0100, k...@midnighthax.com said:
q = ((db.period.begindatestart)(db.period.enddatestart))
if db(query).count():
Argh. Typos. 'q' and 'query' should refer to the same thing, so change the
second line to 'if db(q).count():' (that change needs to take
On Sat, 14 Apr 2012 05:08:01 -0700 (PDT), doncoleon...@gmail.com said:
but i dont
know what the next line of instruction says
It says run this command:
./configure --prefix=$HOME
...from the Python-2.6.5 directory under your home directory. The
'./configure' is the command that will be run
Are you using Fields of type list:string?
--
You can have everything in life you want if you help enough other people
get what they want - Zig Ziglar.
Who did you help today?
On Wed, 11 Apr 2012 00:11:18 -0700 (PDT), halna...@gardeniatelco.com said:
i am trying to work with session like you showed me but still when i add
somthing it just changes the last element in the session to the element
i added
Show us the code.
--
You can have everything in life you want
On Tue, 10 Apr 2012 21:38:15 -0700 (PDT), massimo.dipie...@gmail.com said:
Please open a ticket about this in google code.
Added: http://code.google.com/p/web2py/issues/detail?id=758
--
You can have everything in life you want if you help enough other people
get what they want - Zig Ziglar.
I have a SQLFORM.grid that says 67 records found, and shows the first 20
(as I would expect). At the bottom, there are four buttons for the pages
(1-4). If I click on any of 2, 3 or 4, I get No records found.
Looking deeper, the URL of the first page is
On Sun, 8 Apr 2012 23:32:31 -0700 (PDT), sanjeet.ro...@gmail.com said:
How to call the multiple function or set the multiple target via Ajax
In the view:
form
input name=name onkeyup=ajax('echo', ['name'], ':eval') /
/form
h3Start of target1/h3
div id=target1/div
h3End of target1/h3
On Mon, 9 Apr 2012 12:28:23 +0100, k...@midnighthax.com said:
def echo():
return jQuery('#target1').html(%s);jQuery('#target1').html(%s); \
%
(repr(request.vars.name.upper()),repr(request.vars.name.lower()))
Sorry, the second '#target1' above should be '#target2'
--
You can have
I've been looking that the unit testing page
(http://www.web2py.com/AlterEgo/default/show/260), which is very helpful.
However, most of my controller functions are decorated with
'@auth.requires_login()', and thus if I call them from the test suite,
they fail (issuing a redirect):
File
Is it possible to hide columns in a SQLFORM.grid?
I need to retrieve some columns in the query to build some custom links,
but I don't want those columns displayed. I've tried setting maxtextlength
for those columns to zero, but they still display.
Thanks.
--
You can have everything in life you
On Sat, 7 Apr 2012 07:41:16 -0700 (PDT), abasta...@gmail.com said:
Before constructing the grid, try db.mytable.myfield.readable = False.
Anthony, very neat, and it works: thank you.
--
You can have everything in life you want if you help enough other people
get what they want - Zig Ziglar.
I'm using clienttools.py to put a timer on a page; the timer calls a
controller function (imaginatively called 'tick') every second, which in
turn updates a div on the page via Ajax. So far, so good.
I want the 'tick' controller function to be able to stop/disable the timer
under certain
On Sun, 25 Mar 2012 16:41:09 -0700 (PDT), niph...@gmail.com said:
Doh, you're right. All the datetime api on fields are extracting, not
converting the actual value
Yes, and I've also found that, with Sqlite at least, web2py doesn't
carry out datetime arithmetic correctly within the DAL
If something like this has already been suggested, please point me at the
earlier discussion.
I've read the Web2py manual (and bought three of them) since v1, and the
quality of both web2py and the manual has improved hugely.
To my mind, however, the manual tries to fulfil two roles currently:
On Mon, 19 Mar 2012 14:45:51 -0700 (PDT), niph...@gmail.com said:
for every period, duration is calculated as:
duration = db.periods.end_time.seconds() -
db.periods.start_time.seconds()
This is wrong.
I reworked my data model so that the period start and stop fields were of
type datetime. I
On Mon, 19 Mar 2012 14:45:51 -0700 (PDT), niph...@gmail.com said:
for every period, duration is calculated as:
duration = db.periods.end_time.seconds() -
db.periods.start_time.seconds()
now, get a list of all durations...
result = db(db.periods.id0).select(db.periods.id, duration)
This
Perhaps you could add the seconds as a virtual lazy field.
That sounds worth investigating, thanks.
We shall come to an agreement when you explain plainly what is your real
model... it seems that your start and end columns are time and not
datetime... Time fields don't have a seconds()
My application has broken moving from 1.99.4 to 1.99.7.
I have a field of type list:string (using Sqlite). In 1.99.7, dal.py
breaks at line 1405 (marked with ):
return str(obj)
if fieldtype.startswith('list:'):
if not obj:
obj = []
elif
I'm having problems getting a valid value for seconds() from a time field
under Sqlite. I can extract a time:
for row in db(db.t_periods.id==40).select(db.t_periods.f_period_end):
... print row
...
Row {'f_period_end': datetime.time(17, 50, 51)}
However, if I try to get the seconds(), it
On Wed, 21 Mar 2012 14:43:42 -0700 (PDT), niph...@gmail.com said:
rows = db(db.t_periods.id==40).select(db.t_periods.f_period_end)
for row in rows:
print row.f_period_end.seconds()
No, that gives an error:
rows = db(db.t_periods.id==40).select(db.t_periods.f_period_end)
for row in
Thanks Niphlod, that looks good and I will try it soon.
--
You can have everything in life you want if you help enough other people
get what they want - Zig Ziglar.
Who did you help today?
I've hit an error (web2py bug?) in Niphlod's well-explained example.
I *was* running web2py.1.99.4, which gave this:
duration=(db.t_periods.f_period_end.seconds() -
db.t_periods.f_period_start.seconds()).sum()
I'm using sqlite, and I'm embarrassed about my errors. Thanks for your
help.
--
You can have everything in life you want if you help enough other people
get what they want - Zig Ziglar.
Who did you help today?
I need to run a reasonably complex query, and I'm wondering whether it
would be better to code it in SQL, or should I try to get the DAL to
provide the data (or maybe there's another way). There's no right or wrong
answer, but I'd welcome opinion on the best approach.
Simply put, consider two
On Sat, 17 Mar 2012 15:03:39 -0700 (PDT), abasta...@gmail.com said:
Instead, you can use auth.user_id, which
will simply return None when the user isn't logged in rather than an
error.
Thanks, that's fixed the problem.
--
You can have everything in life you want if you help enough other
I have a function whose definition starts as follows:
@auth.requires_login()
def rbb_time(category_id, from_date, to_date, user_id=auth.user.id):
It works fine. I'll leave the development of this application for a few
days, come back, run it, and get:
Traceback (most recent call last):
File
I have a form based on a table which includes foreign fields. By default,
the foreign fields are displayed as the name from the foreign table
as expected.
I want to have an image displayed rather than the name from the foreign
table.
Not having used 'format' before, I changed the format of the
Thanks Alan, that has enabled me to do what I want.
--
You can have everything in life you want if you help enough other people
get what they want - Zig Ziglar.
Who did you help today?
It's always a conundrum: does one thank people for helping, and thus
contribute an otherwise content-free mail to the list? Or should one thank
those who helped with a personal mail, thus suggesting to everyone else
that you are ungrateful?
Iceberg, Selecta: thanks for your valuable help. I'm
I was to display a form using Ajax in response to a click on a link on the
page. I have tried putting this in the view:
a href=# onclick=ajax(
'{{=URL(request.application,
'todo',
'new')}}',
[], 'DetailArea') /New todo
/a
with this in the controller:
def new():
On Tue, 11 May 2010 21:16:45 +0100, k...@midnighthax.com said:
return = LOAD('todo','todo_form',ajax=True)
Typo in my mail: that is actually
return LOAD('todo','todo_form',ajax=True)
Sorry, Iceburg, I appreciate your attempt to help, but you've lost me
completely! Can you explain?
Thanks
I don't run web2py.py under the debugger. I just put the following where I
want the first breakpoint:
import pydb
pydb.debugger()
...which drops into the debugger when encountered. No GUI, but I believe
you can hook up DDD to pydb if you are so inclined. Whether that works on
GAE or not, I don't
Hi Iceberg
But I would recommend you use a later version, quoted already in
Omicron's post. It uses RotatingFileHandler to avoid unstoppable log
file size
Thanks for providing it. I can see the sense of your suggestion; however,
I want the logging to be to the standard syslog files (which are
On Tue, 27 Apr 2010 09:31:50 -0700 (PDT), minkto...@gmail.com said:
I'd be interested in a step by step guide to setting up this kind of
logging.
I found some older posts that helped in the end. I now have a
modules/logging.py file that looks like:
def _init_log():
From
I've just found a stupid programming error of mine. Code:
task_rows = db(db.tasks.ref==request.vars.number).select()
if len(task_rows):
rows[0].update_record(status = request.vars.new)
On Wed, 21 Apr 2010 16:59:04 +0200, kuba.kuchar...@gmail.com said:
Is it possible to have this as a trigger/checkbox in admin as an
OPTIONAL behaviour for all errors(not only LOAD components)?
Seconded.
Firebug is fine for those using Firefox, but not for the rest of us.
--
Subscription
', 'new')}}',[], 'DetailArea'
) /New/a
--
|Keith Edmunds
|Tiger Computing Ltd
|The Linux Specialists
|
|Tel: 033 0088 1511
|Web: http://www.tiger-computing.co.uk
|
|Registered in England. Company number: 3389961
|Registered address: Wyastone Business Park,
| Wyastone Leys, Monmouth, NP25 3SR
Does anyone have any sample code showing how to call the Web2py 'ajax'
function from a menu? I currently have this as a link on a page, and I'd
like to move it to a menu item:
a href=# onclick=ajax(
'{{=URL(request.application, 'dopy', 'new')}}',[], 'DetailArea'
) /New/a
Thanks
--
What are others doing for application logging? I'm not referring to the
HTTP logs, but program-generated logs.
I've recently been looking at the Python 'logging' module, which I've not
used before. I initiate logging from a file in the 'modules' directory
which does this:
I have the following (sqlite) table definition:
db.define_table('companies',
Field('name', length=512, default='', unique=True),
Field('oncontract', 'boolean', default=False)
)
From the admin app, I am prevented from adding duplicate company names.
However, from the shell, a sequence of:
On Thu, 15 Apr 2010 15:25:56 -0500, thade...@thadeusb.com said:
sqlite does not enforce types/length, or uniqueness.
I understand about types/lengths, but the uniqueness part doesn't
match with what I'm seeing:
$ sqlite3 /dev/shm/test.db
SQLite version 3.5.9
Enter .help for instructions
sqlite
On Thu, 15 Apr 2010 13:56:19 -0700 (PDT), mdipie...@cs.depaul.edu said:
Is it possible you did not have unique=True when you created the table
and added that later?
Yes, that is the case - thanks for clearing that up, much appreciated.
Keith
--
To unsubscribe, reply using remove me as the
On Thu, 15 Apr 2010 15:06:57 -0700 (PDT), mdipie...@cs.depaul.edu said:
Try on a fresh database it should work.
I have, it did, thank you again.
Perhaps a note in the V3 book about this?
Keith
--
Subscription settings: http://groups.google.com/group/web2py/subscribe?hl=en
On Sat, 10 Apr 2010 15:35:05 -0700 (PDT), hamdy.a.fa...@inbox.com said:
This's most likely to happen if you've more than one form in the same
page so the question is , do you've another form inside the page ?
Thanks for the suggestion, but I don't have any other forms there. I'm
using the
Problem solved. For the sake of others searching on this: some of the
distribution files under applications/my_app were from an earlier version
of web2py.
--
To unsubscribe, reply using remove me as the subject.
What I want to do: have a list of items displayed; when one is clicked,
more detail is shown (via an Ajax call) in a defined detail area.
Problem: the web2py ajax call takes three parameters: a controller action,
one or more field ids, and a target DIV. My controller action needs to
identify
I think you could get some good exposure from LWN - it's one of the more
professional Linux sites (imo, the /most/ professional).
Keith aka BackSeat
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
web2py Web
On Sun, 5 Apr 2009 17:08:31 -0700 (PDT), richar...@gmail.com said:
And my version is
fast becoming out of date with all the new features.
This is not a complaint - I do not expect the book to be free - but the
above point is valid. I too have the printed book, but a lot has changed
since it
I'm returning to web2py after a bit of a break, so maybe things have
changed in the intervening six months or so (well, I'm sure they have).
Version 1.58 (2009-03-10 10:51:30)
I have a SQLite database with a number of rows in it. I had been
retrieving the rows with:
todos_ds =
for www.wellbehavedsystems.co.uk - I can fix the problem by flushing the
local DNS cache here.
If I get time, I'll try to see why it's happening.
Keith
--
Keith Edmunds
+-+
|Tiger Computing Ltd| Helping businesses
Received the web2py book yesterday (I'm in the UK and I had to buy it from
Amazon in the US, and it took a while to ship). Good job, Massimo: I'm
up to page 66 and it reads very well. Much better than the earlier
versions posted on the website, although they were helpful too.
I do have a couple
On Sun, 26 Oct 2008 11:55:08 -0700 (PDT), [EMAIL PROTECTED]
said:
1) what other background tasks do people envisage?
A regular display update via Ajax (but that could probably be demanded by
the client rather than pushed)
2) how should you do it in web2py?
Pass.
--
Keith Edmunds
On Wed, 22 Oct 2008 23:12:24 -0700 (PDT), [EMAIL PROTECTED] said:
This is one reason
why many people don't trust web editors -- they are too prone to lose
work.
Whilst I agree with the basic point you make about somehow saving the
context of the editing if possible, if you don't trust web
83 matches
Mail list logo