I am creating a simple model to represent a chart of accounts:
For example, we have
0. top account
1. Account 1
1.1 account 1.1
1.11
1.12
1.13
1.2
(...)
2.
2.1
2.2
2.21
2.22
The model is as below :
db.define_table('accountfrom
Hello I am trying to make a page showing a nested list:
period 1
subperiod 1
subperiod 2
subperiod 3
period 2
subperiod 1
subperiod 2
period 3
subperiod 1
period 4
subperiod 1
subperiod 2
subperiod 3
My model is:
db.define_table('period',
SQLField('descrip
I tried the following view:
{{extend 'layout.html'}}
This is the test/show_periods.html template
{{for period in periods:}}
{{period}}
{{ subperiods = db(db.subperiod.period=period.id).select()}}
{{for subperiod in subperiods:}}
{{subperiod}}
{{pass}}
{{pass}}
Tried what you suggested (see below), but I still have an error
message:
def show_periods():
periods=db().select(db.period.ALL)
return dict(periods=periods)
{{extend 'layout.html'}}
This is the test/show_periods.html template
{{for period in periods:}}
{{=period}}
{{subperiods =
Where line 42 is subperiods = db
(db.subperiod.period=period.id).select()
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
can not access as well, and have an Invalid function.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this
I am trying to show the detail for a foreign key, but I really do not
know how to do it.
My model is:
db.define_table('currency',
SQLField('code',length=3),
SQLField('name',length=100))
db.currency.code.requires=[IS_NOT_EMPTY(),IS_NOT_IN_DB
(db,'currency.code')]
db
Would it be possible to add an example of more complex form on the
web2py website, as it may be a way of answering lots of queries?
On my side, I was asking myself the same question and was trying to do
a complex form using a bit of javascript (Jscript?).
Like lots of new user of Web2py, I find
An example of "return response.render('custom.html',data=data) " would
be useful on the web2py website.
Fabulous framework.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to th
tried to install the spreadsheet application, but I have the following
error message: unable to install application spreadsheet.
It is possible to download the file, but I believe file is corrupt
--~--~-~--~~~---~--~~
You received this message because you are subs
Try to install from the following link
http://www.web2py.com/appliances/default/download/app.source.abebe92ece83f899.73686565742e773270.w2p,
and I still have an error message, Unable to install application
"spreadsheet".
Am I the only one in this case?
Francois
--~--~-~--~~--
I am currently building an accounting system for companies. This could
be used as a foundation to develop more financial applications. Likely
delivery end of the year.
Your release of spreadsheet is proving very useful, eventhough I am
encountering similar difficulties to some people on the mailin
Reviewed chapter 7 Forms and validators.
The chapter deals with multiple forms per page, however a more complex
example would be useful.
Let me explain the limitation of the current presentation. The example
presented page 178 has a validation button for each form, but it is
not possible to vali
Reviewed chapter 7 Forms and validators.
The chapter deals with multiple forms per page, however a more complex
example would be useful.
Let me explain the limitation of the current presentation. The example
presented page 178 has a validation button for each form, but it is
not possible to vali
Agree with Massimo, that it is the best solution.
Still struggling with it though :;)
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegr
Back with an old query, in order to deal with an e-store, we would
need to deal with numeric, as we need to deal with prices which are
monetary amounts in multiple currencies.
I can not remember where we are with numeric implementation?
For example in SQLalchemy, numeric is defined as
class sql
For example in Postgresql and MySQL , we Monetary Types:
http://www.postgresql.org/docs/8.4/static/datatype-money.html
http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html
I really believe that we should store monetary amount using the
monetary amount available in the database if available,
I am trying to make a complex redirection:
Each transaction can have multiple transactions lines. For each
transaction, the user can create a new transaction line or edit an
existing one.
When the user has posted a new transaction line or edited an existing
one, the page should redirect to the p
I am writing a small accounting software using WEB2PY and Jquery
validate. I have started writing a dynamic javascript page, but I am
new to it.
Would anyone be willing to work on it for a fee.
I am using an enhancement of the example dynamic total from the Jquery
validate package, and this i
So there are no members in Linkedin, as Massimo needs to authorise
users who request to join the group :) or alternatively should allow
everyone to join.
On Aug 18, 3:09 pm, mdipierro wrote:
> I do not know what Ning is. There are groups on linked-in and facebook
> but no action there. All the a
how many hours of work are expected for this 5 weeks course?
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this
Is anyone wanting to join forces to create a MIT/GPL accounting
software?
I spent a year writing specification for a multi currencies accounting
software and would love to share with other people. We have a nice
interface for entering transactions:
http://olivvv.aptanacloud.com/compta/index.html
unts.
> However, if you give me some idea of your project perhaps some
> elements would overlap, especially for data entry.
>
> I see a role for Massimo's spreadsheet for reporting or modelling
> budgets etc.
>
> Regards,
> -David
>
> On Dec 17, 7:31 am, "Fra
Forgot to say, I have found a fabulous expert on jquey, who will help
build the nice forms.
Massimo, any chance of paying some students to help on project to
advance on the accounting software project?
--
You received this message because you are subscribed to the Google Groups
"web2py-users" g
have spent one year working on the blueprint of the software, and I
feel it would a very interesting/revolutionnary software for the free
software, as accounting is really what is missing.
On Dec 18, 3:38 am, mdipierro wrote:
> Who pays? I can find the students.
>
> On Dec 17, 3:48 pm,
thers, you might get some
> people to chip in with the costs etc. Something simple which also
> works on GoogleApps could be quite revolutionary!
>
> Regards,
> - David
>
> On Dec 17, 9:40 pm, "Francois (Jersey)"
>
>
>
> wrote:
> > Hi David,
>
>
Dear all,
Having a numeric/decimal support for web2py is key to produce
applications including accounting or financial aspects, and there had
been discussions about it back in March.
I understand that the reason for not including decimal or numerical is
that it is not supported by all the databa
I thought that Python, since version 2.4 could deal with decimal.
Please have a look at the link http://docs.python.org/library/decimal.html
Am I missing something? If Python can deal with decimal and the
database can as well, would it make sense to have decimal implemented
in Web2py?
Apologies,
Floats can not be used, as float may give a different result from
decimal, and this is not acceptable for financial applications:
An explanation of the difference can be found at
http://docs.python.org/library/decimal.html
--~--~-~--~~~---~--~~
You received this me
Agree with Joe, on the need to store decimal in the database. I may be
biaised because I have used Sqlalchemy before.
I suppose we should be able to find inspiration from Sqlalchemy code
for decimal...
Please let me know how I can help.
--~--~-~--~~~---~--~~
You r
The link to the Sqlalchemy page should be useful:
http://www.sqlalchemy.org/docs/05/reference/sqlalchemy/types.html
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group,
31 matches
Mail list logo