Re: [web2py] Re: Deploy on Apache with psycopg2

2013-09-26 Thread ewong1111
Oh and just to clarify, I know I can't just plop over my python with psycopg2 folder somewhere else--it's already part of a packagish thingy that can be easily built/installed in each network. On Thursday, September 26, 2013 2:45:10 PM UTC-7, ewon...@gmail.com wrote: > Aw poo, there's no easie

Re: [web2py] Re: Deploy on Apache with psycopg2

2013-09-26 Thread ewong1111
Aw poo, there's no easier way to do this? I'm using suse btw. The difficulties are that I would need to get virtualenv approved first, which would definitely not happen until after my deadline. I also thought about asking them to just install psycopg2 but that could also take a long time and

Re: [web2py] Deploy on Apache with psycopg2

2013-09-26 Thread ewong1111
I mean that when I log onto the system and do >which python /usr/bin/python This /usr/bin/python does not have psycopg2 installed However I have a /usr/blah/blah/blah/bin/python and this one does have psycopg2 installed. What I was doing during development was adding /usr/blah/blah/blah/bi

[web2py] Deploy on Apache with psycopg2

2013-09-26 Thread ewong1111
Hi, How can I get my web2py deployed on apache to use psycopg2 (on linux)? My "default" python does not have psycopg2 installed. However, I have a separate directory containing python with psycopg2 installed. I got it working when I developed on the Rocket server by adding this directory to

[web2py] Re: Variable db Table Name

2013-09-24 Thread ewong1111
cool thanks! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" gro

[web2py] Variable db Table Name

2013-09-24 Thread ewong1111
Is there any way to use a variable for a db table name as part of a query? Say if I have multiple tables with a field called "name" could I create a function such as this? def query_db(tbl, my_name):

[web2py] SQLFORM grid save checkbox state in multi-page results

2013-09-24 Thread ewong1111
I have the same question as asked here: https://groups.google.com/forum/#!searchin/web2py/grid$20checkbox$20pages/web2py/laMiQozWj_k/Wq6SdDDSajUJ I know how to use ajax to call a controller function that will register the checked row in a session variable. What I don't know is how to use the

[web2py] Re: Querying Multiple Databases

2013-08-21 Thread ewong1111
For some reason I hadn't realized that you could create a DAL in a regular ol controller function so that is what I did. I also had to make sure pool_size=0 and then after I was done with each db in the list I called close() on the DAL object. -- --- You received this message because you ar

[web2py] Re: Connection Closing Issue when Connecting to a Dynamic List of Dbs

2013-08-21 Thread ewong1111
I changed the DAL pool_size to 0 and then my_db.close() did what I wanted. -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.

[web2py] Re: Connection Closing Issue when Connecting to a Dynamic List of Dbs

2013-08-20 Thread ewong1111
Thanks for the response! That code was from a* *module and I am calling the module function from the controller. I just tried my_db.commit() but I am still getting this: OperationalError: FATAL: connection limit exceeded for non-superusers. When that happens, I can do a "select * from pg_s

[web2py] Re: Connection Closing Issue when Connecting to a Dynamic List of Dbs

2013-08-20 Thread ewong1111
Thanks for the response! That code was from a* *module and I am calling the module function from the controller. I just tried my_db.commit() but I am still getting this: OperationalError: FATAL: connection limit exceeded for non-superusers. When that happens, I can do a "select * from pg_st

[web2py] Querying Multiple Databases

2013-08-20 Thread ewong1111
I asked a question last Friday and haven't received any answers https://groups.google.com/forum/#!topic/web2py/t7xI7P0dqn4 I really need help so I thought I would post my core question again. What is the best way to connect to a variable list of legacy Postgres databases? The list could be b

[web2py] Connection Closing Issue when Connecting to a Dynamic List of Dbs

2013-08-16 Thread ewong1111
I have a list of legacy postgres databases (the list is variable) and I want to connect to each of them and pull in data from their summary tables into an SQLite table. I have the list of databases in my controller and there I am looping through them and calling a function I put in a module.

[web2py] Re: Extra Row in Table/Concatenating HTML Helpers

2013-08-16 Thread ewong1111
That's exactly what I needed, thanks! -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://

[web2py] Extra Row in Table/Concatenating HTML Helpers

2013-08-16 Thread ewong1111
I have this line: html = CAT(H4('Search Results'), TABLE(table_html, _CLASS="centered_table" )) using print statements I see that *html* is: Search ResultsBuild Block NameFull Variable Pathbuild1 FOOD_BLOCKHeaderView in Tree

[web2py] Re: SQLFORM.grid query widget not working

2013-06-18 Thread ewong1111
Found the problem and it's a complete newbie mistake. Somewhere along the way I had deleted the {{extend 'layout.html'}} from the view. What I really needed was the ajax (which is included in layout.html) , i.e. {{include 'web2py_ajax.html'}} Sorry, I did not realize this since I am new to

[web2py] Re: SQLFORM.grid query widget not working

2013-06-18 Thread ewong1111
IE8 On Tuesday, June 18, 2013 10:11:07 AM UTC-7, Massimo Di Pierro wrote: > Which IE version? > > On Tuesday, 18 June 2013 10:57:56 UTC-5, ewon...@gmail.com wrote: >> >> It worked when I was using IE. I am having problems with Firefox >> 17.0.5. I am using web2py version 2.4.6-stable. Are th

[web2py] Re: SQLFORM.grid query widget not working

2013-06-18 Thread ewong1111
It worked when I was using IE. I am having problems with Firefox 17.0.5. I am using web2py version 2.4.6-stable. Are there issues using it with Firefox? On Monday, June 17, 2013 10:26:18 PM UTC-7, Massimo Di Pierro wrote: > There should be no difference on whether you use Windows or Linux. P

[web2py] SQLFORM.grid query widget not working

2013-06-17 Thread ewong1111
Hi, I started using web2py on Windows (with IE) but realized that I needed to use Linux (with Firefox). SQLFORM.grids looked very nice on Windows, but now that I am using Linux, they look very plain, and more concerningly, do not seem to be working properly for me. In particular, the query bui

[web2py] Re: Simple Postgres Exercise and ValueError: invalid literal for int() with base 10: 'SELECT'

2013-05-23 Thread ewong1111
The sql.log only said that the table was effectively created (it was), just couldn't read or write to it after. Are you using psycopg2? I was just using the pg8000 that comes with web2py, however someone informed me that web2py is broken as shipped (!) and sure enough, after installing psyc

[web2py] Simple Postgres Exercise and ValueError: invalid literal for int() with base 10: 'SELECT'

2013-05-22 Thread ewong1111
What I really wanted to do was connect to an existing postgres database and read/display the data, but I kept getting this error: ValueError: invalid literal for int() with base 10: 'SELECT' I've pared down to some stupidly simple code that works with sqlite, but when I change to use my postg