[web2py] Re: Admin access on hostmonster account

2013-11-27 Thread Larry Wapnitsky
ppadmin/$anything', BASE + '/$app/appadmin/$anything'), # do not reroute static files ('/$app/static/$anything', BASE + '/$app/static/$anything'), # do other stuff (r'.*http://otherdomain\.com.* /app/ctr(?P.*)', r'\g'), (r'/app(?P.*)&#

[web2py] Admin access on hostmonster account

2012-08-30 Thread Larry Wapnitsky
I'm receiving the following message when logging in to the admin interface of web2py on my hostmonster account: Login requires a secure (HTTPS) connection or running on localhost. I've followed the instructions here: http://www.web2pyslices.com/slice/show/1401/web2py-on-shared-hosting-hostmons

Re: [web2py] Re: Back-and-forth between DAL & SQLAlchemy

2012-08-17 Thread Larry Wapnitsky
: > > I meant this: > > http://web2py.com/AlterEgo/default/show/189 > > > On Wednesday, 15 August 2012 14:22:36 UTC-5, Larry Wapnitsky wrote: >> >> I have a project in which I've just written the database functions using >> SQLAlchemy. It was much

[web2py] Re: How to email attachment with original filename

2012-08-17 Thread Larry Wapnitsky
I'm currently storing the files as BLOBs in MySQL along with a field for the filename. That has been working for me. On Friday, August 17, 2012 8:35:38 AM UTC-4, Cliff Kachinske wrote: > > How can I email uploaded files with the original file name? > > I realize it is possible to make a copy of

[web2py] Back-and-forth between DAL & SQLAlchemy

2012-08-15 Thread Larry Wapnitsky
I have a project in which I've just written the database functions using SQLAlchemy. It was much simpler than my original, hand-written SQL queries, especially once I got the hang of creating "relationships" with SA's ORM. Now, I would like to create a front-end for this using web2py, but, fro

[web2py] Re: variables to determine table columns from database

2012-08-07 Thread Larry Wapnitsky
damned periods! :) Thanks, Anthony On Tuesday, August 7, 2012 2:49:53 PM UTC-4, Anthony wrote: > > rows = db(db[request.args(0)][request.args(2)] == request.args(1)).select > ( > > Anthony > > On Tuesday, August 7, 2012 2:15:09 PM UTC-4, Larry Wapnitsky wrote: >> &

[web2py] variables to determine table columns from database

2012-08-07 Thread Larry Wapnitsky
from a web page, i'm able to successfully query my database using the following: rows = db(db[request.args(0)].id == request.args(1)).select( What I'm having trouble with is passing another argument that specifies another column other than id. I've tried the following with no success: ro

[web2py] empty jqgrid

2012-08-06 Thread Larry Wapnitsky
Pardon me if I asked this before, but I can't seem to find my prior Q&A: I'm attempting to use jqgrid via the plugin_wiki widget, yet all my tables keep coming up as empty. This is what I'm putting my my html file: {{=plugin_wiki.widget('jqgrid',table='recipient')}} And this is the table def

[web2py] LEFT JOIN query issues

2012-08-02 Thread Larry Wapnitsky
I'm trying to take the following MySQL query SELECT recipient.emailAddress FROM recipient LEFT JOIN mr_link ON recipient.id = mr_link.recipID and turn it into a DAL query, but I keep running into 'keyword' issues My code is as such: rows = db().select(db.recipient.emailAddress, db.mr_link

[web2py] existing tables in plugin_wiki

2012-08-01 Thread Larry Wapnitsky
I'm attempting to access database tables created in my db.py file using different aspects of plugin_wiki. Whenever I enter the table name, I get the following as my results on my "page": Traceback (most recent call last): File "/home/lwapnitsky/web2py/applications/EARS_web2py/models/plugin_w

Re: [web2py] Is anyone using GWT?

2012-06-07 Thread Larry Wapnitsky
I'm slowly learning the PyJS/Pyjamas libraries, so I'll say "yes" for me On Thursday, June 7, 2012 11:31:30 AM UTC-4, Richard wrote: > > I can't speak for the orthers, but web2py is tigthly bone to jQuery and it > is very easy to include jQuery UI, so I guest many users just use those lib > in a

[web2py] Three typos/updates in web2py online book (JSON/Pyjamas section)

2012-06-06 Thread Larry Wapnitsky
In section http://web2py.com/books/default/chapter/29/10#JSONRPC-and-Pyjamas 1. Pyjamas is now known as PyJS, even though the libraries are still called pyjamas 2. import pyjamas.ui.KeyboardListener should read import pyjamas.ui.KeyboardListener as KeyboardListener to work properly

[web2py] alternates to pyjamas/pyjs?

2012-05-30 Thread Larry Wapnitsky
Are there any good alternatives to using pyjamas/pyjs or learning JavaScript from scratch? I've tried installing pyjamas/pyjs on a few of my Debian systems (thank G-d for virtual machines), but can't seem to get it to run in development. I've tried from source and followed a ton of informatio

[web2py] Re: Support for MS Access?

2012-05-22 Thread Larry Wapnitsky
Has anyone tested this further? I have an Access database that I'd like to parse for a web2py project. It's a live database that's too big to export to MySQL right now. Thanks, Larry On Thursday, March 17, 2011 9:07:03 AM UTC-4, DenesL wrote: > > > It depends on how you want to connect. > The

Re: [web2py] Re: jqgrid assistance

2012-05-21 Thread Larry Wapnitsky
Any ideas, Massimo? This would really be great, as my database is growing. Thanks. On Tuesday, May 15, 2012 9:55:57 AM UTC-4, Larry Wapnitsky wrote: > > right...realized that after I sent it (long day) > > any ideas? > > On 5/15/2012 9:53 AM, Massimo Di Pierro wrote: >

[web2py] Re: db two selects

2012-05-15 Thread Larry Wapnitsky
If you resort to using Python code, let me know. I just did this for one of the lists in my database that has hit counts, dates, etc. On Sunday, May 13, 2012 3:27:56 PM UTC-4, pbreit wrote: > > I'm not sure that query will do what you want. I think you need to sort by > views separately.

Re: [web2py] Re: jqgrid assistance

2012-05-14 Thread Larry Wapnitsky
', viewrecords: true,height:300});jQuery("#jqgrid_ips"). jqGrid('navGrid','#jqgrid_ips_pager',{search:true,add:false,edit:false,del: false});jQuery("#jqgrid_ips").setGridWidth(700,false);jQuery( 'select.ui-pg-selbox,input.ui-pg-input').css('wid

Re: [web2py] Re: jqgrid assistance

2012-05-14 Thread Larry Wapnitsky
; On Monday, 14 May 2012 08:55:53 UTC-5, Larry Wapnitsky wrote: >> >> Even if I remove "fieldname", et.al. after the table name, no data. >> >> On Friday, May 11, 2012 8:13:59 PM UTC-4, Larry Wapnitsky wrote: >>> >>> better, but still no data sho

Re: [web2py] Re: jqgrid assistance

2012-05-14 Thread Larry Wapnitsky
404 not found On Monday, May 14, 2012 2:02:37 PM UTC-4, Massimo Di Pierro wrote: > > can you use chrome to see what is the ajax request? Can you try call the > url of the ajax request manually? What do you get? A ticket? > > On Monday, 14 May 2012 08:55:53 UTC-5, Larry

Re: [web2py] Re: jqgrid assistance

2012-05-14 Thread Larry Wapnitsky
Even if I remove "fieldname", et.al. after the table name, no data. On Friday, May 11, 2012 8:13:59 PM UTC-4, Larry Wapnitsky wrote: > > better, but still no data showing up. > > On Fri, May 11, 2012 at 7:23 PM, Massimo Di Pierro < > massimo.dipie...@gmail.com> wro

Re: [web2py] Re: jqgrid assistance

2012-05-11 Thread Larry Wapnitsky
t;b_or_w", > fieldvalue="w", fields=["id", "ipaddress", "attacknotes"]) > > On Friday, 11 May 2012 17:07:02 UTC-5, Larry Wapnitsky wrote: >> >> I'll try that, but even adjusting, this (in the controller) does not work: >> >>

Re: [web2py] Re: jqgrid assistance

2012-05-11 Thread Larry Wapnitsky
> > Anyway, I do not see the signature. Are you logged in? > > jqgrid in plugin_wiki requires login if I remember it right. > > > > On Thursday, 10 May 2012 15:02:27 UTC-5, Larry Wapnitsky wrote: >> >> Also just found this via the dev tools:: >> >&

[web2py] Re: jqgrid assistance

2012-05-11 Thread Larry Wapnitsky
UTC-4, Larry Wapnitsky wrote: > > nix that. the updated version in plugin_wiki is still giving me grief. > the standard version you can install from the wizard (jqgrid) works except > for individual column sizing. > > On Friday, May 11, 2012 3:42:04 PM UTC-4, Larry Wapnitsky wrote:

[web2py] Re: jqgrid assistance

2012-05-11 Thread Larry Wapnitsky
nix that. the updated version in plugin_wiki is still giving me grief. the standard version you can install from the wizard (jqgrid) works except for individual column sizing. On Friday, May 11, 2012 3:42:04 PM UTC-4, Larry Wapnitsky wrote: > > got it working by using the wizard to cr

[web2py] Re: jqgrid assistance

2012-05-11 Thread Larry Wapnitsky
got it working by using the wizard to create a new version of my app. On Thursday, May 10, 2012 4:16:00 PM UTC-4, Larry Wapnitsky wrote: > > the whole "plugin_wiki" thing is really starting to get my goat. Now I'm > getting errors trying to delete my test wiki page: >

[web2py] Re: jqgrid assistance

2012-05-10 Thread Larry Wapnitsky
gt; To check you can also delete your tickets in errors/* and see if any new > one shows up. > > On Thursday, 10 May 2012 08:31:15 UTC-5, Larry Wapnitsky wrote: >> >> I'm trying out jqgrid (yes, I finally got plugin_wiki working ;)), but >> can't seem to get

[web2py] Re: jqgrid assistance

2012-05-10 Thread Larry Wapnitsky
Even this fails on a wiki page: `` name: jqgrid table: db.ips col_width: 80 width: 700 height: 300 ``:widget Traceback (most recent call last): File "/home/lwapnitsky/web2py/applications/rbl_web2py/models/plugin_wiki.py", line 635, in render_widget html = getattr(PluginWikiWidgets,name)(*

[web2py] Re: jqgrid assistance

2012-05-10 Thread Larry Wapnitsky
Also just found this via the dev tools:: Request URL: http://127.0.0.1:8000/rbl_web2py/plugin_wiki/jqgrid?columns=ipaddress%2Cattacknotes%2Cb_or_w%2CupdCount&fieldname=&fieldvalue=None&tablename=ips&_search=false&nd=1336679760463&rows=10&page=1&sidx=&sord=asc

[web2py] Re: jqgrid assistance

2012-05-10 Thread Larry Wapnitsky
heck you can also delete your tickets in errors/* and see if any new > one shows up. > > On Thursday, 10 May 2012 08:31:15 UTC-5, Larry Wapnitsky wrote: >> >> I'm trying out jqgrid (yes, I finally got plugin_wiki working ;)), but >> can't seem to get it to displa

[web2py] Re: Problems trying to use jqgrid from plugin_wiki

2012-05-10 Thread Larry Wapnitsky
Massimo- I'm still getting this in the latest trunk of web2py. Any ideas? Thanks, Larry On Monday, January 10, 2011 4:13:12 PM UTC-5, Massimo Di Pierro wrote: > > It took me a while to debug this. > The problem is that the ajax service that fills the table requires > login. > You probably ha

[web2py] jqgrid assistance

2012-05-10 Thread Larry Wapnitsky
I'm trying out jqgrid (yes, I finally got plugin_wiki working ;)), but can't seem to get it to display data. Here is my code: *{{=plugin_wiki.widget('jqgrid', db.ips)}}* I see a table with MOST of my fields showing (not all, strangely), but no data. I know for a fact that the database is popu

[web2py] Re: web2py resources

2012-05-09 Thread Larry Wapnitsky
What about for some of the jquery/JSON specific ideas? What recommendations do you have for those of us who are clueless in those factions? :) On Thursday, May 3, 2012 9:46:35 PM UTC-4, Anthony wrote: > > On Thursday, May 3, 2012 8:20:28 PM UTC-4, newnomad wrote: >> >> For those without any pri

Re: [web2py] datatable plugin customization

2012-05-09 Thread Larry Wapnitsky
;>> ho, I think those plugin could be quite outdated... >>> >>> If you really need a table plugin, look to Datatables or PowerTable >>> (or PowerGrid : http://labs.blouweb.com/PowerGrid/) form Bruno. >>> >>> There is also a plugin_wiki jqgrid coming p

Re: [web2py] Re: plugin wiki issues

2012-05-08 Thread Larry Wapnitsky
if I recreate the database from scratch, then re-import my data, it works fine. On Tuesday, May 8, 2012 4:33:54 PM UTC-4, Larry Wapnitsky wrote: > > even tried it as rootno dice. > > > On 5/8/2012 4:25 PM, villas wrote: > > Hi Larry, it sounds like your DB is not co

[web2py] Re: plugin wiki issues

2012-05-08 Thread Larry Wapnitsky
restarted web2py. no dice. died immediately when accessing any page (1005, u"Can't create table 'rbl.plugin_wiki_page' (errno: 150)") On Tuesday, May 8, 2012 4:16:50 PM UTC-4, Larry Wapnitsky wrote: > > A new, test app worked with no problems. > > Her

[web2py] Re: plugin wiki issues

2012-05-08 Thread Larry Wapnitsky
A new, test app worked with no problems. Here is my DAL DB connection string: db = DAL('mysql://user:passw...@dbserer.company.com/dbname') I was getting "can't create table" errors until I added "grant" rights to the remote "user" account. Now, the page just spins... On Tuesday, May 8, 2012

Re: [web2py] datatable plugin customization

2012-05-08 Thread Larry Wapnitsky
ck and inspect element can > make it pretty easy to find a style and change the properties. > > Richard > > On Tue, May 8, 2012 at 11:46 AM, Larry Wapnitsky wrote: > >> I'm not a CSS guy (still learning), but need to be able to change the >> default column widths in the datatable plugin. Guidance? >> >> Thanks, >> Larry >> > >

Re: [web2py] datatable plugin customization

2012-05-08 Thread Larry Wapnitsky
plugin_datatable from web2py.com/plugins On Tuesday, May 8, 2012 11:58:28 AM UTC-4, Richard wrote: > > Which plugin... Also if you use chrome rigth click and inspect element can > make it pretty easy to find a style and change the properties. > > Richard > > > I'm not a CSS guy (still learning),

[web2py] Re: plugin wiki issues

2012-05-08 Thread Larry Wapnitsky
re there are no fake_migration settings anywhere. > Run python web2py.py -N -M -S yourapp to start web2py > Are there any error messages? > > > On Tuesday, 8 May 2012 14:51:45 UTC+1, Larry Wapnitsky wrote: >> >> David- >> >> No dice. Still getting the same erro

[web2py] datatable plugin customization

2012-05-08 Thread Larry Wapnitsky
I'm not a CSS guy (still learning), but need to be able to change the default column widths in the datatable plugin. Guidance? Thanks, Larry

[web2py] Re: plugin wiki issues

2012-05-08 Thread Larry Wapnitsky
ld now generate the tables. > > I appreciate that step one is a bit of a hassle, but it is so useful to > be able to look inside your DB that I think it is well worth the effort. > You should be able to find something easily on google, especially if you > are using Sqlite.

[web2py] Re: plugin wiki issues

2012-05-04 Thread Larry Wapnitsky
It looks as though the database table generation does not automatically take place unless you use the wizard. How can I initiate this and get the plugin active? The "book" doesn't really give great details on that. Thanks On Friday, May 4, 2012 2:38:51 PM UTC-4, villas wrote: > > >>1. *

[web2py] plugin wiki issues

2012-05-04 Thread Larry Wapnitsky
Two issues with installing the wiki plugin: 1. in my current app, I get the following error immediately after installing the plugin and trying to access any portion of the app * (1146, u"Table 'rbl.plugin_wiki_page' doesn't exist"* 2. when loading the plugin in a brand-ne

Re: [web2py] Re: quick SQL question

2012-05-02 Thread Larry Wapnitsky
u should have something that do what you want! > > Richard > > On Wed, May 2, 2012 at 1:49 PM, Richard Vézina < > ml.richard.vez...@gmail.com> wrote: > >> Maybe raw SQL?? >> >> Richard >> >> >> On Wed, May 2, 2012 at 10:54 AM, Larry Wapnitsky

[web2py] Re: SOLVED Re: Inline image generation with matplotlib

2012-05-02 Thread Larry Wapnitsky
More updated code: def barPlot(data): from matplotlib.backends.backend_agg import FigureCanvasAgg as FigureCanvas from matplotlib.figure import Figure import cStringIO print data stream = cStringIO.StringIO() cx = data.keys() cy = data.values() fig

[web2py] Re: SOLVED Re: Inline image generation with matplotlib

2012-05-02 Thread Larry Wapnitsky
I'm having difficulty with this. Here is my code: def barPlot(data): from matplotlib.backends.backend_agg import FigureCanvasAgg as FigureCanvas from matplotlib.figure import Figure import cStringIO stream = cStringIO.StringIO() cx = data.keys() cy = data.values

[web2py] Re: matplotlib + web2py question

2012-05-02 Thread Larry Wapnitsky
Can this be done without storing the image if it's only needed the one time? On Wednesday, April 4, 2012 4:45:50 PM UTC-4, dancer` wrote: > > Thank you very much. > > One more thing - if I understand correctly this allows me to keep my data > buffer clean and not worry about overwriting plots. I

[web2py] Re: quick SQL question

2012-05-02 Thread Larry Wapnitsky
254 ORDER BY ipCount DESC On Tuesday, May 1, 2012 3:19:27 PM UTC-4, Larry Wapnitsky wrote: > > In a test (non-web2py) program, I'm using a MySQL query that > invokes SELECT SUBSTRING_INDEX. What is the easiest way to convert this to > the proper usage within web2py's DAL specifications? > > Thanks, > Larry >

[web2py] Re: quick SQL question

2012-05-01 Thread Larry Wapnitsky
Let me clarify that the substring in particular I'm using is the first 3 octets of an IP address.. On Tuesday, May 1, 2012 3:19:27 PM UTC-4, Larry Wapnitsky wrote: > > In a test (non-web2py) program, I'm using a MySQL query that > invokes SELECT SUBSTRING_INDEX. What is

[web2py] quick SQL question

2012-05-01 Thread Larry Wapnitsky
In a test (non-web2py) program, I'm using a MySQL query that invokes SELECT SUBSTRING_INDEX. What is the easiest way to convert this to the proper usage within web2py's DAL specifications? Thanks, Larry

[web2py] Not a question, but thanks

2012-04-17 Thread Larry Wapnitsky
Just wanted to say thanks to everyone who answered my questions over the past 2-3 months or so in regards to developing my IP management application. FYI - it's working great, and I couldn't have done it without all of you (particularly Massimo for creating this great framework). -Larry

[web2py] Customizing a widget

2012-03-27 Thread Larry Wapnitsky
Forgive my N00b-ness - not a web developer (but I've said that before) I have the following code in an app I'm writing: Field('b_or_w', 'string', length=1, widget=SQLFORM.widgets.radio.widget, requires=IS_IN_SET(['b','w']), default='b') How do I customize this so that, instead of *b* and *w* ap

[web2py] Two forms, one page

2012-03-20 Thread Larry Wapnitsky
I know it's possible to have multiple forms on one page, but is it possible to have one submit button that submits data based on both forms? I have a SQLFORM field that takes multiple entries. This is followed by a CRUD form based on the DAL (MySQL). I'd like to parse the data in the SQLFORM (m

[web2py] DAL validation issue

2012-03-20 Thread Larry Wapnitsky
I'm having an issue (in my first real web2py application) whereby I'm unable to validate DB data via the DAL without creating a duplicate entry. I have the following code in my db.py: db.define_table('ips', Field('id', 'id'), Field('ipaddress','string', length=15, unique=True), Fiel

[web2py] Re: routes for subdomains

2012-03-16 Thread Larry Wapnitsky
Massimo- I'm still a little unclear on this. I have a setup where web2py is a subfolder of my public_html folder. I have two domains, A and B. I'd like for the following sub1.ADomain.com to go to public_html/web2py/appA1/default/index sub2.ADomain.com public_html/web2py/appA2/de

[web2py] Re: web2py recipe book

2012-03-13 Thread Larry Wapnitsky
Amazon just cancelled my order. They apparently don't have any in stock on the day it was supposed to ship. Guess i"m going directly to packt On Monday, March 12, 2012 3:18:43 AM UTC-4, Massimo Di Pierro wrote: > > The web2py recipes book is finally out: > > > http://www.packtpub.com/web2py-app

[web2py] web2py and twisted

2012-03-07 Thread Larry Wapnitsky
doing some testing with twisted and web2py (proof of concept in between development swings), but can't get anyserver.py to run. I'm getting the following: root@python1:/var/www/web2py# python anyserver.py -s twisted -i 10.102.42.10 -p 8000 -l starting twisted on 10.102.42.10:8000... Traceback

Re: [web2py] more tutorials?

2012-03-05 Thread Larry Wapnitsky
And this link (http://www.web2py.com/books/default/reference/29/alterego) no longer works, as does the one on redirecting, which is where i"m seriously getting stuck. On Mon, Mar 5, 2012 at 16:18, Larry Wapnitsky wrote: > So, I seem to be getting stuck a lot as I'm learning web2py

[web2py] more tutorials?

2012-03-05 Thread Larry Wapnitsky
So, I seem to be getting stuck a lot as I'm learning web2py, but I'm not finding the online documentation to be very thorough in answering my questions. Additionally, as much as have enjoyed the assistance I've gotten from the newsgroup so far, the time delay on responses keeps me from working

[web2py] forms.errors.data multiline?

2012-03-02 Thread Larry Wapnitsky
Is it possible to display a multiline error via forms.errors.data? I'm parsing a list and want to show all invalid entries in the error message that flashes. Thanks.

Re: [web2py] Re: Validating data in a CRUD form before entering into the databse

2012-03-02 Thread Larry Wapnitsky
looks helpful. adapting now. thanks. On Fri, Mar 2, 2012 at 06:32, Wikus van de Merwe wrote: > I think the easiest is to add your validation code in the controller and > then process > the data after successful validation. I don't know how your data looks > like but here > is a simple example o

[web2py] Validating data in a CRUD form before entering into the databse

2012-03-01 Thread Larry Wapnitsky
(please let me know if I need to clarify) I have a form that I'm creating where a user can enter one line of data, multiple lines of data (each line being a different entry), and/or ranges of numbers. I need the application to do the following before entering the data in the database: - V

[web2py] inserting username into database

2012-02-23 Thread Larry Wapnitsky
(newbie disclaimer :)) I'm logging in to my application via AD/LDAP. I can get the variable of the username with no issue. What i need to do next is take this variable and insert it into a field in a CRUD form and have it show in my database. Thanks, Larry

[web2py] multiple 'requires'

2012-02-23 Thread Larry Wapnitsky
I'm trying to use the following in my applications, but only one works at a time: db.ips.ipaddress.requires = IS_NOT_IN_DB(db, 'ips.ipaddress') db.ips.ipaddress.requires = IS_IPV4() How can I get them both to process? Thank you, Larry

[web2py] Re: 1.99.4 Active Directory LDAP Issue

2012-02-23 Thread Larry Wapnitsky
Getting the same error and just updated from the git repository. 10.102.50.37.2012-02-23.07-46-58.25a3ba02-828a-41d8-ae1d-daf22ab847df 'NoneType' object has no attribute 'user_groups' snippets from my db.py: (added to the original skeleton) ## create all tables needed by auth if not custom ta

[web2py] Re: Parsing a list of items - how-to?

2012-02-23 Thread Larry Wapnitsky
Thanks to both of you. I'll try these when I get to my office this morning. Assume I'll be back with either good results or more questions :)

[web2py] Re: Recipe: How to set up web2py + ldap with Windows Active Directory

2012-02-22 Thread Larry Wapnitsky
Which page am I adding the second portion of code to? (web2py newbie here)

[web2py] Parsing a list of items - how-to?

2012-02-22 Thread Larry Wapnitsky
Disclaimer: I'm new to Web2py (2 days and loving it) and re-learning HTML after many years away from it. I have a large text field on a form whose input will be a list of items entered by the user, separated by some sort of delimiter (most likely a newline). Each valid line item will be enter