[web2py] Set Scheduler Run Timeout on Try Except

2016-05-25 Thread Andrew Evans
Hello, I am running a scheduler that I would like to timeout the scheduler_run on a failed execution of my function so that it will attempt to retry running it. try: attempt to run my code except: failed to run, timeout scheduler_run to reattempt Also I have parameters that when a val

[web2py] Files failing to upload because of encryption taking place?

2014-06-30 Thread Andrew Evans
Hello I am building a simple file encryption software and I am facing issues with files larger than 200KB not being fully uploaded but resulting in success. I am running nginx server / web2py. However I am pretty sure it's configuration is set up correctly Perhaps some one could take a look at my

Re: [web2py] Re: Authorized File Download Error

2014-06-24 Thread Andrew Evans
Amazing! Thank you very much. On Tue, Jun 24, 2014 at 10:49 AM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > This line > > db.personal_uploads.file_upload.authorize = lambda record: > auth.is_logged_in() and (record.members.contains(auth.user_id)) > > > should be > > > db.personal_u

[web2py] Display returned objects from load(ed) component when calling URL from Ajax

2014-06-24 Thread Andrew Evans
Hello I am facing a problem with returned output from a controller not displaying when being called from a link using the ajax() function inside a LOAD(ed) component. *index* {{=LOAD('default', 'file_list.load', ajax=False)}} -- *file_list.load* Que For Encryption

[web2py] Detecting OS issue

2014-01-13 Thread Andrew Evans
Hello I am trying to figure out how to detect if a computer is running Windows or Macintosh then load the appropriate files and if any other system Linux/Mobile etc then load the other files The reason for this is I am using Google Earth in a project and I want to load Google Maps if it is not ava

Re: [web2py] Re: How to add users to a table row by request

2014-01-12 Thread Andrew Evans
Excellent! Thank you Anthony this solved my problem. Also thank you for the clear explanations :-) *cheers On Sun, Jan 12, 2014 at 6:05 AM, Anthony wrote: > If these groups are for the purpose of controlling access to resources, > you might consider using the built-in role-based access control

Re: [web2py] Pass Query to SQLFORM

2013-03-10 Thread Andrew Evans
Hi Massimo thank you for you help! What I was trying to do using crud.update initially was have a user update one of their records. When they do this I would like to set a boolean value that is in db.listing named 'confirmed' to False (confirmed=False) which is readable=False and writable=False I

Re: [web2py] Pass Query to SQLFORM

2013-03-10 Thread Andrew Evans
I am now getting this error AttributeError: 'Table' object has no attribute 'SUBSTRING(listing.userinfo,5,(6 - 5))' Using this code listing_id = request.args(0) query = db.listing[listing_id] and db.listing.userinfo[auth.user.id] query = db.listing[query] form = SQLFORM(db.listi

Re: [web2py] Pass Query to SQLFORM

2013-03-10 Thread Andrew Evans
Ok so after doing a bit more research I have come across this: http://www.web2py.com/examples/static/epydoc/web2py.gluon.sqlhtml.SQLFORM-class.html and I have done this listing_id = request.args(0) query = (db.listing.id[listing_id]) & (db.listing.userinfo[auth.user.id]) form = SQL

Re: [web2py] Re: datetime - compare dates while ignoring time Part 2: Time Zones!

2013-03-04 Thread Andrew Evans
Hi I did something I think which is similar you can get the current time based on time zone like this import datetime import pytz import time current_time = datetime.datetime.now(pytz.timezone('US/Eastern')).replace(tzinfo=None) This allowed me to schedule videos to play at a given time Not su

Re: [web2py] Search Form (Advice/Help) with custom Form

2013-01-27 Thread Andrew Evans
I was able to get it working thanks anyway everyone --

[web2py] Search Form (Advice/Help) with custom Form

2013-01-27 Thread Andrew Evans
I am developing a search form in web2py, I create the form like this Enter Keywords Select Region Choose a Region... {{for region in region_query:}}

[web2py] Get the Local time

2013-01-17 Thread Andrew Evans
Hello web2py group! I am trying to find a way to get the local time say PST or EST so I can display a video based on that time. Any suggestions? I was able to convert it to UTC but this doesn't really help the situation {{project_date = db(db.schedule).select(orderby=~db.schedule.date_in, li

[web2py] Re: Get the Local time

2013-01-17 Thread Andrew Evans
I was able to solve my problem with this if anyone is interested import pytz {{current_time = datetime.datetime.now(pytz.timezone('America/Vancouver')).replace(tzinfo=None)}} *cheers On Thu, Jan 17, 2013 at 8:25 AM, Andrew Evans wrote: > Hello web2py group! I am trying to find

[web2py] Advice on working with CSV data

2013-01-10 Thread Andrew Evans
Hello everyone and Happy New Year! I was hoping to ask a few questions on working with existing databases in CSV format that do not come from web2py. So here goes. How can I work with the existing information, How would I make changes/additions to the data using web2py. The imported CSV data wo

[web2py] Help integrating s-cubism uploadify widget

2013-01-07 Thread Andrew Evans
Hi I am having problems integrating this plugin http://dev.s-cubism.com/plugin_uploadify_widget in to my form. In my Models.py I have from plugin_uploadify_widget import ( uploadify_widget, IS_UPLOADIFY_IMAGE, IS_UPLOADIFY_FILENAME, IS_UPLOADIFY_LENGTH ) db.define_table('video', Fiel

[web2py] jquery datetime calendar and Mobile

2012-10-12 Thread Andrew Evans
Hello! How can I get the date and datetime calendar jquery from SQLForm to appear (when a time is being entered) on mobile platforms *cheers and ty --

Re: [web2py] make an item in a field deletable

2012-10-10 Thread Andrew Evans
grr nvm figured it out :-) On Wed, Oct 10, 2012 at 12:15 PM, Andrew Evans wrote: > How can I make an entry in a MySQL Field deletable and not the whole entry > > I have a table structure with > > Field('name') > Field('image') > > I want to make a

[web2py] make an item in a field deletable

2012-10-10 Thread Andrew Evans
How can I make an entry in a MySQL Field deletable and not the whole entry I have a table structure with Field('name') Field('image') I want to make an option for the image Field to be deletable using crud to update the form *cheers and ty --

[web2py] A few session/cart issues hoping to get help with :-)

2012-10-08 Thread Andrew Evans
I am trying to solve an issue in my code and hoping some of you can help I have a cart functionality for *reserving* items based on a month / day / year reservation. The problem is an extra entry is being added to the database when I submit the form. Any ideas how to fix this also will my *chec

[web2py] Help Fixing Controller Function to Validate on Form Submission

2012-10-05 Thread Andrew Evans
Hello I am trying to make a controller function upon submission of the form validate against existing entries in the database *this is the function:* @auth.requires(auth.has_membership('second_year') or auth.has_membership('admin')) def second_year_checkout(): check_id = request.args(0)

[web2py] request.vars returning as Nonetype

2012-10-04 Thread Andrew Evans
Hello I am trying to validate a form entry against existing entries in my database on form submission. But user_start and user_end are returning as None Type. How do I get the values of a form using SQLFORM *cheers if form.accepts(request.vars): for project in project_date:

[web2py] start date to end date and verifying form

2012-10-03 Thread Andrew Evans
Hello I am having a seemingly difficult time with this :-) and I am hoping some one can aid in solving this :-) I am trying to make an item reserved from start-date to end-date any ideas *cheers here is my code This my latest attempt googled and found this function import datetime def dateran

Re: [web2py] Re: list:reference database selection

2012-09-20 Thread Andrew Evans
) > > Anyhow, contains has a special usage for list fields. > > > On Thursday, September 20, 2012 5:07:46 PM UTC+1, Andrew Evans wrote: > >> I have since added format='%(title)s %(id)s' to the region table but the >> listing is not being selected >> >>

[web2py] Re: list:reference database selection

2012-09-20 Thread Andrew Evans
rch method? *cheers and ty On Thu, Sep 20, 2012 at 7:53 AM, Andrew Evans wrote: > Hello I have a field in my table defined like so > > Field('region', 'list:reference region'), > > The data entered is multiple regions in the form, Gibsons, Sechelt > > I am wond

[web2py] list:reference database selection

2012-09-20 Thread Andrew Evans
Hello I have a field in my table defined like so Field('region', 'list:reference region'), The data entered is multiple regions in the form, Gibsons, Sechelt I am wondering since it is not an id how I can pass the name of the town as an argument, so it only selects entries from that town this i

Re: [web2py] Re: int() argument must be a string or a number, not 'list'

2012-09-19 Thread Andrew Evans
Also updating web2py to Nightly seems to have caused a serious load on SSL caused 100% CPU load and raised up to 40% RAM usage until I reverted back to 1.99.7 and 1.99.7 didn't cause any load. Anyway My Report On Wed, Sep 19, 2012 at 11:38 AM, Andrew Evans wrote: > Also th

Re: [web2py] Re: int() argument must be a string or a number, not 'list'

2012-09-19 Thread Andrew Evans
Also the Python Version I am using is 2.6.6 On Wed, Sep 19, 2012 at 10:56 AM, Andrew Evans wrote: > yea I just tried trunk and does not work for me either... > > Maybe I am writing my code wrong? > > Any ideas? > > > > > On Wed, Sep 19, 2012 at 10:47 AM, Andrew E

Re: [web2py] Re: int() argument must be a string or a number, not 'list'

2012-09-19 Thread Andrew Evans
yea I just tried trunk and does not work for me either... Maybe I am writing my code wrong? Any ideas? On Wed, Sep 19, 2012 at 10:47 AM, Andrew Evans wrote: > I upgraded to the nightly build and it still doesn't fix my issue :-( > Version 2.0.9 (2012-09-18 20:11:26) stable

Re: [web2py] Re: int() argument must be a string or a number, not 'list'

2012-09-19 Thread Andrew Evans
t; wrote: > You should always consider the nightly built. It usually contains most of > the fixes as trunk but is a snapshot that we think relatively stable. > > > On Monday, 17 September 2012 22:13:48 UTC-5, Andrew Evans wrote: >> >> Will do I saw it was fixed in Trunk >> >> Does Trunk mean the not released version? >> >> *cheers >> >> Andrew >> > -- > > > > --

Re: [web2py] Re: int() argument must be a string or a number, not 'list'

2012-09-17 Thread Andrew Evans
Will do I saw it was fixed in Trunk Does Trunk mean the not released version? *cheers Andrew --

Re: [web2py] int() argument must be a string or a number, not 'list'

2012-09-17 Thread Andrew Evans
int(x) TypeError: int() argument must be a string or a number, not 'list' Error snapshot [image: help] (int() argument must be a string or a number, not 'list') On Mon, Sep 17, 2012 at 5:50 PM, Andrew Evans wrote: > Hello I am running into issues updating records in my M

[web2py] int() argument must be a string or a number, not 'list'

2012-09-17 Thread Andrew Evans
Hello I am running into issues updating records in my MySQL database after adding multiple=True like so Field('region', db.region, label='Region *', requires=IS_IN_DB(db,db.region.id,'%(title)s', multiple=True)), Any ideas how to fix this I am using web2py 1.99.7 *cheers and ty ;-) --

Re: [web2py] Re: Flash File and Routes

2012-09-03 Thread Andrew Evans
Thanks for your help I solved my problem by modifying the tutorial given here http://net.tutsplus.com/tutorials/wordpress/integrating-the-piecemaker-3d-gallery-into-your-wordpress-theme/ Thanks for the help *cheers Andrew On Mon, Sep 3, 2012 at 1:33 PM, Andrew Evans wrote: > ya its lin

Re: [web2py] Re: Flash File and Routes

2012-09-03 Thread Andrew Evans
run it all that appears is a blank screen and a bunch of errors in the output window :-P Any ideas? On Mon, Sep 3, 2012 at 1:21 PM, Andrew Evans wrote: > its linked in the flash file I believe from what I saw it is looking in > the same directory as the Flash Document > > I wil

Re: [web2py] Re: Flash File and Routes

2012-09-03 Thread Andrew Evans
.25.242.165/turtlebaychemists/default/piecemakerXML.xml and not > finding it. How is the URL to that file configured? > > Anthony > > On Monday, September 3, 2012 3:11:45 PM UTC-4, Andrew Evans wrote: > >> Thank you for your help Anthony >> >> the

Re: [web2py] Re: Flash File and Routes

2012-09-03 Thread Andrew Evans
Flash player" /> here is a link to the online site https://85.25.242.165/turtlebaychemists/default/index so you can see I can attach the flash src file if you like *cheers and ty once again for the help On Mon, Sep 3, 2012 at 10:46 AM, Anthony wrote: > Ca

Re: [web2py] Re: Flash File and Routes

2012-09-03 Thread Andrew Evans
I think because there are some hard coded values in the flash file but since I can't change the file (cause of my version of flash) its causing a problem But I don't know what the hard coded values could be. The only values in the flash file were references to the xml and images folder Would app

Re: [web2py] Re: Flash File and Routes

2012-09-03 Thread Andrew Evans
, Sep 3, 2012 at 9:52 AM, Anthony wrote: > On Monday, September 3, 2012 12:08:20 PM UTC-4, Andrew Evans wrote: >> >> Hello >> >> I have a flash file that requires that the files associated with it be in >> the same directory as views/default/index.html >> > &

[web2py] Flash File and Routes

2012-09-03 Thread Andrew Evans
Hello I have a flash file that requires that the files associated with it be in the same directory as views/default/index.html I did a bit of research and read that I can have the view look like it is in static or the static files look like they are in the views by using routes.py although I am

Re: [web2py] Re: how to escape data from request.post_vars to prevent SQLi

2012-08-27 Thread Andrew Evans
ust 27, 2012 4:32:09 PM UTC-4, Andrew Evans wrote: >> >> How can I escape the data submitted by my form to prevent SQL Injection. >> I read using request.post_vars does not escape the data, I am using a form >> built in HTML and submitting the data passing request.post_vars a

Re: [web2py] Query by latitude and longitude

2012-08-27 Thread Andrew Evans
in polygon, polygon > contains point etc. > > On Sunday, August 26, 2012 8:54:40 PM UTC-7, Andrew Evans wrote: >> >> nvm just found acos cos and such are not available in Dal or sqlite and I >> will need to use mysql >> >> *cheers >> >> ty :D >> &g

[web2py] how to escape data from request.post_vars to prevent SQLi

2012-08-27 Thread Andrew Evans
How can I escape the data submitted by my form to prevent SQL Injection. I read using request.post_vars does not escape the data, I am using a form built in HTML and submitting the data passing request.post_vars as variables to my SQL Query. Any ideas *cheers --

[web2py] Executesql Not returning results

2012-08-27 Thread Andrew Evans
I am trying to figure out why executesql is not returning any results in this query. I am using mysql, any suggestions would be greatly appreciated. There are no errors just an empty view *cheers Code Below *Controller* def location(): current_lat = request.post_vars["lat"] current_lon

[web2py] Re: Executesql Not returning results

2012-08-27 Thread Andrew Evans
Nvm I got it to work my latitude and longitude were in the wrong entries :D On Mon, Aug 27, 2012 at 7:12 AM, Andrew Evans wrote: > I am trying to figure out why executesql is not returning any results in > this query. I am using mysql, any suggestions would be greatly > appreciated.

Re: [web2py] Query by latitude and longitude

2012-08-26 Thread Andrew Evans
nvm just found acos cos and such are not available in Dal or sqlite and I will need to use mysql *cheers ty :D On Sun, Aug 26, 2012 at 8:43 PM, Andrew Evans wrote: > I was able to figure out the jquery side of things and found a query that > suggests a way to do this. How can I do this

Re: [web2py] Query by latitude and longitude

2012-08-26 Thread Andrew Evans
I was able to figure out the jquery side of things and found a query that suggests a way to do this. How can I do this below query in DAL using SQLite ;-) *cheers SELECT id, ( 3959 * acos( cos( radians(37) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(-122) ) + sin( radians(37) ) * s

[web2py] Query by latitude and longitude

2012-08-26 Thread Andrew Evans
Hello I am trying to figure out a problem I am having in a mobile site I am developing Given that I can find my location on a Google Map using jquery I want to pass those (lat and long) values as well as how much range to search to my query I am confused how to pass the values and do the query

[web2py] Unions and select from tables

2012-07-20 Thread Andrew Evans
I am trying to work in Web2py's union method and am wondering a few things if I have a query *db( (db.sample.id>0) and (db.example.id>0) and (db.random.id>0)).select()* I would like to know how to orderby the latest ids as well when I am displaying a page link *

[web2py] Create popular today query

2012-07-19 Thread Andrew Evans
Hello How can I query the database so it pulls the most viewed pages for the current day. I have a counter that calculates views on each page in total, I am just not sure how to implement it based on a time frame :-) *cheers and ty --

[web2py] database query for most popular today

2012-07-19 Thread Andrew Evans
Maybe this is pretty simple, I was wondering how I can get the most popular pages for the current day I have a counter set that checks how many times a page gets viewed here is a query for the most viewed: *popular_original = db(db.episodes.id>0).select(orderby=~db.episodes.views, limitby=(0,5

[web2py] Re: Ajax div refresh on form submission

2012-07-08 Thread Andrew Evans
Spoke to soon the div does not update. What I am after is the div song_list refreshing in real time. I appreciate any help offered *cheers *controllers* def index(): return dict() def page_with_form(): return dict() def ajax_example(): rows = db(db.music2.id>0).select() return

[web2py] Re: Ajax div refresh on form submission

2012-07-08 Thread Andrew Evans
Ok my approach was a bit off. I got the div to update on form submission. But how to separate the form view from the same page as the view to display updates? which I think has to do with this return XML('ajax("%s",[],"#song_list");' % URL('default', 'ajax_example.load')) Any ideas

[web2py] Ajax div refresh on form submission

2012-07-08 Thread Andrew Evans
Hello I have two functions one for querying the data base and one for submitting data. I also have one view for the form and one load file for the database query I then LOAD the load file into index view {{extend "template.html"}} {{=LOAD('default', 'ajax_example.load', ajax=True)}} My Fo

[web2py] How to use instead of input in SQLForm

2012-07-06 Thread Andrew Evans
Hello I am trying to figure out how to replace the submit button in SQLFORM I would like to replace with Upload and add Clear My controller is def index(): form = SQLFORM(db.music2) if form.accepts(request.vars, session): #db.music2.insert(song = db.music2.song.store(request.v

Re: [web2py] Re: Uploadify what am I doing wrong

2012-07-04 Thread Andrew Evans
GREAT ty very much for your help :-) *cheers On Wed, Jul 4, 2012 at 1:29 PM, Relsi Hur wrote: > here a very fast example. > > Em quarta-feira, 4 de julho de 2012 16h40min45s UTC-3, cheer10s escreveu: >> >> thank you for helping me >> >> I looked at some of the documentation and figured out so

Re: [web2py] Re: Uploadify what am I doing wrong

2012-07-04 Thread Andrew Evans
thank you for helping me I looked at some of the documentation and figured out some things but I get an IORERROafter uploading any ideas here is my modified controller and my uploadify script I am using uploadify version 3 def myUpload(): form = SQLFORM(db.music) if form.accepts(request.

[web2py] Uploadify what am I doing wrong

2012-07-04 Thread Andrew Evans
Hello I am trying to use uploadify in my web2py app but I am having a bit of difficulty no errors occur it just doesn't work These are my controllers def index(): return dict() def myUpload(): form = SQLFORM(db.music) if form.accepts(request.vars, session): response.flash =

Re: [web2py] Re: Remove Special Characters and Whitespace in db field

2012-07-03 Thread Andrew Evans
I was mistaken thank you for your help I guess what web2py does is escape those special characters, is that correct? Anyway I used the IS_APHANUMERIC function *cheers

[web2py] Organizing checkboxes to appear in a 3 column layout

2012-07-03 Thread Andrew Evans
Hello I have the following field Field('genre',requires=IS_IN_DB(db,db.genre.id, '%(title)s', multiple=True), widget=SQLFORM.widgets.checkboxes.widget), I am trying to figure out how to layout the checkboxes so there in a 3 column grid Any ideas *cheers

[web2py] Re: Remove Special Characters and Whitespace in db field

2012-07-03 Thread Andrew Evans
Ok nvm I just read that web2py will not allow this by default *cheers :-) On Tue, Jul 3, 2012 at 10:47 AM, Andrew Evans wrote: > Hello I have a field for a table > > Field('profile_name',length=64), > > I would like to make sure special characters and whitespace can&#

[web2py] Remove Special Characters and Whitespace in db field

2012-07-03 Thread Andrew Evans
Hello I have a field for a table Field('profile_name',length=64), I would like to make sure special characters and whitespace can't be added to it How would I go about doing this? and produce an error message if it occurs on form submission (div.error)) *cheers

Re: [web2py] Re: updating linked fields

2012-07-03 Thread Andrew Evans
Gah nvm :-P Its 7 30 am I was a bit under the weather :-P sorry :-( On Tue, Jul 3, 2012 at 7:35 AM, Andrew Evans wrote: > Your right ty :-) > > How can I select channel_name then from my view (so I don't have to change > a million entries) > > {{fo

Re: [web2py] Re: updating linked fields

2012-07-03 Thread Andrew Evans
Your right ty :-) How can I select channel_name then from my view (so I don't have to change a million entries) {{for broadcast in schedule:}} {{=broadcast.channel}}

[web2py] updating linked fields

2012-07-03 Thread Andrew Evans
Hi I am trying to update the records in my database for a field that is linked. I have two entries in the table channel. When I edited channel_name field I expected everything would have changed (because it is linked). but it did not. How do I go about changing the data? *cheers db.define_table(

[web2py] Produce Invalid Input message rather than escape and add entry

2012-06-28 Thread Andrew Evans
Hello I am using Santize=True with some HTML permitted. For any invalid characters or HTML added such as or , how can I produce a response error message rather than escaping the code and adding it to the database? So it just doesn't let you post it if there is any invalid markup Any ideas *chee

[web2py] Re: Redirect Auth based on Membership

2012-01-23 Thread Andrew Evans
Nevermind got everything sorted my logic was a bit off *cheers :D On Mon, Jan 23, 2012 at 9:20 AM, Andrew Evans wrote: > I want to redirect the admin user if they login as admin vs logging in as > a regular user > > if auth.requires_membership('admin'): > auth.

[web2py] Redirect Auth based on Membership

2012-01-23 Thread Andrew Evans
I want to redirect the admin user if they login as admin vs logging in as a regular user if auth.requires_membership('admin'): auth.settings.login_next = URL('control_panel', 'index') auth.settings.logout_next = URL('control_panel', 'index') that is in my model atm but does not seem to

Re: [web2py] PSTV [Paradigm Shift Television] Powered by Inclusion

2012-01-20 Thread Andrew Evans
Yes was made by me and a partner/friend of mine and ty On Fri, Jan 20, 2012 at 8:52 PM, Bruno Rocha wrote: > looks very nice on mobile! congrats! > > > On Sat, Jan 21, 2012 at 12:42 AM, Andrew Evans > wrote: > >> Wondering if this site can be included

[web2py] PSTV [Paradigm Shift Television] Powered by Inclusion

2012-01-20 Thread Andrew Evans
Wondering if this site can be included in the powered by web2py www.paradigmshift.tv *cheers Andrew

Re: [web2py] Re: Ckeditor Crud Controller Problem

2012-01-17 Thread Andrew Evans
*cheers I must of been blind not to see that last night ty very much On Tue, Jan 17, 2012 at 5:51 AM, Anthony wrote: > db.define_table('contrib', >> Field('userinfo', db.auth_user, default=auth.user_id, readable=False, >> writable=False), >> Field('title'), >> Field('contributions'

[web2py] Ckeditor Crud Controller Problem

2012-01-17 Thread Andrew Evans
Hello I am having a problem with CKEditor in Crud I get the following error when I try to use it Traceback (most recent call last): File "/opt/web2py/gluon/restricted.py", line 192, in restricted exec ccode in environment File "/opt/web2py/applications/pstv/controllers/control_panel.py"

[web2py] Default/index fails to load

2012-01-16 Thread Andrew Evans
Just upgraded web2py to the latest version (1.99.4) and it fails to load my default/index pages on a few of my sites. Other pages work fine Any ideas what I am doing wrong? maybe something to do with routes? was working fine before *cheers

[web2py] Re: Default/index fails to load

2012-01-16 Thread Andrew Evans
Ok seems to be an issue using datetime or date Sorry about double posting if I did I may have posted on the wrong email. I appreciate any help though not sure what I need to post to get further help ValueError: invalid literal for int() with base 10 On Sun, Jan 15, 2012 at 6:43 PM, Andrew

[web2py] Re: Default/index fails to load

2012-01-16 Thread Andrew Evans
After a bit of research this is what I found the table which caused an error (it has been removed temporarily) but db.define_table('trailer', Field('userinfo', db.auth_user, default=auth.user_id, readable=False, writable=False), Field('title',requires=IS_NOT_EMPTY()), Field('descripti

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

2012-01-15 Thread Andrew Evans
t() trailers = db(db.trailer.id>0).select(orderby=~db.trailer.air_date) return dict(schedule=schedule,episodes=episodes,categories=categories,trailers=trailers) *cheers ty :D On Sun, Jan 15, 2012 at 6:02 PM, Andrew Evans wrote: > Hello I just updated web2py and after restartin

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

2012-01-15 Thread Andrew Evans
Hello I just updated web2py and after restarting uwsgi I get an error on my site ValueError: invalid literal for int() with base 10: '05 04:36:30' Traceback 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. Traceback (most recent call last): File "/opt/web2py/gluo

Re: [web2py] Re: New Site for web2py poweredby

2012-01-15 Thread Andrew Evans
Oh ya ty will fix that and will make the template easier to maintain today using {{include "nav.html"}} etc *cheers On Sun, Jan 15, 2012 at 7:20 AM, Annet wrote: > Hi Andrew, > > > its not perfect I am sure :-P > > but in line with the rest of the site ;-) > > I just noticed that now matter w

Re: [web2py] Re: New Site for web2py poweredby

2012-01-14 Thread Andrew Evans
ty very much thanks for all the feedback :-) *cheers Andrew On Sat, Jan 14, 2012 at 10:34 AM, Chris Hawkes wrote: > It looks a ton better, good job! > > > On Sat, Jan 14, 2012 at 12:21 PM, Andrew Evans > wrote: > >> Hello I think I finished the styling :-) >> &g

Re: [web2py] Re: New Site for web2py poweredby

2012-01-14 Thread Andrew Evans
Hello I think I finished the styling :-) its not perfect I am sure :-P I think the green at the top of the thread could be replaced (if only I could find where in the style sheet it is) anyway here is the link again www.fireflywra.com and www.fireflywra.com/forum Thank you for all the insight

Re: [web2py] Re: New Site for web2py poweredby

2012-01-13 Thread Andrew Evans
ty everyone! Annet I did the changes you suggested but will have to work on the forum styling later today. Great ideas though *cheers On Fri, Jan 13, 2012 at 5:04 AM, Cliff wrote: > Very nice. > > A agree with Annet about the forum styling, though. > > On Jan 13, 3:16 am, Rahul wrote: > > Lo

Re: [web2py] Re: New Site for web2py poweredby

2012-01-12 Thread Andrew Evans
ty very much :-) On Thu, Jan 12, 2012 at 4:33 PM, chawk wrote: > I just checked it out again, the forum looks great!

Re: [web2py] Re: New Site for web2py poweredby

2012-01-12 Thread Andrew Evans
I also removed the sign up unless you want to post an article or blog post *cheers On Thu, Jan 12, 2012 at 4:20 PM, Andrew Evans wrote: > Great advice! Fixed everything you suggested > > > On Thu, Jan 12, 2012 at 4:05 PM, chawk wrote: > >> Your footer should follow the s

Re: [web2py] Re: New Site for web2py poweredby

2012-01-12 Thread Andrew Evans
Great advice! Fixed everything you suggested On Thu, Jan 12, 2012 at 4:05 PM, chawk wrote: > Your footer should follow the same layout as the nav bar, meaning 100% > width across the screen. > > I cant really see the forum without signing up first. > > Your copyright symbol is not showing up. >

Re: [web2py] Re: New Site for web2py poweredby

2012-01-12 Thread Andrew Evans
No worries no harm done :-) On Thu, Jan 12, 2012 at 3:59 PM, chawk wrote: > > Okay, turns out I am not able to click on the anchor for this post or > another post I just put up myself. Google is giving me a 404 error > page. The problem appears to be on my end. > > Sorry,

Re: [web2py] Re: New Site for web2py poweredby

2012-01-12 Thread Andrew Evans
Really? works for me.. On Thu, Jan 12, 2012 at 3:53 PM, chawk wrote: > Your link is not working :(

[web2py] New Site for web2py poweredby

2012-01-12 Thread Andrew Evans
Hey there I have a new site available to show the web2py community. My Friend/Business Partner/Team mate built most the code in other projects, I just kind of tweaked it fixed a few bugs and added/subtracted some features Anyway everything is coded in web2py including the forums... We had to snag

Re: [web2py] Re: Selecting Latest Thread for a specific category

2012-01-05 Thread Andrew Evans
Hey ty that helped enough to solve my problem db((db.forum_post.category == db.category.id) & (db.category.id == forums.id)).select(db.forum_post.ALL, orderby=~db.forum_post.id, limitby=(0,1)) the "forums" value is a loop through the categories :-) *cheers ty very much for your help On Wed,

Re: [web2py] Re: Selecting Latest Thread for a specific category

2012-01-04 Thread Andrew Evans
Hi no its not on GAE I do get the last post but its for the last category posted in here is a link you can see :-) http://www.fireflywra.com/forum *cheers On Wed, Jan 4, 2012 at 5:10 PM, Anthony wrote: > What do you get with that query? Is this on GAE (on GAE, I don't think the > id's are ne

Re: [web2py] Re: Random Selection Issue

2011-11-13 Thread Andrew Evans
Just to note my code looks like this: @auth.requires_login() def xreflection(): game_id = request.args(0) reflection_id = request.args(1) if reflection_id == None: return dict(redirect(URL('error','invalid'))) if game_id == None: return dict(redirect(URL('error','in

Re: [web2py] Re: Random Selection Issue

2011-11-13 Thread Andrew Evans
Hello just wondering if some one can help with this, still having no luck. Would appreciate any help *cheers On Fri, Nov 11, 2011 at 7:02 PM, Andrew Evans wrote: > Still trying to solve this any ideas are welcome *cheers >

Re: [web2py] Re: Random Selection Issue

2011-11-11 Thread Andrew Evans
Still trying to solve this any ideas are welcome *cheers

Re: [web2py] Re: Random Selection Issue

2011-11-11 Thread Andrew Evans
hmm that did not work any other ideas *cheers this is what we did def xreflection(): game_id = request.args(0) reflection_id = request.args(1) if reflection_id == None: return dict(redirect(URL('error','invalid'))) if game_id == None: return dict(redirect(URL('erro

[web2py] Re: Random Selection Issue

2011-11-11 Thread Andrew Evans
Anyone able to help with this? No pressure, just hoping I can get some insight from one of the Gurus :-) *cheers On Thu, Nov 10, 2011 at 11:22 AM, Andrew Evans wrote: > Hello I am trying to randomly select from entries in my database then > store that random result. The problem is its s

[web2py] Random Selection Issue

2011-11-10 Thread Andrew Evans
Hello I am trying to randomly select from entries in my database then store that random result. The problem is its storing the wrong result (I think its storing the previous random selection) Any ideas how I can achieve my goal? @auth.requires_login() def xreflection(): game_id = request.arg

Re: [web2py] Mapping URLS in routes.py

2011-08-31 Thread Andrew Evans
, Jonathan Lundell wrote: > On Aug 31, 2011, at 1:50 PM, Andrew Evans wrote: > > Hey well for some reason its working now *confused > > > Keep in mind that you need to restart web2py (or at least reload the router > configuration) for changes to take effect. That can be confusing

Re: [web2py] Mapping URLS in routes.py

2011-08-31 Thread Andrew Evans
Hey well for some reason its working now *confused Anyway I won't complain ty for the advice This is a great forum :-) On Wed, Aug 31, 2011 at 1:36 PM, Jonathan Lundell wrote: > On Aug 31, 2011, at 12:06 PM, Andrew Evans wrote: > > Hello I have the following in my routes.py fi

[web2py] Mapping URLS in routes.py

2011-08-31 Thread Andrew Evans
Hello I have the following in my routes.py file but its not mapping the second domain to the web2py project any ideas whats up? routers = dict( # base router BASE = dict( default_application = 'cheer10s', domains = { 'cheer10s.com' : 'cheer10s',

[web2py] is_upload_filename and requires=False

2011-07-24 Thread Andrew Evans
Hello I am trying to figure out how to require a File extension for an upload but make the upload not required. Field('file','upload', required=False, requires=IS_UPLOAD_FILENAME(extension ='(pdf|doc|txt)' , error_message='Inappropiate extension, Please Upload PDF or DOC file only')), Any ideas

[web2py] Message to the creator of Tenthrow regarding Paypal

2011-07-14 Thread Andrew Evans
Hello I am having troubles integrating your code into even a simple example. I was hoping you could help me by creating a working example of your code called something like paypal_test and packing it into a web2py file so I can then work on it in my own code. As well as telling me how you generat

  1   2   >