[web2py] Re: Session data lose...

2010-10-04 Thread mdipierro
Not sure but here request.session_id: None response.session_id: 127-0-0-1-3bf56311-2bf8-454d-9772-5825e8533348 insecure string pickle insecure string pickle insecure string pickle insecure string pickle insecure string pickle insecure string pickle insecure string pickle insecure string pickle

[web2py] Sessions limitation...

2010-10-04 Thread Jason Brower
I noticed that I get the too many files open error with all my new sessions that are created. Would this be a problem when we have REALLY buys connections of people on a page and we need to keep track of all the session information? Should there be a way to adjust or handle the situation? It

[web2py] Re: Postgresql databavse.schema

2010-10-04 Thread mdipierro
because of the name you need to create a db view for it. On Oct 4, 8:26 am, Johann Spies johann.sp...@gmail.com wrote: I want to use a legacy database.  In Postgresql I access it as A.b.c where A is the database, b is the schema and c is where the tables are.sql Here is an example of the sql

Re: [web2py] IE and Firefox differences

2010-10-04 Thread rochacbruno
Did you set id and name attributes for the INPUT? Enviado via iPhone Em 04/10/2010, às 09:17, Kenneth kenneth.t.lundst...@gmail.com escreveu: Hello, everybody. This is not en web2py problem, I think. But don´t know where to start looking for a solution. I have a form with a lot of input

Re: [web2py] How to loop through two items

2010-10-04 Thread Andrew Evans
hey ty worked great *cheers

[web2py] Database JOIN on more than 2 tables

2010-10-04 Thread Alex
Hello, I was wondering what the syntax was to do a SQL JOIN on more than 2 tables. I understand the syntax for 2 tables is: db(db.table1.col == db.table2.FKcol).select() What if I want to JOIN the above resultset with more tables? I tried nesting the statements like: db(db(db.table1.col ==

[web2py] Re: How to loop through two items

2010-10-04 Thread Alex
I'm not quite sure what you are trying to accomplish - but it sounds like you have 2 result sets from the database and you want to show values from both? If so, you can always run two seperate loops and concatenate the values into strings and then display the final string with what you want. If

[web2py] Re: Database JOIN on more than 2 tables

2010-10-04 Thread annet
Hi Alex, Here's how you join more than two tables in web2py: db((db.table1.col == db.table2.FKcol)(db.table1col == db.table3.FKcol)).select() Kind regards, Annet.

[web2py] IE and Firefox differences

2010-10-04 Thread Kenneth
Hello, everybody. This is not en web2py problem, I think. But don´t know where to start looking for a solution. I have a form with a lot of input fields ordered in rows. For every row I have a submit button. Instead of text in the button I have a image like tthis. INPUT(_type=image _src

[web2py] Postgresql databavse.schema

2010-10-04 Thread Johann Spies
I want to use a legacy database. In Postgresql I access it as A.b.c where A is the database, b is the schema and c is where the tables are.sql Here is an example of the sql that created one of the original tables: CREATE TABLE kbase.institution ( id integer NOT NULL, name character

[web2py] format=

2010-10-04 Thread andrej burja
how or where should i define format representation for records if i put it in db.define_table: db.define_table('oseba', Field('ime'), Field('priimek'), Field('naslov'), Field('email',label='Elektronski naslov'), format='%(ime)s %(priimek)s') there is a id reference in SQLTABLE (not ime priimek)

Re: [web2py] Re: Session data lose...

2010-10-04 Thread Jason Brower
Attached is the print out. I still have my old debug information there showing when I press each key. Thanks, Jason Brower On 09/29/2010 04:34 PM, mdipierro wrote: I am going to need your help debugging this. In gluon/globals.py if response.session_id: try:

[web2py] how to: print pretty?

2010-10-04 Thread mart
Hi,

[web2py] Re: Database JOIN on more than 2 tables

2010-10-04 Thread Alex
Thank you very much! So obvious (as it always is once you see the answer) :). Thanks again! On Oct 4, 12:50 am, annet annet.verm...@gmail.com wrote: Hi Alex, Here's how you join more than two tables in web2py: db((db.table1.col == db.table2.FKcol)(db.table1col ==

[web2py] pdf template

2010-10-04 Thread andrej burja
is it possible to use pdf made from DTP application (like indesign,scribus) and merge it to new pdf (on GAE) - with pyfpdf or any other tool like having a template (pdf file) and adding name, surname etc. is it possible on GAE to directly store new file in database?

Re: [web2py] Re: Session data lose...

2010-10-04 Thread Jason Brower
I will look if I am picling anything, but if I remember, I am only pickling things AFTER I started seeing this bug. Though I think you pickling in the application if I am not mistaken. What would you like next? Best Regards, Jason Brower On 10/04/2010 04:44 PM, mdipierro wrote: Not sure but

[web2py] Re: Session data lose...

2010-10-04 Thread mdipierro
The issue is not you picklying. The issue is you storing in the session something the web2py can pickle but not unpickle, like an object of a class defined in a module that you define or import. On Oct 4, 10:18 am, Jason Brower encomp...@gmail.com wrote: I will look if I am picling anything, but

Re: [web2py] Re: Session data lose...

2010-10-04 Thread Jason Brower
Interesting... I will look into it. I was trying to avoid something like this so perhaps the object was thrown in there deep in some dictionary or something. Thanks for the help. I will report back tomorrow. On 10/04/2010 06:24 PM, mdipierro wrote: The issue is not you picklying. The

[web2py] Re: Sessions limitation...

2010-10-04 Thread ron_m
Depends on the OS you use to host - Windows, Linux, OSX. I don't use Windows much but for UNIX based systems there are per process file table limits which would put a cap on the number of open files per process as well as a system wide limit. I would be surprised if this is actually the session

[web2py] Re: IE and Firefox differences

2010-10-04 Thread Kenneth
Now I have set the ID but where do I see it when the form is sent? Kenneth On Oct 4, 4:09 pm, Kenneth kenneth.t.lundst...@gmail.com wrote: I set the name, thats where Firefox picks it up, but no ID. I´ll try with the ID. Kenneth On Oct 4, 4:05 pm, rochacbruno rochacbr...@gmail.com

[web2py] Pagination Issues [web2py_utils]

2010-10-04 Thread Andrew Evans
Hello I am having problems integrating my query in to my paginate code using web2py_utils. query = db(db.product.id 0).select(db.product.ALL, groupby=db.product.category) orderby = db.product.product_name pcache = (cache.ram, 15) paginate = Pagination(db, query, orderby,

[web2py] CRITICAL IMPORTANCE

2010-10-04 Thread mdipierro
Please help me update http://www.appliedstacks.com/NewestFirst/web2py Massimo

[web2py] Re: how to: print pretty?

2010-10-04 Thread mart
Sorry, bad typing day I need to display some dictionaries, these are generated according to DATA provided by the user. I would like to display them on a page, but need to display them pretty (like with pprint). I am wrapping this part of the app in plugin_wiki: I have 4 types of data that

[web2py] Re: how to: print pretty?

2010-10-04 Thread mart
yeah, ok... does not look very nice in this format, but, if we forgo the sample below, the rest is still a valid question, thanks again :) On Oct 4, 1:50 pm, mart msenecal...@gmail.com wrote: Sorry, bad typing day I need to display some dictionaries, these are generated according to DATA

Re: [web2py] Re: how to: print pretty?

2010-10-04 Thread Gary Herron
On 10/04/2010 10:50 AM, mart wrote: Sorry, bad typing day I need to display some dictionaries, these are generated according to DATA provided by the user. I would like to display them on a page, but need to display them pretty (like with pprint). I am wrapping this part of the app in

[web2py] Re: how to: print pretty?

2010-10-04 Thread mdipierro
did you try {{=BEAUTIFY(yourobject)}} On Oct 4, 1:04 pm, Gary Herron gher...@digipen.edu wrote: On 10/04/2010 10:50 AM, mart wrote: Sorry, bad typing day I need to display some dictionaries, these are generated according to DATA provided by the user. I would like to display them on

[web2py] Support for more fine grained database optimisation

2010-10-04 Thread Magnitus
While I'm aware that many of those optimizations can be built on top of the DAL, I think it would be nice if they were provided as optional parts of a more complete optimisation solution with the DAL: 1) Fine Grained Cache Instead of simply caching selects in memory and retrieving it in memory,

Re: [web2py] CRITICAL IMPORTANCE

2010-10-04 Thread Andrew Evans
What can I do to help? *cheers On Mon, Oct 4, 2010 at 10:19 AM, mdipierro mdipie...@cs.depaul.edu wrote: Please help me update http://www.appliedstacks.com/NewestFirst/web2py Massimo

[web2py] plugin_wiki and auth tables

2010-10-04 Thread Christian Foster Howes
Massimo et. al., Can we update plugin_wiki to use the auth settings for auth table names? Since i have not looked into implementing table namespaces on GAE yet, i rename all my tables with an application prefix so applications don't mix data. when i do that plugin_wiki is not so happy. I

[web2py] Re: how to: print pretty?

2010-10-04 Thread mart
Hi :) so I tried {{=BEAUTIFY(a_string)}}, no change. Then, I thought, I'll that the dict obj, pickled somewhere in those DB fileds... unpickled it, and passed it as it to {{=BEAUTIFY(obj)}} and got a TABLE a gorgeous table!! Seems everyday there's something unbelievable to be seen! and

[web2py] Progressbar plus

2010-10-04 Thread winti
I implemented some controller functions which are getting some data from a backend system. This may take more than one minute depending on the amount of informations to download. I would like to show the progress of the download tasks on the users web browser. response.flash or session.flash is

Re: [web2py] Re: how to: print pretty?

2010-10-04 Thread Bruno Rocha
{{obj = BEAUTIFY(.)}} without the '=' at the front '=' sign is a shortcut to {{response.write()}} If the modal window is inside the same view, you will be able to do {{=obj}} or {{response.write(obj)}} But if that modal is being opened as a popup, that will have its own context, I

[web2py] Re: CRITICAL IMPORTANCE

2010-10-04 Thread Magnitus
On Oct 4, 1:19 pm, mdipierro mdipie...@cs.depaul.edu wrote: Please help me update http://www.appliedstacks.com/NewestFirst/web2py Massimo Do you mean check the links to make sure they are still valid or report our aps? If its for reporting an ap, I only have one online atm and its a test

[web2py] Re: IE and Firefox differences

2010-10-04 Thread Kenneth
Does anybody know if this is even possible? Kenneth On 4 loka, 20:04, Kenneth kenneth.t.lundst...@gmail.com wrote: Now I have set the ID but where do I see it when the form is sent? Kenneth On Oct 4, 4:09 pm, Kenneth kenneth.t.lundst...@gmail.com wrote: I set the name, thats where

[web2py] Re: CRITICAL IMPORTANCE

2010-10-04 Thread Anthony
I tried adding a few I know about (tenthrow.com, radbox.me, Sahana Eden demo). The detail pages said the sites were added, but so far, they're not showing up in the list (maybe there's a delay). There are also a lot of sites in the list that don't exist anymore. When I got to their detail pages,

[web2py] Re: how to: print pretty?

2010-10-04 Thread mart
Great! thanks for that as well Bruno!!, already copied/pasted in my growing db of tips tricks we get here:). This may actually turn out to be something good looking (despite my flawed instinct for the esthetically pleasing ;) Thanks On Oct 4, 3:41 pm, Bruno Rocha rochacbr...@gmail.com wrote:

[web2py] Re: redirection question

2010-10-04 Thread Alex
Have you thought about maybe looking into the AJAX calls that are available? That way, the page won't postback. You can call a controller to do whatever you need with the data from the form. Otherwise, I can't see an easy way without somehow saving the state of where the page was called from

[web2py] Re: CRITICAL IMPORTANCE

2010-10-04 Thread Michael Ellis
Tried adding my site, http://peertool.appspot.com. Success was indicated, but so far it's not showing up. On Oct 4, 4:18 pm, Anthony av201...@yahoo.com wrote: I tried adding a few I know about (tenthrow.com, radbox.me, Sahana Eden demo). The detail pages said the sites were added, but so far,

[web2py] Alpha version of web2py book spanish translation

2010-10-04 Thread Gustavo
Good morning, Best regards from the team that makes up the Cluster Latinux. Once again, the organization reaffirms its commitment to support initiatives focused on free technologies. This time the Latinux Press unit is releasing the alpha version of the web2py book by Massimo Di Pierro spanish

[web2py] DB transaction isolation

2010-10-04 Thread Dragonfyre13
I was having a discussion with my DBA on why the DB he tuned for another project ran so much better than the one tuned for general use (I was previously on the dedicated server, now on the general use server). He said the configuration was the same, with one change. Transaction isolation level was

[web2py] problems installing updated plugin_wiki...

2010-10-04 Thread mart
Hi Massimo, I think I had an outdated plugin_wiki (tried to use the new links field for the slideshow widget, and getting an error), so downloaded the latest from web2py.com, and getting this error: File C:\web2py\gluon\restricted.py, line 188, in restricted exec ccode in environment File

[web2py] Re: problems installing updated plugin_wiki...

2010-10-04 Thread mart
Sorry, my bad... fund the right link in the book (i think the other is the daily build output?). Anyways, sorry for the alarm, will install from link ... Mart :) On Oct 4, 7:05 pm, mart msenecal...@gmail.com wrote: Hi Massimo, I think I had an outdated plugin_wiki (tried to use the new links

[web2py] Script to generate schema (models) from PostgreSQL (and possibly others)

2010-10-04 Thread Mariano Reingart
Hi, attached is a PostgreSQL enhanced versión of Alexandre Andrade mysql script. It uses information_schema (ANSI Standard), so it might support others databases too. It connects to live databases (doesn't need SQL dump), and supports: keyed tables, most data types, default values, constraints

[web2py] Spawning WSGI server and web2py

2010-10-04 Thread Dragonfyre13
Anyone used this? Looks absolutely awesome for what I'm doing (heavy ajax/comet type hits, easily thousands of open connections at a given time, etc.) http://pypi.python.org/pypi/Spawning There are of course alternatives out there, but wondering if anyone had ever played with this before.

Re: [web2py] DB transaction isolation

2010-10-04 Thread Mariano Reingart
On Mon, Oct 4, 2010 at 7:30 PM, Dragonfyre13 dragonfyr...@gmail.com wrote: I was having a discussion with my DBA on why the DB he tuned for another project ran so much better than the one tuned for general use (I was previously on the dedicated server, now on the general use server). He said

Re: [web2py] experimental... .pdf

2010-10-04 Thread Mariano Reingart
On Sun, Oct 3, 2010 at 1:10 AM, mdipierro mdipie...@cs.depaul.edu wrote: I am sure this can also be done and better with pyfpdf but I have not tried. Perhaps Mariano can help us Having latest web2py versions (including pyfpdf), write in a views/generic.pdf: begin file {{ from

Re: [web2py] pdf template

2010-10-04 Thread Mariano Reingart
On Mon, Oct 4, 2010 at 12:18 PM, andrej burja andrej.bu...@gmail.com wrote: is it possible to use pdf made from DTP application (like indesign,scribus) and merge it to new pdf (on GAE) - with pyfpdf or any other tool Scribus and Inkscape uses XML file formats. Maybe you can use some XML parser

Re: [web2py] Re: IE and Firefox differences

2010-10-04 Thread Bruno Rocha
I Just made a test, look: code def index(): form = FORM() inputimg = INPUT(_type=image, \ _src='myimg.png', \ _value='testing', \ _id='ordernumber', \ _name='ordernumber') inputname =

Re: [web2py] IE and Firefox differences

2010-10-04 Thread Bruno Rocha
If I use _type=submit I get the variable, but then the submit button shows the ordernumber value. Any ideas? A better solution should be using Ajax, having a hidden input, you can pass it to ajax callback. more on ajax: http://web2py.com/book/default/chapter/10#The-ajax-Function

[web2py] Re: IE and Firefox differences

2010-10-04 Thread mdipierro
SQLFORM(,hidden=dict(...)) On Oct 4, 10:06 pm, Bruno Rocha rochacbr...@gmail.com wrote: If I use _type=submit I get the variable, but then the submit button shows the ordernumber value. Any ideas? A better solution should be using Ajax, having a hidden input, you can pass it to ajax

[web2py] Re: IE and Firefox differences

2010-10-04 Thread Kenneth
I put a list.append(str(INPUT(_name='delivery_'+ str(result.id) + _ + str(product.id), _value=to_be_delivered, _class=deliver_products, _type='text'))) for every product per row, can be anything between 1-6 products. Then I put list.append(INPUT(_type=image, _src=/init/static/img/ delivery_s.gif,

[web2py] BCC in web2py?

2010-10-04 Thread Chris
Hello, I've been using web2py to send mail, and one of my users alerted me that BCCs are visible! I'm using a gmail account, standard web2py setup, and using the following code: status = mail.send(to=%s %s % (recipient['first_name'],custom_recipient or recipient['email']),

Re: [web2py] BCC in web2py?

2010-10-04 Thread Jonathan Lundell
On Oct 4, 2010, at 9:22 PM, Chris wrote: I've been using web2py to send mail, and one of my users alerted me that BCCs are visible! I'm using a gmail account, standard web2py setup, and using the following code: status = mail.send(to=%s %s % (recipient['first_name'],custom_recipient or

[web2py] DAL belongs in GAE

2010-10-04 Thread firedragon852
On GAE, this doesn't work: rows = db((db.geoip.begin_num = value) (db.geoip.end_num = value)).select() BadFilterError: BadFilterError: invalid filter: Only one property per query may have inequality filters (=, =, , ).. So I broke the query into two queries: ids = db(db.geoip.begin_num =

Re: [web2py] Re: Postgresql databavse.schema

2010-10-04 Thread Johann Spies
On 4 October 2010 15:45, mdipierro mdipie...@cs.depaul.edu wrote: because of the name you need to create a db view for it. I do not understand how a postgresql view can help in this case. Regards Johann --  May grace and peace be yours in abundance through the full knowledge of God and of