[web2py] Re: Keep menu floating on top

2014-03-31 Thread Tom Clerckx
Fantastic! Thanks for the responses! Best regards, Tom. On Thursday, March 27, 2014 4:50:29 PM UTC+1, Tom Clerckx wrote: > > Is there an easy way to keep the menu 'floating' on top. > I.e. when a user scrolls down that the menu stays visible at the top of > the page &

[web2py] Re: 'reference auth_user' in Data base tables?

2014-04-02 Thread Tom Clerckx
auth_user is a table used in web2py with respect to access control. You'll find a good overview about this on: http://web2py.com/books/default/chapter/29/09/access-control?search=auth_user Best regards, Tom. On Tuesday, April 1, 2014 8:01:20 PM UTC+2, Shubham Rathi wrote: > > Hi, I

[web2py] GAE app running locally can't open Google Cloud SQL database: "Failure to connect, tried 5 times"

2015-12-11 Thread Tom Campbell
s the latest. db.py contains this code: db = DAL('google:sql://gigcity-1951:dbtest/tomsdatabase') When run, yields this web2py error: Failure to connect, tried 5 times: > Traceback (most recent call last): File > "/Users/tom/Dropbox/work/m/web2py/gluon/dal/base.py"

[web2py] GAE: "UserWarning: There are too many files in your application..." Which files to hide?

2015-12-11 Thread Tom Campbell
While attempting to another GAE problem , I'm running into this GAE error: 15: UserWarning: There are too many files in your application for changes > in all of them to be monitored. You may have to restart the development

[web2py] $100 reward to get a simple web2py app runnnig on GAE with Google Cloud SQL

2015-12-12 Thread Tom Campbell
I want to get a minimal web2py app running on Google Application Engine, using Google Cloud SQL as the backing store. Have not succeeded. Obviously because I have a much bigger app running locally and want to get that up and running. If anyone can show me how to do this via Skype, a well-writte

[web2py] Re: $100 reward to get a simple web2py app runnnig on GAE with Google Cloud SQL

2015-12-18 Thread Tom Campbell
Thank you! Soon as I get back I can't wait! On Saturday, December 12, 2015 at 7:05:04 PM UTC-8, Tom Campbell wrote: > > I want to get a minimal web2py app running on Google Application Engine, > using Google Cloud SQL as the backing store. Have not succeeded. Obviously > beca

[web2py] Re: $100 reward to get a simple web2py app runnnig on GAE with Google Cloud SQL

2015-12-19 Thread Tom Campbell
IT WORKS! Cannot tell you what a relief that was. I will absolutely write it up in a web2pyslice, a blog post, and a book section! THANK YOU -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/we

web2py@googlegroups.com

2015-12-26 Thread Tom Campbell
Trying to display rows using the datatables.net DataTable() function by converting query results to JSON, but getting error "Uncaught SyntaxError: Unexpected token &". Though the raw data displays correctly in the view below, when I look at the results in the web console debugger I see that the

[web2py] Re: datatables.net fail: "Uncaught SyntaxError: Unexpected token &" ANSWERED

2015-12-26 Thread Tom Campbell
After a day of messing this, *of course I answered it myself moments after posting!*Answer was to define columns used and to use {{=XML}} helper:a $(document).ready(function(){ $("#person-table").DataTable({ "data": {{=XML(results)}}, columns: [

web2py@googlegroups.com

2015-12-26 Thread Tom Campbell
Cleaner versions in tutorial style at pyguy and and web2pyslices . Criticism warmly welcom

[web2py] Failing at Google Cloud SQL again: missing MySQLdb import somewhere?

2016-01-02 Thread Tom Campbell
I think I may have lied. When I asked the question $100 reward to get a simple web2py app runnnig on GAE with Google Cloud SQL , I was either incompetent or dishonest in my answer! Masssimo asked me to document the process. I have been

[web2py] Re: Failing at Google Cloud SQL again: missing MySQLdb import somewhere?

2016-01-02 Thread Tom Campbell
Argh, I should have updated this. Thank you for answering! Adding the import to dev_appserver.py did not work. But I had to learn about pip (ahem) and imported Python-MySQL, which definitely helped (now there's another problem I'm tracking down). I am so used to web2py coming with everything it

[web2py] WSGI & Web2py

2016-01-04 Thread Tom Lancaster
ed a hack in the wsgihandler.py of each script to ensure they are the same. Does anyone have any good ideas as to next steps for troubleshooting? I'm running the latest version of apache on ubuntu 14.04 and the latest web2py. (On both servers). Thanks, Tom -- Resources: - http:/

[web2py] Re: Failing at Google Cloud SQL again: missing MySQLdb import somewhere?

2016-01-05 Thread Tom Campbell
So the problem was that on the latest OS X, libraries are now prohibited from using relative pathnames . I am testing, re-testing, and re-re-testing the document I'm writing up on every machin

[web2py] Email Registration

2016-01-09 Thread Tom Russell
am using web2py version 2.12.3-stable+timestamp.2015.08.19.00.18.03 on pythonanywhere. The server where the email from comes from is godaddy. Any ideas what to check for with this? Thanks, Tom -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com

Re: [web2py] Email Registration

2016-01-09 Thread Tom Russell
gt; Il giorno sabato 9 gennaio 2016 21:41:31 UTC+1, Tom Russell ha scritto: >> >> >> Hi, >> >> I have everything in place according to the docs to do the email >> registration process. However every time I try it in the error log it just >> says email not sen

Re: [web2py] Email Registration

2016-01-12 Thread Tom Russell
service > use the site and the problem > > Il giorno sabato 9 gennaio 2016 22:52:17 UTC+1, Tom Russell ha scritto: >> >> Yea I have a premium account with pythonanywhere. >> >> On Saturday, January 9, 2016, Alessio Varalta wrote: >> >>> Maybe is a pr

[web2py] SQLFORM.factory() - Display name instead of integer for user_id?

2016-01-13 Thread Tom Campbell
Creating a custom form that relates first name and last name fields to the db.auth_user's user_id field. In the form below the user ID shows as an integer in the dropdown but I'd like it to show as the user's name. How do I do that? form = SQLFORM.factory( Field('fi

[web2py] Re: SQLFORM.factory() - Display name instead of integer for user_id?

2016-01-13 Thread Tom Campbell
On Wednesday, January 13, 2016 at 3:38:56 PM UTC-8, Tom Campbell wrote: > > Creating a custom form that relates first name and last name fields to the > db.auth_user's user_id field. In the form below the user ID shows as an > integer in the dropdown but I'd like it to s

[web2py] class 'psycopg2.ProgrammingError'> relation "auth_user" already exists

2016-01-29 Thread Tom Campbell
App is on pythonanywhere, using Postgres. Connect string is: db = DAL('postgres://web2pydbadmin:mypassw...@memberable-96.postgres.pythonanywhere-services.com:10096/mydatabase') Existing topics like https://groups.google.com/forum/#!topic/web2py/p740UJkR3Ao do not seem to have helpful info.

[web2py] Re: Probably very naive question from new user

2016-02-10 Thread Tom Campbell
www.pyguy.com has a few beginner-level tutorials that probably answer those questions -- 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 m

[web2py] Email not working

2016-02-12 Thread Tom Russell
other services and nothing so far seems to work. Has anyone tried an actual mail service that works, preferably free or close to it. I am beginning to think that web2py has an issue doing this task. I really need to get past this hurtle for a product launch soon. Thanks, Tom -- Resources

[web2py] Re: Email not working

2016-02-12 Thread Tom Russell
Yea I am not trying to blame web2py but it just seems I am not having any luck getting an email to send. I am using a smtp interface on the other side. I am just at a loss as to what the issue is and how to solve it. Thanks, Tom On Friday, February 12, 2016 at 2:40:43 PM UTC-5, Niphlod wrote

[web2py] Re: Email not working

2016-02-19 Thread Tom Russell
Yea I have the user/pw correct, the smtp settings seem pretty straight forward as well so not sure what the root cause is. On Friday, February 12, 2016 at 4:10:20 PM UTC-5, Dave S wrote: > > > > On Friday, February 12, 2016 at 12:17:57 PM UTC-8, Tom Russell wrote: >> >>

[web2py] SQLite data file in production-backing up

2018-05-03 Thread Tom Campbell
SQLite is more than enough for my needs, I think. In the best of worlds we will have no more than a few thousand customers after we get up and running. But I'm not sure what to do about the database file, which is of course unencrypted. I will place it in a directory that is not accessible to w

[web2py] Where does configuration.get() look for files? Or does it?

2018-05-03 Thread Tom Campbell
Trying to set up the mailer for Gmail. After a spell a way from web2py I see code like this in db.py mail.settings.login = configuration.get('smtp.login') 1. What is "configuration.get()"? I'm assuming it's a function that reads a file with configuration info? When I searched the web2py source <

[web2py] SOLVED: Where does configuration.get() look for files? Or does it?

2018-05-03 Thread Tom Campbell
Ah. It's AppConfig (see http://web2py.com/books/default/chapter/29/13/deployment-recipes?search=AppConfig#AppConfig-module). The values are stored in .ini format in the /private directory, which is not supposed to be part of the Git repo. On Thursday, May 3, 2018 at 1:40:44 AM UTC-7

[web2py] Unable to override Bootstrap in layout.html

2018-05-03 Thread Tom Campbell
Goal is to change the color, size, and eventually default font of Bootstrap 4 navbar. The following seemed to have no effect in web2py-bootstrap4.css (not the final colors! Just wanted contrasting ugly ones to make sure the experiment worked!) file: web2py-bootstrap4.cs .navbar-dark { c

[web2py] Re: "Installed applications" list now missing my applications

2018-05-03 Thread Tom Campbell
Thanks for the response! Seemed that way to me too, but that wasn't the issue (because the list of applications was unique). I solved it the old-fashioned way--git pull on web2py itself -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (

[web2py] Re: Unable to override Bootstrap in layout.html

2018-05-03 Thread Tom Campbell
On Thursday, May 3, 2018 at 9:30:56 PM UTC-7, pbreit wrote: > > I think the property you want is background-color > Not sure what you mean... the bootstrap source at https://github.com/twbs/bootstrap/blob/v4-dev/dist/css/bootstrap.css defines attributes like this: .navbar-dark .navbar-brand {

[web2py] Can we commit the codes from web2py to Git

2018-09-03 Thread Tom Campbell
Yes it works fine with Git. In fact... https://github.com/web2py -- 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

[web2py] Is there such a thing as a reliable, managed web2py/PostgreSQL host with good support?

2019-02-16 Thread Tom Campbell
Need managed, reliable hosting for a mission critical app that hits the eBay API at specified times. It's a generic CRUD app except that scheduled tasks (written in Go) must be run with 1 second accuracy, no more than 200/second at peak times. I am a pretty terrible sysadmin so my strong prefer

[web2py] .gitignore and just backing up one application

2019-02-18 Thread Tom Campbell
Want to get version control right for this one. It will be just one item in the /applications directory, the /applications/init project. Some questions. - Is there any reason to backup more than just /applications/init? I assume it is best simply to note the version of /web2py I'm using an

[web2py] Git: save init application as separate repo from web2py, and exclude the init directory?

2019-03-17 Thread Tom Campbell
My (soon to be production) code is in the application named init. Obviously init is surrounded by the web2py installation itself. We will want to preserve the working version of web2py in a git repo since it's likely we will update web2py separately from the init app. I assume the best practice is

[web2py] Re: Thank you Web2py community - I have completed a live application, ViewBase.com, using Web2py

2019-04-05 Thread Tom Campbell
Amazing piece of work. Congratulations! -- 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

[web2py] Scheduler: next_run_time is initially set to time-date of scheduling

2014-05-12 Thread Tom Clerckx
time, the next_run_time field is properly updated. My web2py version. Version 2.8.2-stable+timestamp.2013.11.28.13.54.07 (Running on Rocket 1.2.6, Python 2.7.5) Best regards, Tom. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] AppAdmin Link

2014-05-13 Thread Tom Russell
tead of just appadmin. How do I set this properly? Also, is there a decorator to hide this button if a user is not in a certain group? Thanks, Tom -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google

[web2py] SQLite Data

2014-05-13 Thread Tom Russell
I used csvstudio to process data to the existing sqlite db in web2py. It all went very well and now the data is there. The dates however for a date column only show up with the word None. Is there something else I am missing for the date not to be showing correctly or at all? Thanks, Tom

[web2py] Form Action

2014-05-16 Thread Tom Russell
_class='date'),INPUT(_type='submit'), _action=URL('grabvoltrindata')) return dict(form=form) Then I have a function that runs some code called def grabvoltrindata() I need to pass in the startdate and enddate, how would I do that? Thanks, Tom -- Resources: -

[web2py] Accessing records

2014-05-19 Thread Tom Russell
oes not match any of the data in the tables which is why I am unsure of the proper way to access the data for a record. Thanks, Tom -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/iss

Re: [web2py] Accessing records

2014-05-20 Thread Tom Russell
e one it is grabbing to do a calculation on it. It is not too clear in the book how I should be getting a record by the id is what I think my problem is. Thanks, Tom On Tuesday, May 20, 2014 4:53:13 AM UTC-4, Johann Spies wrote: > > On 19 May 2014 22:06, Tom Russell >wrote: > > I

Re: [web2py] Accessing records

2014-05-20 Thread Tom Russell
I am inserting into the db. These 5 fields exist already so nothing odd there. My main issue is just getting the last 5 records from the db. Is there a better way to get that data with the DAL? It kind of appears to me that I could possibly use limitby to get these as well? Thanks, Tom On

Re: [web2py] Accessing records

2014-05-20 Thread Tom Russell
Thanks. What would last_five_records be, a list or something I could iterate over? Tom On Tuesday, May 20, 2014 10:16:54 AM UTC-4, Johann Spies wrote: > > > > > On 20 May 2014 16:11, Tom Russell >wrote: > >> I have a table which I insert data from the internet,

Re: [web2py] Accessing records

2014-05-20 Thread Tom Russell
Woks perfect, thank you. On Tuesday, May 20, 2014 11:17:12 AM UTC-4, Anthony wrote: > > It is a Rows objects, so yes, you can iterate over it. > > Anthony > > On Tuesday, May 20, 2014 11:06:34 AM UTC-4, Tom Russell wrote: >> >> Thanks. >> >> What would l

[web2py] Redirect to grid page

2014-05-27 Thread Tom Russell
and press submit the next page that gets redirected to is the last record in the grid. What I want to do is redirect to my grid but go to the page with the l;ast entry and not the first page. How would I do that? I looked in the book but could not see how I would do this. Thanks, Tom -- Resourc

[web2py] Re: Redirect to grid page

2014-05-27 Thread Tom Russell
, Jim S wrote: > > When you say that you want to go to the 'grid' page, do you mean a page > with a SQLFORM.grid on it and you want to go into 'edit' mode on a specific > record on the grid? > > -Jim > > > On Tuesday, May 27, 2014 10:42:31 AM UTC-5, Tom

[web2py] Re: Redirect to grid page

2014-05-27 Thread Tom Russell
w if this doesn't work and I'll code up a test of my own to see > what happens. > > Anyone have a more efficient way of doing this? > > -Jim > > > > On Tuesday, May 27, 2014 11:32:28 AM UTC-5, Tom Russell wrote: >> >> Jim, >> >> Yes I have a gri

[web2py] DAL/Decorator for specific data

2014-05-28 Thread Tom Russell
something that can be done? Thanks, Tom -- 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

[web2py] Re: DAL/Decorator for specific data

2014-05-29 Thread Tom Russell
gt; there would be any benefit over the simple approach above. > > Anthony > > On Wednesday, May 28, 2014 11:00:13 AM UTC-4, Tom Russell wrote: >> >> I have read through the docs but have not come across what I am trying to >> do, if its possible. >> >> I have

[web2py] ValueError: invalid literal for int() with base 10:

2014-05-29 Thread Tom Russell
I am getting the following error when inserting a new record for a table I have. I cannot seem to pinpoint what the cause is at this time. The error is: Traceback (most recent call last): File "/home/tsrdatatech/web2py/applications/ttheorydataextractor/controllers/appadmin.py", line 270, in

[web2py] Re: ValueError: invalid literal for int() with base 10:

2014-05-29 Thread Tom Russell
awesome, worked. On Thursday, May 29, 2014 3:41:12 PM UTC-4, Niphlod wrote: > > drop the table and recreate it. It's a known issue with sqlite. > > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#SQLite > > On Thursday, May 29, 2014 9:34:28 PM U

[web2py] Scheduler

2014-06-04 Thread Tom Russell
I have implemented the scheduler per the info and examples in Chapter 4 of the book. I am trying to start the workers but my problem is I am not sure how to since my app is hosted on pythonanywhere and according to the book I need to do it from the interface from where you set the ip and port.

[web2py] Re: Scheduler

2014-06-05 Thread Tom Russell
e and their associated actions. > > On Wednesday, June 4, 2014 11:00:06 AM UTC-4, Tom Russell wrote: >> >> I have implemented the scheduler per the info and examples in Chapter 4 >> of the book. I am trying to start the workers but my problem is I am not >> sure how to si

[web2py] layout

2014-06-05 Thread Tom Russell
I want to use a few parts from a layout for web2py here http://www.web2py.com/layouts/static/plugin_layouts/layouts/CorporateOffice/index.html Mainly I just want the for my layout.html. I tried adding this but it does not seem to work. Is there an easy way to do this? Thanks. -- Resources:

[web2py] Undesired redirect to other page after submitting a form

2014-06-19 Thread Tom Clerckx
Hi, I have some undesired behavior in my app that I was able to resolve, but I would like to understand what goes wrong. I could easily reproduce the problem with a simple test-application, containing two pages and two forms (I'm skipping the boilerplate code that is created when making a new a

[web2py] Re: Undesired redirect to other page after submitting a form

2014-06-23 Thread Tom Clerckx
t the link associated to the redirect after submitting a form is influenced by using the browser's back-button in the case when no formname paramater is used in the grid. Best regards, Tom. On Thursday, June 19, 2014 9:46:06 AM UTC+2, Tom Clerckx wrote: > > Hi, > > I have some un

[web2py] Re: Undesired redirect to other page after submitting a form

2014-06-26 Thread Tom Clerckx
Sorry being persistent on this, but has somebody any idea why the observed behavior is in place? Best regards, Tom. On Thursday, June 19, 2014 9:46:06 AM UTC+2, Tom Clerckx wrote: > > Hi, > > I have some undesired behavior in my app that I was able to resolve, but I > would lik

[web2py] TV Centric websites

2014-07-11 Thread Tom Clerckx
ap to the remote control arrow-keys and OK key) If this is/will be supported I would be very interested. Other suggestions are very welcome as well. Best regards, Tom. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https:/

[web2py] PythonAnywhere Web2py Script

2014-07-16 Thread Tom Russell
I am trying to run a script that I have in my app. While the log files seem to show my script ran, it does not update the db I have for my app. On the schedule tab in pythonanywhere I have this set up so not sure if it is correct: python2.7 /home/tsrdatatech/web2py/web2py.py -S ttheorydataextra

[web2py] DAL Select

2014-08-18 Thread Tom Russell
the data for the field in my code above. Am I doing this right? Thanks, Tom -- 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

[web2py] Re: DAL Select

2014-08-18 Thread Tom Russell
> > On Monday, August 18, 2014 11:09:37 AM UTC-4, Tom Russell wrote: >> >> I have some simple code that is suppose to grab data from a row in my db >> table. >> >> I do it like: >> >> row = db(db.voltrin.startdate == mydate).select() >> vwtrin = r

[web2py] Why can I peek but not edit some existing files?

2015-01-15 Thread Tom Campbell
I created a file called default/view.html using the web interface. It looks as expected when I peek at it: {{extend 'layout.html'}} This is the default/view.html template {{=BEAUTIFY(response._vars)}} However, when I choose to edit that file using the web interface I get a blank, uneditable pa

[web2py] Mixing pydal with web2py - how to manage the non-web2py setup

2015-01-16 Thread Tom Stratton
rnal .tables files in web2py that tracks which tables are in the db instance but I can't dig up any documentation that suggests how to retreive a table from a db connection without defining it first. Any suggestions or links to documentation that I have missed? Thanks Tom -- Resources

[web2py] Re: error connecting two applications on different computers

2015-01-16 Thread Tom Stratton
can you post the full stack trace? -- 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 Grou

[web2py] Why is the world's smallest web2py app failing?

2015-01-17 Thread Tom Campbell
Having problems with grid and smartgrid not showing Add and buttons. So I created the smallest possible app and they still don't show up. Here is the code. # append to db.py db.define_table('supplier', Field('name')) # file index.html {{extend 'layout.html'}} {{if 'message' in globals():}}

[web2py] Re: Why is the world's smallest web2py app failing?

2015-01-17 Thread Tom Campbell
Took a while to respond because I'm embarrassed. I somehow thought that omitting the @auth.requires_login() decorator would eliminate that default behavior and did not bother to test my assumption. Thank you. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://gi

[web2py] Re: Mixing pydal with web2py - how to manage the non-web2py setup

2015-01-19 Thread Tom Stratton
yself to suggest the changes - could be a great 1st commit ;-) Tom On Sunday, January 18, 2015 at 5:27:33 AM UTC-8, Niphlod wrote: > > if it exist already you don't need .table at all. just set migrate=False. > > .table files are web2py way of tracking what is supposed to be alre

[web2py] Re: Mixing pydal with web2py - how to manage the non-web2py setup

2015-01-21 Thread Tom Stratton
Thank you again - I did not put that together after the first email. I realize now that I should have realized what you were saying would solve my problem. Really appreciate your help. Tom On Monday, January 19, 2015 at 11:32:15 PM UTC-8, Niphlod wrote: > > > > On Monday, January

[web2py] How can I change a form so that the Enter key is disabled for "Submit"

2015-01-30 Thread Tom Stratton
I'm finding that a lot of users are hitting Enter instead of Tab and I'm getting half-filled-in forms. I'd like to set the button to NOT default but not sure where to go about making that change. Anyone have a solution? Thanks Tom -- Resources: - http://web2py.com - http://

[web2py] Re: How can I change a form so that the Enter key is disabled for "Submit"

2015-02-03 Thread Tom Stratton
; in the name. Thanks for the suggestions! Tom On Friday, January 30, 2015 at 1:34:52 PM UTC-8, Niphlod wrote: > > there are a lot if you want to do down that path. > > > http://stackoverflow.com/questions/895171/prevent-users-from-submitting-form-by-hitting-enter > > IMHO disabl

[web2py] Adding entry to the printed book index

2015-02-11 Thread Tom Campbell
I'd like to add terms to the book's index. Looked at the book source on github but couldn't figure out where that would happen so I could issue a pull request. Can someone give me a brief description of where I'd find it? Thanks! -

[web2py] Is SQLFORM hardcoded to use layout.html?

2015-02-11 Thread Tom Campbell
I'm sure it's not, that title was just click bait :-O I have created a file called ltelayout.html, based on layout.html. My new() method in default.py is: def new(): return dict(form=SQLFORM(db.todo, submit_button='Save')) My view new.html is: {{extend 'ltelayout.html'}} NEW!! {{=form}}

[web2py] Re: Is SQLFORM hardcoded to use layout.html?

2015-02-11 Thread Tom Campbell
Um... I put the view in /views/new.html, not /views/default/new.html. TIME TO GET SOME SLEEP -- 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

Re: [web2py] Re: Adding entry to the printed book index

2015-02-11 Thread Tom Campbell
inning?) On Wed, Feb 11, 2015 at 11:30 PM, Niphlod wrote: > please give an example of what you're trying to add ^_^ > > > On Wednesday, February 11, 2015 at 11:33:04 PM UTC+1, Tom Campbell wrote: >> >> I'd like to add terms to the book's index. Looked at the

[web2py] Re: Adding entry to the printed book index

2015-02-12 Thread Tom Campbell
To the printed book index. -- 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 "web

[web2py] Re: Force authentication to whole app

2015-02-12 Thread Tom Campbell
> > To take advantage of the decorators at a file level, you can also do this > at the top level of a file: > > auth.requires_login()(lambda: None)() > > The decorators ultimately call auth.requires, which itself returns a > decorator. The above passes a dummy function to that decorator and then

[web2py] Creating my own layout.html, but errors not displaying

2015-02-23 Thread Tom Campbell
Creating my own layout.html based on the AdminLTE theme . It works, but errors are not being displayed. For example, I have a notnull*=*True validation rule in the 'description' field of the model model but if a description isn't displayed, not error

[web2py] Re: Creating my own layout.html, but errors not displaying

2015-02-23 Thread Tom Campbell
Ugh, I thought I copyedited. For clarification: On Monday, February 23, 2015 at 3:58:52 PM UTC-8, the idiot Tom Campbell wrote: > > Creating my own layout.html based on the AdminLTE theme > <https://github.com/almasaeed2010/AdminLTE>. It works, but errors are not > being disp

[web2py] Re: [solved] Weird 'Row' object has no attribute 'id' and Ñ error

2015-03-03 Thread Tom Stratton
ad of a.b[c] is causing the issue. For safety sake - don't use anything in a field name that can't be part of an object/variable name! Thanks again. Tom On Saturday, January 10, 2015 at 5:20:39 AM UTC-8, Carlos Kitu wrote: > > Hi, just for other developers sake to save some tim

Re: [web2py] Re: [solved] Weird 'Row' object has no attribute 'id' and Ñ error

2015-03-04 Thread Tom Stratton
Oddly, neither of those terms come up when you search the book online ;-) I'm glad to have this forum to find the hidden gotchas! Tom On Tuesday, March 3, 2015 at 9:13:45 AM UTC-8, mcm wrote: > > You can use rname or entity quoting to support all of the names your > chosen db e

[web2py] import_from_csv_file and id_map={}

2015-03-11 Thread Tom Clerckx
included? Best regards, Tom. -- 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 &qu

[web2py] Re: import_from_csv_file and id_map={}

2015-03-17 Thread Tom Clerckx
Thanks. I will try to make some time and contribute in that way. Note: You may want to update the link to your profile on http://web2py.com/init/default/who --> it results in a page not found. Best regards, Tom. On Wednesday, March 11, 2015 at 7:07:04 PM UTC+1, Tom Clerckx wrote: &g

[web2py] "internal error: [Errno 1] Operation not permitted" when attempting Pack All

2015-03-17 Thread Tom Campbell
Attempting to do a Manage > Pack All on a project but I get this message: messageinternal error: [Errno 1] Operation not permitted: I am attempting to save to the Dropbox directory in which web2py lives. What should to do to get it to pack correctly? -- Resources: - http://web2py.com - ht

[web2py] Re: Team of admin/devellopers with different permissions

2015-03-28 Thread Tom Clerckx
m to check in updates? Best regards, Tom. On Thursday, March 26, 2015 at 12:04:24 AM UTC+1, Ramos wrote: > > First web2py admin/developer are the same. > Should it be? > > Also > my server can get crowded in the future with one or more developers. As i > have some apps i don

[web2py] Difference between response.files.insert() and URL(), and congratulations on v2.10

2015-04-01 Thread Tom Campbell
(First--congrats on v2.10 and thanks to all you contributors for an incredible framework.) What's the difference between these two lines of code? response.files.insert(1,URL('static','adminlte/bootstrap/css/bootstrap.min.css')) -- Resources: - http://web2py.com - http://web2py.com/book (Docu

[web2py] Possible bug report - unicode strings in list:string field generating encode errors

2015-04-02 Thread Tom Stratton
8 vs. 16 issues as well. I am guessing that there is some ability to introspect the database to see what encoding has been declared but I have not been into the web2py source before and I know this is going to take me a long time to uncover. Anyone out there on the core team care to suggest a starti

[web2py] Re: route.py I added the route.py and edit it , but it didn't work

2015-04-02 Thread Tom Stratton
Did you remember to restart web2py? See: http://www.ridgesolutions.ie/index.php/2013/02/20/web2py-make-your-app-the-default-web-application/ And there is also a "reload routes" button in the admin interface. Hope that helps. On Thursday, April 2, 2015 at 1:25:43 PM UTC-7, 朱伟 wrote: > > I wrote

[web2py] Re: Possible bug report - unicode strings in list:string field generating encode errors

2015-04-02 Thread Tom Stratton
Update - I found the bug reported here: https://github.com/web2py/web2py/issues/697 I have also suggested a fix but I am not deep enough into the code to know if it might break other behaviors. See the bug tracker for my suggested fix and let me know here if you have any thoughts about what els

[web2py] Stupid Question - how do I run the pydal test suite?

2015-04-02 Thread Tom Stratton
I have google for the last hour to try and figure out how to run the unittests in the tests folder for pydal and have come up short. Is there something simple I am missing? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code)

[web2py] Best way to display table columns in correct order using a Handsontable

2015-04-08 Thread Tom Campbell
I have a query result named todos I am loading into a Handsontable in the view. The code below populates the Handsontable, but columns do not appear in the order they are defined in db.define_table(). In this case, while the database columns are 'id','title'.'description','priority', and 'compl

[web2py] Re: Possible bug report - unicode strings in list:string field generating encode errors

2015-04-09 Thread Tom Stratton
On Thursday, April 2, 2015 at 10:57:41 PM UTC-7, Tom Stratton wrote: > > Update - I found the bug reported here: > https://github.com/web2py/web2py/issues/697 > > I have also suggested a fix but I am not deep enough into the code to know > if it might break other behaviors. &g

[web2py] routes.py breaking login...

2015-04-17 Thread Tom Stratton
referred" controller instead of in the default one? (I had deleted the default.py controller after my limited testing worked) Thanks Tom -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com

[web2py] LOAD() problem: Yes, I am bungling the world's smallest web2py app.

2015-04-23 Thread Tom Campbell
When I run the following no error gets logged but index.html gets the message "invalid function (default/showtasks)" rendered in the view. Controller in default.py: def index(): return dict(grid=SQLFORM.grid(db.task,user_signature=False)) index.html: {{extend 'layout.html'}} {{=LOAD('default

[web2py] Re: LOAD() problem: Yes, I am bungling the world's smallest web2py app.

2015-04-23 Thread Tom Campbell
Anthony, thank you thank you thank you! I made these changes as follows and it works like a charm. In default.py def index(): return locals() def showtasks(): return dict(grid=SQLFORM.grid(db.task,user_signature=False)) I never considered for a second I would require a controller. I s

[web2py] Why doesn't web2py create a PostgreSQL database automatically (curiosity, not criticism)

2017-02-16 Thread Tom Campbell
As a database admin newb last year I had trouble deploying a PostgreSQL site because I forgot that "real" DBMSes require you create a database first, unlike SQLite. So I was trying to create tables in a nonexistent database. Is there some reason web2py doesn't just create a PostgreSQL database

[web2py] Re: Why doesn't web2py create a PostgreSQL database automatically (curiosity, not criticism)

2017-02-16 Thread Tom Campbell
Thanks, Stifan, you rock as always. I thought I had tried & failed with this but I trust you on these matters more than myself. Can't wait to get to my db machine to re-test -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code

[web2py] Re: Things to do to secure server running purely web2py?

2017-02-16 Thread Tom Campbell
As usual the web2py book has tons of great info in the Deployment chapter. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.co

[web2py] Suggestion to add in documantation about reference fields

2017-05-24 Thread Tom Clerckx
The web2py documentation indicates that a reference field has the following default validator: IS_IN_DB(db, table.field, format) I suggest the default validator to be described as: IS_IN_DB(db, table._id, table._format) If you use any other field besides *table._id* in the validator, this cause

[web2py] Compile controller and module files only

2017-10-06 Thread Tom Clerckx
Is it possible to compile an application, but keep the views and the CSS 'uncompiled'? The idea is that other people can change the look and feel without having access to the code of the controllers and the models. Best regards, Tom. -- Resources: - http://web2py.com - http://web2p

[web2py] Re: Compile controller and module files only

2017-10-09 Thread Tom Clerckx
October 6, 2017 at 4:10:57 AM UTC-4, Tom Clerckx wrote: >> >> Is it possible to compile an application, but keep the views and the CSS >> 'uncompiled'? >> The idea is that other people can change the look and feel without having >> access to the code of the

<    1   2   3   4   >