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
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
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
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
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',
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
, 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 way:
if auth.user.first_name == 'admin':
auth.settings.login_next = URL('admin', 'system')
else
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 look at
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
?
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
the graph will need the same grid data, and I'm wondering how get the row
data without running a query only for the graphs
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
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..
table
tbody
tr id=velocities_id__rowtd
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, 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,
()...
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 SQLFORM.grid in
order to get aditionally the data
=
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, maybe using flot js lib
the graph will need the same grid
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'),
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
end of the check_to_true function.
On Friday, March 1, 2013 4:08:05 PM UTC+1, Christian Espinoza wrote:
Hi guys, I want to add a action button(like delete
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
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...
-
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 condition before run the insert of
a new record using SQLForm.grid
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 =
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 attaches
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',
: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) from db_alerts
database for every customer's truck,
but I'm can't get
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
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}}
input type='hidden' id=fences_type name=type
input type='hidden' id=fences_definition name=definition
input type='hidden' id=fences_customer name=customer
{{=form.custom.submit}}
{{=form.custom.end}}
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',
Hi Bruno
I have on this way the code now at the view:
{{=form.custom.begin}}
Name: {{=form.custom.widget.name}}
input type='hidden' id=type name=type
input type='hidden' id=definition name=definition
input type='hidden' id=customer name=customer
{{=form.custom.submit}}
{{=form.custom.end}}
and
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
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
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 2013 14:24:46 UTC+1, Christian Espinoza
Hi, In all my webapps I'm working with SQLFORM.grid, and testing with the
new versions I got this error:
type 'exceptions.TypeError' 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.
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
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, perhaps it would be of help if you could post the relevant
Is easy use a custom form instead of {{=form}}, then you can control
where put your input fields...
{{=form.custom.begin}}
Image name: div{{=form.custom.widget.name}}/div
Image file: div{{=form.custom.widget.file}}/div
Click here to upload: {{=form.custom.submit}}
{{=form.custom.end}}
Reference:
the numeric value as you mentioned. I haven't done that before,
but heard it isn't that difficult.
-Jim
On Thu, Dec 20, 2012 at 2:45 PM, Christian Espinoza chesp...@gmail.com
wrote:
My Model for this App
db_events.define_table('events',
Field('devid', length=15, label='CODE
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 =
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'),
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
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.
name
and to change the logo online.
Thanks to Wikus van de
Merwehttp://stackoverflow.com/users/1054145/wikus-van-de-merwe
Christian.
El lunes, 12 de noviembre de 2012 18:50:57 UTC-3, Christian Espinoza
escribió:
Hello, maybe this question was some answers, ie
http://groups.google.com/group
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-filenamehttp://stackoverflow.com/questions/8008213/web2py-upload-with-original-filename
Using
Hello, maybe this question was some answers,
ie
http://groups.google.com/group/web2py/browse_thread/thread/b04977ace137b317/f4c3e44b4cd5de6d?lnk=gstq=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.
--
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/dal.py in log_execute at line 1653*
Code listing
1648.
1649.
1650.
1651.
1652.
1653.
1654.
1655.
1656.
1657.
command = a[0]
if self.db._debug
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 chespin...@gmail.com
Massimo,
SELECT auth_user.id, auth_user.username, auth_user.first_name
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 -
? If not it is probably using pg8000. Can you
please help us debug? Edit dal.py and in the function log_excecute can you
print the value of the command 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
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 feature
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 viernes, 3 de agosto de 2012 20:23:21
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.
--
, 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 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
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 in the
same way...
The Error appears
.
Christian.
2012/8/22 Anthony abasta...@gmail.com
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:
When I submit the form
-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 wrote:
When I submit the form, on request.vars.id exist this value: ['2
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,
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
def
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 abasta...@gmail.com
Also, note the
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 Espinoza escribió:
Hi, I´m have
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.
--
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,
Hello Bruno, I did download the example app to test it, but i get this
error:
type 'exceptions.AttributeError' '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
64 matches
Mail list logo
