[web2py] Strange invalid function issue after renaming controller name

2024-08-01 Thread at
elopment environment. Any suggestions on what might be causing this discrepancy? Thanks, AT -- 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

[web2py] Re: What is a good way to monitor database changes in web2py?

2022-11-30 Thread at
I found that callback functions can serve the purpose - but just curious if there are other better ways? On Thursday, 1 December 2022 at 11:24:39 UTC+5 at wrote: > Hi, > I was wondering what is a good way to monitor changes in certain database > tables? The purpose is to post d

[web2py] What is a good way to monitor database changes in web2py?

2022-11-30 Thread at
Hi, I was wondering what is a good way to monitor changes in certain database tables? The purpose is to post data to an external API if one of define conditions is met. Thanks, AT -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] Got error when I put 'fields' as an argument to SQLFORM.grid

2021-01-25 Thread at
Here is the code: `fields=['id', 'name']` `grid = SQLFORM.grid(db.engagement, fields=fields)` Error: `AttributeError('str' object has no attribute 'tablename')` -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://c

[web2py] Re: Is it possible to write to session variables from Web2py modules?

2021-01-23 Thread at
Thank you Stifan & Clemens for the help! Best Regards On Saturday, 23 January 2021 at 14:53:26 UTC+5 Clemens wrote: > Just reference the session in the module by: > session = current.session > > Then you can use exactly in the same way as in the controllers. > > Best rega

[web2py] Is it possible to write to session variables from Web2py modules?

2021-01-20 Thread at
Is it possible to write to session variables from Web2py modules? -- 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 a

[web2py] Re: What is the recommended way to translate dynamic contents in a multilingual website?

2016-11-03 Thread at
Thank you Leonel for your reply. I am looking into the suggested solutions. On Wednesday, 2 November 2016 18:21:51 UTC+5, Leonel Câmara wrote: > > If I understood your question correctly, I think I have answered this, > here: > > https://groups.google.com/forum/#!topic/web2py/y1QYmM4HfeM > >

[web2py] What is the recommended way to translate dynamic contents in a multilingual website?

2016-11-01 Thread at
those translation files can grow extremely big, since description for example can contain hundreds of words for each project. What do you think about this? Thanks, AT If T() is used, then those translation files can grow extremely big, since description for example can contain hundreds of words for

[web2py] Re: How does auth.signature work? deletion of inactive records

2015-12-09 Thread at
Thank you Massimo. One quick question: When we use auth.signature, and then delete records in a table, they are marked as deleted but they are not actually deleted from the database. What is the recommended way to delete such records from the database? Best Regards, AT On Thursday, 10

[web2py] How does auth.signature work? deletion of inactive records

2015-12-08 Thread at
ually delete it from the database but it is marked as inactive; what is the recommended way or configuration that allows me delete the *inactive* records from the database? Thanks, AT -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Re: New Web2py Materialize CSS Welcome app scaffold

2015-11-28 Thread at
css. > > The repository is available at: > > https://bitbucket.org/MarkGraves/welcome_materialize/ > > You can preview it at: > > https://gravesmedical.pythonanywhere.com/welcome/ > > There are definitely some issues, but I thought it might be useful for > some folks. &g

[web2py] Why there is a blank option in drop-down and how to avoid it?

2015-11-13 Thread at
Hi, When I create a SQLFORM for a table containing following field, it creates a drop-down listing all specified fields and *additionally a blank option*. How can we avoid it? Field('code', default='F3', requires=IS_IN_SET(['U1', 'F3', 'T9', 'K3', 'S2', 'M1', 'Z5'])), T

[web2py] Re: Dynamic addition of name-value pairs using SQLFORM or CRUD

2015-11-13 Thread at
e('phone', > Field('config2', 'reference config2'), > Field('service_type', 'string'), > Field('phone_number', 'string')) > > Then you could use SQLFORM.smartgrid to display/navigate the two tables > and add r

[web2py] Re: Dynamic addition of name-value pairs using SQLFORM or CRUD

2015-11-12 Thread at
Initially I was thinking the same, but results are not as desired: db.define_table('phone', Field('service_type', 'string'), Field('phone_number', 'string')) db.define_table('config2', Field('cell_phones', '

[web2py] Re: Dynamic addition of name-value pairs using SQLFORM or CRUD

2015-11-12 Thread at
Hi Stifan, Thank you for your prompt reply. This will not give the desired result. After your suggested change, I get: What I need is service-type and phone-number side-by-side, so when I add a record it should add one service-name and one corresponding phone number. Best Regards, Atif On Fr

[web2py] Dynamic addition of name-value pairs using SQLFORM or CRUD

2015-11-12 Thread at
phoneconfig.py form = crud.update(db.config, 1) views/phoneconfig/index.html {{extend 'layout.html'}} {{=form}} Thanks, AT -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/is

[web2py] Has somebody used codenvy for web2py application deployment?

2015-11-02 Thread at
looking for git repository integration so that one of my friend can also collaborate in this project. Is codenvy the right thing for my needs? Thanks, AT -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https

[web2py] Re: pypfdf - how to make text wrap table cells?

2015-09-05 Thread at
Thanks a lot Edwood for your help. I'll definitely try to follow your tips. Best Regards, AT On Sunday, 6 September 2015 09:55:25 UTC+5, Edwood wrote: > > Hi. > > Wrapping inside table columns is not currently supported by "write_html", > nor are CSS prope

[web2py] pypfdf - how to make text wrap table cells?

2015-09-03 Thread at
Hi, I was trying to use the first sample report from: https://code.google.com/p/pyfpdf/wiki/Web2Py. I modified it a little to fill the data dynamically inside the table, but the long text is not wrapping inside the table cells. I've tried setting different css to address the issue but no luck.

[web2py] Re: How to define id for a form created with SQLFORM.factory ?

2015-08-29 Thread at
as well: > > myform = SQLFORM.factory(..., _id='myformid') > > Anthony > > On Friday, August 28, 2015 at 2:55:18 AM UTC-4, at wrote: >> >> Ok, got it. >> >> >> myform = SQLFORM.factory( >> Field('title', label=T

[web2py] Re: How to define id for a form created with SQLFORM.factory ?

2015-08-27 Thread at
Ok, got it. myform = SQLFORM.factory( Field('title', label=T('Title'), requires=IS_NOT_EMPTY()), . . . ) myform['_id'] = 'myformid' On Friday, 28 August 2015 10:54:08 UTC+5, at wrote: > > Hi, > > A quick and silly q

[web2py] How to define id for a form created with SQLFORM.factory ?

2015-08-27 Thread at
Hi, A quick and silly question: *How to define id for a form created with SQLFORM.factory?* 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 r

[web2py] Is it a good idea to convert a jhomla website to web2py app for WHMCS integration?

2015-05-27 Thread at
Hi, I've been asked to integrate WHMCS with a jhomla website. The website currently consists of just a few pages of information on the business, its services, products, clients and feedback/contact form. My most of the recent work experience is on python & web2py and I am intermediate-level de

[web2py] Re: Error while inserting in table with custom id

2014-06-26 Thread at
So it's incorrect or impermissible to add records with custom ids? Thanks On Thursday, 26 June 2014 16:33:02 UTC+5, at wrote: > > > Yes you are right. Without id=1 it's working. > But if I insert data using postgres/psql with id=1, it doesn't give any > error as

[web2py] Re: Error while inserting in table with custom id

2014-06-26 Thread at
Yes you are right. Without id=1 it's working. But if I insert data using postgres/psql with id=1, it doesn't give any error. Regards, AT On Thursday, 26 June 2014 15:39:20 UTC+5, Simon Ashley wrote: > > Believe it will be failing with the id=1 etc. Interfering with the prim

[web2py] Re: Error while inserting in table with custom id

2014-06-26 Thread at
Yes On Thursday, 26 June 2014 14:55:35 UTC+5, Niphlod wrote: > > was the table created by web2py ? > > On Thursday, June 26, 2014 9:53:31 AM UTC+2, at wrote: >> >> Hello, >> >> I am getting getting this: >> >> (lastval is not yet defined i

[web2py] Error while inserting in table with custom id

2014-06-26 Thread at
l NOT NULL, title character varying(50), CONSTRAINT user_role_pkey PRIMARY KEY (id ) ) WITH ( OIDS=FALSE ); Any help please ... Thanks & Regards AT -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.goog

[web2py] Re: PIL library not working with apache 2.2

2014-06-11 Thread at
On Wednesday, 11 June 2014 21:08:43 UTC+5, Niphlod wrote: > > this is the relevant excerpt > > *Note that the version of Python from which this baseline environment is > created must be the same version of Python that mod_wsgi was compiled for. > It is not possible to mix environments based on

[web2py] Re: PIL library not working with apache 2.2

2014-06-11 Thread at
wrote: > > verify that apache is running the same python version you're running and > has PIL installed. This is a well-known issue, but has nothing to do with > web2py. > > On Wednesday, June 11, 2014 2:39:38 PM UTC+2, at wrote: >> >> facing same issue both on ubuntu

[web2py] Re: PIL library not working with apache 2.2

2014-06-11 Thread at
facing same issue both on ubuntu and windows7: Trying: from PIL import ImageGrab Getting: ImportError: No module named PIL and the strange thing is *no errors* on: from PIL import Image Any help? Thanks On Wednesday, 11 June 2014 15:16:47 UTC+5, Sharjeel Ali Shaukat wrote: > > I m having a pr

[web2py] Re: Basic Auth with alternate auth method

2014-04-10 Thread at
Hi Damien, Have you got the answer of your question? I was also looking for the similar stuff. Thanks, AT -- 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

[web2py] Re: Finnish language translator

2014-03-28 Thread at
Thank$ : ) -- 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" grou

[web2py] Finnish language translator

2014-03-26 Thread at
Hi, I am working on a web-application which needs to be translated to finnish language and there are no translator available for *finnish* in web2py languages folder. Can someone suggest what to do now? Thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http:

[web2py] Re: Issues with cpdb - references invalid table

2013-12-01 Thread at
>>> for table in db: >>>print table._tablename returns the correct order, the same as defined in models/db.py, whereas if I add a print statement 'print table' under loop 'for table in self.db:' in scripts/cpdb.py it returns the list of tables in alphabetic order. Thanks & Regards On

[web2py] Issues with cpdb - references invalid table

2013-11-27 Thread at
27;admission' table and hence failing. Any suggestions how it can be fixed? How can we force *cpdb* to use the same order of tables definition as defined in *db.py*? Thanks & Regards, AT PS. I am using -f, -F, -y, -Y & -d switches with cpdb. -- Resources: - http://web2py.com

[web2py] Re: Difference between datetime.now and datetime.now()

2013-11-07 Thread at
Thanks Anthony for the explanation. We am using #1 and occasionally get '*insufficient data left in message*', could it be because of datetime.now? On Thursday, 7 November 2013 17:56:47 UTC+5, Anthony wrote: > > Is there any difference between following two statements: >> #1 >> from datetime imp

[web2py] Difference between datetime.now and datetime.now()

2013-11-07 Thread at
x27;, type='datetime', default=request.now, writable=False ), ) Thanks & Regards AT -- 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 rec

[web2py] Re: Insert Failed: Insufficient data left in message

2013-11-06 Thread at
Yes except datetime fields; the all inserted values seem to be ok and datetime fields are evaluated by datetime.now AT On Thursday, 7 November 2013 12:41:55 UTC+5, Paolo Valleri wrote: > > have you checked the variables content of a failure? > Paolo > -- Resources: - http://web2p

[web2py] Insert Failed: Insufficient data left in message

2013-11-06 Thread at
Hi, Occationally an error is reported stating following problem: "/home/www-data/web2py/gluon/dal.py", line 8514, in insert\nret = self._db._adapter.insert(self, self._listify(fields))\n File "/home/www-data/web2py/gluon/dal.py", line 1206, in insert\nraise e\nProgrammingError: (\'ERR

[web2py] Re: CREATE DATABASE cannot run inside a transaction block

2013-10-03 Thread at
thank you richard! -- 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-use

[web2py] Re: Is is possible to create a postgres database from web2py application?

2013-10-03 Thread at
Thanks all for replies and assistance; I've now a better understading of DAL's scope and limitations. Regards, AT -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/li

[web2py] Is is possible to create a postgres database from web2py application?

2013-10-02 Thread at
Is is possible to create a postgres database from web2py application? Thanks & Regards -- 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

[web2py] CREATE DATABASE cannot run inside a transaction block

2013-10-02 Thread at
Hi, I am getting following error message while trying to run statements: db0 = DAL('postgres://adminuser:testing@localhost/postgres') result=db0.executesql('create database mydb owner user1;') ('ERROR', '25001', 'CREATE DATABASE cannot run inside a transaction block') Can someone help

Re: [web2py] Re: crud forms for multiple records? Multiple tables?

2013-10-02 Thread at
thanks rischard. On Tuesday, 1 October 2013 19:00:49 UTC+5, Richard wrote: > > But you can mimick crud authentication with > auth.has_membership('role_name') or auth.has_permission(...), read the book > about that. > > Richard > > > On Tue, Oct 1, 2013 at

[web2py] Re: crud forms for multiple records? Multiple tables?

2013-10-01 Thread at
Does it work with crud as well? Thanksd On Monday, 12 October 2009 06:37:31 UTC+5, mdipierro wrote: > > Something is wrong with this: > > db.define_table('dogs', > ... > Field('vaccination_id', db.vaccinations)) > > db.define_table('vaccinations', > Field('dog_id', db.dogs), >

[web2py] Re: Homemade Task Queues

2013-08-21 Thread at
s On Wednesday, 21 August 2013 12:06:11 UTC+5, at wrote: > > > Trying to run following script inside a controller: > python web2py.py -S myapp -M -N -R applications/myapp/private/alerts.py > -A 1 2 3 > > and getting: > > SyntaxError: invalid syntax at web2p*y*.py > >

[web2py] Re: Homemade Task Queues

2013-08-21 Thread at
Trying to run following script inside a controller: python web2py.py -S myapp -M -N -R applications/myapp/private/alerts.py -A 1 2 3 and getting: SyntaxError: invalid syntax at web2p*y*.py Can someone assist please. Thanks & Regards AT -- --- You received this message because you

[web2py] Re: How to identify the active .table files

2013-08-19 Thread at
interesting feature .. thanks On Monday, 19 August 2013 19:07:02 UTC+5, Anthony wrote: > > On Sunday, August 18, 2013 12:52:10 AM UTC-7, at wrote: > >> Thank you Niphlod. >> >> If connection string is same, can we generate .table files in one server >>

Re: [web2py] Re: How to identify the active .table files

2013-08-18 Thread at
quite interesting and useful knowledge for me. thanks a lot. On Sunday, 18 August 2013 23:11:45 UTC+5, Anthony wrote: > > On Sunday, August 18, 2013 2:03:47 PM UTC-4, at wrote: > >> >> IC, I was not aware of that. I thought application can't be run without >>

Re: [web2py] Re: How to identify the active .table files

2013-08-18 Thread at
; On 18 Aug 2013, at 10:48 AM, at > wrote: > > Thank you for detailed explaination. > > > > Sorry I couldn't understand that how can we live with a blank databases > folder? > > > > Suppose server1 is active and it has filled databases folder, and &g

[web2py] Re: How to identify the active .table files

2013-08-18 Thread at
Thank you for detailed explaination. Sorry I couldn't understand that how can we live with a blank databases folder? Suppose server1 is active and it has filled databases folder, and server2 is passive with empty databases folder. Both are pointing to same database which is on server3. My und

[web2py] Re: How to identify the active .table files

2013-08-18 Thread at
model is modified. Regards, AT On Saturday, 17 August 2013 16:48:07 UTC+5, Niphlod wrote: > > the part preceding the _options is the md5 of the connection string. If > you want a quick and dirty method, backup those files to another dir, set > fake_migrate=True and let web2py recrea

[web2py] How to identify the active .table files

2013-08-17 Thread at
c5f365ce982338d5733d61d0ac11ded3_option.table eee02c492ba9ed34049a9ff8dc72b10c_option.table Thanks & Regards, AT -- --- 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,

[web2py] Re: File extention automatically changes when a file is uploaded

2013-08-14 Thread at
Thank you Anthony! That means it should be working in 2.4.6-stable? we've 2.4.6-stable on production server. Regards, AT On Thursday, 15 August 2013 10:55:50 UTC+5, Anthony wrote: > > Looks like there was a bug, which has now been fixed in trunk. So, the > second version wi

[web2py] Re: File extention automatically changes when a file is uploaded

2013-08-14 Thread at
2.4.5 On Thursday, 15 August 2013 07:44:02 UTC+5, Anthony wrote: > > What version of web2py are you using? > > On Wednesday, August 14, 2013 9:22:57 PM UTC-4, at wrote: >> >> Thanks a lot anthony, >> db(db.mytable.id==24).update(file1=db.mytable.file1.store(requ

[web2py] Re: File extention automatically changes when a file is uploaded

2013-08-14 Thread at
27;d replied to your post yesterday, but somehow it was not posted On Tuesday, 13 August 2013 19:19:44 UTC+5, Anthony wrote: > > On Tuesday, August 13, 2013 9:20:47 AM UTC-4, at wrote: > >> >> Here is my controller code: >> def test_upload: >> if request.vars.fi

[web2py] Re: File extention automatically changes when a file is uploaded

2013-08-13 Thread at
/mytable.file1.8586ded7f7608eee.746d706c3176667666.txt Thanks, AT On Tuesday, 13 August 2013 17:49:34 UTC+5, Anthony wrote: > > 'txt' is the default extension given if the filename doesn't match the > following regex: '\.(?P\w{1,5})$'. "picture.jpg" should mat

[web2py] Re: File extention automatically changes when a file is uploaded

2013-08-13 Thread at
d? What I mean is, does picture.jpg change into picture.txt > or into picture.jpg.txt? > > Regards, > Ales > > On Tuesday, August 13, 2013 12:10:40 PM UTC+2, at wrote: >> >> >> >> Hi, >> >> Please consider following model: >> db.define

[web2py] File extention automatically changes when a file is uploaded

2013-08-13 Thread at
Hi, Please consider following model: db.define_table('mytable', Field('file1', type='upload', uploadseparate=True, requires = IS_EMPTY_OR(IS_UPLOAD_FILENAME(extension='pdf|jpg|png|gif|doc|docx|rtf|txt', error_message='Only PDF, Word Docs, RTF, Text

[web2py] Re: Connecting to remote database - ERROR', '42P07', 'relation "mytable" already exists

2013-04-25 Thread at
tabase > tables. > > On Thursday, April 25, 2013 12:24:59 PM UTC+2, at wrote: >> >> Hi, >> >> I am trying to connect to a remote postgres database running on a ubuntu >> server. The application is hosted on windows 7 server. Getting following >> error

[web2py] Connecting to remote database - ERROR', '42P07', 'relation "mytable" already exists

2013-04-25 Thread at
Hi, I am trying to connect to a remote postgres database running on a ubuntu server. The application is hosted on windows 7 server. Getting following error on application startup: ('ERROR', '42P07', 'relation "mytable" already exists') The strange thing is in databases folder, I already have

[web2py] Re: The MENU helper and "id"

2013-04-11 Thread at
Thank you Alan for the tip. On Friday, 12 April 2013 00:50:23 UTC+5, Alan Etkin wrote: > > > all you have to do is menu.elements('li') > > Yes, I know, it's just that I had no idea that the MENU helper didn't > support server-side DOM in the same way as the other helpers. Perhaps it > can be enh

[web2py] Re: The MENU helper and "id"

2013-04-11 Thread at
> For example, instead of: > > response.menu = [(T('Home'), False, URL('default', 'index'))] > > you could do: > > response.menu = [LI(A('Home', _href=URL('default', 'index')), _id='myid')] > > Of course, that is

[web2py] Re: The MENU helper and "id"

2013-04-11 Thread at
Hello, Is it possible to define ids of s if we are using MENU helper / response.menu? On Thursday, 11 April 2013 14:47:00 UTC+5, at wrote: > > > Can somebody assist how can we define "id"s for sub-menu items? > > Thanks > > -- --- You received this messag

[web2py] The MENU helper and "id"

2013-04-11 Thread at
Can somebody assist how can we define "id"s for sub-menu items? 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.c

[web2py] Re: web2py with ExtJS - advice required on restructing

2013-04-08 Thread at
Thank you Alan .. will give it a try definately. May be I'll be the first to download this plugin? :) Regards On Monday, 8 April 2013 00:15:12 UTC+5, Alan Etkin wrote: > > > You are right we cant get web2py form helpers but can you > authentication, session management, jsonifying etc. We alrea

[web2py] Re: web2py with ExtJS - advice required on restructing

2013-04-05 Thread at
in static. Your ExtJS should handle > all the data. Add json services and let the ExtJS consume them. Note that > you won't get form helpers or the security that web2py provides, but you > get the authentication, DAL, automatic jsonifying and caching. > > > On Thursda

[web2py] Re: web2py with ExtJS - advice required on restructing

2013-04-05 Thread at
One of the problems is that the extjs implementation has made the application slow. Because each page is itself an extjs application, it reloads extjs libs on accessing a view. So wanted to at least avoid reloading of js libs on each page access request. Regards On Friday, 5 April 2013 19:03

[web2py] web2py with ExtJS - advice required on restructing

2013-04-04 Thread at
HI, Started working on a project where the team is already working on using extjs to develop the views. Each view of web2py application is basically an ExtJS application. They've placed extjs library in web2py/applications/app/static /extjs and created an extjs_views folder in web2py/applicat

[web2py] Re: Change title of db field in a DAL select

2013-03-06 Thread at
is ~ a list of dictionaries, so you can play with it > freely. > > On Wednesday, March 6, 2013 10:21:39 AM UTC+1, at wrote: >> >> actually I wanted to change this label just in current record set, I mean >> in *rows* only; is it possible? >> >> thanks >>

[web2py] Re: Change title of db field in a DAL select

2013-03-06 Thread at
actually I wanted to change this label just in current record set, I mean in *rows* only; is it possible? thanks On Wednesday, 6 March 2013 14:18:32 UTC+5, 黄祥 wrote: > > i'm usually use it on models for : > db.person.dob.label=T('Date of Birth') > the other solution is to use labels in form (SQ

[web2py] Re: Change title of db field in a DAL select

2013-03-06 Thread at
thanks for the swift response! when this label statement should be run ... before or after running * db().select*? regards On Wednesday, 6 March 2013 13:29:21 UTC+5, 黄祥 wrote: > > yes, it can please use label > e.g. > db.person.dob.label=T('Date of Birth') > > or if you use sqltable you can use

[web2py] Change title of db field in a DAL select

2013-03-06 Thread at
Can we change title of a field in DAL select? e.g. in rows=db().select(db.persons.name, db.persons.dob, db.persons.occupation), can we change db.persons.dob title to Date of Birth in resultset i.e. in rows? Thanks -- --- You received this message because you are subscribed to the Google Gr

Re: [web2py] Re: How to use orderby with two or more fields

2013-03-05 Thread at
Thanks Johann, it works. :) I'd tried it earlier but was getting some errror. I hadn't realized that it was due to some other problem. Regards On Wednesday, 6 March 2013 11:33:09 UTC+5, Johann Spies wrote: > > On 6 March 2013 08:10, at > wrote: > > > > Pl cons

[web2py] Re: How to use orderby with two or more fields

2013-03-05 Thread at
Pl consider following select statement: rows=db().select(db.persons.ALL, db.books.ALL, left=db.persons.on(db.persons.id==db.books.owner)) Want to order by persons.dob, then books.purchased, where both are of type date/time. On Wednesday, 6 March 2013 11:01:03 UTC+5, 黄祥 wrote: > > could you be

[web2py] How to use orderby with two or more fields

2013-03-05 Thread at
Is it possible to order by two or more db fields in a DAL select statement? Thanks & Regards, AT -- --- 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 em

Re: [web2py] How to call a web service from web2py application?

2013-02-13 Thread at
thanks for the reply and info. nice to know that you were one of the contributers of urllib3 development. can you help me understanding what is the differnce between Requests source available at http://docs.python-requests.org/en/latest/index.html and @ https://github.com/niphlod/w2p_tvseries

Re: [web2py] How to call a web service from web2py application?

2013-02-13 Thread at
returns xml, but a few are > jsonrpc ... but you'll get the idea). > > > On Wednesday, February 13, 2013 9:00:55 AM UTC+1, at wrote: >> >> >> Thanks, I am trying it now. >> >> What about using external libs like >> *Requests*<http://docs.pyth

Re: [web2py] How to call a web service from web2py application?

2013-02-13 Thread at
using them? Regards On Tuesday, 12 February 2013 19:38:29 UTC+5, tomasz bandura wrote: > > Did you read http://web2py.com/books/default/chapter/29/14#Twitter-API? > > It is an example of Twitter RESTful+ json. > > T. > > > 2013/2/12 at > > >> >> Want to

[web2py] How to call a web service from web2py application?

2013-02-12 Thread at
Want to call a web service from a web2py application. The service supports get/posts methos for taking input and gives response in json. Can someboday help me out? Thanks & Regards, AT -- --- You received this message because you are subscribed to the Google Groups "web2py-use

Re: [web2py] Upgrading web2py 1.99.7 to 2.3.2 on ubuntu

2013-02-07 Thread at
old version of web2py... > > Richard > > > On Thu, Feb 7, 2013 at 4:06 AM, at >wrote: > >> Hi, >> >> Currenty we are usnig web2py (1.99.7) + apache + ssl + mod_wsgi + >> postgresql on ubuntu on production and development servers. >> Before we upgr

[web2py] Upgrading web2py 1.99.7 to 2.3.2 on ubuntu

2013-02-07 Thread at
the best and clean way to accomplish it? Thanks, AT -- --- 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 mo

[web2py] Re: How to check/get the data type of db fields

2012-12-29 Thread at
quot;Found something else" *Regards On Saturday, 29 December 2012 13:23:39 UTC+5, at wrote: > > lets say we've: > dType = type(all_rows[rowid][key]) > > Now how to check if the dType is string, or integer, boolean etc? Any > build-in functions for this purpose? &g

[web2py] Re: How to check/get the data type of db fields

2012-12-29 Thread at
lets say we've: dType = type(all_rows[rowid][key]) Now how to check if the dType is string, or integer, boolean etc? Any build-in functions for this purpose? Regards On Saturday, 29 December 2012 13:07:29 UTC+5, at wrote: > > > While looping through all database fields of a

[web2py] How to check/get the data type of db fields

2012-12-29 Thread at
While looping through all database fields of a table, need to determine data-type of each field before processing data in it. How to determine which fields is of type *str*, which one is of *int type*, etc. Can somebody assist? Thanks --

[web2py] Re: Table Name from ROWS object

2012-12-28 Thread at
> > On Friday, 28 December 2012 01:24:37 UTC-6, at wrote: >> >> thank you massimo for this interesting and very useful tip ... it would >> save my good amount of time >> btw, is this syntax available in web2py documentation? >> >> On Friday, 28 December 2

[web2py] Re: Table Name from ROWS object

2012-12-27 Thread at
ame][myfld] == "")).update( > [myfld] = myvalue)* > * > * > *should be* > * > * > *db((db[table_name].id == rowid) & (db[table_name][myfld] == > "")).update(**{myfld:myvalue})* > * > * > > > On Friday, 28 December 2012 00:40:15 UTC-6, at wr

[web2py] Re: Table Name from ROWS object

2012-12-27 Thread at
uot;")).update( [myfld] = myvalue)* thanks On Thursday, 27 December 2012 19:41:45 UTC+5, Anthony wrote: > > * > db(db[tname].id <http://db.tname.id/> == rowid).select() > > *or just: > > db[tname](rowid) > > Anthony > > On Thursday, December 27, 2012 9:35:5

[web2py] Re: Table Name from ROWS object

2012-12-27 Thread at
thanks all for the prompt response & help. regards On Thursday, 27 December 2012 19:41:45 UTC+5, Anthony wrote: > > * > db(db[tname].id <http://db.tname.id/> == rowid).select() > > *or just: > > db[tname](rowid) > > Anthony > > On Thursday, D

[web2py] Re: Table Name from ROWS object

2012-12-27 Thread at
Wanted to avoid hard-coding table name in the following statement by using var *tname*, but not successful: any tip pls? *db(db.tname.id == rowid).select* Thanks On Thursday, 27 December 2012 19:10:31 UTC+5, at wrote: > > gr8! > *tname,z=my_rows.colnames[0].split('.')* gav

[web2py] Re: Table Name from ROWS object

2012-12-27 Thread at
On Thursday, 27 December 2012 07:45:52 UTC-6, at wrote: >> >> >> How can we get table name from ROWS object? >> >> Thanks >> > --

[web2py] Table Name from ROWS object

2012-12-27 Thread at
How can we get table name from ROWS object? Thanks --

[web2py] Re: Unable to load module mod_wsgi on Windows

2012-12-25 Thread at
odwsgi/6nmiDUt0ldI/discussion> > > > > > Il giorno lunedì 24 dicembre 2012 12:21:45 UTC+1, at ha scritto: >> >> >> After adding mod_wsgi in apache2, I am getting following error on apache >> startup: >> httpd.exe: Syntax error on line 174 of >&g

[web2py] How to set/reset administrator password (apache+wsgi+windows)

2012-12-25 Thread at
Hi After setting up web2py+apache with wsgi on windows, I can see web2py admin page at http://localhost/admin/default/index. But it is asking password to log into the administrative interface. How to set a password? Is there any default password for first time entrance? Thanks AT --

[web2py] Unable to load module mod_wsgi on Windows

2012-12-24 Thread at
module was downloaded from http://code.google.com/p/modwsgi/downloads/list Can somebody assist? Thanks & Regards AT --

[web2py] tuple to gluon.dal.Rows conversion

2012-12-18 Thread at
Can we convert tuple to gluon.dal.Rows (and vise verse) using any standard function? The requirement is to convert executesql results to gluon.dal.Rows. Thanks in advance --

Re: [web2py] How to access a Virtual Field

2012-12-18 Thread at
: they do not appear in the list of db.table.fields and are not visualized by default in tables (TABLE) and grids (SQLFORM.grid, SQLFORM.smartgrid). On Tuesday, 18 December 2012 18:33:43 UTC+5, Jose wrote: > > > > El martes, 18 de diciembre de 2012 10:24:08 UTC-3, at escribió: >>

Re: [web2py] How to access a Virtual Field

2012-12-18 Thread at
27;), Field.Virtual('namey',lambda row: row.taxpayer.name+'y')) * __init__() takes exactly 2 arguments (3 given)* On Tuesday, 18 December 2012 17:32:00 UTC+5, viniciusban wrote: > > See this: http://web2py.com/examples/default/changelog > > > On Tue, Dec 18

Re: [web2py] Can we override DAL methods?

2012-12-18 Thread at
n is use computed fields. > > But if you really need to use a SQL function, you should write your > query by hand. > > > > On Thu, Dec 13, 2012 at 3:48 PM, at > > wrote: > > > > Hi, > > > > Lets say we've a table with name taxpayers; it

[web2py] How to access a Virtual Field

2012-12-18 Thread at
r = db.taxpayer.id queryset = db(db.taxpayer) record_list = queryset.select(db.taxpayer.ALL, orderby = myorder) ** *Thanks & Regards, AT --

  1   2   >