Is web2py.com down, I am not able to access.
Also, in the book services is not responding.
How to call restful services in web2py?
Thank you.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/we
Dear Jim S
I found the error to be in the database in one of the tables. When I
corrected the form worked nicely. It was all a programming error on my
part. Thank you so much for your valuable time and effort in helping me
out. Web2py rocks.
--
Resources:
- http://web2py.com
- http://web2
The print rowsconlab for id other than 1910 is
web2py Web Framework
Created by Massimo Di Pierro, Copyright 2007-2020
Version 2.14.6-stable+timestamp.2016.05.10.00.21.47
Database drivers available: sqlite3, imaplib, pyodbc, pymysql, pg8000
please visit:
http://127.0.0.1:8000/
starting bro
>-
>
>
>
>
>
>
>
>I get this error for a particular amcid = 1910, for others it is
>working ok. What might be the problem. The sp
>
>usr_getconlabqty_amc_new is indeed returning row from db when checked
>in the backend. please elucidate.
>
>-
>
>
>
>
>
>def schII():
>if not URL.verify(request, hmac_key=KEY): raise HTTP(403)
>amcid = request.vars.amcid
>rowsamcdet = db(db.amc_details.amc_id ==
>amcid).select(db.amc_details.amcno)
>if not rowsamcdet:
>sess
On Wednesday, October 14, 2020 at 10:40:53 AM UTC+5:30 T.R.Rajkumar wrote:
>
> I get this error for a particular amcid = 1910, for others it is working
> ok. What might be the problem. The sp
>
> usr_getconlabqty_amc_new is indeed returning row from db when checked in the
&g
I get this error for a particular amcid = 1910, for others it is working
ok. What might be the problem. The sp
usr_getconlabqty_amc_new is indeed returning row from db when checked in the
backend. please elucidate.
Error ticket for "web_ocms" Ticket ID
127.0.0.1.2020-10-14.10-26-27.939fd264
I use the following.
mssql2://user:pwd@servername\instance/databasename
for connecting to mssql 2016
I have my webserver apache and web2py running in windows8.
mssql in windows 2016 server.
In servername I use the IP of the machine.
In instancename I have SQL16S7INS1 --- the instance name created
Thank you AGRogers. It works.
--
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
"
Thank you villas.
The dblc I am using a view and referencing that views lc_no in my table
pm_events. I shall try how it works and if not I will go as you said.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://co
Thank you AGRogers
As you said the equipment record format to include the location, that would
do for me.
Can you please tell how to do that.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/we
db.define_table('pm_events',
Field('eqp_id', 'reference pm_equip'),
Field('lc_no', 'reference
dblc.lc_vw_lc_master.lc_no'),
Field('pending_work', type='string'),
Field('remarks', type='string'),
Field('
sqlform filed validators do not check for the precision of decimal fields.
It would be nice it web2py validates the precision of fields.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/i
Thanks. I did as you said .0001,1.
--
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 Grou
How to achieve >0.0 and <=1.0 float validator?
--
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
ts2admin.asmx is the web service. ValidateLogin is the method of that service.
I pass the username and password to that service and it returns the result. If
ret_code is 1 I allow login to my application LP.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://git
In the controller login.py
--
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
"web
I do like this
from gluon.contrib.pysimplesoap.client import SoapClient
client =
SoapClient(wsdl="http://172.16.164.64/ws_ts2admin/ts2admin.asmx?WSDL";)
rs = client.ValidateLogin(lcUname, lcPwd, lnCode, lcMsg)
rs1 = rs['ValidateLoginResult']
ret_code = rs1[
Thank you Alex. I removed the @import in bootstrap.min.css I do not want
that.
On Friday, December 8, 2017 at 3:36:35 PM UTC+5:30, T.R.Rajkumar wrote:
>
> I have an application. The views extend layout.html. When there is no
> internet connection my pages wait for fonts.googleapis.com
Its an intranet application.
On Friday, December 8, 2017 at 3:36:35 PM UTC+5:30, T.R.Rajkumar wrote:
>
> I have an application. The views extend layout.html. When there is no
> internet connection my pages wait for fonts.googleapis.com
> I dont want that to happen. How to remove the
I have an application. The views extend layout.html. When there is no
internet connection my pages wait for fonts.googleapis.com
I dont want that to happen. How to remove the dependecy on
fonts.gooleapis.com
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://git
It's uploadfolder
--
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
Thank you Anthony. Now I understand uploadseparate. I will use uploaded as that
will suit me better.
--
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
The uploadseparate creates folder sructure like
uploads/amc_master.annexure/a0, uploads/amc_master.annexure/87 for the
field annexure in table amc_master. Here a folder is created with the first
two letters of UUID. So for me each session a new UUID folder is created
and the annexure file is st
The order table id will be returned by the insert statement. There will be
no race. We can use the returned id in items table.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list
Any ideas?
--
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
I want data to be captured for tdr_bid_unrev_detls.rate. I have the query
below.
select d.jcod,d.qty,u.rate,u.amt
from tdr_tender_master t join amc_master m on t.amc_id = m.id
join amc_details d on m.id = d.amc_id
left join tdr_bid_unrev_detls u on u.tdr_id = t.id and u.amc_id = m.id
where m.
Yes, Anthony I did del session.auth in logout action and it working fine.
Thanks for all the input. I thought I cannot use the grid without auth. But
now because of your help the dependency has been removed and I am on my own
authentication. Thanks again.
--
Resources:
- http://web2py.com
- ht
Now I have ant\other small hitch. When I logout the action logout is called
and redirect to login page.
If I or another user logins in with the same browser window digital
signature is not available in grid.
If I close the browser window and open the browser and login _signature is
available.
Yes, perfect Anthony. Thanks a lot for forbearing with me. Anyway it is my
pleasure to learn from the group.
I put the above code in my login action as below. It is working perfectly.
from gluon.storage import Storage
from gluon.utils import web2py_uuid
def login():
form = FORM(TABLE(
Anthony, When I comment out auth and in model amc/amc.py I add this
from gluon.storage import Storage
from gluon.utils import web2py_uuid
if not 'auth' in session:
session.auth = Storage(hmac_key=web2py_uuid())
Now the smartgrid lists the rows but when add or edit button is clicked I
get not
If I am not defining auth the error does not appear, but the grid
user_signature is not working. I am setting the hmac_key as mentioned in
model amc.py.
from gluon.storage import Storage
from gluon.utils import web2py_uuid
if not 'auth' in session:
session.auth = Storage(hmac_key=web2py_uuid(
I put the below code in my model file amc.py
from gluon.storage import Storage
from gluon.utils import web2py_uuid
if not 'auth' in session:
session.auth = Storage(hmac_key=web2py_uuid())
But now when in run http://127.0.0.1:8000/web_ocms/amc/new_contract I get
this error.
Error ticket for
Yes, Anthony now with user_signature = True prevents tampering of urls
generated by smartgrid.
This is when I use auth and signup and then call the grid.
But in my app I am using custom login form with user credentials from a
legacy table.
Can I achieve the same result with custom login form?
As
Thank you Anthony. I will do the same.
--
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
I have this page from the edit button of the child.
http://127.0.0.1:8000/web_ocms/amc/new_contract/amc_master/amc_details.amc_id/17/edit/amc_details/10
Here 17 is the id of the master and 10 is the id of the child.
I have set common_filter in controller so that the records of master and
child be
If you are creating the form in html then for update forms you must add a
hidden input with name id and set to the edit records id.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues
Am I not clear in my question?
--
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
In grid we have this in book. links_in_grid if set to False, links will
only be displayed in the "details" and "edit" page (so, not on the main
grid).
I want the reverse, the links to be displayed in the main grid and not in
the edit or details page. And that too in the parent gird only, not i
Thanks a lot icodk. Now I am able to change the text of buttons.
--
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
Thanks icodk for the code. But I do not understand grid[1][0][2][0]. What
is that? Could you pl. tell me. Thank you once again.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/lis
Thanks icodk. You said The last part is after the call to
SQLFORM.smartgrid. Here you can manipulate the serialized HTML data by for
example changing the "+Add record" text to "+Add person" in the auto
generated button
I would like to know how you manipulate the html in controller as above f
Yes, Anthony. It now works. Thank you for your valuable time.
--
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 su
As said I did this in controller but there is no effect in either create or
edit forms of amc_master or amc_details. I added the closing parenthesis
for the first dict. Anything I miss?
form = SQLFORM.smartgrid(db.amc_master,
linked_tables=['amc_details'],
Sorry. I am able to do it. In view new_contract.html I have now this.
{{extend 'layout.html'}}
New Contract
{{=form}}