Re: [web2py] How to filter a referenced field in a for

2019-11-15 Thread Steve
Sorry for my late reply That is what i was looking for... thanks Op woensdag 6 november 2019 21:45:29 UTC+1 schreef Massimiliano: > > Try with: > > Is_empty_or(is_in_db(...)) > > Il giorno mer 6 nov 2019 alle 15:34 Steve > > ha scritto: > >> Hi, >>

[web2py] How to filter a referenced field in a for

2019-11-06 Thread Steve
me',requires=IS_NOT_EMPTY()), Field('stock', 'integer', requires=IS_NOT_EMPTY() ) Hope you can help me, Steve -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.

[web2py] Re: 1215 Cannot add foreign key constraint

2019-09-13 Thread Steve
two tables and after that prefill the first table with a couple of records. After that i could upload my backup data withoout a problem. Thanks for the help. Rgards, Steve Op donderdag 12 september 2019 10:49:15 UTC+2 schreef Dave S: > > > > On Wednesday, September 11, 2019 at 1:55

[web2py] Re: 1215 Cannot add foreign key constraint

2019-09-13 Thread Steve
ave S: > > > > On Wednesday, September 11, 2019 at 1:55:04 PM UTC-7, Steve wrote: >> >> Hi Dave, >> >> After performing a Fake_migration_all=True the Db files where created in >> de app/databases folder. >> So, in de admin i can see all of the tables. >&g

[web2py] Re: 1215 Cannot add foreign key constraint

2019-09-11 Thread Steve
o the document about broken migrations but no luck yet. The exact error: ProgrammingError: (1146, u"Table 'abc' doesn't exist") Any idea's how to fix this regards, Steve Op woensdag 11 september 2019 10:35:22 UTC+2 schreef Dave S: > > > > On Tuesday, Sept

[web2py] Re: 1215 Cannot add foreign key constraint

2019-09-11 Thread Steve
). I am still no step further with solving this issue. Steve Op woensdag 11 september 2019 10:35:22 UTC+2 schreef Dave S: > > > > On Tuesday, September 10, 2019 at 2:58:06 PM UTC-7, Steve wrote: >> >> Goodevening, >> >> I am trying to migrate from Sqite to MySQL

[web2py] 1215 Cannot add foreign key constraint

2019-09-10 Thread Steve
s=IS_NOT_EMPTY(error_message='cannot be empty!'), label=T('Mobile')), Field('Email','string', requires=IS_EMAIL(error_message='invalid email! Please fill in a correct e-mail address.'), label=T('Email')),

[web2py] How to use cache

2019-07-11 Thread Steve
implement this ? ( i have added the @cache.action to the index controller, which speeds up the page a lot but when you try to log out, it stays on the page and i get weird behaviour) So apperently i am doing things wrong. Anyone a suggestion regards, Steve -- Resources: - http://web2py.com

[web2py] Files in Static folder not showing in admin interface

2019-06-19 Thread Steve
? See added screenshots Thanks, Steve -- 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: Foreign key error after adding new table instance

2019-06-18 Thread Steve
OK, After searching the sqlite db and the views problem solved. DB inegrity was ok ... the view was wrong Op zondag 16 juni 2019 17:53:33 UTC+2 schreef Steve: > > Hi All, > > Busy with my platform, just added some tables. > I have defined extra fields for the Auth table.

[web2py] Foreign key error after adding new table instance

2019-06-16 Thread Steve
te=False) added auth rows auth.settings.extra_fields['auth_user']= [ Field('work_position',db.caretype, label=T('Profession')), Field('picture', 'upload', default='static/images/user_icon.png'),] Steve -- Re

[web2py] Re: placeholder for update record field names

2019-03-31 Thread Steve
Hi Anthony, Thanks, i will give it a try Op vrijdag 29 maart 2019 21:53:49 UTC+1 schreef Anthony: > > You can create a dictionary of field names and values and then do: > > workrecord.update_record(**dict_of_new_values) > > Anthony > > On Friday, March 29, 2019 at 4:49:

[web2py] Re: placeholder for update record field names

2019-03-31 Thread Steve
Hi Anthony, Thanks, i will give it a try Op vrijdag 29 maart 2019 21:53:49 UTC+1 schreef Anthony: > > You can create a dictionary of field names and values and then do: > > workrecord.update_record(**dict_of_new_values) > > Anthony > > On Friday, March 29, 2019 at 4:49:

[web2py] placeholder for update record field names

2019-03-29 Thread Steve
this is possible and if so how. The %s or %d does not work on fieldnames Steve -- 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] Calculation with imput from different tables

2018-12-02 Thread Steve
w how to setup the three tables but how to compare user input with 2 different tables and write the outcome to the same table where the userinput is stored. IHope someone can point me in the right direction steve -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Server does not exist or access denied error connecting web2py to MS SQL server

2018-08-31 Thread Steve Lyle
- result error--- Error: (u'IM002', u'[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified') --- --- end edit --- On Thursday, August 30, 2018 at 4:49:01 PM UTC-4, Steve Lyle wrote: > > I've read the book &

[web2py] Server does not exist or access denied error connecting web2py to MS SQL server

2018-08-30 Thread Steve Lyle
I've read the book & plenty else offered by up on the little pits available on Prof. Google. And I just don't get it I guess. I'm on a Windows 10 Pro x64 box I'm running web2py from cmd as: """ cd c:\web2py python web2py web2py Web Framework Created by Massimo Di Pierro, Copyright 2007-2018 Versi

[web2py] MSSQL connection

2016-12-21 Thread Steve Lyle
Hi guys. Newbie (of sorts) here. 20+ years in programming including Python but not for a couple of years now. But now I have the first time opportunity to build my application in web2py ~ so not a newbie but yes a web2py newbie. Any quick start guides/guide for dummys style for adapting the defa

[web2py] Is it safe to delete all folders from sessions? Does it have any side effect?

2016-10-20 Thread Steve Joe
I need to use my app from fresh. Will it have any disadvantage? -- 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] Why isn't WEB2PY a part of Googles summer of code? Will it be this time?

2016-10-06 Thread Steve Joe
I am seeing that Django, RoR all are on GSOC. Maybe web2py too should be there. -- 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: What's wrong here such that the delete query in accept() doesn't work at all?

2016-09-24 Thread Steve Joe
rror? If so, let's see the traceback. Otherwise, > what do you expect, and what do you observe instead? It would probably also > help to show the controller code of the main page, and possibly relevant > parts of your models. > > Anthony > > On Friday, Septem

[web2py] What's wrong here such that the delete query in accept() doesn't work at all?

2016-09-23 Thread Steve Joe
in view: {{if not (authdetails.id==auth.user_id):}} {{if db((db.friends.friend1==auth.user_id) & (db.friends.friend2==authdetails.id)).select() or db((db.friends.friend2==auth.user_id) & (db.friends.friend1==authdetails.id)).select():}} YOU BOTH ARE FRIENDS. {{elif db((db.friend_requests.

[web2py] How do I make this button redirect to a controller function when enter is pressed?

2016-09-22 Thread Steve Joe
document.getElementById("search") .addEventListener("keyup", function(event) { event.preventDefault(); if (event.keyCode == 13) { document.getElementById("searchbutton").click(); } }); I see that neither enter works nor search.text is correct at thi

Re: [web2py] Re: I am trying to login from Phonegap app into my web2py app, what's wrong here?

2016-08-28 Thread Steve Joe
and > values returned, at runtime. > > > Kiran Subbaramanhttp://subbaraman.wordpress.com/about/ > > On Sat, 27-08-2016 2:50 PM, Steve Joe wrote: > > Anyone there? Anthony? > > On Friday, August 26, 2016 at 7:38:40 PM UTC+5:30, Steve Joe wrote: >> >> *db(

[web2py] Re: I am trying to login from Phonegap app into my web2py app, what's wrong here?

2016-08-27 Thread Steve Joe
Anyone there? Anthony? On Friday, August 26, 2016 at 7:38:40 PM UTC+5:30, Steve Joe wrote: > > *db(db.auth_user.username == request.vars.username and > db.auth_user.password == CRYPT(request.vars.password)).select()* > > > *if db(db.auth_user.username == request

[web2py] Re: I am trying to login from Phonegap app into my web2py app, what's wrong here?

2016-08-26 Thread Steve Joe
ext on web2py :D You > need to apply CRYPT() before comparing. Read more about that on the book. > > On Friday, August 26, 2016 at 3:31:54 PM UTC+2, Steve Joe wrote: >> >> IN PHONEGAP: >> >> https://#someurl#.pythonanywhere.com/welcome/phonegap/log

[web2py] I am trying to login from Phonegap app into my web2py app, what's wrong here?

2016-08-26 Thread Steve Joe
IN PHONEGAP: https://#someurl#.pythonanywhere.com/welcome/phonegap/login";> username: Password: IN WEB2PY: def login(): k="false" if db(db.auth_user.username == request.vars.username and db.auth_user.password == request.vars.password).select(): k="true"

[web2py] How should I tackle this error?

2016-08-22 Thread Steve Joe
def index(): display=SQLFORM(db.dp ,point.id, showid=False, submit_button="Update" ).process() if display.accepted: redirect(URL('you','resizedp', args=auth.user_id)) return locals() def resizedp(): display=db(db.dp.user_id == auth.user_id).select().first() from PIL im

[web2py] Re: How to ensure that the upload field only accepts .jpg or .png files?

2016-08-21 Thread Steve Joe
Thank you Annet. What should I do for pdf? On Saturday, August 20, 2016 at 5:53:18 PM UTC+5:30, Annet wrote: > > Use the IS_IMAGE() validator > > http://web2py.com/books/default/chapter/29/07/forms-and-validators#IS_IMAGE > > > requires = IS_IMAGE(extensions=('jpg', 'png')) > > > > > Kind regards,

[web2py] How do I send a pdf as json object saved in the web2py db?

2016-08-21 Thread Steve Joe
How would you do it? -- 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 "web2py-us

[web2py] What's wrong with this snippet as it's not giving the correct result?

2016-08-20 Thread Steve Joe
db((db.user_interests.user_id == auth.user_id) and (db.user_interests.interest == nosubscription.category)).select() -- 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 I

[web2py] How to ensure that the upload field only accepts .jpg or .png files?

2016-08-20 Thread Steve Joe
What is the exact snippet for the same? -- 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: How do I make user redirect to a different page you/index instead of predefined on clicking PROFILE?

2016-08-17 Thread Steve Joe
Please look at the attached image above. I want to go to page you/index upon clicking "Profile'. On Wednesday, August 17, 2016 at 6:26:16 PM UTC+5:30, Ron Chatterjee wrote: > > Can you elaborate the problem better? What exactly u trying to solve. Give > a url structure of before n after u want t

[web2py] Re: How do I make user redirect to a different page you/index instead of predefined on clicking PROFILE?

2016-08-17 Thread Steve Joe
anyone there? On Tuesday, August 16, 2016 at 9:58:34 AM UTC+5:30, Steve Joe wrote: > > > -- 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

[web2py] How do I make user redirect to a different page you/index instead of predefined on clicking PROFILE?

2016-08-15 Thread Steve Joe
-- 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 "web2py-users" group. To unsub

[web2py] Re: How to get Month name instead of month number

2016-06-19 Thread Steve
Works like a charm thanks for your quick reply Steve Op zaterdag 18 juni 2016 23:43:14 UTC+2 schreef Steve: > > Goodevening, > > I loop through rows and am trying to show a date format like: 23 april. > What i get is : 23 4 ( as expected) and i would like to convert the month

[web2py] How to get Month name instead of month number

2016-06-18 Thread Steve
}} {{=row.f_title}} {{=row.f_log}} {{pass}} this works fine except month name ... not able to convert number to name hope that someone can help me... steve -- Resources: - http://web2py.com - http

[web2py] Though I changed datetime format to %d-%m-%Y %H:%M in web2py_ajax.html it gives the old results?

2016-06-17 Thread Steve Joe
Do I have to change it anywhere else too? -- 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 Goog

Re: [web2py] How do I redirect to a different application from one application?

2016-06-17 Thread Steve Joe
> Il 17/06/16 08:20, Steve Joe ha scritto: > > exact syntax? > > Have you looked for it in the doc? > > > http://www.web2py.com/books/default/chapter/29/04/the-core?#HTTP-and-redirect > > http://www.web2py.com/books/default/chapter/29/04/the-core#URL > &g

[web2py] How do I sort a list containing the rows of a db query according to a db table field?

2016-06-17 Thread Steve Joe
def index(): skills=db(db.skills.id>0).select() pro_lang=[] fake=[] for skill in skills: if skill.skilltype=="Programming Languages": pro_lang.append(skill) else: fake.append(skill) # how do i sort both the arrays as per the field skill.co

[web2py] How do I redirect to a different application from one application?

2016-06-16 Thread Steve Joe
exact syntax? -- 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 "web2py-users" gr

[web2py] How to add a Facebook like to a field in a db table, such that 1 like increases it by one?

2016-06-13 Thread Steve Joe
How do I code it? -- 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 "web2py-users

[web2py] Re: Why is my code not working? What correction has to be made?

2016-06-12 Thread Steve Joe
27;,'deciser')}}' + '?at=' + id, [], id.toString()) >> >> Anthony >> >> On Saturday, June 11, 2016 at 11:41:40 AM UTC-4, Steve Joe wrote: >>> >>> It does nothing. >>> However in >>> function change(id) >>&

[web2py] Why doesn't form accept the hidden fields as vars here?

2016-06-12 Thread Steve Joe
Please look at my code and let me know why I am getting emails in such a way: db.define_table('pokes', Field('name',requires=IS_NOT_EMPTY(error_message="Please enter your name")), Field('email_id',requires=IS_EMAIL()), Field('msg','text', label='M

[web2py] Re: Why is my code not working? What correction has to be made?

2016-06-11 Thread Steve Joe
; In the browser network tab, what's happening with the Ajax requests? Are > they being sent as expected, and if so, what response is returned? > > On Friday, June 10, 2016 at 8:14:55 AM UTC-4, Steve Joe wrote: >> >> in .load file: >> {{for i in range(0,3):}} >&

[web2py] Why is my code not working? What correction has to be made?

2016-06-10 Thread Steve Joe
in .load file: {{for i in range(0,3):}} {{for j in range(0,3):}} {{idd=str(i+1)+str(j+1)}} {{=l[i][j]}} {{pass}} {{pass}} function change(id) { ajax('{{=URL('default','deciser')}}'+'?at='+id,[],id); } def deciser(): return request.vars.at def

[web2py] How do I change the admin such that it doesn't redirect to welcome by default but to some other app?

2016-06-07 Thread Steve Joe
How do I change the admin such that it doesn't redirect to welcome by default but to some other app? -- 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

[web2py] Any body here used pythonanywhere? Question for you.

2016-06-07 Thread Steve Joe
Apart from 'welcome' how many web apps can you hostel to a domain name say, mystyle.com, at max? -- 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 rece

[web2py] How do I host my web2py app on openshift?

2016-06-07 Thread Steve Joe
any stepwise procedure? -- 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 "web2py

[web2py] This query doesn't fulfill what I need as it doesn't follow first condition? How to correct?

2016-06-05 Thread Steve Joe
rides=db(db.carpools.start_time > request.utcnow+datetime.timedelta(0,19800) and db.carpools.starter!=auth.user_id).select() -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

[web2py] Re: auth.signature and Format ....issue

2016-06-01 Thread Steve
_verification = False auth.settings.registration_requires_approval = False auth.settings.reset_password_requires_verification = True auth.settings.actions_disabled=['register'] Op woensdag 1 juni 2016 16:06:10 UTC+2 schreef Niphlod: > > at a minimum you need to extend auth BEFORE referen

[web2py] Does the code below the raise execute or it terminates at raise?

2016-06-01 Thread Steve Joe
-- 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 "web2py-users" group. To unsub

[web2py] auth.signature and Format ....issue

2016-06-01 Thread Steve
ition', db.work_position, label=T('Profession')), etc Anyone an idea to solve this ? Without the auth.signature it works fine. steve -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://

[web2py] I am trying to establish a startup in India that designs sites using web2py. Have a look here.

2016-05-25 Thread Steve Joe
I am designing the main website. Meanwhile I created the Facebook page for it. Have a look here and please give me some tips based on my posts. https://www.facebook.com/techavocado/ -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Sour

[web2py] I think I can make websites now with web2py but is there any scope for freelancing?

2016-05-24 Thread Steve Joe
I see everyone wants php -- 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 "web2p

[web2py] Which free email service works fine with web2py?

2016-05-23 Thread Steve Joe
I used to use gmail. Had a lot of struggle and one fine day it started working. Now again it doesn't work. I get no emails! -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (R

[web2py] Re: I tried learning scheduler but got messed up. Can someone help me with this?

2016-05-14 Thread Steve Joe
No it didn't add anything to the db checker. I made a few edits. I am not sure how they are working but they still don't work. scheduler.queue_task(adder, start_time=request.now, #datetime stop_time = None, #datetime timeout = 60, #seconds prevent_drift=False, period=60, #seconds immediate=F

[web2py] Re: I tried learning scheduler but got messed up. Can someone help me with this?

2016-05-14 Thread Steve Joe
Anthony wrote: > > Always helps to show what you have tried so far, and explain what happened. > > On Saturday, May 14, 2016 at 5:38:57 AM UTC-4, Steve Joe wrote: >> >> how to write a scheduler function that will send me an email with subject >> "hello" ev

[web2py] Re: I tried learning scheduler but got messed up. Can someone help me with this?

2016-05-14 Thread Steve Joe
ow what you have tried so far, and explain what happened. > > On Saturday, May 14, 2016 at 5:38:57 AM UTC-4, Steve Joe wrote: >> >> how to write a scheduler function that will send me an email with subject >> "hello" every night at 12 am? >> > -- Resour

[web2py] I tried learning scheduler but got messed up. Can someone help me with this?

2016-05-14 Thread Steve Joe
how to write a scheduler function that will send me a message with subject "hello" every night at 12 am? -- 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) ---

[web2py] Re: Are web2py apps safe from xss attacks?

2016-05-13 Thread Steve Joe
Saw it. Have a last doubt. Does web2py avoid file inclusion vulnerability? How? On Friday, May 13, 2016 at 8:31:49 PM UTC+5:30, Anthony wrote: > > Have a look here: > http://web2py.com/books/default/chapter/29/01/introduction#Security > > On Friday, May 13, 2016 at 10:20:29 AM U

[web2py] I have a file 'you.html' in static, how do I open it in my web2py app?

2016-05-13 Thread Steve Joe
I tried the following but it didn't work. in controller: def rough(): import os file = open(os.path.join(request.folder, 'static','index.html')) return locals() in view: {{extend 'layout.html'}} {{=file}} -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Are web2py apps safe from xss attacks?

2016-05-13 Thread Steve Joe
cally > escape all content inserted in views. > > Anthony > > On Thursday, May 12, 2016 at 4:14:00 PM UTC-4, Steve Joe wrote: >> >> how? > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Are web2py apps safe from xss attacks?

2016-05-12 Thread Steve Joe
how? -- 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 "web2py-users" group. To u

[web2py] How to take javascript variables from one view to a different view?

2016-05-12 Thread Steve Joe
can u write syntax for the same? -- 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

[web2py] How to take javascript variables from one view to a different view using ?

2016-05-12 Thread Steve Joe
syntax for the same? -- 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 "web2py-us

[web2py] Re: How do I update only the last row of a db query?

2016-05-11 Thread Steve Joe
nesday, May 11, 2016 at 1:15:45 PM UTC+2, Steve Joe wrote: >> >> db(db.loc_data.school_id == >> auth.user_id).update(end_time=request.utcnow+datetime.timedelta(0,19800) >> ).last() >> >> this doesn't tend to work. >> > -- Resources: - http://w

[web2py] How do I update only the last row of a db query?

2016-05-11 Thread Steve Joe
db(db.loc_data.school_id == auth.user_id).update(end_time=request.utcnow+datetime.timedelta(0,19800) ).last() this doesn't tend to work. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py

[web2py] Which payment gateway works best with web2py for india based website?

2016-05-01 Thread Steve Joe
how much does it cost? -- 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 "web2py-

[web2py] I removed navbar from layout and implemented in view like this but I don't get toggle in mobile view

2016-04-30 Thread Steve Joe
I want toggle navigation button when opened from mobile and not like this. My code in index.html: {{if response.menu:}} {{=response.logo or ''}} {{=MENU(response.menu, _class='nav navbar-nav',li_class='dropdown',ul_class='dropdown-menu')}}

[web2py] Re: How to add payment integration in web2py?

2016-04-26 Thread Steve Joe
But the code for stripe is only for credit cards. What about debit cards and net banking? -- 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 th

[web2py] Someone tell me what's wrong here?

2016-04-21 Thread Steve Joe
auth = Auth(db) auth.user_email.readable=False auth.user_email.writable=False -- 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 be

[web2py] Re: How to change login form such that it will ask the field username (added to auth) instead of email?

2016-04-19 Thread Steve Joe
o: > > auth.define_tables(username=True) > > or alternatively: > > auth.settings.use_username = True > auth.define_tables() > > If that case, the registration and login forms will automatically include > the username field. > > Anthony > > On Tuesday, April 1

[web2py] What is the difference between the both?

2016-04-19 Thread Steve Joe
ajax('{{=URL("default","data")}}',[],'target'); where target is id of a div and ajax('{{=URL("default","data")}}',[],':eval); How do their functionality differ? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https

[web2py] How to change login form such that it will ask the field username (added to auth) instead of email?

2016-04-19 Thread Steve Joe
username field is also unique -- 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 "

[web2py] What's wrong in this syntax?

2016-04-19 Thread Steve Joe
in db.py: auth.settings.extra_fields['auth_user']= [Field('last_active', default=request.utcnow+datetime.timedelta(0,19800), readable=False, writable=False), Field('last_seen', default=request.utcnow+datetime.timedelta(0,19800), readable=False, writable=False)] in controller person=db

[web2py] Re: How to compare between two datetime in web2py?

2016-04-19 Thread Steve Joe
in db,py auth.settings.extra_fields['auth_user']= [Field('last_active', default=request.utcnow+datetime.timedelta(0,19800), readable=False, writable=False), Field('last_seen', default=request.utcnow+datetime.timedelta(0,19800), readable=False, writable=False)] in controller for person in peop

[web2py] How to ensure each row in the db table having distinct value of a partcular field?

2016-04-18 Thread Steve Joe
db.define_table('person', Field('name'), Field('dob','datetime'), Field('username') #has to be unique ) how to ensure that the field username is unique? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - ht

[web2py] How to compare between two datetime in web2py?

2016-04-18 Thread Steve Joe
suppose I have two datetime as following. Now how do I compare between both and return true if time gap between both is 4 seconds or not. I am confused because they are none type objects so how to compare them? 2016-04-19 01:25:09.9090 2016-04-19 01:25:09.8765 -- Resources: - http://web2py.com

[web2py] What is the difference between request.args and request.vars in web2py?

2016-04-17 Thread Steve Joe
example? -- 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 "web2py-users" group.

[web2py] Re: How should I handle this?

2016-04-17 Thread Steve Joe
if auth.user_id <1: redirect(URL('default','index'), client_side=True) Why this isn't working? On Sunday, April 17, 2016 at 3:37:31 PM UTC+5:30, Leonel Câmara wrote: > > add client_side=True to the redirect calls > > redirect("http://google.com";, client_side=True) > -- Resources: - http

[web2py] Can we write a func such that a variable will have value 1 for a mint and again value 0?

2016-04-17 Thread Steve Joe
what's the syntax? -- 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 "web2py-user

[web2py] How should I handle this?

2016-04-17 Thread Steve Joe
def data(): if auth.user_id==0: redirect("http://google.com";) rows=0 if request.vars.q: db.chats.insert(shouter=auth.user and auth.user.first_name, msg=request.vars.q) size=len(db(db.chats.id>0).select()) lower=size-8 if size-8<=0: l

[web2py] Is there anything wrong with this syntax? Related with quotes inside quotes?

2016-04-16 Thread Steve Joe
-- 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 "web2py-users" group. To unsub

[web2py] What's wrong here?

2016-04-16 Thread Steve Joe
I am trying to show the user the recent 6 db entries at every 5 secs. But it doesn't seem to work! What am I doin wrong here? view:

[web2py] How to call an ajax process for controller function from script in the view? What's wrong here?

2016-04-16 Thread Steve Joe
window.setInterval(function(){ajax('{{=URL('data')}}',['q'],'target');}, 5000); -- 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] How to invoke this ajax process every 5 secs?

2016-04-16 Thread Steve Joe
so here when one gives some value, it will be displayed in the div id=target. However this is a chat room, so one has to see what others have too to say. So how do I invoke the ajax process to refresh the div id=target? -- Resources: - http://web2py.com - http://web2py.com/book (Document

[web2py] How to check whether an auth.user is online?

2016-04-16 Thread Steve Joe
What's the syntax? -- 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 "web2py-user

[web2py] incorporate response.menu in a bootstrap3 side-menu

2016-03-21 Thread Steve
Form Buttons etc Steve -- 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

[web2py] add value to dropdown list

2016-03-05 Thread Steve
that the already prefilled form is still there.. Any idea how to get this working steve -- 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

[web2py] Re: FORM or SQLFORM

2015-01-09 Thread Steve
Massimo, Thanks, i am still getting to know web2py. and i am going through the documentation I guess i will go for the second option :-) Steve Op vrijdag 9 januari 2015 05:46:59 UTC+1 schreef Massimo Di Pierro: > > You have to options. You can use custom widgets to represent for e

[web2py] FORM or SQLFORM

2015-01-07 Thread Steve
after the approval stores the data into the database. That is the idea, hope that someone can point me in the right direction. Steve -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py

[web2py] FORM or SQLFORM

2015-01-06 Thread Steve
ching what is the best choice Hope that someone can point me in the right direction ( meanwhile i am seachring through the documentation and this usergroup) ... one table and SQLFORM doesn't give me what i want Steve -- Resources: - http://web2py.com - http://web2py.com/book (Docume

Re: [web2py] Re: how to disable "register" item from the default upper right-hand side dropdown

2014-07-29 Thread steve van christie
please try : settings.actions_disabled = ['register'] best regards, stifan -- 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 beca

[web2py] Problem streaming videos in OS X

2013-08-17 Thread Steve Chalmer
When I upload a video file (in MPEG4 format) to the static area, only the first several seconds will play in the video control appearing on the page. This happens whether I use an auth.wiki() provisioned page, or if I simply embed a ... tag on the Welcome index page. I've tried both video files

Re: [web2py] Re: help with examples

2013-06-08 Thread steve . van . christie
For examples u can learn it from web2py appliances too. Sent from my BlackBerry® powered by Sinyal Kuat INDOSAT -Original Message- From: Anthony Sender: web2py@googlegroups.com Date: Sat, 8 Jun 2013 10:29:37 To: Reply-To: web2py@googlegroups.com Subject: [web2py] Re: help with examples

[web2py] Re: Rendering 'raw' HTML for AngularJS with Web2py

2013-05-25 Thread Steve Starr
*Dirk Krause solution did work for me but not very well, angularjs had some issues. *Now massimo's suggestion worked perfectly. Here is what I did. views/default/index.html* Bootstrap 101 Template {%include 'web2py_ajax.html'%} 'use strict';

Re: [web2py] Re: datetime diff between tables

2013-03-31 Thread steve . van . christie
I've already built it from the scratch (new data, new application) for all your recommendation function above. The data for created on is set by default in function signature in db.py. I can share the full apps, if you want. Any recommendation how to solve this? Thank you very much Sent from my

Re: [web2py] Re: Smartgrid: How to display value from foreign table in a table when only foreign key is in table

2013-02-25 Thread steve van christie
please fill with whatever name you want Application name: testdict Upload a package: (path where you downloaded from dropbox file : web2py.app.TechDictionary.w2p) click install -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe

Re: [web2py] Re: centralize file view *.html

2013-02-14 Thread steve van christie
already, i even tested it : *example code that not work* *views/block_footer.html* {{block footer}} custom_footer {{end}} *views/default/blog.html* *1.* * *{{extend 'layout.html'}} {{include 'block_footer.html'}} i think the server is confused about which block footer that they will use, so the

  1   2   >