got it..thanks
On Oct 20, 8:04 pm, Cliff wrote:
> The very long thread (~115 posts) about grid and smartgrid is the best
> source. Sorry, don't recall the title.
>
> On Oct 20, 10:57 pm, greenpoise wrote:
>
>
>
>
>
>
>
> > I keep reading
I keep reading SQLFORM.grid. Any example out there with the different
options?
thanks
Dan
On Oct 20, 7:35 pm, Massimo Di Pierro
wrote:
> Do not use crud.select. use SQLFORM.grid instead. So much better.
>
> On Oct 20, 8:34 pm, Matthew wrote:
>
>
>
>
>
>
>
> > Is there any way to change the
inside resizable pane. and
> they will be resizable.
> I will separate two tables in different tabs , they shouldn't be
> inside one page i guess.
>
> On 10/20/11, greenpoise wrote:
>
>
>
>
>
>
>
> > ah ok..got it..I have never tried or didnt know anyt
st priority :D) .
> > i am going to get it work tomorrow. if you guys have any idea feel
> > free to suggest :) .
>
> > On 10/20/11, greenpoise wrote:
> >> Cool. Is your wife currently using a POS?? we are currently using
> >> Microsoft Dynamics RMS and wow.
I cant change or add values. I tried adding a user but login does not
work for me. I like the simplicity of the table
On Oct 19, 4:29 pm, Phyo Arkar wrote:
> Multiple item of same type can be added by incresing the items count.
>
> Multiple items of different type , should be easy to do too ,
ard-code it. coz qooxdoo
> is totally js and web2py's template code wont work inside JS files.
>
> One thing is to pass via url-string is that acceptable ?
>
> On 10/20/11, greenpoise wrote:
>
>
>
>
>
>
>
> > Got ya..thanks..will do..
>
> &g
Got ya..thanks..will do..
d
On Oct 19, 4:19 pm, Phyo Arkar wrote:
> rename it to HersPOS (URL is hardcoded).
>
> On 10/20/11, greenpoise wrote:
>
>
>
>
>
>
>
> > Mine does not show anything. I did as pbreit said, under /herspos but
> > nothing.
&
w2p release.
> > I will also make it configurable.
> > You guys feel free to clone. modify what you feel needed.
> > I had tested on chrome and firefox on linux and firefox on windows ,
> > can you give me the firebug output or chrome devtool output ?
>
> > On 10/
Neat,thanks for sharing. I download it havent checked out. Can you
package it so users can install?
d
On Oct 19, 3:24 pm, Phyo Arkar wrote:
> Hello Web2py.
>
> As a practice for integrating Qooxdoo and web2py. I had created a
> Point of Sales system for my wife's sushi shop.
>
> All people who
I am still a web2py fan dont get me wrong. However, I recently came
accross and started playing with MODx CMS, and I was impressed with
the ease one can transport an HTML5 to a MODx CMS template. This is
great for designers who dont care too much for the db part..I know, I
know is php which I hate!
Hi there. Is there an official features page? I am looking for a
feature that was added to web2py a few months ago (did not bookmark
it!!!) but anyways, it was a feature that was common in ruby and was
added to web2py. The example presented was of listing prices from
other websites (I think it was
how could I dynamically re arrange custom form fields (mostly
textboxes) after a set of dates have been selected on a datepicker???
what are my options to disable a textbox based on a criteria? also, is
there such thing as creating a bunch of textboxes based on a criteria
with the value going to a database
Thanks
d
I sort of found a solution to this problem by adding a payperiod date
field on top on the from - to date fields..But now
Field('hastafecha',
'date',default=midday,requires=IS_NOT_IN_DB(db,'db.timesheet.hastafecha'))
is this validator accurate? it is not validating and I am getting
double entries o
firstday=datetime.date(anio,mes,sov[0]) did it.
On Feb 28, 12:43 pm, greenpoise wrote:
> Nevermind, got it.
>
> thanks anyways
>
> d
>
> On Feb 28, 12:34 pm, greenpoise wrote:
>
>
>
> > I am trying to use the calendar.monthrange function to return the
Nevermind, got it.
thanks anyways
d
On Feb 28, 12:34 pm, greenpoise wrote:
> I am trying to use the calendar.monthrange function to return the last
> weekday of the month but my datefield in my model, wont accept 2
> (february), it needs 02.
>
> now = datetime.datet
I am trying to use the calendar.monthrange function to return the last
weekday of the month but my datefield in my model, wont accept 2
(february), it needs 02.
now = datetime.datetime.now()
mes = now.month
anio = now.year
sov=calendar.monthrange(anio,mes)
how could I format this with a current d
alidation=f)
>
> but not in
>
> return dict(...,onvalidation=f)
>
> On Feb 25, 1:53 pm, greenpoise wrote:
>
>
>
> > I have a simple validation according to the books page 296. Is
> > actually simpler and it is not even being evaluated, no errors
> >
I have a simple validation according to the books page 296. Is
actually simpler and it is not even being evaluated, no errors
either... Here it is:
def f(form):
if form.vars.suns>form.vars.sunv: form.errors.sunv="cant be
more than 9"
return dict(employee=employee,form=form,onvalidation=f
exactly, no overlapping date ranges
On Feb 25, 11:14 am, Jonathan Lundell wrote:
> On Feb 25, 2011, at 11:01 AM, greenpoise wrote:
>
>
>
> > How could I combine these two? I have a table that accepts two dates.
> > I would not like duplicates between in those entry
How could I combine these two? I have a table that accepts two dates.
I would not like duplicates between in those entry dates.
Basically a From Date and a To Date
Thanks
Dan
I dont know where my posts are going...anyways, I have a Crud custom
form. Its set but I am also customizing the layout of the crud update
form and I cant seem to get the delete checkbox...how would I go for
that??
{{=form.custom.widget.?
tried:
{{=form.custom.widget.delete/checkbox/delete_r
I am using form.custom. I've got the submit as form.custom.submit but
is there anything for the delete button/checkbox?? I am using CRUD and
as it gives me more flexibility over the forms layout and add some
fanciness to them...also cuz the crud.settings.formstyle='divs' never
worked for me...
tha
Hi there. Found this toggle on the CRM appliance. Thought it would fit
perfectly on my app however this works properly, bringing the smart
table up and closing the form:
{{response.files.append(URL(r=request,c='static',f='jquery.dataTables.min.js'))}}
{{response.files.append(URL(r=request,c='stati
I am using this:
http://web2pyslices.com/main/slices/take_slice/102
how would I go for deleting/updating a record if it is in multiple
tables?
thanks
I got this http://web2pyslices.com/main/slices/take_slice/102
How would I go about editing/deleting the records??
thanks
I wasnt sure if this was going to be a good post because of the
subject, but I totally agree with Antonio...I have bought the book the
three times it has been out and I would buy it again and again but I
wish the book could cover more examples that are here in the groups
rather than us having to fi
I want to put 2 checkboxes next to the fields of my table..the form is
crud.
thanks
On Feb 21, 10:43 am, greenpoise wrote:
> is it possible to achieve this on CRUD:
>
> def do_what_timmie_asks():
> rows=db(db.sometable.id>0).select()
> db.sometable.id.represent
is it possible to achieve this on CRUD:
def do_what_timmie_asks():
rows=db(db.sometable.id>0).select()
db.sometable.id.represent=lambda id: DIV(id,INPUT
(_type='checkbox',_name='check%i'%id))
form=FORM(SQLTABLE(rows),INPUT(_type='submit'))
if form.accepts(request.vars):
I mean, I did not know I couldnt name the fields using uppercase.
On Feb 18, 3:19 pm, greenpoise wrote:
> So odd...the capital letters did the trick...I changed my fields to
> small caps and it worked.. AGH haaa..I am laughing now but I wasnt
> before.. I did not know i coul
So odd...the capital letters did the trick...I changed my fields to
small caps and it worked.. AGH haaa..I am laughing now but I wasnt
before.. I did not know i couldnt write small caps, like i said, it
worked two days ago
Thanks
dan
On Feb 18, 1:59 pm, greenpoise wrote:
> Mass
erything was working to perfection.
Thanks
dan
On Feb 18, 1:42 pm, Massimo Di Pierro
wrote:
> Please post a complete example so I can reproduce the problem. Also
> give us more details about OS, web2py version and OS.
>
> On Feb 18, 3:30 pm, greenpoise wrote:
>
>
>
> >
I am still trying to solve my issue. The date picker shows up and when
I pick a date, it puts it in the text box. However, it does not saves
it (either thru the application or thru database administration tool).
But if I do Field('DesdeFecha', 'date',default=request.now), it saves
the date/time int
, greenpoise wrote:
> # coding: utf8
> if auth.is_logged_in():
> me=auth.user.id
> else:
> me=None
>
> db.define_table('timesheet',
> Field('empleado',db.auth_user),
> Field('DesdeFecha', 'date'),
> Field('Hasta
es=[IS_NOT_EMPTY(),IS_FLOAT_IN_RANGE(0,
10,error_message=T('too small or too large!'))]
db.timesheet.segundodia.requires=[IS_NOT_EMPTY(),IS_FLOAT_IN_RANGE(0,
10,error_message=T('too small or too large!'))]
On Feb 17, 11:34 am, Massimo Di Pierro
wrote:
> Can you post your model
One more thing which might not be the culprit but just in case, I
upgraded web2py yesterday. Current version using is 1.92.1
On Feb 17, 10:41 am, greenpoise wrote:
> Ok, very cautious when I program cuz I am not an expert by any means.
> My application just saves one value to the table. E
Ok, very cautious when I program cuz I am not an expert by any means.
My application just saves one value to the table. Even if I go through
web2py database administration tool, date values are not being saved
agh..annoying..I get no error whatsoever.
any help appreciated
thanks
Where is the limit? could I align the textboxes horizontally??
The code above worked did the reisizing!
On Feb 16, 3:02 pm, Massimo Di Pierro
wrote:
> On Feb 16, 7:09 am, Massimo Di Pierro
> wrote:
>
> > given...
> > from=crud.create()
>
> > you can do
>
> > form e in form.elemen
7;).css('width':'50px'):
>
> or better in CSS
>
> input[type=text] {width: 50px;}
>
> On Feb 15, 10:59 pm, greenpoise wrote:
>
>
>
> > Sorry for a possible double post but honestly, I could not find my
> > previous post. I had asked if it was
Sorry for a possible double post but honestly, I could not find my
previous post. I had asked if it was possible to customize CRUD forms?
such as the length of the text boxes? if so, how? I love the
simplicity of CRUD and would prefer it over manually creating forms
THanks
lf.error_message)
> return (value, None)
>
> db.define_table('mytable',Field('name',requires=IS_NOT_BAD()))
>
> On Feb 15, 11:52 am, greenpoise wrote:
>
>
>
> > Calling out there to see common practices in web development regarding
> &g
Calling out there to see common practices in web development regarding
spam control/word filtering. How is this handled in web development
once a site is developed? what are the practices? I know that captcha
is some sort of spam control but how about word filtering? or to
prevent users from enteri
nevermind, got it..I had commented out the web2py_ajax lines
thanks
On Feb 14, 4:06 pm, greenpoise wrote:
> Something is wrong in my app. The date picker is not working. Which
> web2py files that come standard in web2py I might have edited?? the
> picker is just not showing and I don
Something is wrong in my app. The date picker is not working. Which
web2py files that come standard in web2py I might have edited?? the
picker is just not showing and I dont get any error.
THanks
put1
> > comment1
> > label2
> > input2
> > comment2
> > etc.
>
> > That seems what you looking for...
>
> > For comparaison purpose :
> > table3cols will give :
> > Form
> > label1,input1,comment1
> > etc.
>
> > Rich
I am trying to align a crud form horizontally. That is with labels on
top, fields on bottom and they should run across horizontally on the
page. Is crud.settings.formstyle my answer?? Any good example out
there? I searched on the groups with no success...I did find some talk
about it but I just do
Ok..it was my ISP blocking port 80...apparently it is a common
practice by ISPs.
Worked fine after I changed the port..thanks
d
On Feb 1, 2:15 pm, greenpoise wrote:
> Ok, I was able to deploy web2py using uWSGI & Cherokee. I can access it
> locally but not from the outside of t
Ok, I was able to deploy web2py using uWSGI & Cherokee. I can access it
locally but not from the outside of the network. The connection basically
times out when I try to access it. Any setting on cherokee that I am not
aware of? I open the firewall to see if that was it but did not solved the
p
thanks for the leads. I tried starting all over again, removing the
packages and configuration files. Now the connection just times out. I
get no error from cherokee, it just simply times out.
On Jan 31, 6:43 pm, GoldenTiger wrote:
> About the problem Upgrade required, this is the solution from
Ok. I have tried what the book says. I also have seen the famous uwsgi
thread & how to. However, I want to stick to the method shown in the
book. It looks LOOKS simple but it is not. Everything works but when I
go to the url of my site, this is what I get:
426 Upgrade Required
The requested resou
y more configuration options, in
> particular security options such as allow/deny clients and individual
> urls.
>
> On Jan 26, 11:32 am, greenpoise wrote:
>
>
>
> > I read on the Web2py Deployment recipes Chapter of the book that the
> > webserver web2py runs in is should be
I read on the Web2py Deployment recipes Chapter of the book that the
webserver web2py runs in is should be avoided for production
environments of high volume traffic. My setup is within the company
(intranet) with limited access to other offices. I cant specify the
volume of traffic it will receive
I did not know that. Is that a web2py common practice? last time I
read anything similar was in TGears.
Thanks again, appreciate it!
d
On Dec 23, 2:38 pm, Branko Vukelić wrote:
> 2010/12/23 greenpoise :
>
> > brilliant!! THANKS SO MUCH!
>
> You're welcome. It
brilliant!! THANKS SO MUCH!
On Dec 23, 1:33 pm, Branko Vukelić wrote:
> On Thu, Dec 23, 2010 at 10:22 PM, greenpoise wrote:
> > when I issue echo $BROWSER I get firefox. I have not used web2py in a
> > long time, since I have ArchLinux because of this problem. Is the
Funny cuz when I try this: webbrowser.get() I get 'webbrowser' is not
defined
agh
On Dec 23, 1:22 pm, greenpoise wrote:
> when I issue echo $BROWSER I get firefox. I have not used web2py in a
> long time, since I have ArchLinux because of this problem. Is there a
> way
when I issue echo $BROWSER I get firefox. I have not used web2py in a
long time, since I have ArchLinux because of this problem. Is there a
way to change web2py as to where it does not launches any browser
I have no plans of changing my system distribution.
THanks
dan
On Dec 18, 9:57 pm
> http://docs.python.org/library/webbrowser.html
>
> On Nov 17, 5:31 pm, greenpoise wrote:
>
>
>
> > Ok, I must admit, I am one of those with a weird setup. I dont have
> > firefox, seamonkey, IExplorer. I just happen to have Chromium and
> > Opera as my two browsers.
Ok, I must admit, I am one of those with a weird setup. I dont have
firefox, seamonkey, IExplorer. I just happen to have Chromium and
Opera as my two browsers. When I try to load web2py I get this error:
Traceback (most recent call last):
File "web2py.py", line 20, in
import gluon.widget
just noticed the response, thanks. I guess is all about compute even
when it is strings and numeric fields..Thanks again
dan
On Jun 23, 2:51 am, mdipierro wrote:
> db.vlanman.location.compute=lambda r: '%s%s' %
> (r['locationprevis'],r['patchnumber'])
>
How could I concatenate two db field values in my Model?? My example
is this:
db.define_table('vlanman',
Field('person',db.person,default=None),
Field('switchselect'),
Field('locationprefix'),
Field('patchpanel'),
Field('patchnumber'),
Field('switchnumber'),
Field('loca
ugh I am very annoyed that you cannot use it offline, that means no
> > debugging in Opera in the metro on my way home :(
>
> > On Jun 18, 2:12 am, greenpoise wrote:
>
> > > Anybody here using Opera to program? I have been a long time fan of
> > > Opera but I can
I meant the EditArea. That is what drags really slow in my opera.
Thanks again
On Jun 18, 11:57 am, greenpoise wrote:
> I am using Opera 10.5x as well on linux. Weird. Thanks!!
>
> On Jun 18, 7:59 am, Carl wrote:
>
> > I don't use Web2py integrated code editor (I u
Anybody here using Opera to program? I have been a long time fan of
Opera but I cant use it with web2py because where you do the
programming (dunno the name of it) renders super slow. I was wondering
if anybody else is experiencing the same thing??
ok, it worked and after one browser refresh it stoped working. How
could I show you that it worked somehow??
On Jun 16, 1:18 pm, greenpoise wrote:
> Oops my bad. This one
>
> desde=datetime.datetime(request.now.year,request.now.month,request.now.day)
> hasta=desde+datetime.ti
.waitertip.sum())
for row in rows: print
row[db.orden.waitertip.sum()]
return dict(form=form,rows=rows)
On Jun 16, 1:09 pm, greenpoise wrote:
> I dont know how this could be different but this one did worked:
>
> desde=request.now
> hasta=request.now
>
> de
15, 11:51 pm, mdipierro wrote:
> This should never have worked.
>
> On Jun 15, 8:57 pm, "mr.freeze" wrote:
>
> > I would just check that fromvar and tovar are not None before getting
> > the rows.
>
> > On Jun 15, 8:40 pm, greenpoise wrote:
>
> &g
un 15, 9:37 pm, "mr.freeze" wrote:
> Do you get an error? If so, can you show the traceback?
>
> On Jun 15, 8:01 pm, greenpoise wrote:
>
> > Ok this used to work:
>
> > def qryfecha():
>
> > form=FORM (H1(TABLE
> > (TR(('Fro
Ok this used to work:
def qryfecha():
form=FORM (H1(TABLE
(TR(('From:',INPUT(_name="desde",_class='date',_id="desde",requires=IS_DATE())),
('To:',INPUT(_name="to",_class='date',_id="to",default=request.now,requires=IS_DATE(),
INPUT(_type='submit')))
fromvar=request.vars.desde
t
How is it called? I have a custom form (no SQLForm) how would I get
the date picker to come out??
D.
On Jun 10, 2:02 pm, greenpoise wrote:
>
> > Ok. I got this working afterall. I am going to leave it open because I
> > still have questions regarding it. Like for example, this is what I
> > did:
>
> > db.orden.sellercommision.compute=lambda r:round(float(r['
will dig into that. THanks
dan
On Jun 10, 3:04 pm, mdipierro wrote:
> You cannot. Perhaps you should use crud.create(,onvalidator=lambda
> form:) if you need more complex computations.
>
> On Jun 10, 2:02 pm, greenpoise wrote:
>
> > Ok. I got this working afterall
w to fix it.
>
> On Jun 10, 10:03 am, greenpoise wrote:
>
> > I see in the book how to compute values from fields within a form. I
> > still dont get how to do this under CRUD. I am able to compute values
> > using the compute function but if I have a value that depends on
I see in the book how to compute values from fields within a form. I
still dont get how to do this under CRUD. I am able to compute values
using the compute function but if I have a value that depends on the
sum of other field I get an error. Can someone show me how to do
this?
Thanks
Hmmm..I see. Tough stuff. I wonder if there is room for improvement in
that area for web2py. Something that is transparent between the
developer and the production site.
Thanks
Dan
On May 26, 1:28 pm, Yarko Tymciurak
wrote:
> On May 26, 11:53 am, greenpoise wrote:
>
> > Oh
gt; re-import it. This also has the advantage that you can use something
> like PostgreSQL on your production machine.
>
> --
> Thadeus
>
> On Wed, May 26, 2010 at 9:39 AM, greenpoise wrote:
> > I have web2py production and my development environment. How would I
> &g
I have web2py production and my development environment. How would I
go for leaving the data intact in my production? Is there a way? What
I did is I packedAll the project and took it to my production but I
will keep working on it on my development environment. Is this how it
should be done?
Tha
gt; I recommend GAE unless you have special requirements, like a c based
> library.
>
> Richard
>
> On May 25, 10:10 am, greenpoise wrote:
>
> > I am looking for web2py hosting. I have seen most posts of webfaction.
> > I just want to make sure that what I pick requires the least of my
> > intervention to get it going. Leads?
>
> > THanks in Advance
gt; I recommend GAE unless you have special requirements, like a c based
> library.
>
> Richard
>
> On May 25, 10:10 am, greenpoise wrote:
>
> > I am looking for web2py hosting. I have seen most posts of webfaction.
> > I just want to make sure that what I pick requires the least of my
> > intervention to get it going. Leads?
>
> > THanks in Advance
I am looking for web2py hosting. I have seen most posts of webfaction.
I just want to make sure that what I pick requires the least of my
intervention to get it going. Leads?
THanks in Advance
ld
> you show me the link to that?
> Best Regards,
> Jason Brower
>
> On Mon, 2010-05-24 at 08:06 -0700, greenpoise wrote:
> > by the way, I was referring to the idea of: "To have a [level]
> > Certificate, your campany needs fill some
> > criterias... ".
&g
commercial purposes.
Just a thought.
dan
On May 24, 10:06 am, greenpoise wrote:
> I think that rather than discriminating and hence giving competitive
> advantage to one company over another would defy the purpose of it
> all! I dont know what a good admission system would be like but I am
&g
I think that rather than discriminating and hence giving competitive
advantage to one company over another would defy the purpose of it
all! I dont know what a good admission system would be like but I am
all up for a filter type rather than giving some competitive advantage
to ones more than other
Count me in.
Dan
On May 24, 7:39 am, Albert Abril wrote:
> I am interested too.
> Still learning daily a bit more.
> I'm planning to do a dental clinic management, but had a lot of work to do.
>
> Regards.
>
> On Mon, May 24, 2010 at 1:31 PM, Richard wrote:
> > I am interested, and glad you br
what is the crud.search() about?? I see it as part of the new release.
Any examples?
thanks
Is there an alternative to drop down? a type ahead type of widget?
I did it the mdpierro way because just saw your post. Your way would
have worked too. Exactly what I wanted.
Thanks
On May 19, 10:36 am, annet wrote:
> > I want the user to click on the link and if there is already
> > a project _location for a project then just display it (crud.read),
> > if t
).first()
> form=crud.update(db.project_location,location)
>
> if location is None, crud.update defaults to crud.create
>
> On May 19, 8:57 am, greenpoise wrote:
>
> > Hi there. I am a bit stuck here. ANy help greatly appreciated. I have
> > this:
>
Hi there. I am a bit stuck here. ANy help greatly appreciated. I have
this:
@auth.requires_login()
def crear_project_location():
project_id=request.args(0)
project=db.project[project_id]
if project:
db.project_location.project.default=project_id
db.project_location.pro
nevermind, tried it. it works
On May 18, 2:00 pm, greenpoise wrote:
> does this works with CRUD?
>
> On May 18, 11:48 am, mdipierro wrote:
>
> > or db.table.id.readable=False
>
> > On May 18, 10:10 am, Jose wrote:
>
> > > On 18 mayo, 06:59, Andrew Buchan
Got it. Thanx
On May 18, 1:31 pm, mdipierro wrote:
> db(db.project.id>0).update(number=db.project.id+1000)
>
> db.project.number is a field object, not a field value. that is whay
> you cannot use the syntax below.
>
> On May 18, 12:20 pm, greenpoise wrote:
>
>
does this works with CRUD?
On May 18, 11:48 am, mdipierro wrote:
> or db.table.id.readable=False
>
> On May 18, 10:10 am, Jose wrote:
>
> > On 18 mayo, 06:59, Andrew Buchan wrote:
>
> > > Hello,
>
> > > Very simple one today:
>
> > > SQLFORM(db.CAR_Report, record = CARId , readonly = True, fiel
How come I cant do this:
db.project.number=db.project.id+1000
I want the project number to be the same as the project id plus 1000
Could it be with the template? I changed the template and it worked.
It does not work with Balanced
On May 17, 10:53 am, Thadeus Burgess wrote:
> You cannot have random = signs in your view.
>
> The syntax is
>
> {{python code here}}
>
> {{=python variable here}}
>
> You MUST declare {{= with no
Ticket
127.0.0.1.2010-05-17.09-48-36.ca732008-3e5a-4346-8d65-27ee970109ea
missing "pass" in view
Error traceback
1.
2.None
On May 17, 9:29 am, szimszon wrote:
> I think it's related to the new templating engine :-o
>
> Ticket 127.0.0.1.2010-05-17.09-20-49.56d45b51-05f0-49b5-9b10-
> cd7e9a
will try. Thanks
On May 13, 1:50 pm, Vasile Ermicioi wrote:
> this is working
>
> db(db.orders.id > 0).select("count(1) as nr, round(id/10) as gr",
> groupby='gr')
>
> so I think you can use database datetime function to compute week and then
> grouping,
> most database have such functions
rds by some time range we you can maniputale them
> at the Python/web2py level. How really depends on details. You could
> also create a function that uses datetime weekday to build query
> ranges for dal.
>
> On May 13, 11:10 am, greenpoise wrote:
>
> > Is there such thing? i
Is there such thing? i need to group a result set by weeks. Sort of
like total sales of the week. How could I accomplish this? I really
dont want the user to be entering a range of dates. The weeks will
always start on Monday and finish on Sunday. My table takes daily
sales.
Thanks
ficate
> program:http://www.cdm.depaul.edu/ipd/Programs/Pages/WebDevelopmentwithPython...
> (as long as other programs on Java and Rails and more).
>
> I teach it. I may teach it in Fall but I am not sure yet.
>
> Massimo
>
> On May 11, 1:24 pm, greenpoise wrote:
>
> > will
{{= row.tableorder.ordernumber}} td>{{=row[db.tableorder.totalsale.sum()]}}
> {{pass}}
>
>
> On May 11, 12:37 pm, greenpoise wrote:
>
> > I have this:
>
> > def view_totals():
> > rows = db().select(db.tableorder.ALL, 'sum(tableorder.
I have this:
def view_totals():
rows = db().select(db.tableorder.ALL, 'sum(tableorder.totalsale)',
groupby=db.tableorder.orderdate)
for row in rows: print row.tableorder.ordernumber,
row._extra['sum(tableorder.totalsale)']
return dict()
What would be my view to present my sum?
201 - 300 of 340 matches
Mail list logo