[web2py] Re: using legacy mysql tables

2013-10-12 Thread James Thompson
Thanks! It works now. On Saturday, October 12, 2013 2:13:48 AM UTC-10, Niphlod wrote: > > did you add a format= attribute for the referenced table ? > > > > On Saturday, October 12, 2013 4:28:15 AM UTC+2, James Thompson wrote: >> >> I tried it without the dotted notation, it gets rid of the error

[web2py] Re: web2py!!!

2013-10-12 Thread chicks
Yeah, I thought of doing the processing and admin interfaces in web2py on dept servers. Unfortunately they're Solaris, so can't (easily) mount corp drives, even if I could get the permissions, and break through several firewalls... Sigh. Just have to bite the bullet and learn some PHP framewo

[web2py] Re: how to avoid committing sensitive data to github?

2013-10-12 Thread Niphlod
or just prepare a nice bash script (or even better, a fabfile) to deal with "fetch updates from vcs, move them into production". I usually keep "replacements" in the private folder, and that folder is added to .gitignore. On Saturday, October 12, 2013 10:52:33 PM UTC+2, Michael Herman wrote: > >

[web2py] Re: auth.change_password() - no flash message

2013-10-12 Thread Anthony
Is there any code in the settings function or view that could be clearing the session flash or somehow removing/overriding the flash? auth.change_password sets session.flash before the redirect, so session flash should get moved into response.flash after the redirect. Anthony On Saturday, Octo

[web2py] Re: auth.change_password() - no flash message

2013-10-12 Thread lesssugar
OK, I removed next from auth.change_password(). Now, after submitting, I'm being redirected to default/index and the default flash message appears. The thing is I would like to stay on Settings page after changing the password - hence I tried next. Is there a way to change the default redirect

[web2py] Re: auth.change_password() - no flash message

2013-10-12 Thread Anthony
auth.change_password() does a redirect when you specify "next", so you can't set anything after calling it. However, instead you can just do: auth.messages.password_changed = 'Your custom flash message' Of course, there is already a default message set ("Password changed."), so if you're not se

Re: [web2py] Re: web2py!!!

2013-10-12 Thread Michele Comitini
Can't you launch anything from PHP? http://www.php.net/manual/en/refs.fileprocess.process.php http://www.php.net/manual/en/function.system.php maybe something slipped through security checks... ;-) 2013/10/12 chicks > Yes, it's IIS7. The only access I have to the web server is a Windoze > sha

[web2py] Re: web2py!!!

2013-10-12 Thread LightDot
Wildly brainstorming here: you could use the web2py to do everything on your departmental servers (blog, data representation, reports, etc.), then use web2py to automatically generate everything as static html and automatically upload the generated files to the IIS7 share. Not sure this is the

[web2py] auth.change_password() - no flash message

2013-10-12 Thread lesssugar
I'm using auth_change_password() in my profile Settings section. The code responsible for the form: change_password = auth.change_password(next=URL('seafarer', 'settings')) change_password.update(_class='formstyle', _name='change_password') return dict(change_password=change_password) The form

[web2py] Re: Best way to migrate from sqlite to postgresql (or other db)

2013-10-12 Thread Michael Herman
Or you can try it the long, round about way - http://www.realpython.com/blog/python/web2py-migrating-from-sqlite-to-mysql/#.Ulm3xmTTXCU On Friday, October 11, 2013 6:14:43 PM UTC-6, François Delpierre wrote: > > Hi, > > For performance reason I would like to migrate my DB from sqlite to > postg

[web2py] Re: web2py!!!

2013-10-12 Thread chicks
Yes, it's IIS7. The only access I have to the web server is a Windoze share, so can only copy files to it, can't launch anything from command line, as I have no access to it. :( This is megacorp, with 60K worker bees, so IT is very strict about what can and can't be run on these hosts. I have

[web2py] Re: how to avoid committing sensitive data to github?

2013-10-12 Thread Michael Herman
You can handle this in a number of way. Probably the easiest is just to use global variables for all your sensitive info and place them in config file. Then just add that config file to your .gitignore file. On Saturday, October 12, 2013 2:24:23 PM UTC-6, stefaan wrote: > > Hello all, > > When c

Re: [web2py] Decrypt base64 and insert image in db

2013-10-12 Thread Michele Comitini
for 3. you may find some reference here https://developer.mozilla.org/en-US/docs/Web/API/FileReader?redirectlocale=en-US&redirectslug=DOM%2FFileReader#readAsBinaryString() 2013/10/12 Michele Comitini > I do not understand exactly what the code does, but here is what I would > try: > 1. Don't

Re: [web2py] Decrypt base64 and insert image in db

2013-10-12 Thread Michele Comitini
I do not understand exactly what the code does, but here is what I would try: 1. Don't use GET use a POST 2. Use a binary post see: https://developer.mozilla.org/en-US/docs/Web/API/XMLHttpRequest/Sending_and_Receiving_Binary_Data 3. use binary strings in javascript 4. use a bjson library 2013/10/

[web2py] how to avoid committing sensitive data to github?

2013-10-12 Thread stefaan
Hello all, When creating web2py applications, are there any "best practices" regarding ensuring you don't push sensitive data (e.g. email password) to github by accident? Do people test using new email addresses that were created specifically for testing web apps? Or perhaps someone has develop

[web2py] Re: IMAP: Insert email to Sent folder

2013-10-12 Thread Alan Etkin
> > OK, I have uploaded my code: > https://code.google.com/p/web2py/issues/detail?id=1707 > When you add the binary file data as read from the stream to the attachment payload without base64 encoding, you'll get the EOF imaplib error. I'll upadate the web2pyslices recipe to do the payload encod

[web2py] Re: web2py!!!

2013-10-12 Thread 黄祥
http://en.wikipedia.org/wiki/Comparison_of_web_application_frameworks#Comparison_of_features please take a look for consideration. best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.googl

Re: [web2py] Re: web2py!!!

2013-10-12 Thread Michele Comitini
I suggest Niphlod approach: install web2py for win binary. Or use a virtualization with linux, you will be able to access the MSSQL without problems. Since the guy that is asking you to do the job is using it to make optimization of business process he will listen carefully if you explain to him t

[web2py] Re: web2py!!!

2013-10-12 Thread LightDot
You just said "Windows, SQL Server, and zero support for Python", which doesn't even tell us which web server (I assume IIS?) and other tech do you have available. Do you even have PHP? I had good experience with CakePHP some years ago, but haven't followed PHP frameworks that closely since. An

[web2py] Re: web2py!!!

2013-10-12 Thread User
Woah if you're on Windows and can't use python I wouldn't choose PHP as my first choice. Try C#/ASP.NET with either webforms or mvc ( http://www.asp.net/mvc). You can use free Visual Studio express IDE. Very easy/powerful development IMO and a large community with plenty of examples. If you'

Re: [web2py] Re: sqlform.grid boolean field search doesn't return any rows

2013-10-12 Thread Adnan Smajlovic
done: http://code.google.com/p/web2py/issues/detail?id=1718 On Sat, Oct 12, 2013 at 2:33 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Can you please open a ticket about this? > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/

[web2py] web2py binary contest

2013-10-12 Thread Niphlod
Hi all, in the near future web2py will build binaries using bbfreeze instead of py2exe. We noticed a few shortcomings of py2exe (it's kinda old, latest release is dated november 2008) and start wondering if there were better tools for the job. In the latest two weeks, I tested bbfreeze and mana

[web2py] Re: web2py!!!

2013-10-12 Thread Niphlod
are you allowed to use the binary version ? no python needed, all the beauty of web2py available :P On Saturday, October 12, 2013 8:14:53 PM UTC+2, chicks wrote: > > I've been using web2py for a couple of years now for an intranet site for > our small department of about 20. Absolutely love its

[web2py] Re: web2py!!!

2013-10-12 Thread Massimo Di Pierro
Thanks. I personally do not know. Look into CakePHP and perhaps ask there. They may have a suggestion. On Saturday, 12 October 2013 13:14:53 UTC-5, chicks wrote: > > I've been using web2py for a couple of years now for an intranet site for > our small department of about 20. Absolutely love its

Re: [web2py] Re: sqlform.grid boolean field search doesn't return any rows

2013-10-12 Thread Massimo Di Pierro
Can you please open a ticket about this? On Saturday, 12 October 2013 09:27:45 UTC-5, Adi wrote: > > Thanks Massimo. I'm talking about the automatic search query above > smartgrid that gets created when boolean field is selected as a filter. It > gets created as table.field = "on". So that one w

[web2py] Re: html2canvas to db

2013-10-12 Thread Ruud Schroen
I keep getting this error: GET http://localhost:8000/ezwireframes/wireframe/update/1?data=data%3Aimage%2Fp…BQpYBSsMrLbtEECBAgQIAAAQIECBAgQIAAAQI1C%2FwGTQp2HFGzKI0ASUVORK5CYII%3D

[web2py] Decrypt base64 and insert image in db

2013-10-12 Thread Ruud Schroen
Hi. I posted a topic earlier about html2canvas to db. Now i got a new issue so i figured i'd start a new thread. html2canvas takes a screenshot of all the content inside a div and creates a canvas which acts as the image. After that the canvas is converted to a base64 code. I send this code a

Re: [web2py] Re: auth, redirect after login

2013-10-12 Thread Junior Phanter
Sorry to ask, but you went through a recent update of web2py, more precisely the version 2.6.x to version 2.7.x? If you recently updated, you must copy the file web2py.js the admin folder and appadmin.html from welcome application to your application. 2013/10/12 LightOfMooN > Thanks, but it

[web2py] web2py!!!

2013-10-12 Thread chicks
I've been using web2py for a couple of years now for an intranet site for our small department of about 20. Absolutely love its intuitive design, the built-in IDE, the ease of database interaction, basically everything about it. Massimo, you are brilliant! Now, I've been tasked with building

Re: [web2py] Re: sqlform.grid boolean field search doesn't return any rows

2013-10-12 Thread Adnan Smajlovic
Thanks Massimo. I'm talking about the automatic search query above smartgrid that gets created when boolean field is selected as a filter. It gets created as table.field = "on". So that one works, but != "on" doesn't seem to work. On 2013-10-11 11:25 PM, "Massimo Di Pierro" wrote: > there are th

Re: [web2py] Re: onvalidation upload size

2013-10-12 Thread __pyslan__ - Ayslan Jenken
Gosh! Of course I should!! Thanks! On Fri, Oct 11, 2013 at 7:41 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > If you read the file (csv.reader(sent_file) or sent_file.readlines(), > etc.) you then have to rewind it: > > sent_file.seek(0) > > > > > On Tuesday, 23 July 2013 21:18:0

Re: [web2py] Re: codemirror tabbing problem

2013-10-12 Thread Roberto Perdomo
Dont be angry, only write us, and we help to solve your suggestions. For now, codemirror have the extrakeys option "indentMore" but the "IndentLess" is missing. Thanks for reporting, I have tested and sent a pull request to add "IndentLess" 2013/10/12 LightOfMooN > fixed by adding extraKeys i

[web2py] Re: codemirror tabbing problem

2013-10-12 Thread LightOfMooN
fixed by adding extraKeys in admin/views/edit.html: CodeMirror.defaults.extraKeys["Tab"] = "indentMore"; CodeMirror.defaults.extraKeys["Shift-Tab"] = "indentLess"; вторник, 5 марта 2013 г., 20:19:48 UTC+6 пользователь LightOfMooN написал: > > How to disable wrong codemirror smart-tabbing? It real

[web2py] Re: using legacy mysql tables

2013-10-12 Thread Niphlod
did you add a format= attribute for the referenced table ? On Saturday, October 12, 2013 4:28:15 AM UTC+2, James Thompson wrote: > > I tried it without the dotted notation, it gets rid of the error message, > but > in the admin interface it shows raw integer values for the foreign key > fields

[web2py] Re: windows script to run locally

2013-10-12 Thread Niphlod
no need... there's taskkill... @echo off set QCURDIR=%~dp0 set QWEB2PY_PORT=2024 set QWEB2PY_PID_FILE="%CURDIR%httpserver.pid" set QWEB2PY_PASSWORD="password" set QWEB2PY_APP=welcome set QWEB2PY_PATH="%~dp0web2py.py" start "web2py_server" python.exe %QWEB2PY_PATH% -a %QWEB2PY_PASSWORD% -p % QWEB2

[web2py] Re: windows script to run locally

2013-10-12 Thread step
Some options. In Windows you can run TASKEND to kill a process by pid or process name. Getting the pid using just standard Windows commands is complicated, though. You could download the freeware pstools suite from www. sysinternals.com and feel more at home. Pstools is a collection of command-li

[web2py] Re: onselect ajax...

2013-10-12 Thread Avi A
Shame to say but Bingo! It nicely works now :). Thank you very much. On Saturday, October 12, 2013 3:36:59 AM UTC+3, Derek wrote: > > perhaps you didn't save the echo.html in the proper folder? > > On Friday, October 11, 2013 5:34:56 PM UTC-7, Derek wrote: >> >> Pretty strange. My example as sho

[web2py] Re: windows script to run locally

2013-10-12 Thread Tim Richardson
If you install the git for windows binary, you end with an excellent bash shell full of tools (like sleep). Since it's great to have git anyway, this may be something worth thinking about. On Saturday, 12 October 2013 01:18:04 UTC+11, Carlos Cesar Caballero Díaz wrote: > > Hi, sometimes I need

[web2py] Re: Blank screen from app/admin/edit button

2013-10-12 Thread Paolo Caruccio
just sent a patchon issue tracker. Il giorno sabato 12 ottobre 2013 02:07:40 UTC+2, Dave S ha scritto: > > > > On Friday, October 11, 2013 12:02:55 PM UTC-7, Paolo Caruccio wrote: >> >> Thank you Dave S for testing my code. >> I r