On Sunday, November 19, 2017 at 10:39:27 AM UTC-5, Yoel Benitez Fonseca
wrote:
>
> I don't mean to set the length, i just wanted to know the DAL behavior
> behind the scene. So, DAL translate 'string:list' to a list in
> databases that natively support lists and to a TEXT field on normal
> rela
I don't mean to set the length, i just wanted to know the DAL behavior
behind the scene. So, DAL translate 'string:list' to a list in
databases that natively support lists and to a TEXT field on normal
relational databases and hence set the length of the text field to the
default ?
2017-11-17 15:5
I don’t think you can set this but not sure why you would want to. However
beware if testing the length of the field as I think if you only have 1 item in
the list then this is a string and you get the number of chars in the string.
While if you have more than 1 you get the length of the list.
h!
I always wanted to ask: According the online book, it is recommended
to explicit set the length of "string", "password" or "upload", but
what about list:string ?
--
Msc. Yoel Benítez Fonseca
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2
Hi everyone,
I have a sqlform to display a list:string field form and an onvalidation
function to check each data entry of the list. The error message always
shows at the bottom of the form whereas I would like to identify the
precise data entry responsible for that error (show the error in the
Hi everyone,
am trying to input a list:string field via a SQLFORM(list_string_table). It
works fine with the + and - buttons but I'd like to fix a limit like 30
strings max for every list:string
Is this possible ?
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- h
I've started using a list:string field on the auth_user model.
I'm running web2py on GAE with the datastore.
I noticed web2py's admin tool started crashing on this page
appadmin/select/db?query=db.auth_user.id>0
looking at the console I found:
/gluon/dal.py", line 10035, in
return '
Hi Guys,
I am using a list:string to store a list of lists. Each seperate list has 4
values, qty (int), name (string), description (text) and price(double).
Stores nicely and looks fine in the db table eg.
[1, 'OS 7030', 'OS 7030', 755.0], [3, 'SMT 24 Btn', 'SMT IP Phone', 360.0],
[1, 'SMT IP'
Il 03/04/14 14:01, horridohobbyist ha scritto:
> Well, I added data by using db.update() instead of SQLFORM. The data
> is definitely in there, and it works. However, in admin, *the data is
> not visible* in the list:string field (it's empty), so I can't edit
> it. The behaviour of the list:string
Well, I added data by using db.update() instead of SQLFORM. The data is
definitely in there, and it works. However, in admin, *the data is not
visible* in the list:string field (it's empty), so I can't edit it. The
behaviour of the list:string data type is very strange. Why is it like
that? Or
Il 03/04/14 06:23, horridohobbyist ha scritto:
> I've added a 'list:string' field to my table, but when adding a new
> record from admin (using the new record form), I can't figure out how
> to enter the data. I don't understand what format it expects.
>
> I tried "['item1','item2']". I tried "|'it
I've added a 'list:string' field to my table, but when adding a new record
from admin (using the new record form), I can't figure out how to enter the
data. I don't understand what format it expects.
I tried "['item1','item2']". I tried "|'item1'|'item2'|". They both don't
work.
--
Resources:
I'm making use of list:string to store registration numbers (for cats):
db.define_table(
'cat',
...
Field('reg_numbers', 'list:string'),
format = '%(name)s'
)
and using sqlform.grid in the 'cat' controller. For web2py versions <=
2.4.x this worked fine - displaying a text
I have added a list:string field to my auth_user table using
auth.settings.extra_fields:
auth.settings.extra_fields['auth_user'] = [
Field('f_dtf', type='list:string', custom_qualifier=dict())
]
The new field shows up fine. But when I try to manipulate that field from
the Profile page,
I have a list:string field without any "represent" definition, and when
open record for editing in smartgrid, the field is represented as string
(one line). I remember in the past seeing a button with the plus sign on
the right side, and ability to add multiple values into a field. Should I
sp
is it possible to display just one error message of a list:string input
right after the last input control, using SQLFORM.grid?
With SQLFORM,grid create/update form, when a list:string field with
validators has errors it should be possible to hide the error display on
all list inputs but the la
hi folks,
is it possible to change list:string type field output format?
e.g.
*in grid output : a, b*
*in shell output : |a|b|*
>>> print db(db.test.test.contains('b')).select()
test.id,test.test
1,|a|b|
*in view using query output : ab*
{{for i, row in enumerate(rows):}}
{{=DIV(row.test)}}
hi,
is it normal for list:string type field is empty when on editing page?
e.g.
db.define_table('contact',
*Field('salutation'),*
Field('first_name'),
Field('last_name'),
*Field('gender', 'list:string'),*
Field('birthday', 'date'),
Field('job_title'),
Field('address',
This has been an oft-disucssed topic. Just search for "list:string crud"
But having just experienced the pain myself, and not easily locating the
status of this issue, I felt compelled to ask for myself:
Shouldn't list:string have a default interactive (jQuery OK) widget that is
an expandable/
Hi
Having another problem today with the following:
table defined as:
priceBackerItem = db.define_table('priceBackerItem',
Field('priceBackerItemId', 'id'),
Field('priceBackerId', db.priceBacker, required=True,
label='Price Backer'),
Field('itemType', 'list:
Hi,
I have a model using a list:string field called type.
Validation for type field:
IS_IN_SET({'finished':T('Finished'),'service':T('Service')},
zero=T("-- Choose Type Of The Product --"))),
So, when I create an update form using SQLFORM it shows the form fine
but, the dropdown thats belong to
I'm getting frustrated with the list:string field type.
I store products, each product has "keywords" that describe the
product.
db.define_table('products',
Field('keywords', 'list:string'))
I don't know what the keywords will be, so I can't use IS_IN_SET()
It seems to stores the keywords fine
Using web2py 1.87.2 with sqlite
I need to store and retrieve a list of strings from a multple select.
I have a case where the list can be the empty list []. It will encode
to the datebase as '||', but will decode to ['|'], not [].
The current gluon.sql.py is:
def bar_encode(items):
return '|
I possibly found a problem with list:string field.
I´ve searched for a widget and I could found one for it.
So I starte to make my own based on this
http://blog.crazybeavers.se/wp-content/demos/jquery.tag.editor/
I could be like that tag editor in plugin_wiki too but I found it
harder to base on it
24 matches
Mail list logo
