[web2py] link to item on list.

Hi, I understand the url structure: app/function/view but assuming I have a list of items on the view, How do I get to a view page for each one of them and where can I build that page template? Thanks. -- --- You received this message because you are subscribed to the Google Groups "web2py-u

[web2py] Re: Data of 'reference db on select

On Sunday, September 1, 2013 12:25:32 AM UTC+3, אבי אברמוביץ wrote: > > Hi, > I do this query: > items = db.executesql('SELECT * FROM project;') > For the field below, which is a field in the db.project: > Field('company_name', 'reference company', notnull=True). > On the view, "{{=item[3]}}" ren

[web2py] Re: Data of 'reference db on select

index.html: {{extend 'layout.html'}} All projects: {{for item in items: }} {{=item[3]}} {{pass}} def_index: items = db.executesql('SELECT * FROM project;') return locals() model: db.define_table('company', Field('company_name', notnull=True, unique=True), Field('email'), Field('phon

Re: [web2py] User Preference Settings

Tell us what is not working in your try. On Sat, Aug 31, 2013 at 11:33 AM, dirman wrote: > i want to add a preference settings page where a logged in user can change > font size and also turn off advertisement on the website > and this will be unique to the user.i don like the cookie method that

Re: [web2py] need syntax help

First things, first. 1) Paste your code in a pastebin service, like pastebin.com and tell us the url. In python, indentation is important. 2) Paste all your error, telling in which line the error occurred. 3) If your message says "no JSON object could be decoded", probably you didn't get a string

Re: [web2py] reference + represintation

Maybe because your orders._format mentions invalid fieldnames, i.e., phone2_id and deal_id. On Sat, Aug 31, 2013 at 5:26 AM, Dmitry Ermolaev wrote: > How show names instead id in complex base? > > > db.define_table('phones', >Field('number', length=12, unique=True), >Field('text', 'text')

[web2py] Re: Simple steps to run web2py on Ubuntu Desktop 12.04 (precise) 64-bit - linux

Though Python should already be there in Ubuntu. On Saturday, August 31, 2013 2:20:26 PM UTC-7, Massimo Di Pierro wrote: > > You can just do > >sudo apt-get install python > > then download and unzip web2py_src.zip > > You then start it with > >python web2py.py -a 'password' > > This is eq

[web2py] Re: Minus Query

Thanks for the quick response! On Saturday, August 31, 2013 10:09:16 PM UTC-4, Massimo Di Pierro wrote: > > db(queryA)(~db.table.id.belongs(db(queryB)._select(db.table.id))).select() > > On Saturday, 31 August 2013 20:11:49 UTC-5, arche...@gmail.com wrote: >> >> I was wondering how to do the equiv

[web2py] Re: Minus Query

db(queryA)(~db.table.id.belongs(db(queryB)._select(db.table.id))).select() On Saturday, 31 August 2013 20:11:49 UTC-5, arche...@gmail.com wrote: > > I was wondering how to do the equivalent of a minus sql query > (http://www.umanitoba.ca/

[web2py] Minus Query

I was wondering how to do the equivalent of a minus sql query in DAL or the best way to emulate this functionality? Thank you in advance! -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving em

[web2py] Re: Data of 'reference db on select

I need to see more code. On Saturday, 31 August 2013 16:25:32 UTC-5, אבי אברמוביץ wrote: > > Hi, > I do this query: > items = db.executesql('SELECT * FROM project;') > For the field below, which is a field in the db.project: > Field('company_name', 'reference company', notnull=True). > On the view

[web2py] Re: OperationalError: near ", ": syntax error, I'm new to this, maybe I dont use DAL properly.

Thanks Niphlod for pointing me to the right direction: db.define_table('items,', ^ (there is an extra comma right there, at the table name definition) -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsu

[web2py] Data of 'reference db on select

Hi, I do this query: items = db.executesql('SELECT * FROM project;') For the field below, which is a field in the db.project: Field('company_name', 'reference company', notnull=True). On the view, "{{=item[3]}}" renders only '1'.(instead of the company name). What should I do? Thanks. -- --- Yo

[web2py] Re: Simple steps to run web2py on Ubuntu Desktop 12.04 (precise) 64-bit - linux

You can just do sudo apt-get install python then download and unzip web2py_src.zip You then start it with python web2py.py -a 'password' This is equivalent to the windows and mac binaries. On Saturday, 31 August 2013 09:59:10 UTC-5, Rob_McC wrote: > > Having run web2py on Mac and windo

[web2py] column auth_user.first)name does not exist

I have an application that contains only model files: db_model the databases folder contains the .table files models contains the _db.py files Furthermore I have 2 applications: init cms the databases folder of both applications is empty models containsthe _db.py with the connection string set

[web2py] Re: Starting web2py fails silently with Cygwin python

I uninstalled Cygwin and the Windows Python, and reinstalled Cygwin to make sure there's no conflict between the two Python versions. Unfortunately I get the same behavior. As mentioned before, the last statement traced is "func = self._FuncPtr((name_or_ordinal, self))". On Friday, August 30, 2

[web2py] Re: OperationalError: near ", ": syntax error, I'm new to this, maybe I dont use DAL properly.

open up your dataabses/sql.log to see what command has been issued to create the tables... On Saturday, August 31, 2013 5:43:45 PM UTC+2, George Petsagourakis wrote: > > Hello everyone, > I have the following table definitions: > > db.define_table('identities', > Field('name', 'string', requi

[web2py] OperationalError: near ", ": syntax error, I'm new to this, maybe I dont use DAL properly.

Hello everyone, I have the following table definitions: db.define_table('identities', Field('name', 'string', required=True), Field('profession', 'string', required=True), Field('address','text', required=True), Field('vat_number',unique=True, required=True, length=9, requires=IS_

[web2py] Re: querying database if a user exists, and retrieve fields if exists, is there a better way.

Thanks... that was just what I needed. I learned about: Ternary conditional operator in Python http://stackoverflow.com/questions/394809/ternary-conditional-operator-in-python *and I understand much better the D

Re: [web2py] DAL , pymysql

now thats ok, but let me reflect about: take into consideration that, i dont have experience in web application, neither database server, all are new for me, so i could be wrong, i hope not. Application "B" (DAL standalone), should read, update and insert data in the database, then: db = DAL ('mys

[web2py] Simple steps to run web2py on Ubuntu Desktop 12.04 (precise) 64-bit - linux

Having run web2py on Mac and windows effortlessly ... I expected the same on Ubuntu... but... I found it a bit harder to get running. Ubunto Desktop works great on old Windows machines, and it is fun to play with. I bought a used $30 computer and installed Ubunto and was impressed with how fast

[web2py] User Preference Settings

i want to add a preference settings page where a logged in user can change font size and also turn off advertisement on the website and this will be unique to the user.i don like the cookie method that runs on client machines. I am thinking of a function that can manipulate css property values an

[web2py] Re: Webhosts for Web2py

On Saturday, August 31, 2013 6:32:16 AM UTC-7, Adi wrote: > Their pricing looks good. Do they offer different distributions (ubuntu > primarily)? > Ubuntu 10.4, 12.04, 12.10, and 13.04 in x32 and x64. Also, CentOS, Debian, Arch Linux, and Fedora. > I've been with linode for the last year, an

[web2py] Re: Webhosts for Web2py

Their pricing looks good. Do they offer different distributions (ubuntu primarily)? I've been with linode for the last year, and so far very happy. Adnan On Thursday, August 29, 2013 5:20:10 PM UTC-4, Anthony wrote: > > You might consider Digital Ocean (j

[web2py] need syntax help

hi all, I need some syntax help. I need to talk to a remote server, post a request adn receive the answer. I thought I would use the Stipe.py as a basis because it almost suits my needs. I need an equivalent of this curl statement to receive a list of my invoices the 8e7659 is the api of my

[web2py] reference + represintation

How show names instead id in complex base? db.define_table('phones', Field('number', length=12, unique=True), Field('text', 'text'), format='%(number)s', ) db.define_table('orders', Field('name', required=True, notnull=True), Field('created_on', 'datetime', writable=False, def

Re: [web2py] Re: Janrain/RPX widget migration

Done. Thanks. On Sat, Aug 31, 2013 at 12:29 AM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Please open a ticket. We will do that asap. > > > On Friday, 30 August 2013 12:54:06 UTC-5, molhokwai wrote: >> >> Hi, >> >> The janrain/rpx widget is no longer supported since July ( >> http