[web2py] Rating Plugin Issue

2010-11-11 Thread George
and still couldn't find a resolution. I believe the problem might be coming from : tablename=request.vars.tablename record_id=request.vars.record_id However, I played around with changing that and still nothing worked. Any help would be appreciated! Thanks, George

Re: [web2py] Re: Website doesn't show up.

2012-03-10 Thread George
Putting in return dict() made it work. Thanks. What exactly does that do? Where does it get sent to? On Sat, Mar 10, 2012 at 4:53 PM, Alan Etkin wrote: > It appears that your controller sent a None object response. For using > the view's template, the return statement of the function should > r

Re: [web2py] Re: How can I union 2 different table datasets?

2017-04-27 Thread George
>> Does your database support views/materialized views? >> >> Anthony >> >> >>> On Thursday, April 27, 2017 at 8:48:26 AM UTC-4, George D Elig wrote: >>> Unfortunately, I cannot combine the two tables. The existing product uses >>> one of them exte

[web2py] response.menu

2011-01-09 Thread Nathan George
I'm new to web2py and trying to set up my site from the beginning. I was trying to customize my menu, and couldn't find any relevant documentation on response.menu. For example, in the code: response.menu = [ (T('Home'), False, URL(request.application,'default','index'), []) ] what is t

[web2py] web2py and roundcube

2012-03-16 Thread George Jekner
But I am stuck on trying to either have roundcube respond on a different port or have web2py not respond on this page. Any ideas? Thanks, George

Re: [web2py] Re: web2py and roundcube

2012-03-21 Thread George Jekner
Hello, I installed web2py using the deployment script. So whatever is the default. Where can I find the vhost file you are talking about? Thanks, George On Mon, Mar 19, 2012 at 1:29 PM, LightDot wrote: > This is a problem with your web server configuration. Could you please > post how a

[web2py] upgrade web2py

2013-05-09 Thread George Hellman
I am trying to upgrade web2py automatically I am running "Version 1.99.4" " Running on Apache/2.2.20 (Ubuntu)" (ubuntu server) with full root access. It says: "Checking for upgrades..." or, if there is an upgrade button, it does not upgrade. This may have to do with "file locking" as on pos

[web2py] Re: Autocomplete Widget "changed" after upgrade

2013-08-05 Thread Wilson George
On Thursday, November 17, 2011 2:37:04 AM UTC+5:30, Martin wrote: > > Hi, > > I upgraded web2py to latest version. everything works fine exept the > autocomplete widget > > I use MySQL as my database. > > The autocomplete is reading from a db VIEW. The reason for this is > that I have 2 columns i

[web2py] OperationalError: near ", ": syntax error, I'm new to this, maybe I dont use DAL properly.

2013-08-31 Thread George Petsagourakis
Hello everyone, I have the following table definitions: db.define_table('identities', Field('name', 'string', required=True), Field('profession', 'string', required=True), Field('address','text', required=True), Field('vat_number',unique=True, required=True, length=9, requires=IS_

[web2py] Re: OperationalError: near ", ": syntax error, I'm new to this, maybe I dont use DAL properly.

2013-08-31 Thread George Petsagourakis
Thanks Niphlod for pointing me to the right direction: db.define_table('items,', ^ (there is an extra comma right there, at the table name definition) -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsu

[web2py] Even after setting routes.py to my app name GideonGeorge, my site doesn't go as expected

2015-11-05 Thread Gideon George
What could be the problem? my site goes to http://www.gideongeorge.com/welcome/default/index when it should just go to the domain root. Please somebody help me out. Thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code)

[web2py] Web2py Views: Multiple images changing in the background of index?

2014-06-24 Thread Gideon George
Please I need a help, this is the first time I am posting here and I am in my journey to be the Africa's number one Web2py enthusiast. I am currently developing my first web2py application and I have less than a week to complete it and head over to a more complex application by next week. My qu

[web2py] Background images slides like twitter?

2014-06-24 Thread Gideon George
Please I need somebody to help me on suggestions on how to put background-images in my website's index. just like twitter. Thank you -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issue

[web2py] Re: Importing an already existing MySQL database

2014-07-03 Thread Gideon George
Please how can I use the script? I mean, where will I save the script? anywhere online where I can just download it instead of copy & paste? On Wednesday, 15 July 2009 00:09:20 UTC+1, Boriel wrote: > > Hi, > > I'm rather new to web2py, but I think this script might be helpful to > others. > I've

[web2py] How can I import an existing database to my db.py model?

2014-07-03 Thread Gideon George
I have successfully changed the default sqlite connection to mysql. Now I want to import an exported file (database.sql) which is an existing database. I need help on how I can do this please -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/

[web2py] Can I create an RSS Reader like Techi in web2py?

2014-07-04 Thread Gideon George
I want to create an awesome rss feed agregator like that of techi.com please is there any example of site that did it in web2py? Also I need suggestions on how to go about it. Thank you -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (

[web2py] DAL using Mysql.server on pythonanywhere is not working. Giving errors

2014-08-05 Thread Gideon George
Please I need somebody to help me make my site visible by telling me what to do to make my database connection work on the pythonanywhere.com remote server I have tried all I could but never seems to get close. This is how I did it from the pythonanywhere database dashboard and below to is my D

Re: [web2py] Can I create an RSS Reader like Techi in web2py?

2014-08-07 Thread Gideon George
> > Thank you everyone for your contributions. > Ricardo please I am still trying to figure out how to to this, and looking at the url you gave on www.feeds.uni.me redirrects to http://vioos.com/. I really like the layout of http://vioos.com/ .Please was that done using rss in web2py? if yes

Re: [web2py] Can I create an RSS Reader like Techi in web2py?

2014-08-08 Thread Gideon George
eed you to help me on this. Thank you On Fri, Aug 8, 2014 at 4:41 PM, Ricardo Pedroso wrote: > On 8/8/14, Gideon George wrote: > > > >> > >> Thank you everyone for your contributions. > >> > > > > Ricardo please I am still trying to figure out ho

[web2py] form = crud.create(db.post)

2014-08-08 Thread Gideon George
I have a table named "post" in my db model and because of this line in my action controller "form = crud.create(db.post)" I keep on getting this error below. long() argument must be a string or a number, not 'Table' Please help me and tell me what to do. Thank you -- Resources: - htt

Re: [web2py] Can I create an RSS Reader like Techi in web2py?

2014-08-10 Thread Gideon George
> > WOW! That's really great to hear. I don't even know how to start > appreciating right now. I am really grateful for that, Absolutely grateful! I will love to learn and implement it. it's gonna help me alot. Thank you very much and I pray that God grant you all your heart desires, Amen. It

[web2py] Please help me clear this error! long() argument must be a string or a number, not 'Table'

2014-08-10 Thread Gideon George
I have to copy the error ticket and paste it here, please help me. It's been killing me for days! I can't write a post and post it to the database of the form crud.create(db.table) All the tutorials I follow used it perfectly but I have never used it successfully. What is happening? " long() a

[web2py] Re: Web2py Form Error! PLEASE HELP!!!! => long() argument must be a string or a number, not 'Table'

2014-08-11 Thread Gideon George
This is my action in default.py (Everything is working fine, except the form in the view, if I write and submit the post, it gives this error above) @auth.requires_login() def timeline(): db.post.posted_by.default = auth.user_id db.post.posted_on.default = request.now #create form wit

Re: [web2py] Can I create an RSS Reader like Techi in web2py?

2014-08-14 Thread Gideon George
Oh Ok, that will be great! I can't wait... Wish you the best of the best. Thank you On Wed, Aug 13, 2014 at 11:28 PM, Ricardo Pedroso wrote: > Next weekend I can share the code. I have to cleanning it a little bit. > > Ricardo > > > On 8/11/14, Gideon George wrote: &g

Re: [web2py] Can I create an RSS Reader like Techi in web2py?

2014-08-20 Thread Gideon George
rss or something. Thank you once more again I am very grateful. On Mon, Aug 18, 2014 at 11:22 PM, Ricardo Pedroso wrote: > On 8/14/14, Gideon George wrote: > > Oh Ok, that will be great! I can't wait... Wish you the best of the best. > > Follows attached... > > >

[web2py] How can I create a virtualenv and follow this instruction in web2py?

2014-09-17 Thread Gideon George
Please somebody help me on how to go about following this instruction below. On a mission to create something http://feeds.uni.me/ (RSS Feed reader) I don't know exactly where to start. where can I find the web2py commandline to help create the virtualenv? Or is it not all going to be done within

[web2py] Like the 1st example in the web2py book, can I customize my session.counter to count all sessions?

2014-12-01 Thread Gideon George
Please what I can do if I want to display the number of visits to each page of my site without restricting it to just individual sessions? Unlike the code below where it displays number of visits for a particular session, I want a situation where by I can put something like this at my footer

[web2py] How to use crud.select(db, query) to extract values in db table

2014-12-04 Thread Gideon George
This is my db db = DAL('sqlite://storage.sqlite') db.define_table('entry', Field('name'), Field('location'), Field('state_of_origin'), Field('local_govt'), Field('file', 'upload'), Field('posted_on','dat

[web2py] How can I create a DAL Select statement from a SQL exists clause?

2017-04-21 Thread George D Elig
I have the following SQL statement that I'm having difficulty converting to a db()Select statement. I could use a left join but I can only return one row, which is being addressed with 'limit 1' select sites.domain_name, batch.batch_name from sites, batch where exists (select batch.id from

[web2py] Help with creating a Select within the Web2Py DAL for a SQL query that uses an 'exists' clause

2017-04-21 Thread George D Elig
I have a simple SQL query that pulls a column value from a secondary table, based on a ID being equal in both tables. The query uses an exists clause on a subquery. select sites.domain_name, batch.batch_name from sites, batch where exists (select batch.id from batch where sites.b

[web2py] How can I union 2 different table datasets?

2017-04-22 Thread George D Elig
I have the following tables defined and would like to display rows of cats, followed by rows of dogs db.define_table(‘cat’, Field('name', 'string', length=45), Field(‘age’, ‘integer’), Field(‘apt_time’,’datetime’) ) db.define_table(‘dog’, Field('name', 'string', length=45), Field(‘age’, ‘i

[web2py] Re: How can I union 2 different table datasets?

2017-04-25 Thread George D Elig
egant solution. On Saturday, April 22, 2017 at 4:51:21 PM UTC-4, George D Elig wrote: > > I have the following tables defined and would like to display rows of > cats, followed by rows of dogs > > db.define_table(‘cat’, > > Field('name', 'string', leng

[web2py] Re: How can I union 2 different table datasets?

2017-04-27 Thread George D Elig
Unfortunately, I cannot combine the two tables. The existing product uses one of them extensively for queue processing and I don't want to possibly break any of that functionality. All I want to do is update the SQLFORM with information from the new table. I can use db.executesql but won't that

Re: [web2py] Re: How can I union 2 different table datasets?

2017-05-10 Thread George D Elig
view or materialized view in the db, and then just create a DAL > model based on that view (turn off migrations for that model so the DAL > does not attempt to create a table for it). From that point, you can use > that model for queries via the DAL. > > Anthony > > On Thur