[web2py] Deployment - SSL certificate under Windows

2010-05-06 Thread greenpoise
I got the 2nd edition of the book yesterday and I am stuck in this part. How to make a SSL certificate for windows deployment? more than production, this is for production/intranet. This is the only error Apache throws. I tried removing it but the certificate is necessary. What is the procedure?

[web2py] Deployment - SSL certificate under Windows

2010-05-06 Thread greenpoise
I had removed the post thinking that I got it working but nah. I cant set web2py on Windows. I get an error message that it cant find the certificate files. Is there a way around this? or do I need a certificate and how do I make one?? I tried going from the book but the certificate part is under l

[web2py] Re: When will the web2py book open to all editing?

2010-05-07 Thread greenpoise
My take. Keep things separate. I got the book both times and knowing the source had a lot if not the majority of weight in my decision. I think that more input to a site such as web2pyslices is a good complement for the book. On May 7, 5:23 pm, mdipierro wrote: > LOL. > > People who ask to be

[web2py] Calculation error

2010-05-08 Thread greenpoise
Can someone help me. I am trying to do a simple calculation of fields. Fields are defined as decimal in db.py and here is the calculation: db.order.tipgranted.compute=lambda r: r['totalsale']*r['tipvalue'] error: TypeError: can't multiply sequence by non-int of type 'float'

[web2py] Re: Calculation error

2010-05-08 Thread greenpoise
form=crud.create(db.order) orders=db(db.order.employee==employee.id).select(orderby=db.order.ordernumber) return dict(employee=employee,orders=orders,form=form) thanks On May 8, 10:54 pm, mdipierro wrote: > Can you show us the model and the action that triggers this? > > On May

[web2py] Re: Calculation error

2010-05-08 Thread greenpoise
db.order.tipgranted.compute=lambda r: > > decimal.Decimal(r['totalsale'])*decimal.Decimal(r['tipvalue']) > > > On May 8, 10:00 pm, greenpoise wrote: > > > > Model: > > > > db.define_table('order', > > >     Fi

[web2py] Re: Calculation error

2010-05-10 Thread greenpoise
;])*float(r['tipvalue']) > > or better > > db.order.tipgranted.compute=lambda r: > decimal.Decimal(r['totalsale'])*decimal.Decimal(r['tipvalue']) > > On May 8, 10:00 pm, greenpoise wrote: > > > Model: > > > db.define_table(&#

[web2py] Stuck on Authentication or perhaps the logic of my project

2010-05-10 Thread greenpoise
Whenever I use authentication on its basic form: 1. Any user can register something I do not want. 2. Any user can see all the data I want to be more specific and have control of the registration process as to where I create the users and group they pertain to and hence look at their specific dat

[web2py] Re: Stuck on Authentication or perhaps the logic of my project

2010-05-10 Thread greenpoise
;, length=512,writable=False, >                       readable=False,default=''), >                 Field('reset_password_key', length=512,writable=False, >                       readable=False, default='', >                       label=auth.messages.label_reset_password_k

[web2py] Re: New to web app development -- is web2py a good choice

2010-05-10 Thread greenpoise
You seem to be concerned with the aesthetics for the most. My take is this, there is the development part and there is the design part of a web application. You can make any site look the same with any of the frameworks you mentioned including web2py. You have to be good at CSS/ HTML and some photo

[web2py] Re: Stuck on Authentication or perhaps the logic of my project

2010-05-10 Thread greenpoise
ermission on records they create > def give_permission(form): >      for name in ('read','update','select','delete'): > > auth.add_permission(auth.user_group(),name,form.table,form.vars.id) > crud.settings.create_onaccept=give_permission > > On May 10, 5:5

[web2py] Re: Calculation error

2010-05-10 Thread greenpoise
as string internally and there for > compute should be > > db.order.tipgranted.compute=lambda r: > float(r['totalsale'])*float(r['tipvalue']) > > or better > > db.order.tipgranted.compute=lambda r: > decimal.Decimal(r['totalsale&#

[web2py] Re: Review my web2py app: Radbox.me

2010-05-11 Thread greenpoise
Great stuff. On May 11, 8:25 am, cjrh wrote: > On May 11, 11:40 am, Adi wrote: > > > Radbox (http://radbox.me) is a video bookmarking service. Its still a > > very young product, but I believe its pretty good at what it does. > > Cool!

[web2py] Re: Calculation error

2010-05-11 Thread greenpoise
; > db.order.tipgranted.compute=lambda r: > > > decimal.Decimal(r['totalsale'])*decimal.Decimal(r['tipvalue']) > > > > On May 8, 10:00 pm, greenpoise wrote: > > >> Model: > > > >> db.define_table('order', > > >

[web2py] Display Sum of values

2010-05-11 Thread greenpoise
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?

[web2py] Re: Display Sum of values

2010-05-11 Thread greenpoise
{{= 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.

[web2py] Re: Display Sum of values

2010-05-11 Thread greenpoise
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

[web2py] group by weeks

2010-05-13 Thread greenpoise
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

[web2py] Re: group by weeks

2010-05-13 Thread greenpoise
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

[web2py] Re: group by weeks

2010-05-13 Thread greenpoise
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

[web2py] Re: web2py 1.78.2

2010-05-17 Thread greenpoise
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

[web2py] Re: web2py 1.78.2

2010-05-17 Thread greenpoise
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

[web2py] Table.id on another field

2010-05-18 Thread greenpoise
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

[web2py] Re: hide id field in update or read-only forms

2010-05-18 Thread greenpoise
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

[web2py] Re: Table.id on another field

2010-05-18 Thread greenpoise
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: > >

[web2py] Re: hide id field in update or read-only forms

2010-05-18 Thread greenpoise
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

[web2py] CRUD read or OneToOne

2010-05-19 Thread greenpoise
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

[web2py] Re: CRUD read or OneToOne

2010-05-19 Thread greenpoise
).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: >

[web2py] Re: CRUD read or OneToOne

2010-05-19 Thread greenpoise
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

[web2py] Drop Down alternative

2010-05-20 Thread greenpoise
Is there an alternative to drop down? a type ahead type of widget?

[web2py] crud.search()

2010-05-20 Thread greenpoise
what is the crud.search() about?? I see it as part of the new release. Any examples? thanks

[web2py] Re: monetize web2py anybody?

2010-05-24 Thread greenpoise
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

[web2py] Re: monetize web2py anybody?

2010-05-24 Thread greenpoise
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

[web2py] Re: monetize web2py anybody?

2010-05-24 Thread greenpoise
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

[web2py] Re: monetize web2py anybody?

2010-05-24 Thread greenpoise
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

[web2py] web2py hosting - least intervention required

2010-05-24 Thread greenpoise
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

[web2py] Re: web2py hosting - least intervention required

2010-05-26 Thread greenpoise
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

[web2py] Re: web2py hosting - least intervention required

2010-05-26 Thread greenpoise
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

[web2py] Changes in Development environment

2010-05-26 Thread greenpoise
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

[web2py] Re: Changes in Development environment

2010-05-26 Thread greenpoise
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

[web2py] Re: Changes in Development environment

2010-05-26 Thread greenpoise
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

[web2py] compute values when using CRUD

2010-06-10 Thread greenpoise
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

[web2py] Re: compute values when using CRUD

2010-06-10 Thread greenpoise
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

[web2py] Re: compute values when using CRUD

2010-06-10 Thread greenpoise
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

[web2py] Re: compute values when using CRUD

2010-06-10 Thread greenpoise
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['

[web2py] Date picker widget

2010-06-15 Thread greenpoise
How is it called? I have a custom form (no SQLForm) how would I get the date picker to come out?? D.

[web2py] code broke, help

2010-06-15 Thread greenpoise
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

[web2py] Re: code broke, help

2010-06-15 Thread greenpoise
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

[web2py] Re: code broke, help

2010-06-16 Thread greenpoise
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

[web2py] Re: code broke, help

2010-06-16 Thread greenpoise
.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

[web2py] Re: code broke, help

2010-06-16 Thread greenpoise
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

[web2py] Opera Browser

2010-06-17 Thread greenpoise
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??

[web2py] Re: Opera Browser

2010-06-18 Thread greenpoise
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

[web2py] Re: Opera Browser

2010-06-18 Thread greenpoise
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

[web2py] Concatenate str and int values in Model

2010-06-22 Thread greenpoise
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

[web2py] Re: Concatenate str and int values in Model

2010-06-23 Thread greenpoise
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']) >

[web2py] Controllers for a newbie

2010-04-13 Thread greenpoise
Hi all. Dont know where to begin when it comes to controllers. I used to develop client/server applications and the transition to webframeworks web developing in general has been tough for me. Do I simply use pure python on web2py controllers? I bought the book and its perfect but I need more. Any

[web2py] Re: Controllers for a newbie

2010-04-13 Thread greenpoise
> Section 4.2 of the book explains what happens. > > If the URL does not request a static file web2py processes the request > in the following order: > • Parses cookies. > • Creates an environment in which to execute the function. > • Initializes request, response, cache. > • Opens the existing se

[web2py] Display contents of a folder

2010-04-22 Thread greenpoise
I want to display the contents (files) of a folder and be able to click and download the files. How is this accomplished within a controller? leads? any examples out there? I know there is os.path, os.listdir and glob. Do I have to import the modules in Web2Py? Thanks -- Subscription settings

[web2py] Re: Display contents of a folder

2010-04-22 Thread greenpoise
will try and post. Thanks dan On Apr 22, 9:39 am, mdipierro wrote: > something like this? > > def folder(): >     import os >     return dict(files=TABLE(*[TR(TD(f)) for f in os.listdir('/ > path/')])) > > On Apr 22, 7:48 am, greenpoise wrote: > > >

[web2py] Re: Display contents of a folder

2010-04-22 Thread greenpoise
It works. Thanks. Is this TABLE(*[TR(TD(f)) for the purpose of the view? On Apr 22, 10:01 am, mdipierro wrote: > just make sure you NEVER do os.chdir() that is not thread safe and > breaks web2py. > > On Apr 22, 8:49 am, greenpoise wrote: > > > will try and post. Than

[web2py] Re: Display contents of a folder

2010-04-22 Thread greenpoise
hat is properly escaped. > > Also, for situations like this, the X-Sendfile header would be perfect ! > > -- > Thadeus > > On Thu, Apr 22, 2010 at 9:25 AM, greenpoise wrote: > > It works. Thanks. Is this TABLE(*[TR(TD(f)) for the purpose of the > > view? >

[web2py] Web2py Upload Function

2010-04-22 Thread greenpoise
My question is, which controller takes careof the upload field in web2py??? Web2py makes it easy to upload a file but I want to know how it does it so I can write a function based on it. Thanks dan -- Subscription settings: http://groups.google.com/group/web2py/subscribe?hl=en

[web2py] Re: Web2py Upload Function

2010-04-22 Thread greenpoise
to something safe > > -- > Thadeus > > On Thu, Apr 22, 2010 at 2:54 PM, greenpoise wrote: > > My question is, which controller takes careof the upload field in > > web2py???  Web2py makes it easy to upload a file but I want to know > > how it does it so I can write

[web2py] Re: Web2py Upload Function

2010-04-22 Thread greenpoise
Perfect. Will try. Thanks again! Dan On Apr 22, 4:51 pm, mdipierro wrote: > Most of it is done in the Field.store() method in sql.py. In fact you > can do > > db.mytable.insert(filefield=db.mytable.filefield.store(stream,filename='ori­ginal_filename.txt')) > > On

[web2py] Re: Web2py Upload Function

2010-04-23 Thread greenpoise
is stream part of a module? thanks dan On Apr 22, 4:51 pm, mdipierro wrote: > Most of it is done in the Field.store() method in sql.py. In fact you > can do > > db.mytable.insert(filefield=db.mytable.filefield.store(stream,filename='original_filename.txt')) > > On

[web2py] Re: Web2py Upload Function

2010-04-23 Thread greenpoise
ert(filefield = db.workspace.droppedfile.store(files,filename='test.pdf')) return dict(storedfiles=storedfiles,form=form) On Apr 22, 8:48 pm, greenpoise wrote: > Perfect. Will try. Thanks again! > > Dan > > On Apr 22, 4:51 pm, mdipierro wrote: > > > Most of it is done in the Field.s

[web2py] Re: Display contents of a folder

2010-04-25 Thread greenpoise
Nice to know. I was not sure what you were trying to accomplish since I am new to web2py and I am well, learning. But thanks for the input. Does jquery lets the user download the file? On Apr 25, 2:54 pm, Iceberg wrote: > On Apr26, 1:38am, Vasile Ermicioi wrote: > > > If you need a jquery

[web2py] Re: Web2py Upload Function

2010-04-25 Thread greenpoise
ilename=files)) NameError: global name 'stream' is not defined Thanks in advance On Apr 23, 5:34 pm, mdipierro wrote: > yes, you have to set > > db.workspace.filefield.uploadefolder='/somewhere/' > > On Apr 23, 2:40 pm, greenpoise wrote: > > >

[web2py] Re: Web2py Upload Function

2010-04-25 Thread greenpoise
x27; >     for filename in files: >         stream=open(filename,'rb') > > db.document.insert(scandoc=db.document.scandoc.store(stream,filename=filename)) > > storedfiles=db(db.document.id>0).select(orderby=db.document.scandoc) >     return dict(storedfiles=storedfiles,form=form)

[web2py] Re: Web2py Upload Function

2010-04-25 Thread greenpoise
cument.scandoc.store(stream,filename=filename)) > > storedfiles=db(db.document.id>0).select(orderby=db.document.scandoc) >     return dict(storedfiles=storedfiles,form=form) > > On Apr 25, 7:23 pm, greenpoise wrote: > > > Thanks! you make it look so easy! > > From th

[web2py] Re: Web2py Upload Function

2010-04-25 Thread greenpoise
Also noticed that it works with txt files. PDF wont make it to the database is there a specific reason for this? On Apr 25, 9:01 pm, greenpoise wrote: > It works! Thanks. Question, now I need to create a controller to > download the files? > I will try to add a few lines to local

[web2py] Decimal

2010-04-27 Thread greenpoise
I see a few threads on decimal values. What is the final status of this? Is the field name type Numeric or Integer decimal? such as : Field('totalsale', 'integer')) db.document.totalsale.requires=IS_DECIMAL() I am using sqlite. -- Subscription settings: http://groups.google.com/group/web2py/

[web2py] Re: wordpress2py

2010-05-02 Thread greenpoise
Interesting. I read this: "If you make any modification to web2py you must distribute it together with the modified source code according to GPLv2.0" and I understand that it is if you modify the web2py code. Is this what you are referring to? Also the person mentions this at the beginning: "R

[web2py] Re: wordpress2py

2010-05-02 Thread greenpoise
hey is a good thing to be alarmed sometimes specially when one deserves the credit! :-) On May 2, 6:43 pm, Thadeus Burgess wrote: > When I first looked at it I just scanned and thought he was claiming > it as his own. > > But it does not seem to be that way, he is just mirroring information,

[web2py:25320] Re: Web2py is not too designer friendly?

2009-06-30 Thread greenpoise
Wait. Am I missing something here? Due to the fact I have been very busy, I have left my hobby (web2py) aside for a bit. I still check the group very often. Isnt CSS suppose to be one thing and development another? and the ability to integrate css to any web development environment depends solely

[web2py:29877] Re: Foreign Keys - one to Many and one to One Relationships

2009-09-02 Thread greenpoise
> > with > > SQLField("id_project_location","reference project_location")) > > On Sep 2, 9:43 am, greenpoise wrote: > > > I have two samples here, one works, the other does not. They are > > pretty similar: > > > Example#1 > > &g

[web2py:29872] Foreign Keys - one to Many and one to One Relationships

2009-09-02 Thread greenpoise
I have two samples here, one works, the other does not. They are pretty similar: Example#1 DOES NOT WORK: db.define_table("project", SQLField("project_number", "text", notnull=True, default=None), SQLField("project_name", "text", notnull=True, default=None), SQLField("project

[web2py:30503] SQLite for Production?

2009-09-09 Thread greenpoise
Is it a good alternative? I am a fan of Postgresql myself BUT just for the simplicity of the whole development, can SQLite handle the job in the long run (users, record, db size)? I am sure is almost transparent when using both (correct me if I am wrong) but doesnt the Auth method changes? Feedba

[web2py:30511] Re: SQLite for Production?

2009-09-09 Thread greenpoise
> respect. > > On Wed, 2009-09-09 at 09:16 -0700, greenpoise wrote: > > Is it a good alternative? I am a fan of Postgresql myself BUT just for > > the simplicity of the whole development, can SQLite handle the job in > > the long run (users, record, db size)? I am sure is al

[web2py:20842] Hosting Alternatives

2009-04-29 Thread greenpoise
I was skimming through the web2py book. Trying to put my ideas together, I went directly to the deployment recipes and I have some doubts/questions. Do I need special hosting? I see shared hosting in the posts of this group. A dedicated server? Will a regular hosting account cut it? Leads appreci

[web2py:20851] Re: Hosting Alternatives

2009-04-29 Thread greenpoise
ut web2py works with most of them > as long as they provide python 2.5 (web2py trunk works with 2.4 and > 2.6 but 2.5 is the official version) and support mod_proxy, mod_wsgi, > fcgi or cgi (algthough cgi is not recommended because some features > like streaming would not work). >

[web2py] Unable to detect your browser

2010-11-17 Thread greenpoise
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

[web2py] Re: Unable to detect your browser

2010-12-18 Thread greenpoise
> 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.

[web2py] Re: Unable to detect your browser

2010-12-23 Thread greenpoise
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

[web2py] Re: Unable to detect your browser

2010-12-23 Thread greenpoise
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

[web2py] Re: Unable to detect your browser

2010-12-23 Thread greenpoise
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

[web2py] Re: Unable to detect your browser

2010-12-24 Thread greenpoise
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

[web2py] Rocket wsgi for Intranet production app

2011-01-26 Thread greenpoise
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

[web2py] Re: Rocket wsgi for Intranet production app

2011-01-26 Thread greenpoise
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

[web2py] Re: DataTables Help needed

2012-04-05 Thread greenpoise
nsider asking on their > user forum. > > Anthony > > On Wednesday, April 4, 2012 12:50:33 PM UTC-4, greenpoise wrote: >> >> Anthony, >> >> I first get an error. Then the select dropdown picks the values with some >> additional characters and when I

[web2py] Re: DataTables Help needed

2012-04-10 Thread greenpoise
> > With that much of data to load, your best bet would be AJAX. > dataTables plugin provides for loading data with server-side ajax function. > Nice to know. Did not know that. That just puts a roadblock on what I want to accomplish. I will search for Ajax though. Thanks You may visit their

[web2py] Add a Add To Cart button in SQLFORM.grid

2012-04-11 Thread greenpoise
Based on the online example, POS Online Store, I want to add a button to add to cart in the SQLFORM.grid. So if my grid goes like this: def store(): fields = [db.product.name,db.product.product_code,db.product. productcategory,db.product.description,db.product.price] orderby =db.product.n

[web2py] Re: Add a Add To Cart button in SQLFORM.grid

2012-04-11 Thread greenpoise
Nevermind, got it to work like this: links = [lambda row: A('+',callback=URL('cart_callback',vars=dict(id=row.id, action='add')))] On Wednesday, 11 April 2012 13:06:49 UTC-7, greenpoise wrote: > > Based on the online example, POS Online Store, I want to a

[web2py] How to add an input field in SQLFORM.grid??

2012-04-11 Thread greenpoise
Is this possible?? I have a products table that shows all the products. I also created an add to cart button in it problem is if I want to add 100 items I would have to press the button 100 times. Is there a way to add a quantity text field??? Thanks Dan

[web2py] Re: How to add an input field in SQLFORM.grid??

2012-04-11 Thread greenpoise
rm and you add > > SQLFORM.grid(..., link=[lambda row: INTPUT(...)]) > > On Wednesday, 11 April 2012 17:07:58 UTC-5, greenpoise wrote: >> >> Is this possible?? I have a products table that shows all the products. I >> also created an add to cart button in it problem

[web2py] Re: How to add an input field in SQLFORM.grid??

2012-04-11 Thread greenpoise
x27;/> > {{pass}} > > > On Wednesday, 11 April 2012 20:23:08 UTC-5, greenpoise wrote: >> >> A bit confused..I thought SQLFORM.grid was itself a form? Also, can I add >> more than one link per grid? Reading from the book, it creates a column so >> technically

[web2py] Re: How to add an input field in SQLFORM.grid??

2012-04-12 Thread greenpoise
e_form:}} > {{=grid}} it is a form > {{else:}} > {{=grid}} it is not a form but you can embed it in one type='submit'/> > {{pass}} > > > On Wednesday, 11 April 2012 20:23:08 UTC-5, greenpoise wrote: >> >> A bit confused..I thought SQLFORM.grid was itse

Re: [web2py] Re: How to add an input field in SQLFORM.grid??

2012-04-13 Thread greenpoise
as to read directly Excel file, I would need to write a > lot of code with xlrd. If I can avoid that I will be happy :) > > Thanks. > > Richard > > On Thu, Apr 12, 2012 at 5:14 PM, greenpoise wrote: > >> Massimo, >> >> where do I change the INPUT size (leng

[web2py] SQLFORM.grid Links question

2012-04-13 Thread greenpoise
Based on this: links = [lambda row: INPUT(_name='qty', _value='1'), lambda row: A('+', callback=URL('cart_callback',vars=dict(id=row.id,action='add',qt=request. vars.qty)))] Is there a way to grab the value of the INPUT to pass them to another function??? qt=request.vars.qty does not cut it.

  1   2   3   4   >