Re: [web2py] Re: Selecting booleans from sqlite3 database

2017-01-09 Thread Austin Taylor
I'll give that a try. I did try porting the database over from django so I'm guessing that's probably the issue. On Mon, Jan 9, 2017 at 3:49 PM, Niphlod wrote: > did you try dropping the databae and letting web2py recreate it ? sqlite > doesn't go well with fields altering their type "afterwards

Re: [web2py] Re: Updated appliances or web2py blog?

2015-01-12 Thread Austin Taylor
Hi Paolo, Thank you for the recommendation. I followed the instructions on the Movuca web page, but this install fails right out of the box File "applications\at_blog\modules\movuca.py", line 51, in define_classes obj = cls(self) File "applications\at_blog\modules\basemodel.py", line 51,

Re: [web2py] Re: Creating a mobile friendly site -- How?

2014-07-27 Thread Austin Taylor
Thanks, Massimo. I'll give that a try. Would it be possible to just have a mobile site and redirect the user based on their agent string? On Sun, Jul 27, 2014 at 12:00 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > It looks horrible about of the CSS that you use. Your divs have a f

Re: [web2py] Re: How to -- Popup window: Record already exists are you sure you want to upload file?

2014-07-15 Thread Austin Taylor
That might work Manuele. How would the code look? On Jul 15, 2014 1:39 AM, "Manuele Pesenti" wrote: > Il 14/07/14 21:21, Niphlod ha scritto: > > until the user clicks on "submit", there's no way for web2py (or you) > > to know the name of the file being uploaded beforehand, using a normal > > inp

Re: [web2py] create a link SQLFORM to another table with id.belongs

2014-06-06 Thread Austin Taylor
yes On Fri, Jun 6, 2014 at 1:09 PM, Fabiano Almeida wrote: > Are you logged in your app? > > > 2014-06-06 14:07 GMT-03:00 LoveWeb2py : > >> That was it! THANK YOU! Why does it work without a signature though? >> >> >> On Friday, June 6, 2014 1:03:35 PM UTC-4, Fabiano Almeida wrote: >>> >>> Try:

Re: [web2py] Re: Create a copy record button in SQLFORM?

2014-05-02 Thread Austin Taylor
I actually see it trying to return the values in the variables in the URL it says field1='data', field2='data2', but its hanging for some reason... On Fri, May 2, 2014 at 4:15 PM, Austin Taylor wrote: > return **dict(form=form)? I am sorry I know my questions are noob,

Re: [web2py] Re: Create a copy record button in SQLFORM?

2014-05-02 Thread Austin Taylor
return **dict(form=form)? I am sorry I know my questions are noob, but I can't tell you how much I appreciate your help. I've spent two days on this problem. On Fri, May 2, 2014 at 4:11 PM, Richard Vézina wrote: > **dict(...) > > > On Fri, May 2, 2014 at 4:10 PM, Austi

Re: [web2py] Re: Create a copy record button in SQLFORM?

2014-05-02 Thread Austin Taylor
I will definitely upgrade in the upcoming months... but for now I"m stuck with 2.6. Your dict comprehension worked, but now I'm getting an error when I click bthe button saying there are too many values to unpack. I'm guessing this is because I'm using 2.6 again and its something to do with my func

Re: [web2py] Re: Change button to "loading" after clicked

2014-04-24 Thread Austin Taylor
Thanks for the update Niphlod! I'm using 2.3.2. Do you know if its available in that version? I tried using data={'loading-text':'loading} in the controller, but its not taking it for some reason. On Thu, Apr 24, 2014 at 3:08 PM, Niphlod wrote: > python won't let you do _data-loading-text in t

Re: [web2py] Current date/time for datetime field (time is wrong)

2014-04-15 Thread Austin Taylor
Perfect. Thank you! On Tue, Apr 15, 2014 at 1:04 PM, Marco Mansilla wrote: > El Tue, 15 Apr 2014 10:13:26 -0700 (PDT) > LoveWeb2py escribió: > > > Hello, > > > > I love the calendar that pops up in the 'datetime' field with a > > time/date selector. However, when my customers use it their time

Re: [web2py] Re: Enter from 0 to 255 characters on grid=SQLFORM How to fix?

2014-04-11 Thread Austin Taylor
It's for mysql. Its stored as VARCHAR in the data base and up to 500 chars but fixing it to text in my db.py model fixed it. I'm guessing there is a built in validator for strings On Apr 11, 2014 4:00 PM, "Derek" wrote: > is this mssql or mysql or postgres? i think mysql has a limit of 255 for >

[web2py] Re: Enter from 0 to 255 characters on grid=SQLFORM How to fix?

2014-04-10 Thread Austin Taylor
Fixed it by changing string to text. Is there anything that could go wrong by me doing that? On Thursday, April 10, 2014 12:52:13 PM UTC-4, Austin Taylor wrote: > > Are there any other suggestions? I've tried everything and I really need > help with this. > > When the tab

[web2py] Re: Enter from 0 to 255 characters on grid=SQLFORM How to fix?

2014-04-10 Thread Austin Taylor
Are there any other suggestions? I've tried everything and I really need help with this. When the table is set to Migrate=True the sql log shows VARCHAR(255) even though my actual SQLDatabase shows 499 length and my length on the db model is set to length=500 On Thursday, April 10, 2014 11:05:

[web2py] Re: Custom grid based on user profile -- any cool smartgrid examples welcomed!!

2014-04-10 Thread Austin Taylor
Hi Stifan, I guess I didn't properly phrase my question but I really appreciate your response. Currently users can access one of our databases using the grid layout. I want to give them the option of only seeing select fields through some type of checkbox or multiple select. Like this: http:

[web2py] Re: Enter from 0 to 255 characters on grid=SQLFORM How to fix?

2014-04-10 Thread Austin Taylor
I set migrate to True and checked the database logs. You're right... its showing as a VARCHAR 255. Even though I have length=499 defined in the db.define_table. Is web2py limited to 255 for VARCHARS? On Thursday, April 10, 2014 10:50:56 AM UTC-4, Austin Taylor wrote: > > I only defin

[web2py] Re: Enter from 0 to 255 characters on grid=SQLFORM How to fix?

2014-04-10 Thread Austin Taylor
I only define the table in my db.py though. I don't see it referenced anywhere else. On Thursday, April 10, 2014 10:46:23 AM UTC-4, 黄祥 wrote: > > perhaps try to set migrat = True, to take effect for your defined table. > > best regards, > stifan > -- Resources: - http://web2py.com - http://web2

[web2py] Custom grid based on user profile -- any cool smartgrid examples welcomed!!

2014-04-10 Thread Austin Taylor
Hello, I'm trying to create a custom grid based on the user who is logged in. In other words something that would allow them to select which columns they'd like to see in the database, have it save to their profile, and then view the grid. Are there any examples on how I could achieve this? I'

[web2py] Re: Enter from 0 to 255 characters on grid=SQLFORM How to fix?

2014-04-10 Thread Austin Taylor
what's the table definition ? what backend are you using ? > > On Wednesday, April 9, 2014 9:06:12 AM UTC+2, Austin Taylor wrote: >> >> Wow thanks for the quick reply! I did try the length=499, but I still >> get the validator error. Do I need to restart web2py? >&

[web2py] Re: Enter from 0 to 255 characters on grid=SQLFORM How to fix?

2014-04-09 Thread Austin Taylor
;string', length=255) > > it gets a default "requires" that resembles IS_LENGTH(maxsize=255) > > if you need more of that, use length=morethan255 > > On Wednesday, April 9, 2014 8:54:40 AM UTC+2, Austin Taylor wrote: >> >> I'm creating a grid using grid=SQ

[web2py] Enter from 0 to 255 characters on grid=SQLFORM How to fix?

2014-04-08 Thread Austin Taylor
I'm creating a grid using grid=SQLFORM.smartgrid(db.mydatabase, user_signature=True) when I try to update one of the fields using the edit button I get enter from 0 to 255 characters. The field already has over 255 characters in it because its in the database, but I cannot add extra characters

[web2py] Secure RSS Feeds

2014-04-01 Thread Austin Taylor
Hi guys, I'm trying to get secure RSS feeds, but when I try to make the request using feed parser I can't get the request. How could I use my certificates with feedparser? I'm currently running web2py hosted by apache here is my code controller: import feedparser def index(): d = feedpar

Re: [web2py] Using Post mail in CentOS for Web2py

2014-04-01 Thread Austin Taylor
Solved it! mail = auth.settings.mailer mail.settings.server = '127.0.0.1:25' mail.settings.sender = 'testu...@domain.com' mail.settings.tls = False mail.settings.login = None On Tue, Apr 1, 2014 at 11:04 AM, Austin Taylor wrote: > Hello, > > I'm trying to

[web2py] Using Post mail in CentOS for Web2py

2014-04-01 Thread Austin Taylor
Hello, I'm trying to setup web2py to use mail for linux. I already have linux configured, so I don't need to use the configuration settings in db.py. For example, I could type 'mail -s "test email" u...@domain.com' and send an e-mail. How could I incorporate web2py's register/lost password fea

Re: [web2py] Make grid view larger & add scroll bar to top

2014-03-10 Thread Austin Taylor
gt; which you need to be wider. > > > It may be considered an unusal request here because most people are > conscious of keeping sites responsive to different screen widths. Perhaps > you can redesign your form so that people click buttons or links to view > additional information a

Re: [web2py] Make grid view larger & add scroll bar to top

2014-03-08 Thread Austin Taylor
yeah I mean the entire grid wider. I know its at 100%, but I'm not sure how to make the overall layout of my grid bigger. I guess I would have to increase the default css layout? On Sat, Mar 8, 2014 at 7:42 PM, Tim Richardson wrote: > When you say larger, do you mean wider? > It defaults to 100%

[web2py] Re: Complex css layout -- is web2py the right choice?

2014-03-08 Thread Austin Taylor
settings' variable is in an external javascript file and > assuming that the javascript file is in the static/js folder > > "../static/images/slide01.jpg": 'bottom center' > > should work but please test it. > > > Il giorno sabato 8 marzo 2014 21:46:0

[web2py] Re: Complex css layout -- is web2py the right choice?

2014-03-08 Thread Austin Taylor
s/ > for firefox https://developer.mozilla.org/en-US/docs/Tools > Anyway the simplest and trivial check is to verify if all the files are in > the static/css folder. > > Il giorno sabato 8 marzo 2014 20:31:03 UTC+1, Austin Taylor ha scritto: >> >> Thank you so muc

Re: [web2py] Re: Complex css layout -- is web2py the right choice?

2014-03-08 Thread Austin Taylor
x27;images/slide02.jpg': 'top center', 'images/slide03.jpg': 'bottom center' }, // Transition speed (in ms) speed: 3000, // Transition delay (in ms) delay: 4500 }; Is there a way for me to point to my pictures while in javascript? Can I do {{URL('static','image

[web2py] Re: Complex css layout -- is web2py the right choice?

2014-03-08 Thread Austin Taylor
dd the following: > > def intro(): > return locals() > > 6) in the browser see http://ipserver/appname/default/intro page (of > course you have to replace ipserver and appname with real values). > > As said this is only a basic guide. You should make other adjustments in

[web2py] Complex css layout -- is web2py the right choice?

2014-03-07 Thread Austin Taylor
Hello, I purchased this CSS template and I want to integrate web2py with it (because I love web2py). http://www.4templates.com/website-templates/726353988-WT00926/#green It has multiple html files it references, js files, and css sheets. Index.html located here: http://pastebin.com/zbnWjs1v Ho

Re: [web2py] Re: How do I track who clicks a submit button?

2014-03-07 Thread Austin Taylor
any case, the current logged in user's id is in auth.user_id (which is > None if the user isn't logged in), so you could store that wherever you like > upon form submission. > > Anthony > > > On Friday, March 7, 2014 5:01:03 PM UTC-5, Austin Taylor wrote: >> >>

[web2py] How do I track who clicks a submit button?

2014-03-07 Thread Austin Taylor
I'm trying to figure out a way to track users who click the submit button. Maybe using their db.auth_user.username and appending it to a list whenever they click submit? I literally just have no idea where to start and any advice would be appreciated. Best, Austin -- Resources: - http://web2

[web2py] Make grid view larger & add scroll bar to top

2014-03-07 Thread Austin Taylor
Hello, I'm using grid=SQLFORM.grid(db.table) I want to know how to make the form it returns larger? I have looked all over for the CSS and I can't find it. It just says width 100% for .web2py_grid Is there a way to make the overall layout larger since I have a bigger table, and is it possible

[web2py] Re: wildcard for grid=SQLFORM(db.tablename)??

2014-03-05 Thread Austin Taylor
Anthony > > On Wednesday, March 5, 2014 12:21:16 PM UTC-5, Austin Taylor wrote: >> >> I've looked through the book and forum and can't seem to find any >> reference to a wildcard search when using the SQLFORM layout that web2py >> provides. Does anyone know of a

[web2py] wildcard for grid=SQLFORM(db.tablename)??

2014-03-05 Thread Austin Taylor
I've looked through the book and forum and can't seem to find any reference to a wildcard search when using the SQLFORM layout that web2py provides. Does anyone know of a wildcard search you can use like %? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://gith

[web2py] Re: input validation and redirection -- how?

2014-02-27 Thread Austin Taylor
to it. On Thursday, February 27, 2014 4:45:05 PM UTC-5, Austin Taylor wrote: > > Anthony, > > I have another function in the code that redirects the page, but that > should only work if form.process().accepted works. > > After if form.process().accepted: > I have it run thro

[web2py] Re: input validation and redirection -- how?

2014-02-27 Thread Austin Taylor
e the behavior you observe. Can > you show the view code? Is there any other relevant code that might be > doing a redirect somewhere? > > On Thursday, February 27, 2014 12:24:14 PM UTC-5, Austin Taylor wrote: >> >> Also want to add that the function takes me to a page that

[web2py] Re: input validation and redirection -- how?

2014-02-27 Thread Austin Taylor
014 2:08:11 PM UTC-5, Austin Taylor wrote: > > Hello, > > I setup a form similar to the display form on the tutorial: > > def display_form(): > form = FORM('Your name:', > INPUT(_name='userinput', > requires=IS_IPV4()),INP

[web2py] input validation and redirection -- how?

2014-02-26 Thread Austin Taylor
Hello, I setup a form similar to the display form on the tutorial: def display_form(): form = FORM('Your name:', INPUT(_name='userinput', requires=IS_IPV4()),INPUT(_type='submit')) if form.process().accepted: session.flash = 'form accepted' redirect(URL('nex

[web2py] Re: Change color of grid=SQLFORM.grid(db.abc, user_Signature=False)

2014-02-24 Thread Austin Taylor
even.with_id that web2py uses when converting sql databases into a form. Hope this helps someone else. Best, Austin On Friday, February 21, 2014 4:15:41 PM UTC-5, Austin Taylor wrote: > > I apologize for the vagueness. Part of that is my lack of knowledge and > not knowing what to provide in the

[web2py] Re: Change color of grid=SQLFORM.grid(db.abc, user_Signature=False)

2014-02-21 Thread Austin Taylor
n, or you can use a plugin > like Firebug for Firefox). This will show you which CSS definitions cause > the color changes and which CSS file are they coming from. Then you can > override them. > > Regards > > On Friday, February 21, 2014 5:31:35 PM UTC+1, Austin Taylor wrote: &

[web2py] How to use markdown with dictionary

2014-02-21 Thread Austin Taylor
I tried using this answer located here: http://stackoverflow.com/questions/9679090/using-modules-in-views/9680031#9680031 Here is the response i'm trying to follow (so you don't have to click the link). - Just for record. It is not a good idea to use locals() instead of passin

[web2py] Re: Change color of grid=SQLFORM.grid(db.abc, user_Signature=False)

2014-02-21 Thread Austin Taylor
Really need help with this so if my question isn't clear please let me know and i'll try to rephrase. On Thursday, February 20, 2014 11:16:50 AM UTC-5, Austin Taylor wrote: > > I'm currently using a CSS template in my layout, but it changed my grid > spreadsheet to a

[web2py] Change color of grid=SQLFORM.grid(db.abc, user_Signature=False)

2014-02-20 Thread Austin Taylor
I'm currently using a CSS template in my layout, but it changed my grid spreadsheet to an unreadable color. I've tried playing with the different css settings with no luck. Is there a way to just change the spreadsheet color? -- Resources: - http://web2py.com - http://web2py.com/book (Docume

Re: [web2py] Re: How to reset authentication?

2014-02-11 Thread Austin Taylor
Finally fixed!! Thank you so much! I had to delete all of the files in the app/databases folder. I didn't realize that checking those logs would help me see if the files could be written, but that helped a lot. Thank you! On Tue, Feb 11, 2014 at 6:13 AM, Austin Taylor wrote: >

Re: [web2py] Re: How to reset authentication?

2014-02-11 Thread Austin Taylor
need to keep the old data from the main database: > a) drop all tables from the main database > b) delete all files from the applications/yourapp/databases folder (assuming > there are no sqlite databases in there that you still need) > > Regards > > > > On Friday, February

[web2py] Re: how to make dictionary key a link

2014-02-10 Thread Austin Taylor
I actually meant the value of the dictionary key: For example, a{'abc':'http://learnyourabcs.com'} a{'link':'http://thisisalink.com'} a{'user':'bob'} a{'norm':'anothervalue'} On Monday, February 10, 2014 6:00:54

[web2py] how to make dictionary key a link

2014-02-10 Thread Austin Taylor
Hello, I'm displaying a dictionary using def results(): return dict(message=BEAUTIFY(session.dictionaryRequest)) Three of my keys have link values that I'd like the user to be able to click on. Is there a short way to do this? -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] Re: How to reset authentication?

2014-02-07 Thread Austin Taylor
Now I just tried to reset password and I get 1054, "Unknown column 'auth_membership.is_active' in 'field list' On Friday, February 7, 2014 4:07:15 PM UTC-5, Austin Taylor wrote: > > Thanks, Massimo. Whenever I click register I get some new unknown column > 

[web2py] Re: HTML Input (POST) field

2014-02-07 Thread Austin Taylor
gt; > On Wednesday, February 5, 2014 3:32:46 PM UTC-5, Austin Taylor wrote: >> >> Now if I want to run it through a series of functions should I put the >> functions in the model.py? What would be the best way to do it? >> > > If the functions are needed in multiple contr

[web2py] Re: How to reset authentication?

2014-02-07 Thread Austin Taylor
and that is often an important requirement. > > On Thursday, 6 February 2014 06:38:26 UTC-6, Austin Taylor wrote: >> >> I've tried creating another app and authentication works fine there with >> the sqlite database, but when I try to use my mysql instance I run into

[web2py] Re: How to reset authentication?

2014-02-06 Thread Austin Taylor
Or would it be possible for my authentication to be handled by another database?? I'm open for ideas/best practices. On Thursday, February 6, 2014 7:38:26 AM UTC-5, Austin Taylor wrote: > > I've tried creating another app and authentication works fine there with > the sqlite

[web2py] Re: [web2py:19089] Re: Input type button

2014-02-06 Thread Austin Taylor
Steve, I know this is an old post, but i'm trying to implement something like this (the classes). Where should I put the class index(): and how would I import it? Would it go in the default.py? On Sunday, April 5, 2009 6:03:26 AM UTC-4, Steve Shephed wrote: > > Where did you find the book in p

[web2py] How to reset authentication?

2014-02-06 Thread Austin Taylor
I've tried creating another app and authentication works fine there with the sqlite database, but when I try to use my mysql instance I run into error after error. Right now I have Login, Forgot Username and Lost Password when I hover over the login button. I don't know how to get it back to th

[web2py] Re: MySQL not showing tables when using python web2py.py -S appname -M

2014-02-05 Thread Austin Taylor
n them? Did you > inadvertently redefine the "db" object in a subsequent model file (that > will remove any previously defined models)? > > Anthony > > On Wednesday, February 5, 2014 3:35:29 PM UTC-5, Austin Taylor wrote: >> >> Hi Anthony, >> >&

[web2py] Re: MySQL not showing tables when using python web2py.py -S appname -M

2014-02-05 Thread Austin Taylor
rned off (or the database is > not writable), then defining those tables in the model will not result in > them actually being created in the database. > > Regarding the existing tables in the database, do you have models in your > app defining them? > > Anthony > >

[web2py] Re: HTML Input (POST) field

2014-02-05 Thread Austin Taylor
On Wednesday, February 5, 2014 2:20:21 PM UTC-5, Austin Taylor wrote: >> >> I found what I was looking for. request.vars returns the data in >> dictionary format. All I had to do was assign a variable to the name of my >> key in request.vars (example: ip = request.vars['ip&

[web2py] MySQL not showing tables when using python web2py.py -S appname -M

2014-02-05 Thread Austin Taylor
Hello, I followed the instructions for importing legacy databases and created a db1.py which gave me a nice model, but I'd like to be able to interact with my current database. When I type db the shell returns I run for x in db: print x and it only shows user, user_group, user_me

[web2py] Re: HTML Input (POST) field

2014-02-05 Thread Austin Taylor
I found what I was looking for. request.vars returns the data in dictionary format. All I had to do was assign a variable to the name of my key in request.vars (example: ip = request.vars['ip'] and it worked. Thank you!! On Wednesday, February 5, 2014 10:20:35 AM UTC-5, Austin Ta

[web2py] Re: HTML Input (POST) field

2014-02-05 Thread Austin Taylor
would be in request.vars (and request.post_vars, assuming a post > request). Hard to help further without seeing some code. > > On Wednesday, February 5, 2014 10:20:35 AM UTC-5, Austin Taylor wrote: >> >> This is driving me insane!! I've been trying to create an input field

[web2py] HTML Input (POST) field

2014-02-05 Thread Austin Taylor
This is driving me insane!! I've been trying to create an input field for a user to type in an IP address. I then want to assign their input to a variable, run it through my IP checks and return the result from our SQL database. In a nutshell, how can I assign their input to a variable (I'm thi

Re: [web2py] Anyway to interact with SQL Database?

2014-02-04 Thread Austin Taylor
Perfect! Thank you On Feb 4, 2014 2:00 PM, "Austin Taylor" wrote: > I am using mysql. I've tried importing MySQLdb, pymysql, and importing > DAL. I want to have an interactive prompt that I can practice querying > tables on. > > -- > Resources: > - http://w

[web2py] Anyway to interact with SQL Database?

2014-02-04 Thread Austin Taylor
I am using mysql. I've tried importing MySQLdb, pymysql, and importing DAL. I want to have an interactive prompt that I can practice querying tables on. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.goo

Re: [web2py] Re: Setting up examples (views/controllers)

2014-02-03 Thread Austin Taylor
> On Monday, February 3, 2014 3:17:25 AM UTC+1, Austin Taylor wrote: >> >> >> <https://lh4.googleusercontent.com/-k_GRjLmq2JQ/Uu78MulrZ5I/Fwo/DjaeMAVpGa0/s1600/webshot2.png> >> Tried that here is the result: >> >> On Sunday, February 2,

Re: [web2py] Re: Setting up examples (views/controllers)

2014-02-02 Thread Austin Taylor
tml > 3) create template_examples/variables.html > > Only. > > > > Ovidio Marinho Falcao Neto > ITJP.NET.BR > ovid...@gmail.com > itjp@gmail.com > Brasil

Re: [web2py] Re: Setting up examples (views/controllers)

2014-02-02 Thread Austin Taylor
html, but is > views/views/ template_examples/variables.html. > > > > > Ovidio Marinho Falcao Neto > ITJP.NET.BR > ovid...@gmail.com > itjp@gmail.com > Bra

[web2py] Re: Setting up examples (views/controllers)

2014-02-02 Thread Austin Taylor
Same error: invalid function (views/template_examples) On Sunday, February 2, 2014 4:03:24 PM UTC-5, Massimo Di Pierro wrote: > > The view should be > > views/template_examples/variables.html > > On Sunday, 2 February 2014 11:21:30 UTC-6, Austin Taylor wrote: >> >

[web2py] Setting up examples (views/controllers)

2014-02-02 Thread Austin Taylor
I've tried some of the examples on the site and created a function in my controllers folder. Controllers folder I have template_examples.py with a function called: def variables(): return dict(a=10, b=20) In my views folder I have variables.html with this code: {{extend 'layout.html'}} You vari