Hi Thanks for the reply,
I have got query 2 working with the following:-
qry = request.vars.upn_no
q = (db.pupils.upn_no == qry)
s = db(q)
row = s.select(db.pupils.upn_no,db.pupils.surname)
which gives me the following.
pupils.upn_no pupils.surname
Dalglish
Once in the
for the same exact reason.
NOT field = True
in t-sql means just FALSE, not FALSE and NULL
On Monday, March 9, 2015 at 2:37:46 PM UTC+1, Dmitry Ermolaev wrote:
I use negate - why this not worked?
воскресенье, 8 марта 2015 г., 23:15:49 UTC+3 пользователь Niphlod написал:
booleans in
Dear Web2pyers,
I have dilemma not connected directly to Web2py. I am running / developing
a web application where different projects seek impact investments and
donations. Each project is obliged to submit a report by the end of the
year.
For the first two years we accepted written reports
thelist=[row.first_name for row in db(db.user.upn == 444).select()]
Have you read chapter 6 from the book? It is well worth your time and
should help with most of your questions.
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer
-Jim
On Monday, March 9, 2015
I'm new to web2py, but do have a php and mysql background using codeigniter.
I'm trying to write a couple of queries but sure how to do them.
These are the queries I'm trying to write,
query1
SELECT user.s_name, user.f_name, user.year, pe.date, pe.sport, pe.id
FROM user
INNER JOIN pe
ON
Dear All,
I am facing the same problem for storing a large number of data files.
My database backend is PostgreSQL. And I am using the default fs with
separated folder selected.
I would like to know if there is other choices of file system recommended
for my case, besides buying Amazon S3
If you just need to store the reports, then just use XML blobs.
If you need to do math on data within the reports (i.e. analytics across
projects) then break it into a schema.
On Monday, March 9, 2015 at 9:48:23 AM UTC-4, Najtsirk wrote:
Dear Web2pyers,
I have dilemma not connected directly
I use negate - why this not worked?
воскресенье, 8 марта 2015 г., 23:15:49 UTC+3 пользователь Niphlod написал:
booleans in T-SQL are not treated the same way as python. in T-SQL,
NULL values are neither True or False, they are just NULL.
So, if you want closed either None or False, you
This should do what you want :
https://groups.google.com/d/msg/web2py/oiyOIC0IH04/6-NvVOJECU8J
I remember having post this solution somewhere else (other thread) and
other web2py users had posting many other solution but can find it back...
You have at least this solution that work very well and
Hi
My view is basic at the moment just showing the column headings and results
from db.
{{extend 'layout.html'}}
h1Results/h1
{{=row}}
The headings show :- pupil.upn_no and pupils.surname with the results
underneath.
what I would like to do is put the results in my own table.
coming
What does your view look like?
Also, this chapter should be helpful:
http://web2py.com/books/default/chapter/29/05/the-views
-Jim
On Monday, March 9, 2015 at 8:56:38 AM UTC-5, Garry Smith wrote:
Hi Thanks for the reply,
I have got query 2 working with the following:-
qry =
Hello Annet,
I have hard time follow... It could be easier I think if you just pasting
the view with the LOAD() that don't work and both controller the main page
and the loaded page...
Thanks
Richard
On Mon, Mar 9, 2015 at 5:45 AM, Annet anneve...@googlemail.com wrote:
I have the following
Me and my team is fine since we are always on the edge :) .
But i would like to see input from old wizards that uses Old RedHat
for servers and Debian 4.x .
On Sun, Mar 8, 2015 at 10:04 AM, Ron Chatterjee
achatterjee...@gmail.com wrote:
I use 2.7.6 from canopy. I will b okay.I think...
--
Hi again after reading chapter 6,
I have found what I'm looking for.
I did the following and got thre results I wanted.
{{for r in row:}}
p{{=r.surname}}p
{{pass}}
One other question I would like to ask.
web2py works a lot like codeigniter for php using MVC, does web2py let you
use jquery to
Hello all.
I would like to add a global search form in a website, the classical one
with one field and a search button.
I've got some idea's about how doing it, but I would like to know if
there's an example on line, or if someone have some suggestions.
Thanks.
--
Resources:
-
On Monday, March 9, 2015 at 9:53:42 AM UTC-7, Ron Chatterjee wrote:
you need to do
{{response.files.append(URL('static','js/java_script_file_I_am_runnning.js))}}
in web2py before ajax call layout.html
and then use
script
your function
/script
Correct me if I am wrong. Someone?
Wonder if he can try to make it a list and do list.remove?
Have you tried that?
On Thursday, March 20, 2014 at 3:07:47 PM UTC-4, Leonel Câmara wrote:
I think you should have a third table anyway or searches for T-shirts of a
given colour will be quite slow.
--
Resources:
-
you need to do
{{response.files.append(URL('static','js/java_script_file_I_am_runnning.js))}}
in web2py before ajax call layout.html
and then use
script
your function
/script
Correct me if I am wrong. Someone?
On Monday, March 9, 2015 at 12:12:47 PM UTC-4, Garry Smith wrote:
Hi again
Annet
Bear in mind that within .load extension files you dont write this line
{{extend layout.html}} REMOVE THIS LINE FROM YOUR .LOAD FILE
try this. good luck.
On Monday, March 9, 2015 at 4:45:39 AM UTC-5, Annet wrote:
I have the following page/index.html view:
{{extend
Hi ANdré, did you find a way to solve this?
On Thursday, 20 March 2014 22:10:33 UTC, André Kablu wrote:
Yes just migrated to mongodb, and there really exist some issue.
using CASCADE or SET NULL, it does not matter, web2py does not respect and
remove the reference from the referencing
Sure.
The search field at the top:
http://www.chainreactioncycles.com/us/en
Il giorno lunedì 9 marzo 2015 17:47:09 UTC+1, Ron Chatterjee ha scritto:
Can you give an example of global Search. Any reference site?
On Monday, March 9, 2015 at 12:18:54 PM UTC-4, Gael Princivalle wrote:
Hello
Can you give an example of global Search. Any reference site?
On Monday, March 9, 2015 at 12:18:54 PM UTC-4, Gael Princivalle wrote:
Hello all.
I would like to add a global search form in a website, the classical one
with one field and a search button.
I've got some idea's about how doing
Have you tried,
lastmodified
?
On Monday, March 9, 2015 at 1:31:04 PM UTC-4, Alex Glaros wrote:
ahhh... this worked...needed quotes
db.InternalMessage.subjectLine.represent = lambda value,row: DIV(value,
_style='font-size:75%;color:#656555') if 'modified_on' != None else DIV(
value,
Thank you both for your replies.
I finally found the issue has nothing to do with the controller and views.
I am using a CDN to get jquery, in layout.html I've got:
script src=//code.jquery.com/jquery-1.11.1.min.js/script
{{include 'web2py_ajax.html'}}
and from web2py_ajax.html I removed
ahhh... this worked...needed quotes
db.InternalMessage.subjectLine.represent = lambda value,row: DIV(value,
_style='font-size:75%;color:#656555') if 'modified_on' != None else DIV(
value, _style='font-size:135%;color:#991155')
--
Resources:
- http://web2py.com
- http://web2py.com/book
wait... did NOT work
can anyone type example of correct syntax or say that the concept doesn't
exist?
--
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)
---
SQLFORM.build_query[(db.table.field)]
Passing a list ([]) into that will give you a text in that field. and then
you can use a form input to do the display like the book on page 84 on the
book. Damn I am getting good at this!
On Monday, March 9, 2015 at 1:44:23 PM UTC-4, Gael Princivalle
Hello all.
I've got some news categories:
db.define_table('news_categories',
Field('name', type='string', requires=IS_NOT_EMPTY(), label=
'Nome'),
format = '%(name)s')
And some news:
db.define_table('news',
Field('title', type='string',
can content of one grid field control formatting of other field in same row?
tried many variations including this but got: 'Row' object has no attribute
'modified_on'
db.InternalMessage.subjectLine.represent = lambda value,row: DIV(value,
_style='font-size:75%;color:#656555') if
How do I get the form to autofocus the cursor into the text box? Here's one
of the approaches I've tried.
attributes = {'_autofocus':'autofocus', '_type':'tel',
'_autocomplete':'off', '_style':'height:80px; width:80px'}
score_box = SQLFORM.factory(Field('score', 'integer'), **attributes)
but
db((db.progs.promo==True)).select():
is work!
понедельник, 9 марта 2015 г., 16:58:26 UTC+3 пользователь Niphlod написал:
for the same exact reason.
NOT field = True
in t-sql means just FALSE, not FALSE and NULL
On Monday, March 9, 2015 at 2:37:46 PM UTC+1, Dmitry Ermolaev wrote:
Hello,
is there a way to do a decode('utf-8') on a string containg for example the
€ sign?
Kenneth
--
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)
---
not work:
for pr in db((db.progs.promo.belongs((None, False)))
(db.progs.closed.belongs((None, False.select():
work:
for pr in db(db.progs).select():
if pr.promo or pr.closed: continue
понедельник, 9 марта 2015 г., 16:58:26 UTC+3 пользователь Niphlod написал:
The search function on SQLFORM grid works fine for single terms, but when
typing multiple terms, it doesn't seem to work.
For example:
If I have a field value of 'example example1', it will find it with a
search for 'example' or 'example1'. A search for 'example example1' comes
up with the
Hi,
I have built an PDF report using the Template of pyfpdf, but I have done it
a stupid way. The problem is that I need different templates on every page.
This is not directly a web2py questions, but maybe somebody might have an
idea how to use different Templates on different pages when
with that query you get None or False for both promo and closed. What do
you want ?
On Monday, March 9, 2015 at 8:27:27 PM UTC+1, Dmitry Ermolaev wrote:
not work:
for pr in db((db.progs.promo.belongs((None, False)))
(db.progs.closed.belongs((None, False.select():
work:
thanks Ron. This below really works
db.InternalMessage.subjectLine.represent = lambda value,row: DIV(value,
_style='font-size:115%;color:#33') if row.InternalMessage.modified_on ==
None else DIV(value, _style='font-size:85%;color:#99')
--
Resources:
- http://web2py.com
-
Hi
Thanks for the reply
I have messing about a little with jquery today.
With some success, then not with others.
I put this code in a js file.
function DoAction( id )
{
$.ajax({
type: POST,
url: http://127.0.0.1:8080/School_Clubs/default/test1;,
data: id= + id,
Because web2py_ajax.html is loading jquery if I remember...
Richard
On Mon, Mar 9, 2015 at 2:15 PM, Annet anneve...@googlemail.com wrote:
Thank you both for your replies.
I finally found the issue has nothing to do with the controller and views.
I am using a CDN to get jquery, in
I use SQLFORM to add records to a table. However, one of the fields is a
password which requires=[IS_STRONG(upper=2),CRYPT(salt=False)].
I would like to use SQLFORM to update records in the table, but I run into
a problem: the password field contains the hash of the password, which
will not
Yes, utf-8 is perfectly capable of representing €, that decode should
convert an utf-8 string with the € character into unicode. If you're having
any problems somewhere in your stack something isn't using utf-8.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
-
Try createing a new app from the admin interface and replace it's bootstrap
css-files (in static/css) and js-files (in static/js) with bootstrap3 files
and see what you get.
Regards
Johann
On 5 March 2015 at 07:16, Moiz Nagpurwala moiz...@gmail.com wrote:
Hello,
I'm using latest relaease of
still don't see any reference in the docs..
On Monday, March 9, 2015 at 8:01:13 AM UTC+1, da...@mail.hebrew.edu wrote:
the work around is to set truncate(0).
On Sunday, March 8, 2015 at 5:14:14 PM UTC+2, da...@mail.hebrew.edu wrote:
hi,
after python 2.7.2, seek(0) on an opened file
the work around is to set truncate(0).
On Sunday, March 8, 2015 at 5:14:14 PM UTC+2, da...@mail.hebrew.edu wrote:
hi,
after python 2.7.2, seek(0) on an opened file for append does not seek to
the begining - read the manual.
so LockedFile(...) used by languages, is screwing up the language
I have the following page/index.html view:
{{extend 'scaffolding/outer_layout.html'}}
div class=main
{{include 'page/ad.html'}}
{{if groupcomponent:}}
section class=main-group
div class=container
div id=group-component
{{include 'page/group.html'}}
/div !--
i replied from my mailer, which goggle sent to the moderator :-)
here we go again:
sure, e.g:
https://docs.python.org/2.4/lib/bltin-file-objects.html
look for seek:
*seek*(
*offset*[*, whence*])
Set the file's current position, like stdio's fseek(). The *whence* argument
is optional
the docs:
sure, e.g:
https://docs.python.org/2.4/lib/bltin-file-objects.html
look for seek:
*seek*(
*offset*[*, whence*])
Set the file's current position, like stdio's fseek(). The *whence* argument
is optional and defaults to 0 (absolute file positioning); other values are
1 (seek
Hi All,
My question is about expanding form on dynamically for example.
we have two tables. company and address
now did SQLFORM.factory(db.company,db.address)
Now requirement is says that where company can have multiple address so i
need a button for add more address. On click we need to
48 matches
Mail list logo