[web2py] Re: SQLEDITABLE: redirect after submit

2014-07-09 Thread 'kato' via web2py-users
Hi.

You can write same as SQLFORM.

example.
def demo070():
response.title = 'demo070'
response.view = 'plugin_sqleditable/sample.html'
editable = SQLEDITABLE(db.employee_sheet, showid=False, maxrow=5)
if editable.accepts(request.vars, session):
response.flash = T('editable accepted')
elif editable.errors:
response.flash = T('editable has errors')
else:
response.flash = T('please fill out the editable')
return dict(editable=editable)

def demo071():
response.title = 'demo071'
response.view = 'plugin_sqleditable/sample.html'
editable = SQLEDITABLE(db.employee_sheet, showid=False, maxrow=5)
if editable.process().accepted:
response.flash = T('editable accepted')
elif editable.errors:
response.flash = T('editable has errors')
else:
response.flash = T('please fill out the editable')
return dict(editable=editable)

2014年7月8日火曜日 20時00分59秒 UTC-3 Fabiano Almeida:

 Hi,

 Has like 'accepted' attribute in SQLEDITABLE?

 I need redirect to other page after 'ok' click.

 Thanks,

 Fabiano.


-- 
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)
--- 
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/d/optout.


[web2py] Re: SQLEDITABLE: redirect after submit

2014-07-09 Thread 'kato' via web2py-users
I was a little wrong. If you want to redirect, and will not work because 
such in the ajax. 
Please write as the following.

def demo050():
response.title = 'demo050'
response.view = 'plugin_sqleditable/sample.html'
editable = SQLEDITABLE(db.employee_sheet, showid=False, maxrow=5, 
deletable=True).process(next=URL('static', 'success.html'))
return dict(editable=editable)



2014年7月9日水曜日 8時52分21秒 UTC-3 kato:

 Hi.

 You can write same as SQLFORM.

 example.
 def demo070():
 response.title = 'demo070'
 response.view = 'plugin_sqleditable/sample.html'
 editable = SQLEDITABLE(db.employee_sheet, showid=False, maxrow=5)
 if editable.accepts(request.vars, session):
 response.flash = T('editable accepted')
 elif editable.errors:
 response.flash = T('editable has errors')
 else:
 response.flash = T('please fill out the editable')
 return dict(editable=editable)

 def demo071():
 response.title = 'demo071'
 response.view = 'plugin_sqleditable/sample.html'
 editable = SQLEDITABLE(db.employee_sheet, showid=False, maxrow=5)
 if editable.process().accepted:
 response.flash = T('editable accepted')
 elif editable.errors:
 response.flash = T('editable has errors')
 else:
 response.flash = T('please fill out the editable')
 return dict(editable=editable)

 2014年7月8日火曜日 20時00分59秒 UTC-3 Fabiano Almeida:

 Hi,

 Has like 'accepted' attribute in SQLEDITABLE?

 I need redirect to other page after 'ok' click.

 Thanks,

 Fabiano.



-- 
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)
--- 
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/d/optout.


Re: [web2py] SQLEDITABLE plugin

2014-07-07 Thread 'kato' via web2py-users
Hi fabiano.

It is not possible to pass a query currently. 
But record parameter is so callable, please set there. 
Please see to the demo5 
http://docs1.erp2py.com/sqleditable/demo/demo_en.html#demo5 .

thanks.

2014年7月6日日曜日 15時19分04秒 UTC-3 Fabiano Almeida:

 Hi kato!

 How to use SQLEDITABLE with a query?

 If I try this in your first example:

 query = db.employee_sheet.resigned == True
 editable = SQLEDITABLE(query, showid=False, maxrow=5).process()

 Return error:

 AttributeError: 'Query' object has no attribute '_id'

 How to filter table?

 Thanks,

 Fabiano



 2014-07-01 10:12 GMT-03:00 'kato' via web2py-users 
 web...@googlegroups.com javascript::

 Hi.

 I tried to make SQLEDITABLE plugin.

 demo-page: http://docs1.erp2py.com/sqleditable/demo/demo_en.html

 It is similar as gluon/contrib/spreadsheet. But, it is easy to use more.
 If you are interested, please try.

 Thanks.

 -- 
 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)
 --- 
 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+un...@googlegroups.com javascript:.
 For more options, visit https://groups.google.com/d/optout.




-- 
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)
--- 
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/d/optout.


[web2py] Re: SQLEDITABLE plugin

2014-07-03 Thread 'kato' via web2py-users
Hi all.

Thank you for your quick reply.

kato

2014年7月1日火曜日 20時35分06秒 UTC-3 JorgeH:


 Cool!!

 Great work

 On Tuesday, July 1, 2014 8:12:29 AM UTC-5, kato wrote:

 Hi.

 I tried to make SQLEDITABLE plugin.

 demo-page: http://docs1.erp2py.com/sqleditable/demo/demo_en.html

 It is similar as gluon/contrib/spreadsheet. But, it is easy to use more.
 If you are interested, please try.

 Thanks.



-- 
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)
--- 
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/d/optout.


[web2py] SQLEDITABLE plugin

2014-07-01 Thread 'kato' via web2py-users
Hi.

I tried to make SQLEDITABLE plugin.

demo-page: http://docs1.erp2py.com/sqleditable/demo/demo_en.html

It is similar as gluon/contrib/spreadsheet. But, it is easy to use more.
If you are interested, please try.

Thanks.

-- 
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)
--- 
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/d/optout.