Hmm ... if one is gonna be anal about this, I think lost should be used
instead. Some users never really know their passwords or usernames, they
are either recorded somewhere or recorded automatically (autofill?), and in
case they loose this, then they never really forgot since they never
I access a legacy table that contains a number of fields:
db.define_table(source
,Field('sourceID', 'id')
,Field('name', 'string')
,Field('refNumber', 'string')
,Field('actualText', 'text')
,Field('remarks', 'text')
,Field('fields', 'blob'))
The fields field contains an XML description of
congratulations Massimo!
kudos, too, to everyone who makes this mailing list an excellent
peer-to-peer support site. (That goes for you, Anthony.) ;-)
On Monday, January 9, 2012, Anthony wrote:
Offhand, I could think of a custom app for that itch you want to scratch ..
On Tuesday, January 10, 2012, Plumo wrote:
what is the use case for running a web framework on your Android phone?
Do you mean a registered user's email address? It's included in web2py,
just enable it. Check out
http://web2py.com/book/default/chapter/09#Mail-and-Auth
On Friday, January 6, 2012, thstart wrote:
Verifying email account ownership - I am brainstorming for the best way to
know email address
malipayong bag-ong tuig!
On Sunday, January 1, 2012, Massimo Di Pierro wrote:
Happy new year everybody!
I've set showbuttontext=False but all i get are tiny buttons without any of
the default icons. Did I miss anything during the upgrade?
The book states:
In fact db.tablename and reference tablename are equivalent field types.
But this seems to be true only if you are using a single database. I had a
second database, db2 and defined a reference field to it as:
Field('myfield', db2.country)
and Web2Py created the field type:
Thanks to Anthony for correcting my virtual field definition from
geo.ad1.vname=Field.Virtual(lambda r: %s, %s % (r.name,
geo.country(r.id_un).iso3_0))
to:
geo.ad1.vname=Field.Virtual(lambda r: %s, %s % (r.ad1.name,
geo.country(r.ad1.id_un).iso3_0)) #table name specified
However, it seems
Malipayong Pasko!
On Sunday, December 25, 2011, Richard Vézina wrote:
:)
Richard
PS.: Thank you all for helps, particularly Anthony, Massimo...
When I try to access the ad1 table from appadmin, a message is displayed
Invalid Query 'name' and the table isn't displayed. No exceptions or
tickets are generated. If I comment out the virtual field, it works fine.
What is wrong in my virtual field definition below?
geo.define_table('country'
When I try to access the ad1 table from appadmin, a message is displayed
Invalid Query 'name' and the table isn't displayed. No exceptions or
tickets are generated. If I comment out the virtual field, it works fine.
What is wrong in my virtual field definition below?
geo.define_table('country'
When I try to access the ad1 table from appadmin, a message is displayed
Invalid Query 'name' and the table isn't displayed. No exceptions or
tickets are generated. If I comment out the virtual field, it works fine.
What is wrong in my virtual field definition below?
geo.define_table('country'
http://code.google.com/p/web2py/issues/entry
On Wednesday, December 21, 2011, greenguerilla wrote:
Hi guys,
I found a small error in the documentation and was looking for a
bugtracker where I could log this.
Can someone please pass me the url?
Thanks,
John
Martin,
I have a feeling that what you're looking is multi-form updates (try to
search for that term) where a parent record (your person) and child
record (your cvrows) are updated simultaneously.
On Wednesday, December 21, 2011, Jim Steil wrote:
have you looked at SQLFORM.smartgrid?
commas at the beginning of a line is not a common practice, but not
necessarily a bad one. I use it myself, having been bitten by too many
missing commas too often. ;)
On Tuesday, December 20, 2011, Richard Vézina wrote:
I have difficulty to understand your models because they are not in
Couldn't you just add something like this?
#in your db.py, after auth.define_tables()
db.auth_user.email.requires=(IS_LOWER(),IS_EMAIL(),IS_NOT_IN_DB(db,'auth_user.email'))
Or if you use customize your auth tables ...:
Field('email', length=512,default='',comment='*'
IS_IN_DB(db(db.mytable.id0), 'mytable.id', db.mytable._format
,error_message=T(Sorry chap, that doesn't exist))
You may specify your own error_message for any built-in validator.
On Sunday, December 11, 2011, Constantine Vasil wrote:
How to change the message 'value already in database or
Anthony, could you elaborate a bit on that notation?
multiple=(0,3)
I wanted a maximum of two items and yet I need to write 3. In the book,
I've seen something similar with the limitby argument for DAL select:
for row in db().select(db.person.ALL, limitby=(0, 2)): print row.name
which fetches
please check:
http://code.google.com/p/web2py/issues/detail?id=572
Thanks
On Friday, December 16, 2011, Massimo Di Pierro wrote:
Can you please open a ticket about this?
On Dec 16, 12:10 am, Nik Go nikolai...@gmail.com javascript:; wrote:
A grid search causes an exception when a user
Thanks Anthony. I don't think I've seen that in the docs.
On Thursday, December 15, 2011, Anthony wrote:
Try
IS_IN_DB(..., multiple=(0, 3))
The multiple argument to IS_IN_SET and IS_IN_DB can be a list or tuple
specifying a minimum and maximum number of items to be selected (strictly
less
Isn't that the default behavior? I mean, after registration a user is
automatically logged in.
Anyway, what I did was when a currently logged-in and unverified user's
account is verified or updated by the admin, his status will be updated
when he checks his profile (or logs out and logs in
Try this:
db.po_sku.default=lambda v,r: db.sku[r.sku_id].cpu
On Friday, December 16, 2011, Adi wrote:
I'm still trying to resolve my problem, and desperately need someone's
help :)
When I try to add a new sku to a purchase order, I would like to
prepopulate CPU field with the value from
form=SQLFORM.grid(blah, ... fields=fields ...)
This is handy for lots of things. Beware of this, though:
if len(request.args) 1 and request.args[-2]=='new':
Anyway, you get the picture.
On Dec 14, 11:19 pm, Nik Go nikolai...@gmail.com javascript:; wrote:
Is there a parameter to specify
Ah .. so you want it processed as soon as the drop-down is selected? That
would need some Ajax magic.
On Friday, December 16, 2011, Adi wrote:
i put it as suggested, but it didn't work...
another problem is onchange', when a different value gets selected in
dropdown how to pass the
Yes. Because your first statement only declares a default value for a field
type 'string', the default field type.
The second statement, redefines the field as a reference field which by
default deletes all references if the parent record is deleted.
Check out
ondelete='CASCADE' #this is the
Hmm.. I've actually declared fields of type 'integer', then declare a
validator field much later in the code. Often in a custom auth_user fields
that needs to refer to tables which will be defined much later. Kinda makes
it like a pseudo-reference field.
Field('account_status', 'integer')#
Everytime a *new* stable version is out, I come to expect minor releases
happening in the next several days and try to hold off my own upgrade for
as long as possible. :P
On Friday, December 16, 2011, Massimo Di Pierro wrote:
Looks like we need a 1.99.5 thanks Omi
On Dec 15, 9:43 am, Omi
A grid search causes an exception when a user enters an unexpected field
type.
I have this field:
Field('gender', 'integer', default=0,
requires=IS_IN_SET([(0,'Unknown'), (1, 'Male'), (2, 'Female')])
Since they are represented as a string (ie Male) on screen, the user may
attempt a search like
, had I realized this, my
question should be, and is now:* is there a way to update a currently
logged-in user's status to reflect the latest value in the db other than
asking the user to log-off first?*
/r
On Tuesday, December 13, 2011, Nik Go wrote:
I'm still stuck with this :(
I've already
, had I realized this, my
question should be, and is now:* is there a way to update a currently
logged-in user's status to reflect the latest value in the db other than
asking the user to log-off first?*
/r
On Tuesday, December 13, 2011, Nik Go wrote:
I'm still stuck with this :(
I've already
If
showbuttontext=False
I couldn't see the default icons anymore. (i.e the magnifying glass for the
view button)
Is there a parameter to specify initial fields to display in a grid and
still display the rest of the viewable fields only when the record is
accessed?
For example, I would like the grid to initially show: field1, field2,
field3,field4 but when the view button is clicked it will display all
I have a list:reference field and would like a user to select none or up to
two values from the list
I could validate by calling onvalidation but I'm wondering if there's any
built-in validator that should work? I've tried the following, none of
which worked for me:
-
hmm ... I tried auth.user.account_status=db.auth_user[auth.user.id
].account_status
, but I get an error:
AttributeError: 'NoneType' object has no attribute 'account_status'
On Wednesday, December 14, 2011, Anthony wrote:
In my design case registration doesn't require approval, but access to
columns support has been dropped, right?
On Thursday, December 15, 2011, Cliff wrote:
On 1.99.2, grid will display a row for each row returned by the query,
but won't show any data from the secondary table.
Unless I'm missing a step. Actually I would be happy if that were the
case, as I
I'm not sure if it's my crappy mobile Internet connection or something else
but I couldn't seem to download a good copy of the version 1.99.3.
When testing the zip file, I get this error: error: invalid compressed
data to inflate web2py/applications/examples/static/artwork.tar.gz. I
already
connection or just clear your
cache and try downloading again... or use wget
On Dec 13, 6:04 am, Nik Go nikolai...@gmail.com javascript:; wrote:
I'm not sure if it's my crappy mobile Internet connection or something
else
but I couldn't seem to download a good copy of the version 1.99.3
P.S.
I downloaded using aria2 and wget. Same result.
On Wednesday, December 14, 2011, Nik Go wrote:
Yeah, probably. I just ignored the file, and it seems to be working.
On Wednesday, December 14, 2011, kasapo wrote:
I downloaded the 1.99.3 source today and unzipped it with no issues.
Maybe
.
Under what conditions would this thing happen: a function returning a row
that doesn't exist? What are the other things I should check?
On Monday, December 12, 2011, Nik Go wrote:
And the other fields are still set to none, while their true values are
otherwise.
On Monday, December 12, 2011
I have a custom auth_user field that I could edit from admin (and I can
verify that changes are actually written in the sqlite table) but every
time I check the data from a view, the field value is always set to the
initial default values, and not whatever's actually stored in the table.
It's like
And the other fields are still set to none, while their true values are
otherwise.
On Monday, December 12, 2011, Nik Go wrote:
Here's a screenshot. Noticed that i edited the name toGJonathan but the
response.flash retrieves it as Jonathan
On Monday, December 12, 2011, Nik Go wrote:
I
db.table_settings.default_value.requires = IS_IN_SET(['a','b'])
db.table_settings['parent_table'].default_value*.default*
I think this is what you want, but make sure that you assign your
validators first in your table_settings, because otherwise they're empty
(or properly, None)
On Monday,
How do I add a new button in a user's profile page that redirects to
another view?
My own workaround for this issue is to to declare it as string and regexp
,Field('actual_date', 'string', length=10
# or -MM or -MM-DD
,requires=IS_EMPTY_OR(IS_MATCH('^(\d{4})$|^(\d{4})[-
/.]((0[1-9])|(1[0-2]))$|^(\d{4})[- /.]((0[1-9])|(1[0-2]))[-
Yes! Really weird.
I created a ticket: http://code.google.com/p/web2py/issues/detail?id=544
On Thursday, December 1, 2011, Massimo Di Pierro wrote:
It gets compiled without you clicking the button?
On Nov 30, 8:44 pm, Nik Go nikolai...@gmail.com javascript:; wrote:
This is a trifle
You can do it here: http://code.google.com/p/web2py/issues/entry
On Thursday, December 1, 2011, Vinicius Assef wrote:
Where do I open it?
On Thu, Dec 1, 2011 at 2:57 AM, Massimo Di Pierro
massimo.dipie...@gmail.com javascript:; wrote:
I would consider this an improvement. Please open a
look for roles, groups and memberships in the book
On Thursday, December 1, 2011, Vinicius Assef wrote:
I think I'll use web2py multi-tenancy, but I have some doubts:
I have different user profiles in my app:
a) customer: can view/edit only it's own data.
b) seller: can view/edit its own
with full access, who don't can count on
filtered accesses.
--
Vinicius Assef.
On Thu, Dec 1, 2011 at 12:44 PM, Nik Go nikolai...@gmail.comjavascript:;
wrote:
look for roles, groups and memberships in the book
On Thursday, December 1, 2011, Vinicius Assef wrote:
I think I'll use
IS_IN_DB(db, 'field.id', db.table._format, *multiple=True*)
process the selection with onvalidation
On Friday, December 2, 2011, Constantine Vasil wrote:
I want to use SQLFORM.factory to define a check box field with a list of
email addresses.
When the user checks several, then to send an
+1. The name isn't so bad. We could all probably name other projects with
worse names.
The packaging, if that is really important to the community would help
improve the image. Django's packaging is not suprising since it was
originally developed internally in a news company - the media is
+1. The name isn't so bad. We could all probably name other projects with
worse names.
The packaging, if that is really important to the community would help
improve the image. Django's packaging is not suprising since it was
originally developed internally in a news company - who knows more
yourlist = [[u'John Doe', u'john_...@gmail.com'], [u'Mary Doe', u'
mary_...@gmail.com']]
and in your validator
IS_IN_SET(yourlist, *multiple=True*)
multiple to render checkboxes.
On Friday, December 2, 2011, Kenneth Lundström wrote:
You either have an multi select select item in the form or
a 'date' field implicitly gets the SQLFORM.widgets.date.widget. of course,
being explicit helps make it clearer.
On Friday, December 2, 2011, Rick wrote:
Thanks! This is the final code:
dayform = SQLFORM.factory(
Field('thedate', 'date', label=T(''),
auth.settings.login_onaccept=URL('afterlogin') #assuming it's in the
default controller.
does the same.
For reference, the other callsbacks *(before) db io* are:
auth.settings.login_onvalidation = []
auth.settings.register_onvalidation = []
auth.settings.profile_onvalidation = []
Interesting. Do you have any recommended links to know more about this
topic?
On Friday, December 2, 2011, Bruno Rocha wrote:
I have an opinion about that.
For me the /models folders should be renamed to /scripts since it has
scripts that are executed in every request. Going on this
This is a trifle behavior that I experience every time I create a new
simple application from the admin interface. For some reason, the new
app gets compiled. I'm running Ubuntu 10.04 and running web2py from source.
I need to press the remove compiled to proceed with editing the new app. I've
Arghh... for some reason or another, I lost my:
auth.define_tables()
Thanks for the feedback Massimo.
On Tuesday, November 29, 2011, Nik Go wrote:
I've been deleting tables and playing around with various settings, so I
don't know what I've done exactly but now my app lost the links
I needed an advanced profile for a registered user with fields coming from
another table. Since I want to keep the same auth_user profile link, I
thought I'd used a virtual field in the auth_user table to display a link
to the other table.
class VFprofile(object):
def
Nice! Are you planning to release the plugin?
Let me know if you need any help testing it. :)
On Saturday, November 26, 2011, monotasker wrote:
I'm adapting the select_or_add widget from web2py slices so that it can be
packaged as a plugin. In that process I'm moving the business logic from a
I've been deleting tables and playing around with various settings, so I
don't know what I've done exactly but now my app lost the links for logging
in, registering or resetting passwords.
If I try to access the links manually (i.e.
http://127.0.0.1:8000/s1/default/user/register) or do the same
Is it possible to run something like acme.127.0.0.1:8000?
I've already set the common_field, and I want to do other local tests. I
tried a different IP address, and it works but I lose access to the admin
interface.
This is my routes.py
routers = dict(
BASE = dict(
domains = {
I've already set the request_tenant field and each domain can only see the
data they create.
However, from the localhost, I can only see auth_user data, and data
created from localhost. How do I allow access to all data from the
localhost administrators?
Also, how to I allow tenants to access to
Cliff, you alluded that this doesn't work, but it's actually a valid
signature and should work:
IS_IN_DB(db(db.categories.parent_table==request.args(0)),'categories.id','
categories.name')
just as valid as the following signatures:
IS_IN_DB(db(db.categories.parent_table==request.args(0)),
countries = {'ti': 'Timor Leste', 'vn': 'Vietnam','in': 'India','kr':
'Korea','cn': 'China'}
db.define_table('address', Field('country'), Field('state'),
Field('street_address'))
db.address.country.requires=IS_IN_SET(countries, zero=None)
db.define_table('personal_address', db.person,
try this :
,links = [lambda row:
A(
SPAN(_class='icon magnifier')
,'View Post'
,_class='button',_title='View Post'
,_href=URL(args=[view, db.person, row.id])
)
]
On Monday, November 21, 2011, Rahul wrote:
Hi Johann,
That is correct but I just wanted to
How is it possible to accept the following values in a date field:
- -MM-DD - no problem
- -MM (year and month only) - entered manually, accepted by
IS_DATE(format=T('%Y-%m')) but the actual field contains -MM-*1. *Where
1 is added automatically by w2p.
- (year
, 2011, Nik Go wrote:
That's nice Peter. Good work!
Thanks for sharing.
On Wednesday, October 26, 2011, peter wrote:
I am using and enjoying sqlform.grid. I have the latest version of
web2py, however, I think that the css files within my application have
become out of date.
If I have ten
It mentions: If you use jqueryui then the links are rendered as buttons.
am still trying to find an answer about how to use icons for your custom
buttons.
On Friday, October 28, 2011, Cliff wrote:
I'll try to keep an eye on it.
On Oct 27, 1:47 pm, Massimo Di Pierro
I experience the same unexpected behavior.
On Friday, October 28, 2011, szimszon wrote:
I have to tables
db.define_table( 'wdirs',
Field( 'name', type = 'string',
requires = IS_NOT_EMPTY()),
*(a)* *format='%(name)s %(id)s'*
)
db.define_table( 'files',
Johan, we're you able to specify your own icons for your custom buttons? If
so, may I know how you did it?
On Thursday, October 27, 2011, Johann Spies wrote:
On 26 October 2011 19:15, Cliff cjk...@gmail.com javascript:_e({},
'cvml', 'cjk...@gmail.com'); wrote:
So you need a column on the
That's nice Peter. Good work!
Thanks for sharing.
On Wednesday, October 26, 2011, peter wrote:
I am using and enjoying sqlform.grid. I have the latest version of
web2py, however, I think that the css files within my application have
become out of date.
If I have ten pages, then the page
*bump*
On Tuesday, October 18, 2011, Nik Go wrote:
how do I specify the other icons available from the default icon sprite?
In a smartgrid, I'm trying to generate a clickable link to view another
records. How do I pass the signature?
how do I specify the other icons available from the default icon sprite?
manual entry doesn't work on the ff browsers:
- Chromium 15.0.871.0
- Epiphany/GNOME Web Browser 2.30.2
- Mozilla Firefox 3.6.22
I'm running ubuntu 10.04
On Friday, October 7, 2011, Massimo Di Pierro wrote:
Which browser? When I tried it, if I remember, I was able to type.
*bump*
any inputs?
On Friday, October 7, 2011, niknok wrote:
**
I have a self-referencing table [1] with a defined format for representing
a record in this fashion: Lastname, Firstname [-mm-dd]. In the father
field, I expect it to display the drop-down list of persons as defined in
Yes, actually I'm playing with them right now. Thanks.
My kung-fu is not very good, and I couldn't make them work the way I like
it. That's why I'm asking, just in case, there are any other suggestions.
For example, adding new entries on the fly ...
On Monday, October 10, 2011, Bruno Rocha
Done.
http://code.google.com/p/web2py/issues/detail?id=463
Thanks.
On Monday, October 10, 2011, Massimo Di Pierro wrote:
Please open a ticket.
On Oct 9, 3:39 am, niknok nikolai...@gmail.com javascript:; wrote:
When using checkboxes.widget the expected selection box disappears,
instead a
Here you go ...
On 3/6/11, Massimo Di Pierro massimo.dipie...@gmail.com wrote:
Can you help us please? Download the README file from web2py/ and
reorder the items.
On Mar 5, 2:54 pm, luismurciano luismurci...@gmail.com wrote:
In the change log
Like Richard's opinion, I like snake #1's expression as well and would vote
to have a new rendering of that snake posing similar to image #4 where it is
intertwining with web and py.
Web2Py is a developer's tool, hence a crazy logo is fine as long as it
represents the ideas the
I was trying to do the following:
for n in g[:]:
query += ' | ' if bool(query) else ''
query += (db.contacts.membership.like('% + n + %'))
rows=db(query).select(db.contacts.number)
but couldn't get it to work so I resorted to executing the query using
SQLexecute
I'm not sure if it's the same error but I got the same problem.
I unpacked the 1.63 to an existing web2py (v1.62.3) directory.
Once I get to the default index. Clicking on administrative interface
generates an error ticket but clicking on the ticket only causes it to
generate another ticket. ad
83 matches
Mail list logo