[web2py] Re: Error mysql

2013-02-20 Thread Niphlod
if auth tables are yet in the db, no need to create them auth.define_table(,migrate=False) Alternatively, let the app create the .table files auth.define_table(.,fake_migrate=True) hit the appadmin once, then auth.define_table(...) On Wednesday, February 20, 2013 8:24:41 AM UTC+1, Has

[web2py] Re: Fatal problem with date field, SQLite and DAL - german/czech date format

2013-02-20 Thread Mirek Zvolský
I am very sorry for this thread. I am not sure about the reason of problems. I have now few web2py versions here (include 2 copies of 2.3.2-src) and proper code with date formatting, which however fails with one copy of 2.3.2-src versions. So it looks like there were problems with date formattin

Re: [web2py] Re: Cannot get a to update, once form inputs have been successfully processed and Ajax used.

2013-02-20 Thread Ann Gledson
Hi No it would appear that the $.post is not fired. I replaced the code with $form.submit(function(){ alert("Hello - the form.submit ran"); $.post($(this).attr('action'), $(this).serialize(), function(response){ alert("Hello - the post ran"); },'json'); return fa

[web2py] Re: a spreadsheet-like-table for user inserting data

2013-02-20 Thread Filipe S.
Hi! thanks a lot for your reply, i'm trying to implement your answer but i'm having a couple of issues for which i'm not sure what's the solution. your code reads: form = FORM(SELECT(*[OPTION() for f in ], _name="function"), table) There's two things here i don't understand: first,

Re: [web2py] Re: web2py and google app engine

2013-02-20 Thread Jeremiah Gordon
I must be going crazy, but there isn't a gaehandler.py file anywhere in the web2py I downloaded. I am using the Windows version if that makes any difference. I've tried downloading a new copy just to make sure I didn't accidentally delete it, but I still can't find any gaehandler file. How are p

Re: [web2py] Re: web2py and google app engine

2013-02-20 Thread Niphlod
Windows version is a compiled binary, can't be run on anything else than the included webserver. Download the source code, gaehandler.py will be there. On Wednesday, February 20, 2013 1:41:43 PM UTC+1, jjg0 wrote: > > I must be going crazy, but there isn't a gaehandler.py file anywhere in > the

Re: [web2py] Re: Cannot get a to update, once form inputs have been successfully processed and Ajax used.

2013-02-20 Thread Niphlod
console.log("whatever") will print in the debugger "whatever" without the "ugly" alert. Chrome dev extension, Explorer developer tools, firefox log, firebug, etc all work fine with console.log(). At this point try to log (or to "alert") $(this).attr('action'), $(this).serialize() and see if th

[web2py] Re: a spreadsheet-like-table for user inserting data

2013-02-20 Thread Alan Etkin
> > Hi! thanks a lot for your reply, i'm trying to implement your answer but > i'm having a couple of issues for which i'm not sure what's the solution. > <...> are placeholders for whatever function names and list object you are handling. I can think of two options: The first <...> is f act

Re: [web2py] Re: web2py and google app engine

2013-02-20 Thread Jeremiah Gordon
The Windows one can't run on anything else? That solved all the problems I was seeing! The source code works much better, thanks everyone. On Wed, Feb 20, 2013 at 7:48 AM, Niphlod wrote: > Windows version is a compiled binary, can't be run on anything else than > the included webserver. > > Do

Re: [web2py] Re: web2py and google app engine

2013-02-20 Thread Niphlod
it's a binary, you get what's compiled in it and anything else. On Wednesday, February 20, 2013 2:08:52 PM UTC+1, jjg0 wrote: > > The Windows one can't run on anything else? That solved all the problems > I was seeing! The source code works much better, thanks everyone. > > On Wed, Feb 20, 2013

[web2py] Re: ajax update session data

2013-02-20 Thread Anthony
On Wednesday, February 20, 2013 1:10:32 AM UTC-5, 黄祥 wrote: > thank you so much for your hints anthony. > actually i'm still confuse about session.order.get(id, 0), on book only > have connect, secure and forget, so that i'm so lack of information what is > session can do. > session is a Storag

[web2py] Loading component is quite slow?

2013-02-20 Thread Loïc
Hello All In my application I use the LOAD helper to insert a component in my page. The component is a simple form that allows user to subscribe to the newsletter. When I refresh the page, I see a "loading..." message during 2 or 3 seconds, and then my component is loaded. As my component is

[web2py] Re: login by ajax

2013-02-20 Thread yashar
this is what i added in tools.py inside auth class, this is just modification of login() function and difference from main login_bare is this one also check, creates and logs in users which authenticated with other authentication methods. def ajax_login_bare(self, username, password):

[web2py] Re: ajax update session data

2013-02-20 Thread 黄祥
a, i understand right now, thank you for detail explaination, anthony. after now that, i still have a question def order_update(): id=int(request.vars.id) qty=int(request.vars.qty) session.order.get(id, 0)=qty session.order[id]=session.order.get(id, 0) return locals() why in

[web2py] [Newbee] - Error message with plugin_Wiki : 'auth' not defined

2013-02-20 Thread openoc80
Hi all, I am beginner in Web2Py and I like it much. I have tried some applications, like InstantPress... all is very interesting. But when I want (after installation) run the plugin_Wiki in the applications's liste, I have one ticket that gives this error message : Traceback (most recent call

[web2py] Re: ajax update session data

2013-02-20 Thread Anthony
The .get() method retrieves values from a dict -- you cannot use it for assignments. Anthony On Wednesday, February 20, 2013 9:10:26 AM UTC-5, 黄祥 wrote: > > a, i understand right now, thank you for detail explaination, anthony. > after now that, i still have a question > > def order_update():

[web2py] Re: ajax update session data

2013-02-20 Thread 黄祥
a, i c, so that's why it returns an error on the page. so is there a way to set the session value? i'm trying to do it with session.order.get(id, 0)*0+qty is not work too. my goal is to update the value with the user input value in the field. thank you so much in advance -- --- You received

[web2py] Re: ajax update session data

2013-02-20 Thread Anthony
Why not just session.order[id] = qty? On Wednesday, February 20, 2013 9:49:14 AM UTC-5, 黄祥 wrote: > > a, i c, so that's why it returns an error on the page. so is there a way > to set the session value? > i'm trying to do it with session.order.get(id, 0)*0+qty is not work too. > my goal is to up

[web2py] callback target in two places

2013-02-20 Thread 黄祥
hi, is it possible for callback target in two places? *e.g. 1. not work* {{for id, qty in order.items():}} {{p=db.product(id)}} {{=SPAN(p.product_name)}} {{=SPAN('Rp. %s' % p.unit_price)}} {{=SPAN(qty, _id='item_%s' % p.id)}} {{=SPAN(qty*p.unit_price, _id='t

[web2py] Re: ajax update session data

2013-02-20 Thread 黄祥
not worked. i've already tried it, i'm trying to figure it out why it not work, but still can find the reason on the book. any idea about this? thank you very much -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this

[web2py] Re: Loading component is quite slow?

2013-02-20 Thread Anthony
That seems slow. Are there other components on the page? On Wednesday, February 20, 2013 8:46:47 AM UTC-5, Loïc wrote: > > Hello All > > In my application I use the LOAD helper to insert a component in my page. > The component is a simple form that allows user to subscribe to the > newsletter. >

[web2py] Re: ajax update session data

2013-02-20 Thread Anthony
Rather than simply saying something didn't work, it helps if you can explain in more detail exactly what you expected and what happened instead. Did you get an error? How do you observe that it "didn't work"? On Wednesday, February 20, 2013 10:03:56 AM UTC-5, 黄祥 wrote: > > not worked. i've alrea

[web2py] Re: callback target in two places

2013-02-20 Thread Anthony
No, you cannot have two targets (even if you could, your attempted syntax of providing two "target" keywords in a single function call would be illegal in Python). However, you can specify ":eval" as the target, in which case the callback function can return Javascript code that does whatever y

[web2py] Re: callback target in two places

2013-02-20 Thread Niphlod
no. target is supposed to be a unique element. -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit

[web2py] Re: callback cannot redirect

2013-02-20 Thread Anthony
Your first example is working because you are not using an Ajax callback -- the link is just a regular request for a full page. You second example doesn't redirect the whole page because the callback is an Ajax request -- so, the redirect just returns the redirect output as the Ajax response, an

[web2py] Re: Loading component is quite slow?

2013-02-20 Thread Loïc
No, this is the only component in the page... Just to be sure, I have tried to load my component with ajax=False {{=LOAD('default', 'newsletter.load', ajax=False)}} In this case, the component loads instantly. (but of course I can not submit my form since ajax=False) Le mercredi 20 février 2013 1

[web2py] Re: ajax update session data

2013-02-20 Thread 黄祥
no error occured, i'm expected to update the quantity value through form fields that user enter. nothing change, even after i refresh the page (F5), the value in quantity form field and in span is not update. i'm not sure what is running when i'm update the quantity form field and then press TAB

[web2py] VirtualFields on select options

2013-02-20 Thread Felipe Meirelles
Hi, Just found a bug in validators.py, line 468. If I use a virtualfield to format the select options, it will drop an exception, trying to order the select by de virtual field. Can you patch it in trunk? from gluon.dal import FieldVirtual fields = filter(lambda f: type(f) != FieldVirtual, fie

[web2py] Re: Loading component is quite slow?

2013-02-20 Thread Niphlod
Windows on the default rocket webserver ? session locking on that combo is pretty damn slow (OS fault, but still...) On Wednesday, February 20, 2013 4:28:10 PM UTC+1, Loïc wrote: > > No, this is the only component in the page... > Just to be sure, I have tried to load my component with ajax=False

[web2py] Re: callback cannot redirect

2013-02-20 Thread 黄祥
a, thank you so much for your detail info, anthony. i've tried it but still not work (no error occured), but what i'm expected to clear the session data is not achieve. i'm not sure why this is happened. *#controller : default.py* def order_callback(): id=int(request.vars.id) if request.

[web2py] Re: Setting up memcache on GAE - a basic question

2013-02-20 Thread Andy W
many thanks - a great help as always! Andy On Wednesday, February 20, 2013 2:43:31 AM UTC+4, howesc wrote: > > sorry about my typo. i can never remember as_dict! > > for my views i generally access the objects as dictionaries, using the > ['key'] notation. if you like you may cast the items ba

[web2py] browser question

2013-02-20 Thread Hector Magnanao
Is there a way to specify a different browser when I launch web2py ? -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. F

[web2py] Re: [Newbee] - Error message with plugin_Wiki : 'auth' not defined

2013-02-20 Thread Paolo valleri
Hi Pibol, plugin_wiki is now deprecated, use auth.wiki() instead. http://web2py.com/books/default/chapter/29/03?search=auth.wiki#The-built-in-web2py-wiki paolo On Wednesday, February 20, 2013 3:17:42 PM UTC+1, open...@gmail.com wrote: > > Hi all, > > I am beginner in Web2Py and I like it much. I

[web2py] Re: callback target in two places

2013-02-20 Thread 黄祥
yes, you're right niphlod, i'm realize it right now, thank you so much. thank you for your guide, anthony, yet, the value is not updated. no errors occured, but when i tried to hit the button add , the value is still same even after i refresh it. i'm not sure why it's not responding what i've ex

[web2py] Re: browser question

2013-02-20 Thread Luca Zacchetti
Do you mean to start it in a browser different form the default-system one? Il giorno mercoledì 20 febbraio 2013 16:52:49 UTC+1, Hector Magnanao ha scritto: > > Is there a way to specify a different browser when I launch web2py ? -- --- You received this message because you are subscribed to

[web2py] Re: suggestion for markmin qr to use google chart

2013-02-20 Thread 黄祥
just want to share the qr code using google chart, hope after it embed into markmin, the code is much simplified. *#view* {{for i,row in enumerate(rows):}} {{full_address=row.address+', '+row.city+', '+row.country}} {{=SPAN(A(full_address, _title=T('View Maps'), _target='_blank', _href='http://m

[web2py] Re: suggestion for markmin qr to use google chart

2013-02-20 Thread Niphlod
on the matter, infographics of the chart api is officially deprecated and, according to this https://developers.google.com/chart/terms?hl=it , will work until April 2015. Beware for long term projects. -- --- You received this message because you are subscribed to the Google Groups "web2py-u

[web2py] Re: browser question

2013-02-20 Thread Hector Magnanao
Yes, that's what i want On Wednesday, February 20, 2013 10:01:44 AM UTC-6, Luca Zacchetti wrote: > Do you mean to start it in a browser different from the default-system one? > > Il giorno mercoledì 20 febbraio 2013 16:52:49 UTC+1, Hector Magnanao ha > scritto: >> >> Is there a way to specify a

[web2py] Re: callback target in two places

2013-02-20 Thread Anthony
> > if request.vars.action=='add': *"jQuery('item_%s' % p.id).session.order[id]=session.order.get(id, > 0)+1;"* > "jQuery('total_%s' % p.id).session.order[id]=session.order.get(id, > 0)+1;" > First, the above isn't actually returning anything -- it just creates two

[web2py] Re: browser question

2013-02-20 Thread Niphlod
currently the browser is started with the help of the webbrowser lib https://github.com/web2py/web2py/blob/master/gluon/widget.py#L125 Feel free to send a patch, although I can't see the need for such customization. -- --- You received this message because you are subscribed to the Google Gr

[web2py] Re: callback cannot redirect

2013-02-20 Thread Anthony
Well, for starters, your link passes the value "empty" in the action variable, but your order_callback() function tests for the value "reset" -- there is no condition for "empty". On Wednesday, February 20, 2013 10:43:24 AM UTC-5, 黄祥 wrote: > > a, thank you so much for your detail info, anthony.

[web2py] Re: Loading component is quite slow?

2013-02-20 Thread Anthony
You can submit a form with ajax=False as long as you have ajax_trap=True. Still, I don't see why it should take 2-3 seconds to load. I was wondering if the session was being locked by some other request (e.g., another component on the page), but doesn't sound like that's the problem. Anthony O

[web2py] Re: ajax update session data

2013-02-20 Thread Anthony
The process involves multiple steps -- activity on the server, followed by Javascript updates in the UI. If the UI doesn't update as expected, there is no reason to believe the problem must be with the code on the server -- the problem may be with the Javascript. I believe your code is updating

[web2py] Create a total row in a SQLFORM

2013-02-20 Thread José Manuel López Muñoz
Hi, I want to make a table with a simple query and finally a row with the result of a SUM. I'm over GAE. Is there a way to do it with SQLFORM or I have to do a table manually with a Total Row?. Thank you -- --- You received this message because you are subscribed to the Google Groups "web

[web2py] Re: Loading component is quite slow?

2013-02-20 Thread Loïc
*Niphlod* Yes I'm working on Windows (7 pro x64) with the default rocket webserver. I have tried to deploy my application on my webserver (ubuntu server + nginx). The loading time is better but I still have to wait about 1 second to see the content of my component. *Anthony* I did'nt know ajax_t

[web2py] Re: Loading component is quite slow?

2013-02-20 Thread Derek
ajax loading probably waits for the whole page to finish rendering before it loads the component. On Wednesday, February 20, 2013 11:01:22 AM UTC-7, Loïc wrote: > > *Niphlod* > Yes I'm working on Windows (7 pro x64) with the default rocket webserver. > I have tried to deploy my application on my

[web2py] Re: Loading component is quite slow?

2013-02-20 Thread Anthony
With ajax=False (the default), the component is constructed on the server at the same time as the containing page and simply inserted into the page before it is delivered to the browser -- so there is no separate Ajax request for the component -- it is created and rendered along with the contai

[web2py] Re: VirtualFields on select options

2013-02-20 Thread Felipe Meirelles
I was using a outdated version of web2py, in the new version the line is 511 On Wednesday, February 20, 2013 12:42:05 PM UTC-3, Felipe Meirelles wrote: > > Hi, > > Just found a bug in validators.py, line 468. > > If I use a virtualfield to format the select options, it will drop an > exception, t

[web2py] Re: suggestion for markmin qr to use google chart

2013-02-20 Thread 黄祥
a, thanks for the info niphlod, do you know others url that can parse the url, that is free? thank you -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to we

[web2py] Re: Error mysql

2013-02-20 Thread samuel bonilla
look: db = DAL('*mysql://root:@localhost/hasaad', migrate=False*) ready El miércoles, 20 de febrero de 2013 02:24:41 UTC-5, Hassan Alnatour escribió: > > Dear ALL , > > Am trying to connect to a mysql database but am getting this error , how > can i solve this problem : > > connection st

[web2py] Re: movu.ca site timeout

2013-02-20 Thread samuel bonilla
alan, movuca esta fuera de funcionamiento hace mucho, las noitificaciones que te manda hacen parte de el kernel de movuca (https://github.com/rochacbruno/Movuca/blob/master/modules/datamodel/notification.py) tienes que decirle a bruno que cambien o edite el archivo modules/datamodel/notificati

Re: [web2py] Re: Error mysql

2013-02-20 Thread samuel bonilla
the best way for migrate is: db = DAL('*mysql://root:@localhost/hasaad', migrate=True*) for migrate all table... 2013/2/20 samuel bonilla > look: > > db = DAL('*mysql://root:@localhost/hasaad', migrate=False*) > > ready > > El miércoles, 20 de febrero de 2013 02:24:41 UTC-5, Hassan Alnatou

[web2py] Need for '/index/args' following controller to grab 'args'?

2013-02-20 Thread Alec Taylor
Is there some method—e.g.: rewriting/specifying-in the routes—that will allow me to grab 'args' from '/controller_name/args' rather than having to use '/controller_name/index/args'? (this will result in much cleaner URLs for my users/clients) Thanks for all suggestions, Alec Taylor PS: I have

[web2py] very important! we need to help Python

2013-02-20 Thread Cliff Kachinske
This situation can affect developers in the USA also. If this trademark is granted, you will need to eliminate any mention of Python if a visitor to your site has an IP address in the EU. Please check out the link Massimo posted at the start of this thread and contribute if you have any of the

[web2py] Keyed tables and str references?

2013-02-20 Thread Alec Taylor
I have a bunch of tables, for simplicity lets say: db.define_table('foo', Field('foo_id'), # str Field('bar', 'reference haz.haz_id'), primarykey=['foo_id'] ) db.define_table('haz', Field('haz_id'), # str Field('foo_id', 'reference foo.foo_id'), primarykey=['haz_id'] ) (a

[web2py] what is the name of an uploaded file using sqlform.factory?

2013-02-20 Thread Tim Richardson
web2py 2.3.2 on windows With this, i can save files form = SQLFORM.factory(Field("Stocktake_date","date"), Field("Description_of_stocktake","string",length= 60), Field('spreadsheet_upload','upload', uploadfolder=os.pa