'\gany'),
# restore the BASE prefix
('/$anything', BASE + '/$anything'),
)
my access.py for the admin is at the latest default for the git pull.
Advice, please?
On Thursday, August 30, 2012 8:04:50 AM UTC-4, Larry Wapnitsky wrote:
I'm receiving the following message when logging
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:
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 the
UTC-5, Larry Wapnitsky wrote:
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
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, from
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:
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:
from a web page, i'm able
Pardon me if I asked this before, but I can't seem to find my prior QA:
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
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,
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
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
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
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
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
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:
It is not really a comment
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.
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 wrote:
The second argument is the name
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 Wapnitsky wrote:
Even if I
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 showing up.
On Fri, May 11, 2012 at 7:23 PM, Massimo Di Pierro
massimo.dipie...@gmail.com
the url? this should be calling an action in plugin wiki. must be
there.
On Monday, 14 May 2012 13:11:03 UTC-5, Larry Wapnitsky wrote:
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
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:
class
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 create a new
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:
got it working by using the wizard
UTC-5, Larry Wapnitsky wrote:
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%**2CupdCountfieldname=**
fieldvalue=Nonetablename=ips**_search=falsend=**
1336679760463rows=10page=1**sidx
, 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:
wl2 = plugin_wiki.widget('jqgrid', db.ips, fieldname=b_or_w,
fieldvalue=w, fields=[id, ipaddress, attacknotes])
nor does:
wl2 = plugin_wiki.widget
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
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 have
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 display data. Here is my code:
*{{=plugin_wiki.widget('jqgrid', db.ips
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%2CupdCountfieldname=fieldvalue=Nonetablename=ips_search=falsend=1336679760463rows=10page=1sidx=sord=asc
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 =
it fail? Why?
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 it to display data. Here is my code
.
Richard
On Tue, May 8, 2012 at 3:36 PM, Larry Wapnitsky la...@kvetsch.comwrote:
Also, I found the truncate switch, which is helping me, but my table
is appearing on the right. Is there a list of the available switches
for
datatable?
On Tuesday, May 8, 2012 11:58:28 AM UTC-4, Richard
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 prior
, 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.
Regards, David
On Friday, 4 May 2012 20:12:25 UTC+1, Larry Wapnitsky wrote:
It looks as though
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
-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 errors. It does not want to create the
tables in my MySQL database. I've made sure the settings are as you
stated
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), but
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
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
restarted web2py. no dice. died immediately when accessing any page
class 'gluon.contrib.pymysql.err.InternalError' (1005, uCan'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.
Here
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 configured properly for your
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
*class 'gluon.contrib.pymysql.err.ProgrammingError' (1146, uTable
'rbl.plugin_wiki_page' doesn't
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. *class
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
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. Is it
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 =
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
...@gmail.com wrote:
Maybe raw SQL??
Richard
On Wed, May 2, 2012 at 10:54 AM, Larry Wapnitsky la...@kvetsch.comwrote:
Here's the actual query:
http://pastie.textmate.org/3848916
SELECT SUBSTRING_INDEX( ipaddress, '.', 3 ) AS first_three_octet, count( *
) AS ipCount, updated
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
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
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*
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),
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
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
Amazon just cancelled my order. They apparently don't have any in stock on
the day it was supposed to ship. Guess im 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:
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
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
And this link (http://www.web2py.com/books/default/reference/29/alterego)
no longer works, as does the one on redirecting, which is where im
seriously getting stuck.
On Mon, Mar 5, 2012 at 16:18, Larry Wapnitsky la...@kvetsch.com wrote:
So, I seem to be getting stuck a lot as I'm learning
looks helpful. adapting now. thanks.
On Fri, Mar 2, 2012 at 06:32, Wikus van de Merwe dupakrop...@googlemail.com
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 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.
(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:
-
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 :)
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
type 'exceptions.AttributeError' 'NoneType' object has no attribute
'user_groups'
snippets from my db.py: (added to the original skeleton)
## create all
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
(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
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
Which page am I adding the second portion of code to? (web2py newbie here)
67 matches
Mail list logo