[web2py] Re: web2py 2.14.4 is OUT

2016-05-04 Thread Derek
PYTDS is now DBAPI 2.0 compliant, which means you can now use it with Web2py. It's fully python not dependent on any installed libraries, for your MSSQL needs. That means you can use this in pypy or ironpython as well... On Tuesday, April 12, 2016 at 2:29:26 PM UTC-7, Massimo Di Pierro wrote:

[web2py] Re: Mysterious key error

2016-01-22 Thread Derek
company_field_id and company_id_field are not the same. Look closely. On Friday, January 22, 2016 at 3:29:47 PM UTC-7, Seraaj Muneer wrote: > > Hello everyone again, still taking web2py for a spin but encountering some > really strange errors. > > Here is my data definition > >

[web2py] Re: console.log on page reload?

2015-11-05 Thread Derek
put it in new.html not web2py_ajax On Thursday, October 1, 2015 at 4:54:33 PM UTC-7, Tom Campbell wrote: > > Thank you, Derek, but I'm still flummoxed. I added this new script tag to > web2py_ajax.html: > > console.log('loaded ' + Date.now()) > > But I'm getting this message

[web2py] Re: console.log on page reload?

2015-10-01 Thread Derek
You don't need that, just do this... console.log('loaded ' + date()) On Thursday, October 1, 2015 at 4:01:14 PM UTC-7, Tom Campbell wrote: > > Working on a single-page app and trying to ensure that only part of the > page gets refreshed. Doing some tests using LOAD() that look like this: > >

[web2py] Re: AppAdmin: CSV import bug

2015-09-01 Thread Derek
If your CSV file is not RFC-4180 compliant, I would expect it not to work. RFC-4180 calls for CR+LF linefeeds. Your program may just be outputting a single linefeed without the carriage return. On Monday, August 31, 2015 at 6:00:45 PM UTC-7, Gary Fung wrote: > > worked for me doing the same

Re: [web2py] Re: IronPython support

2015-08-31 Thread Derek
;> get speed up when you render a lot of records? >> >> Richard >> >> On Thu, Aug 27, 2015 at 6:09 PM, Derek <sp1...@gmail.com > >> wrote: >> >>> It gains on complex templated pages, mainly. If you are just accessing >>> databases, you won't

Re: [web2py] Re: IronPython support

2015-08-27 Thread Derek
It gains on complex templated pages, mainly. If you are just accessing databases, you won't get speed increases. If your server is CPU overloaded, switching to PyPy will benefit. On Thursday, August 27, 2015 at 1:05:45 PM UTC-7, Richard wrote: Derek, where is the gain come with PyPy? Just

[web2py] Re: Is there any alternative to Pythonanywhere hosting?

2015-08-26 Thread Derek
You could open a connection to both databases then copy the data over that way. That's what my day job is, transferring data, ETL. On Sunday, August 23, 2015 at 7:49:12 PM UTC-7, Joe wrote: Yes, now I can connect but I wasn't able to connect before. First, I couldn't upload the packaged app

[web2py] Re: folders structure for ajax requests

2015-08-24 Thread Derek
put it in modules and import modules as you need them. On Monday, August 24, 2015 at 6:39:10 AM UTC-7, Dmitri Ermolaev wrote: If I use ajax - it willl load all in /model - menus too but for what? ajax requests need in db + settings - and not need in menu My idea: - make separate folder

[web2py] Re: Ajax callback with current select value

2015-08-14 Thread Derek
That explains why I had to stuff it into a hidden variable or input... cool! On Wednesday, August 12, 2015 at 10:35:47 AM UTC-7, Val K wrote: Yes! Of course! Because there is a small bug in web2py.js in ajax() (or in the manual) : If middle arg ( '[ ]' ) is string, it's treated as

[web2py] Re: web2py exe

2015-08-14 Thread Derek
start it from the command line, what do you see? On Friday, August 14, 2015 at 11:37:11 AM UTC-7, web2py newbie wrote: Hi I recently started coding a python app and decided to explore web2py. however, when I download the windows exe and run it, I see neither the admin console nor the

[web2py] Re: Ajax callback with current select value

2015-08-11 Thread Derek
The only way I found to do it was to set a hidden variable on change of the dropdown. On Tuesday, August 11, 2015 at 8:43:59 AM UTC-7, Gael Princivalle wrote: Hello. I'm still making a form like in this post:

[web2py] Re: File upload/download over https freezes site

2015-07-31 Thread Derek
one interpreted and therefore execution is serialized anyway. For scalability you should have processes (not threads) one per core. On Thursday, 30 July 2015 14:15:36 UTC-6, Derek wrote: looks like that change came from here: https://groups.google.com/forum/#!searchin/web2py/processes$3D1

[web2py] Re: Auth_user dynamic cascading registration fields

2015-07-31 Thread Derek
You will want to take a look at my example here: http://www.web2pyslices.com/slice/show/1724/cascading-dropdowns-simplified let me know if you have questions. You should be able to easily extend it to do multi level cascading. On Tuesday, July 28, 2015 at 3:30:18 PM UTC-7, Wabbajack wrote: I

[web2py] Re: File upload/download over https freezes site

2015-07-30 Thread Derek
looks like that change came from here: https://groups.google.com/forum/#!searchin/web2py/processes$3D1$20threads$3D1|sort:date/web2py/jumZFKX2614/pu-NNXSMKHgJ based on the post from Thomas... Thomas J. 10/3/13 I've recently been comparing Web2py and PHP, this is what i found, maybe it helps:

Re: [web2py] Re: When will we have a proper forum ?

2015-07-30 Thread Derek
I really dislike Discourse. It's a Ruby app, and it requires a ton of addons. It's bloated and slow, and since it uses virtual infinite scroll, it's very difficult to search within discussions. https://www.techfuel.net/pyforum/default/index pyForum is based on web2py, though it looks like the

Re: [web2py] Microservices

2015-07-28 Thread Derek
Micro services are services which you could split the workload onto different servers to handle load. I think for that purpose, you'd want to write in flask or bottle. You could use web2py but I think it's overkill for micro services. On Tuesday, July 28, 2015 at 11:49:36 AM UTC-7, Dave S

[web2py] Re: csv upload limit

2015-07-28 Thread Derek
There's no way. You could modify the 'base.py' of pydal to add it... It looks like it will stop on a line if the whole line is this: END On Sunday, July 26, 2015 at 6:47:47 AM UTC-7, Yebach wrote: Hello How can i limit the number of rows user can upload trough

[web2py] Re: Server CAS

2015-07-21 Thread Derek
Every web2py application is a CAS provider and can optionally be a CAS consumer. So any application you have which uses authentication IS a CAS provider. This is in the book, which you have read. http://web2py.com/books/default/chapter/29/09/access-control On Tuesday, July 21, 2015 at 8:41:06

[web2py] Re: import csv file into table

2015-07-21 Thread Derek
I would first suggest you export to csv (even a blank table) and then you will know the headers you need for your file. On Tuesday, July 21, 2015 at 12:07:34 AM UTC-7, Yebach wrote: Hello I would like to import csv file into a database table - user imports how do you recommend to do it. I

[web2py] Re: Server CAS

2015-07-21 Thread Derek
(the consumer) by simply delegating authentication to the provider: ## in consumer app auth = Auth(db,cas_provider = 'http://127.0.0.1:8000/provider/default/user/cas') On Tuesday, July 21, 2015 at 10:20:21 AM UTC-7, Derek wrote: Every web2py application is a CAS provider and can optionally be a CAS

[web2py] Re: New feature in trunk: API tokens

2015-07-13 Thread Derek
replace the current token system? pros/cons? On Thursday, 9 July 2015 15:02:43 UTC-5, Derek wrote: Yes, I did read up on it, and I am familiar with jwt. I do think it's more insecure than this. On Wednesday, July 8, 2015 at 11:16:43 PM UTC-7, Niphlod wrote: do you know what a jwt token

[web2py] Re: New feature in trunk: API tokens

2015-07-09 Thread Derek
Yes, I did read up on it, and I am familiar with jwt. I do think it's more insecure than this. On Wednesday, July 8, 2015 at 11:16:43 PM UTC-7, Niphlod wrote: do you know what a jwt token is instead of just blindly bashing a solution? On Thursday, July 9, 2015 at 12:25:54 AM UTC+2, Derek

[web2py] Re: my question in posted into this group?

2015-07-09 Thread Derek
first one takes a while, it has to be moderated, after that, they should be immediate. On Thursday, July 9, 2015 at 4:32:28 PM UTC-7, ari wrote: because i cannot see it test -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Re: New feature in trunk: API tokens

2015-07-08 Thread Derek
The only difference between this and jwt (saying jwt tokens is like saying atm machine, it's redundant) is that jwt can be generated client side (provided the client knows the secret) and thus would be less secure than this. On Wednesday, July 8, 2015 at 1:16:31 PM UTC-7, Niphlod wrote:

[web2py] Re: Help with MSSQL Connection

2015-07-02 Thread Derek
Wow, that's great. I tried that a while ago and I had issues. I created issues for the developer but I wasn't aware he had fixed them. https://github.com/denisenkom/pytds/issues/33 I had to use some hacks to get mine to work with TDS, but once I did that, I can use it in pypy, with full

[web2py] Re: pymysql gives Broken Pipe

2015-06-30 Thread Derek
are you on osx perchance? On Tuesday, June 30, 2015 at 3:59:07 PM UTC-7, Ben Lawrence wrote: I am seeing broken pipe errors like this on low volume site using pg8000 on web2py Version 2.11.2-stable+timestamp.2015.05.30.16.33.24 Should we use this http://stackoverflow.com/a/180922/3950334

[web2py] Re: language detecting

2015-06-17 Thread Derek
That may work, but I have multiple accept-languages. I can read in Russian and English, even though I am an American living in USA. Accept-Language values can have multiple values, so by blocking ru-RU you are just blocking anyone who can read russian. here's my header...

[web2py] Re: Basic usage statistics

2015-06-11 Thread Derek
Google has, it's called Google Analytics. There are alternatives out there. You could also use your web server log files. On Thursday, June 11, 2015 at 9:55:18 AM UTC-7, Leonel Câmara wrote: Minor implementation details aside, has anyone came up with a better way to do this?

[web2py] Re: soap client with windows NTLM authorization

2015-06-09 Thread Derek
using the code you provided. But I want to create a SoapClient object based on this SOAP service. I still cannot figure it out yet. On Monday, June 8, 2015 at 5:28:08 PM UTC-4, Derek wrote: a simple monkey patch will do you. I would suggest you don't import into the base namespace though

[web2py] Re: Python framework benchmarks

2015-06-08 Thread Derek
https://github.com/TechEmpower/FrameworkBenchmarks/tree/master/frameworks/Python/web2py It's open source, easy to see, perhaps we can create pull requests for our changes... On Monday, June 8, 2015 at 3:32:27 PM UTC-7, Niphlod wrote: it's the usual weirdo-test. I bet all has been done with

Re: [web2py] Re: Python framework benchmarks

2015-06-08 Thread Derek
I created two pull requests, so it should be a bit faster now. I see it's also storing sessions in the database and logs, no need for that... On Monday, June 8, 2015 at 3:44:04 PM UTC-7, Alfonso de la Guarda Reyes wrote: Massimo, As Derek shows we can change anything and rerun the tests

Re: [web2py] Re: Python framework benchmarks

2015-06-08 Thread Derek
. 991935157 1024D/B23B24A4 5469 ED92 75A3 BBDB FD6B 58A5 54A1 851D B23B 24A4 On Mon, Jun 8, 2015 at 5:27 PM, Derek sp1...@gmail.com javascript: wrote: well, that's not a fair bet, falcon will compile itself with cython if it's available. On Monday, June 8, 2015 at 3:05:05 PM UTC

[web2py] Re: Python framework benchmarks

2015-06-08 Thread Derek
well, that's not a fair bet, falcon will compile itself with cython if it's available. On Monday, June 8, 2015 at 3:05:05 PM UTC-7, Alfonso de la Guarda Reyes wrote: Hello, As I'm finishing a project that requires processing information very quickly (machine learning) and lately i am

[web2py] Re: soap client with windows NTLM authorization

2015-06-08 Thread Derek
() On Monday, June 8, 2015 at 11:45:44 AM UTC-7, Pengfei Yu wrote: Hi Derek, Thanks for your reply! I saw similar source code as well. But there is no document how to set it up using pysimplesoap. Could you provide an example? I tried to use following, but it cannot work. import sys,time

[web2py] Re: Debugging Web2py applications.

2015-06-08 Thread Derek
http://inventwithpython.com/blog/2012/04/06/stop-using-print-for-debugging-a-5-minute-quickstart-guide-to-pythons-logging-module/ It's not difficult to use logging, and that is the correct answer. On Saturday, June 6, 2015 at 2:15:44 AM UTC-7, Niphlod wrote: I'd go with print vars simply.

[web2py] Re: OFF Topic -RiotJS

2015-06-08 Thread Derek
I just hate non-compliant html. I've always been drawn to html compliant templates, like TAL (Template Attribute Language). In any case, I see that it generates html, and it is a lot smaller than the alternatives. I'd be willing to give this a shot. On Monday, June 8, 2015 at 3:02:30 AM UTC-7,

[web2py] Re: soap client with windows NTLM authorization

2015-06-08 Thread Derek
looks like pycurl is supported by pysimplesoap. That supports NTLM. See line 67. https://code.google.com/p/pysimplesoap/source/browse/pysimplesoap/client.py?r=6ed06397b4f0c1894156ee5d0a1c165f80ed6a68 On Monday, June 8, 2015 at 7:28:39 AM UTC-7, Pengfei Yu wrote: Hi, I am trying to access a

[web2py] Re: Resource webservice built on web2py for web2py comunity [BETA]

2015-06-05 Thread Derek
The slider thing on the top moves the content up and down. And it repeats, so it's like trying to use your website on a mexican jeep on it's way to Costa Maya. On Thursday, June 4, 2015 at 2:40:14 PM UTC-7, Ivica Kralj wrote: Hi All, This is my little personal project I have worked on for

[web2py] Re: RuntimeError: no driver available Sybase

2015-06-05 Thread Derek
Your 'drivers.py' isn't looking for 'sybpydb' it's looking for 'Sybase' (hence he's asking you to install the correct package) so it is calling 'import sybase'. You could modify your drivers.py and 'import sybpydb as Sybase' and web2py won't know the difference. You may get errors, you may

[web2py] Re: Silly out of band question about deploying web2py

2015-06-03 Thread Derek
Take a look at OpenShift by Redhat, they do good work. GAE is another PaaS. GAE is probably a good bet, as they also have a key-value store you can use, which you'll need once your site starts scaling outwards unless you store sessions in the database. On Monday, June 1, 2015 at 3:54:54 PM

Re: [web2py] Re: Web2py adding additional and not wanted orderby

2015-06-01 Thread Derek
Yeah, I had to explain that to a few of my coworkers once. If it's faster to give you your data unordered, and you didn't specify an order, you're going to get it in any kind of order. Like if another query before yours returns the exact same data but it's reverse ordered... well, if you do

[web2py] Re: Strip Spaces

2015-05-29 Thread Derek
Yes there are, it's called the 'trim' function. It's part of SQL-92. http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt Postgres, MSSQL, MySQL, SQLite, and Oracle all have rtrim, and ltrim. I think it's widely supported and thus we should support it in DAL. It's easy enough to write a

[web2py] Re: Customizing registration fields for linkedin login

2015-05-29 Thread Derek
What don't you understand? Step 2 - Retrieve basic profile data Once you have obtained a valid access token for the user, you can use the following REST API call to retrieve basic profile data for the user: GET https://api.linkedin.com/v1/people/~?format=json sample api response {

[web2py] Re: how to put a controller name in a var if later want to execute the the controller name

2015-05-27 Thread Derek
cancel_1A=cancel_1B, cancel_2A=cancel_2B))}) uh, you aren't setting 'specificMeetingGroup.id' equal to 10 by doing that, you know... you're setting cancel_1A and your FORM is called without anything assigned to cancel_1B or cancel_2B. On Wednesday, May 27, 2015 at 12:46:58 PM UTC-7, Alex

[web2py] Re: how to put a controller name in a var if later want to execute the the controller name

2015-05-27 Thread Derek
varsdict = dict() varsdict[cancel_1a]=cancel_1b vars=varsdict something like that. On Wednesday, May 27, 2015 at 1:15:56 PM UTC-7, Alex Glaros wrote: you're right Derek so how would have the end result be vars(dict(specificMeetingGroupID=10)) thanks, Alex -- Resources: - http

[web2py] Re: update_record not working but not failing.

2015-05-26 Thread Derek
Well, I suppose you could start by running a profiler on the database to record activity, or you can log all sql statements and see what's going on there. On Saturday, May 23, 2015 at 1:44:25 AM UTC-7, peter wrote: It is in a regular HTTP request. I actually somewhat later when someone

Re: [web2py] Re: Recommended strategy for passing complex query parameters to a REST API

2015-05-22 Thread Derek
you can also simply urlencode it. as json... ?searchcriteria={'date':'5/31/2015','locations':[{'location_name':'Los+Angeles','attendees':10,'services':['Housekeeping','Catering']},{'location_name':'New+York','attendees':5,'services':['Housekeeping']}],'duration':60} On Friday, May 22, 2015 at

[web2py] Re: Using for

2015-05-13 Thread Derek
yea lets look at that... for i in hola... that sets i to 'h' then 'o' then 'l' and finally 'a' and prints each letter to the console. then 'return locals()' i will be 'a' because that's what it was set to last. get it? so if you want hola or aloha... controller: i = 'aloha' return i view:

[web2py] Re: function

2015-05-12 Thread Derek
just call it... function2() you could even define the second function inside the first if you wanted. On Tuesday, May 12, 2015 at 10:07:03 AM UTC-7, KevC wrote: Hi community! I want to call a function inside other function, What can I do? For example: def function_1(): y = 'This is

[web2py] Re: Why web2pyslices.com is down? What we can do?

2015-05-11 Thread Derek
You just can't login with google... On Monday, May 11, 2015 at 8:24:21 AM UTC-7, Carlos A. Armenta Castro wrote: ATENTION: You can acces web2pyslices from the URL: http://web2pyslices.pythonanywhere.com/ I hope in a future we can have a special domain to allocate all the web2py

[web2py] Re: web2pyslicesgate

2015-05-11 Thread Derek
Looks okay, needs to be pruned though as I see mirek posted a bunch of nonsense there. On Sunday, May 10, 2015 at 6:33:33 AM UTC-7, Alan Etkin wrote: I forgot I was the web2pyslices app admin :P BTW: there seem to be some issue about the web2pyslices.com domain, since the one that is

[web2py] Re: web2pyslicesgate

2015-05-11 Thread Derek
zvolsky also. On Monday, May 11, 2015 at 10:43:25 AM UTC-7, Derek wrote: Looks okay, needs to be pruned though as I see mirek posted a bunch of nonsense there. On Sunday, May 10, 2015 at 6:33:33 AM UTC-7, Alan Etkin wrote: I forgot I was the web2pyslices app admin :P BTW: there seem

Re: [web2py] Re: socket.io to connect to tornado websocket

2015-05-01 Thread Derek
package documentation https://atmospherejs.com/joncursi/socket-io-client but it does not work!! dont know why... Iḿ trying to have a meteorjs app connecting to my web2py tornado websockets app any ideas? 2015-04-30 21:18 GMT+01:00 Derek sp1...@gmail.com javascript:: those aren't

[web2py] Re: socket.io to connect to tornado websocket

2015-04-30 Thread Derek
those aren't the same url. don't you need /mygroup1 ? On Tuesday, April 28, 2015 at 3:34:05 AM UTC-7, Ramos wrote: hello i have an app with tornado websockets in the back my webpage has this code web2py_websocket('ws://serverip:12200/realtime/mygroup1') it just works !! now i need to

Re: [web2py] anyone had developed something related to electronic signature in web2py app

2015-04-28 Thread Derek
, Derek wrote: I'd have to agree, put the user account (email, username, whatever) and the fields all together, calculate hmac on that, and store it. If someone changes the data, the hmac won't match and you'll see it's not valid. Of course, an admin could just go in and modify the hmac

Re: [web2py] anyone had developed something related to electronic signature in web2py app

2015-04-28 Thread Derek
I'd have to agree, put the user account (email, username, whatever) and the fields all together, calculate hmac on that, and store it. If someone changes the data, the hmac won't match and you'll see it's not valid. Of course, an admin could just go in and modify the hmac signature after

[web2py] Re: print html page view on dot matrix printer

2015-04-27 Thread Derek
I would suggest using a fixed width font, preferably a font that is installed on the printer. On Monday, April 27, 2015 at 6:13:04 AM UTC-7, 黄祥 wrote: hi, is it possible to print html page view on dot matrix printer using web2py? i've tried it but the result is not expected? the font is

[web2py] Re: Need support for web2py application with over 1 million users.

2015-04-23 Thread Derek
Barring him sharing that information, what general advice can you give regarding this? For example, should you store sessions in redis and setup squid and nginx on the hosts? How do you handle the migrations, etc? On Saturday, April 18, 2015 at 8:26:00 PM UTC-7, Massimo Di Pierro wrote:

[web2py] Re: SQLFORM hanging on insert

2015-04-13 Thread Derek
You may want to run some database consistency checks. I've had that happen when one of my tables was corrupted. On Saturday, April 11, 2015 at 8:16:22 AM UTC-7, Ian W. Scott wrote: Update: When I put together a minimal app I couldn't reproduce the problem. I've had to set aside working on

[web2py] Re: [Request] LDAP/FreeIpa Schema support

2015-04-09 Thread Derek
If you can make your addition more generic, then you can issue a pull request from Github. On Thursday, April 9, 2015 at 6:32:21 AM UTC-7, Vicente Carro wrote: Hi, We had a hard time configuring web2py to authorise using our LDAP/FreeIPa schema. More precisely getting the groups of the

[web2py] Re: Dumb Question - from a real beginner

2015-04-09 Thread Derek
Richard's answer should work, but I just wanted to add, if you put an 'a' link to /btnon it will also call your function. On Thursday, April 9, 2015 at 6:32:21 AM UTC-7, DXX wrote: So im just starting with Python / Web2py i want to do a simple test page to have a button to turn on a led

[web2py] Re: Using ajax to call a function that uses LOAD, not working

2015-04-08 Thread Derek
I don't have an answer, just a comment on the style... This is what you should not do - you're mixing the model, view, and controller into an inconceivable mess. On Tuesday, April 7, 2015 at 7:11:58 AM UTC-7, sasogeek wrote: default.py @auth.requires_login() def load_home(): loader =

Re: [web2py] Database

2015-04-06 Thread Derek
product wouldn't be as secured as MYSQL since its open source. But I do agree with the rest. -Ron On Monday, April 6, 2015 at 12:52:34 PM UTC-4, Derek wrote: I have to take issue with your 'not for production' criticism of sqlite. https://www.sqlite.org/whentouse.html It has changed a lot

[web2py] Re: IronPython support

2015-04-06 Thread Derek
:58 UTC-5, Derek wrote: I tried loading the latest Web2Py in IronPython but I hit a few snags. I've changed the driver module loader to check for an additional error type which gets past the db drivers loader, and now it seems to stop on the rocket.py with some error about a string expected

Re: [web2py] Database

2015-04-06 Thread Derek
I have to take issue with your 'not for production' criticism of sqlite. https://www.sqlite.org/whentouse.html It has changed a lot since 2009 and you should really get familiar with it if you are going to use it. Also, concerning the data types, SQLITE only supports 4 data types. NULL,

Re: [web2py] Re: Design flaw in auth.impersonate ?

2015-04-06 Thread Derek
Chrome allows not just incognito mode, but that little person icon in the upper right by the minimize is 'switch account' and you can use a guest account that's not incognito, which is just perfect for testing out stuff like that. On Monday, April 6, 2015 at 9:02:21 AM UTC-7, Anthony wrote:

[web2py] IronPython support

2015-04-03 Thread Derek
). It's a work in progress... but, it's very encouraging. Thanks, Derek Wilson -- 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: Possible bug report - unicode strings in list:string field generating encode errors

2015-04-03 Thread Derek
Well, test coverage is kind of low, but TravisCI and the like will make sure you don't break something. That's automatic, so generate those pull requests. On Thursday, April 2, 2015 at 10:57:41 PM UTC-7, Tom Stratton wrote: Update - I found the bug reported here:

[web2py] Re: How to properly connect to .css and .js ?

2015-04-02 Thread Derek
ok first of all, you work with your application and you should just modify your db.py, layout.html and etc. You should not worry about not having the same thing as in the scaffolding in the latest versions, because as you are aware, web2py is fully backwards compatible. So if your application

[web2py] Re: sorting ip address

2015-04-02 Thread Derek
Wrong again. You really should just go to sleep. First, you need to convert your IP addresses to decimal representation, then sort them. import socket, struct def ip2long_1(ip): return struct.unpack(!L, socket.inet_aton(ip))[0] On Tuesday, March 31, 2015 at 3:52:51 PM UTC-7, Niphlod

[web2py] Re: LinkedIn API Please help for the love of god.

2015-03-30 Thread Derek
Didn't have to, only used javascript with it. On Friday, March 27, 2015 at 9:18:47 PM UTC-7, DeanK wrote: @Derek - Did you get auth0 integrated with web2py? On Monday, March 2, 2015 at 2:33:59 PM UTC-5, Derek wrote: It would help if you describe what you are doing, some code behind how

[web2py] Re: PythonAnywhere performance is significantly slower than locally

2015-03-26 Thread Derek
nevermind, apparently this conversation was going on on their website and spilled here... they fixed it. https://www.pythonanywhere.com/forums/topic/2087/ On Thursday, March 26, 2015 at 3:01:13 PM UTC-7, Derek wrote: I'm not seeing the slowness. I checked, and maximum time was maybe half

[web2py] Re: PythonAnywhere performance is significantly slower than locally

2015-03-26 Thread Derek
I'm not seeing the slowness. I checked, and maximum time was maybe half a second. Geographically where are you located? On Monday, March 23, 2015 at 7:53:08 PM UTC-7, NeoToren wrote: 1. I have installed the EXACT configuration Web2Py app on MySQL DB with a different email on

[web2py] Re: Best method for storing images from base64 data?

2015-03-26 Thread Derek
I was just looking at this today. No, you don't get anything out of that because you have to process the dataurl from the canvas, because it's not really base64, it's base64 dataURL... first, you remove this from the file: data:image/png;base64, including the last comma. Then, you convert the

[web2py] Re: pyquery, pyjs and web2py

2015-03-24 Thread Derek
http://www.rapydscript.com/ This one seems to be pretty good too. On Tuesday, March 24, 2015 at 12:46:21 AM UTC-7, Massimo Di Pierro wrote: This is the last one I have seen: http://apppyjs.appspot.com/ Anyway, to echo Niphlod. Programming with these systems is a nightmare because you get

[web2py] Re: last minute web2py hackaton

2015-03-24 Thread Derek
I did find a new bug (well, not really a bug but a documentation error that didn't reflect the code in one of the examples) and fixed it in a pull request. Anyway, should have at least a week's notice if you want to pull people into a competition. On Friday, March 20, 2015 at 8:41:16 AM

[web2py] Re: Show busy during AJAX?

2015-03-19 Thread Derek
eh, use an animated gif... http://www.ajaxload.info/ gotta love their license... On Thursday, March 19, 2015 at 5:00:31 PM UTC-7, Dave S wrote: On Wednesday, March 18, 2015 at 10:18:23 PM UTC-7, Dave S wrote: On Wednesday, March 18, 2015 at 7:26:35 PM UTC-7, Leonel Câmara wrote:

[web2py] Re: LinkedIn API Please help for the love of god.

2015-03-02 Thread Derek
It would help if you describe what you are doing, some code behind how you are doing it, and what errors you are having. That said, I've had much success with Auth0. https://auth0.com On Monday, March 2, 2015 at 10:56:36 AM UTC-7, John Costantino wrote: I have been trying to get this to

[web2py] Re: Request vars - basic question

2015-02-20 Thread Derek
It doesn't appear to be a string object anymore, you have a python dictionary object. Try this.. print type(request.vars.input) On Friday, February 20, 2015 at 11:19:55 AM UTC-7, clara wrote: Hello, I am making an Ajax call and calling a controller with the json data I need to process in

[web2py] Re: How to copy and move a file from the admin interface?

2015-02-19 Thread Derek
I thought you could just rename the file and it would move it. ex: file.txt renamed to /static/file.txt would move the file to static. On Thursday, February 19, 2015 at 1:25:48 PM UTC-7, Massimo Di Pierro wrote: Please open a ticket. We should add the funtionality On Wednesday, 18 February

Re: [web2py] Re: Dropdown lists

2015-01-27 Thread Derek
of the html? On Tuesday, January 27, 2015 at 12:13:09 PM UTC-7, Richard wrote: Derek, I understand your point, but from the testing point of view, the only option remaining for testing view is Selenium HQ which is slow, so if you want to be able to test your controller that depend a lot

[web2py] Re: Date format

2015-01-27 Thread Derek
db.mytable.datetime_field.represent = lambda value, row: value.strftime(format-here) (thanks Rocha http://stackoverflow.com/questions/12605934/formating-date-in-web2py-python) see here for the directives to use in 'format-here'...

[web2py] Re: Dropdown lists

2015-01-27 Thread Derek
Well, where do I start? It looks like you are a victim of copy and paste coding. Delete your two functions and start over again. That said, you are mixing your view with your controller, please don't do that. I would suggest you use this web2pyslice as a starting point. (yes, I wrote it)

[web2py] Re: Translate Controller names and Function names

2015-01-27 Thread Derek
Honestly, I have never seen a need for this. Any time I visit a foreign language site, the URL mapping is in english. Chinese, Japanese, Russian, all seem to keep the URL pretty much the same regardless of the language. I can usually hunt my way around a foreign language website by the

[web2py] Re: Dropdown lists

2015-01-27 Thread Derek
create your models in your controllers or views, don't create html in your models or controllers, and don't put logic in models and views. https://www.youtube.com/watch?v=8FWdQVNeTlI On Tuesday, January 27, 2015 at 10:15:50 AM UTC-7, Derek wrote: Well, where do I start? It looks like you

[web2py] Re: What is the best way to add an extra input on the client side?

2015-01-22 Thread Derek
you very much Derek. I've adapted your solution and it works very well. Thanks a lot! That link also helped me get my first ajax button done. Good stuff to be found here, thanks! /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py

[web2py] Re: Mastering web2py DAL

2015-01-22 Thread Derek
expect it on your local bookstore shelf next winter. On Wednesday, January 21, 2015 at 5:57:07 AM UTC-7, Ramos wrote: Hello all I suggest a new book (so few in web2py world) Mastering web2py DAL DAL Its so powerfull and a lot of people dont use it properly. I see a lot of use cases and

[web2py] Re: What is the best way to add an extra input on the client side?

2015-01-15 Thread Derek
I would suggest that you do something similar to what I've done here... http://www.web2pyslices.com/slice/show/1612/ajax-adding-child-records-to-parent On Sunday, January 11, 2015 at 11:18:56 PM UTC-7, Przemysław wrote: Partially solved. Manually added field of the reference type now has a

[web2py] Re: What is the correct parser to use for web2py template HTML files in Eclipse?

2015-01-14 Thread Derek
No, web2py templates do not have to be valid html. If we used TAL then that would be different, but we don't. On Tuesday, January 13, 2015 at 2:45:45 AM UTC-7, Carl Hunter Roach wrote: Eclipse's standard HTML parser kicks our errors and warnings when validating Web2py HTML template files.

[web2py] Re: lazy question: does anyone have a simple backbone.js/web2py example or tutorial?

2015-01-14 Thread Derek
I suppose you haven't seen 'DataTables.net' ? On Wednesday, January 14, 2015 at 2:06:54 PM UTC-7, Tim Richardson wrote: I'd like to use more javascript in my form grid apps, to get more use of ajax. This won't work unless I can get equivalent to SQLFORM.grid, which is great for someone as

[web2py] Re: routes.py and current.T

2015-01-14 Thread Derek
So it looks like you'd need to implement this closer to the webserver than web2py. it is available in a header, Accept-Language. You could build a middleware and run web2py as a WSGI app. On Wednesday, January 14, 2015 at 3:58:01 AM UTC-7, alex wrote: Is it possible to use current.T in

[web2py] Re: Don't use 64 bit ODBC with Web2Py and SQL Server

2015-01-14 Thread Derek
So have you tried to use pypyodbc? If that doesn't work, you could use pytds and bypass odbc altogether. On Tuesday, January 13, 2015 at 5:06:37 PM UTC-7, Pbop wrote: Spent days trying to track down an error with a Web2Py app and SQL Server 2008 R2 running 64 bit ODBC drivers. Switched to

[web2py] Re: How would one design a promotion for products using web2py?

2015-01-07 Thread Derek
I think I would handle it by creating a controller function which calculates a price given the objectid and quantity, it returns the line item price per single item and price total together as well as the percentage saved (if any). the code in that function would probably change for every

[web2py] Re: javascript problem (in load called via response js)

2015-01-07 Thread Derek
Well, it could be ordering. Dependencies in javascript are difficult. You may want to use RequireJS. What's probably happening is that this script is running before jqx-all is loaded completely. You might also change your $(document).ready() into $(window).load() to give the rest of the files

[web2py] Re: How would one design a promotion for products using web2py?

2015-01-07 Thread Derek
UTC-7, Dave S wrote: On Wednesday, January 7, 2015 10:25:05 AM UTC-8, Derek wrote: I think I would handle it by creating a controller function which calculates a price given the objectid and quantity, it returns the line item price per single item and price total together as well

[web2py] Re: Web2py query relevance rank

2015-01-07 Thread Derek
Yeah, I don't think you'd want to do this in python anyway, it's more efficient to let the server handle that, as it has optimizations that we can't use. On Tuesday, January 6, 2015 3:47:41 PM UTC-7, Massimo Di Pierro wrote: No. :-( On Tuesday, 6 January 2015 12:23:49 UTC-6, Ruud Schroen

Re: [web2py] Re: Rocket // HTTP 400 Bad Request - Body is incomplete

2015-01-06 Thread Derek
Just a question, Amon, do you need to use Rocket, or can you use anyserver.py and try something like greenlets? On Saturday, January 3, 2015 4:56:54 PM UTC-7, Louis Amon wrote: I've tested the native error handler (working fine) versus my custom error handler (generating HTTP 400 error +

Re: [web2py] Re: Rocket // HTTP 400 Bad Request - Body is incomplete

2015-01-06 Thread Derek
Yeah, this is strange, I wonder why Rocket reports it's version as 1.2.6 when the latest version of Rocket is 1.2.4? On Monday, December 29, 2014 11:19:55 AM UTC-7, Louis Amon wrote: This is the request received by my ticket handler (I removed some big chunks so that it's readable):

[web2py] Re: javascript problem (in load called via response js)

2015-01-06 Thread Derek
make sure it's loading jqx. It doesn't appear to be. did you put it in a folder 'js' inside the static files? mixing javascript and web2py's templating system should be discouraged if it's not already. It's bad practice to have web2py write your javascript for you. it may be that the mix

  1   2   3   4   5   6   7   8   9   >