Hi guys,
I'm using 2.6.4-stable+timestamp.2013.09.22.01.43.37 and I trying to log at
db every new record
created with SQLFORM.grid:
My controller:
def bodies():
grid = SQLFORM.grid(db.bodies, orderby=~db.bodies.id, oncreate=
log_action('System','Created new body'))
return dict(grid=gri
This was very useful to me too, Thanks.
--
---
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 https:
The problem now is how use that dal query into:
IS_IN_DB(query,db.phone_line.id, '%(phone_number)s')
Because a query object doesn't have a select attribute... :-/
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this g
Well, so far, I think I've get a DAL query that works like the second SQL
query(LEFT OUTER JOIN based):
db(db.simcard.phone_line==None).select(db.phone_line.ALL, db.simcard.ALL,
left=db.simcard.on((db.simcard.phone_line==db.phone_line.id)))
I wil trying to solve the main problem with the dropdow
Hi guys, please could somebody help me?
from my tables:
db.define_table('phone_line',
Field('tel_plan',db.tel_plan),
Field('phone_number',length=30),
signature, format='%(phone_number)s'
)
db.define_table('simcard',
Field('serial',lengt
;, 'system'))
>
> Anthony
>
> On Thursday, May 2, 2013 12:54:34 PM UTC-4, Christian Espinoza wrote:
>>
>> Hi guys,
>> I'm trying to do a different 'first view' for a admin user, and for this,
>> I was modified my db.py file on this wa
Hi guys,
I'm trying to do a different 'first view' for a admin user, and for this, I
was modified my db.py file on this way:
if auth.user.first_name == 'admin':
auth.settings.login_next = URL('admin', 'system')
else:
auth.settings.login_next = URL('mainboard', 'index')
But seems that on
I have the same Problem..
El martes, 2 de abril de 2013 17:07:35 UTC-3, Torvald Baade Bringsvor
escribió:
>
> Hi
>
> I'm trying out the jquery mobile plugin for web2py (2.4.5) and I'm having
> no success. When I load the page (both on mobile device and desktop) I get
> a blank page.
>
> When I
tain the records you see on the page only. Would this be ok?
> Pros/Cons?
>
>
> On Tuesday, 9 April 2013 10:12:57 UTC-5, Christian Espinoza wrote:
>>
>> Hi Massimo, I'm rendering a grid in a view and I'm need add a graph to it,
>> maybe using flot js lib
>> th
Thanks Mark!
--
---
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 https://groups.google.com/groups
Thanks Anthony, your answer get me the right direction for my solve my
issue.
Christian.
--
---
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.
Hi, I have this table definition:
db.define_table('timetable',
Field('customer', db.customer, label='Cliente'),
Field('name', length=160, label='Nombre'),
Field('start', 'time', label='Inicio' ),
Field('finish', 'time', label='Final' ),
Hi guys, somebody know how hide the comments column at a edit form using
SQLFORM.grid() ??
I can do it using jquery with:
$("tr td:nth-child(3)").each(function(){this.remove()});
But 'm finding a server side(controllers maybe) way to do it..
Id: 1
Cliente:
Intsercom Ltda
Nombre:
Velocida
>
> it would contain the records you see on the page only. Would this be ok?
> Pros/Cons?
>
>
> On Tuesday, 9 April 2013 10:12:57 UTC-5, Christian Espinoza wrote:
>>
>> Hi Massimo, I'm rendering a grid in a view and I'm need add a graph to
>> it, m
by SQLFORM.grid()...
Christian.
El martes, 9 de abril de 2013 11:14:50 UTC-3, Massimo Di Pierro escribió:
>
> I do not understand the question. :-(
>
> On Tuesday, 9 April 2013 08:38:48 UTC-5, Christian Espinoza wrote:
>>
>> Hi guys, I'm answering how can I take advantage from
Hi guys, I'm answering how can I take advantage from SQLFORM.grid in order
to get aditionally the data from the query
something like:
SQLFORM.grid():
.
.
return (htmlcode, rawrows)
grid, rows = SQLFORM.grid(query,fields=campos,
editable=False,
searchable=False,
deletable=F
Thanks a lot Nihplod, all is working as expected now!!!
--
---
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 optio
to true without leaving the page holding the grid (ajax).
> If you need to refresh the values also on the grid page, than a full
> refresh of the page is needed, so remove the callback argument, use that
> url in the href and put a redirect(URL('function_showing_the_grid')) at the
Hi guys, I want to add a action button(like delete,edit, view, i/e) at the
grid, something to change a value from the record indicated at the line,
this is my table:
db_events.define_table('alerts',
Field('type', length=20, label='Clase' ),
Field('rule', label='Regla'),
ore and after callbacks -
> http://web2py.com/books/default/chapter/29/06#before-and-after-callbacks
>
> That should get the job done.
>
> -Jim
>
> On Friday, February 22, 2013 7:22:06 AM UTC-6, Christian Espinoza wrote:
>>
>> Hi guys, there a way to validate some c
Hi guys, there a way to validate some condition before run the insert of a
new record using SQLForm.grid() ?
For example if I need insert a record, but a rule ( a value at the db, a
constant) said that the records must be
only < 5 and I have already 4 records, then the insert can't be run...
Th
I'm using this query with executesql(), Thanks to all for the support!!
El sábado, 16 de febrero de 2013 15:23:00 UTC-3, Niphlod escribió:
>
> neither let's leave alone event('name') that isn't in the table.
> that query returns the event id for each device_id in the events table,
> and attac
Hi guys, for this json service I'm using simplejson implicitly because the
result of db.executesql
isn't serialized automatically by decorator, is this the normal behavior
for db.executesql or something I'm missed here?
@auth.requires_login()
@service.json
def test_trackers():
dthandler = l
l lunes, 18 de febrero de 2013 13:34:01 UTC-3, Niphlod escribió:
>
> DAL can't do cross database queries, unless you use executesql.
>
> On Monday, February 18, 2013 5:27:38 PM UTC+1, Christian Espinoza wrote:
>>
>> Hi all, I'm need get the last alert(a table record
Hi all, I'm need get the last alert(a table record) from db_alerts database
for every customer's truck,
but I'm can't get it, I'm using MYSQL.
Table trucks at db_base:
db_app.define_table('trucks',
Field('customer_id', db_app.customers),
Field('lic', length=10),
Field('cap', 'integer'
Hi all!, could somebody get me a hand in order to improve this code, please?
I'm getting a array of dicts here, every device have it last event attached
in the dict...
I'm want delete the iteration over the events table, I don't think it is
efficient enough
maybe it could be changed doing a bett
Hi all, I'm wondering about if .update_or_insert was enhanced or not yet?
Thanks in advance.
Christian.
El jueves, 3 de mayo de 2012 09:46:46 UTC-4, Anthony escribió:
>
> You're manual version updates only two fields, whereas update_or_insert
>>> updates six fields -- maybe that's the difference
Hi Bruno, now my form at the view is:
{{=form.custom.begin}}
Name: {{=form.custom.widget.name}}
{{=form.custom.submit}}
{{=form.custom.end}}
I'm was testing a lot of times a insert with it, and every first time I'm
login to app
this form doesn't insert the data and nothing else shows, after t
Weird, because I'm noted that the first save process doesn't work, but from
the second all work fine :-/
and I'm have the same code without changes...
I'm have the trunk version..
El lunes, 21 de enero de 2013 17:12:38 UTC-3, rochacbruno escribió:
>
> SQLFORM expects a field named "fences_cu
Hi Bruno
I have on this way the code now at the view:
{{=form.custom.begin}}
Name: {{=form.custom.widget.name}}
{{=form.custom.submit}}
{{=form.custom.end}}
and I getting the values for every input ok, but SQLForm doesn't store
nothing at the db...
Thanks
Christian.
El lunes, 21 de enero
Hello!! I have a Form for this table, but I'm only want to get the 'name'
field from the user input.
the other fields I need fill them from javascript vars...
Model:
db.define_table('fences',
Field('customer', db.customer, label='Cliente', notnull=True),
Field('name', leng
attribute on
> the delete button that called the delete url correctly.
>
> Now there are both the full link to the delete url and the onclick
> attribute, so behaviour is consistent both in javascript-enabled and
> javascript-disabled browsers.
>
> Il giorno venerdì 11 gennaio
This Problem is currently active in 2.3.2
There is something with the link for delete action at generation of grid code:
With 2.2.1
View->http://127.0.0.1:8000/webapp/admin/users/view/auth_user/6?_signature=d408cbb7bcbce4ec22a9089465dcefc7f1f2a5db
Edit->http://127.0.0.1:8000/webapp/admin/user
Is easy use a custom form instead of {{=form}}, then you can control
where put your input fields...
{{=form.custom.begin}}
Image name: {{=form.custom.widget.name}}
Image file: {{=form.custom.widget.file}}
Click here to upload: {{=form.custom.submit}}
{{=form.custom.end}}
Reference:
http://web2py
2013 19:57:59 UTC-3, Alan Etkin escribió:
>
> El viernes, 4 de enero de 2013 19:23:35 UTC-3, Christian Espinoza escribió:
>>
>> Hi, In all my webapps I'm working with SQLFORM.grid, and testing with the
>> new versions I got this error:
>
>
> For debugging, pe
Hi, I had a lot of problems like this when I was developing with sqlite,
now my rule
is develop from beginning with the final database what will run in
production environment..
Christian.
El viernes, 4 de enero de 2013 22:45:18 UTC-3, Michele Comitini escribió:
>
> I have no idea where the err
Hi, In all my webapps I'm working with SQLFORM.grid, and testing with the
new versions I got this error:
must be string, not listVERSIÓNweb2py™(2, 3,
2, datetime.datetime(2012, 12, 17, 15, 3, 30), 'stable')PythonPython 2.7.3:
C:\Python27\python.exeTRACEBACK
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
Tra
;> This should then automatically display the right value - the only
>>>> problem is that it wouldn't guarantee that the index would be 0, 1, and 2.
>>>> It would be whatever the primary key on the actions table worked out to
>>>>
My Model for this App
db_events.define_table('events',
Field('devid', length=15, label='CODE'),
Field('type', length=15, label='Type'),
Field('index','integer', label='Action'),
Field('datetime','datetime', label='Date'),
Field('latitude',
Hi, I'm wondering about if is possible process the values of a column to
show the result on the grid instead of original value...
My Code:
(db_events.events.device_id == request.vars.id) &\
(db_events.events.event_datetime >= from) &\
(db_events.events.event_datetime <= to)
grid = SQLFORM.grid(qu
Hi guys, I'm thinking put my hands on some CSS preprocesor to get a
centralized control over the stylesheets,
but I'm wondering about how is the impact on the user experience, if it
have a speed cost on page loading...
Can somebody share some experience about that used with Web2py??
Thanks.
Ch
Hi, I need only one auth_user form with the option to select the group
membership in order to get a simple way to add users.
I'm thinking override the auth_membership table use, and add a reference
from auth_user directly to auth_group to achieve it, also formatting the
output of the drop dow
13, 2012 10:00:24 AM UTC-7, Christian Espinoza wrote:
>>
>> Well, thanks anyway, its was resolved using the base code from
>> http://stackoverflow.com/**questions/8008213/web2py-**
>> upload-with-original-filename<http://stackoverflow.com/questions/8008213/web2py-uploa
With this code was enough to get the uploaded files with the original name
and to change the logo online.
Thanks to Wikus van de
Merwe<http://stackoverflow.com/users/1054145/wikus-van-de-merwe>
Christian.
El lunes, 12 de noviembre de 2012 18:50:57 UTC-3, Christian Espinoza
esc
Hello, maybe this question was some answers,
ie
http://groups.google.com/group/web2py/browse_thread/thread/b04977ace137b317/f4c3e44b4cd5de6d?lnk=gst&q=Change+upload+behaviour#f4c3e44b4cd5de6d
But I don't understand if these args (custom_store or custom_retrieve)
could be necessary for that I
Hi, somebody know how connect web2py on linux box to a db2 database server?
I have pyodbc installed, but I dont know how to..
Thanks in advance
Christian.
--
pty postgresql
database, with a empty sqlite db all works fine...
Im using if db(db.auth_group).isempty():
To check if is empty to insert the firsts values...
Christian.
2012/9/6 Christian Espinoza
> Massimo,
>
> SELECT auth_user.id, auth_user.username, auth_user.first_name,
> auth
after
>
> command = a[0]
>
> I want to know what is the invalid command. The ticket only shows part if
> it.
>
> On Wednesday, 5 September 2012 17:27:49 UTC-5, Christian Espinoza wrote:
>>
>> Hi Massimo, this is:
>>
>> *File /opt/web-apps/web2py/gluon/da
ommand variable? What does it print when it fails?
>
> On Wednesday, 5 September 2012 11:29:42 UTC-5, Christian Espinoza wrote:
>>
>> Hello, I'm in trouble with a webapp that I'have.
>>
>> I develop it using sqlite only for a best approach of web2py features
>
Hello, I'm in trouble with a webapp that I'have.
I develop it using sqlite only for a best approach of web2py features with
it.
And I'm trying to migrate it to a Postgresql DB to put it on Testing phase.
But It doesn't work with PostgreSQL, only work with sqlite, I'd tried with
1.99.7 - 2.0.6
I'm trying step to step now...and only was needed an little changes
El martes, 4 de septiembre de 2012 18:03:16 UTC-3, Christian Espinoza
escribió:
>
> Hi Alan, I did test this script at a clean Centos 6, and the result is: 502
> Bad Gateway
> Christian
>
>
> El viern
Hi Alan, I did test this script at a clean Centos 6, and the result is: 502
Bad Gateway
Christian
El viernes, 3 de agosto de 2012 20:23:21 UTC-3, Alan Etkin escribió:
>
> Updated the script to:
>
> - Write port 443 admin password
> - Create welcome.w2p package (for solving admin create app featu
Hello guys,
There are somebody with some experience using wx instead of a web view
layer??
I have some questions about it, and I want to know if exist some
example over there...
Thanks in advance.
Christian.
--
10:14:12 AM UTC-4, Massimo Di Pierro wrote:
>>
>> You have two id fields. One in request.get_vars.id (from the url) and
>> one in request.post_vars.id (from the form submission).
>>
>>
>>
>> On Wednesday, 22 August 2012 08:51:38 UTC-5, Christian Espinoza
without a user interaction.
Christian.
2012/8/22 Anthony
> It's really hard to say without seeing the code that generates the id.
> Somehow your id is a list instead of a single value.
>
> Anthony
>
> On Wednesday, August 22, 2012 9:51:38 AM UTC-4, Christian Espinoza wrote:
quest.vars.id being set -- in the query string? What is its
> value when the form is created, and what is the value when submitted?
>
> On Tuesday, August 21, 2012 7:16:18 PM UTC-4, Christian Espinoza wrote:
>>
>> Hi Anthony, I was try with .select().first(), but I get a error
.
Thanks in advance.
Christian
2012/8/21 Anthony
> How is request.vars.id being set -- in the query string? What is its
> value when the form is created, and what is the value when submitted?
>
> On Tuesday, August 21, 2012 7:16:18 PM UTC-4, Christian Espinoza wrote:
>>
>> Hi Ant
Hi Anthony, I was try with .select().first(), but I get a error in the
same way...
The Error appears after I submit the form with the changes over the field,
the form for a id user works, the problem is when I submit it.
Thanks.
Christian
2012/8/21 Anthony
> Also, note the .select().first() r
Hi Bruno, this error appear after I submit the changes on the form,
I can get the form without problems for a user, but the problem appears
after submit any change.
Christian
El martes, 21 de agosto de 2012 18:58:47 UTC-4, rochacbruno escribió:
>
> You are getting an empty rows object
>
>
> de
Hello, I'm trying to edit the group membership for a user, I have in my
controller:
def change_membership():
if request.vars.id:
row = db(db.auth_membership.user_id == request.vars.id).select()
id = row[0].id
form = SQLFORM(db.auth_membership,
Well, I fix it, pointing (action) to my controller from the form:
form = SQLFORM(db.table, request.vars.id[0], _class='formulario',
_id='form_std', keepopts=['sede'], _action=URL())
Thanks
Christian.
El jueves, 9 de agosto de 2012 17:35:23 UTC-4, Christian Espin
Hi, I´m have working a custom SQLFORM in update mode, into a modal popup,
when I try to submit changes
the popup disappear obviously, but it isn't make any changes.
But if I try the code out from the modal, it's make the changes without
problems...
Any Idea?
Thanks in advance.
Christian.
--
Hello Bruno, I did download the example app to test it, but i get this
error:
'PowerFormWizard' object has no
attribute 'readonly'
do you know what can be the problem?
Thanks in advance
Christian.
El jueves, 30 de junio de 2011 08:44:42 UTC-4, rochacbruno escribió:
>
> Even without client si
I'm newbie too, but I know that all layout's are only a html skeleton, you
can modify it freely or create your own layout plugin
If you want you can uninstall this layout plugin without problems from the
admin interface.
Good Luck
Christian.
El lunes, 18 de junio de 2012 07:24:09 UTC-4, rahul
64 matches
Mail list logo