[web2py] Re: web2py with SSL is not starting

2013-04-17 Thread Marko Poutiainen
I finally figured this out (yesterday was my second night trying to get this to work). It was the Linux firewall. I added a few lines to iptables and after that I could open the admin panel. It's not my server so I was unaware that iptables was even installed. Sorry for this. At least I now kn

Re: [web2py] Re: REF: Component + Javascript

2013-04-17 Thread Teddy Nyambe
The button has a href="#mymodal" calling a modal window. What I want is to pass an ID to the modal window. I have a LOAD() in the modal window. so in essence the situation is i have a grid listing with each row a button, then click a button calls a modal window which has a {{=LOAD('c','a', args='x'

[web2py] Re: list:string type field output format

2013-04-17 Thread 黄祥
thank you so much for your hints niphlod and anthony, i've tried both of your hints, but the result is not what i'm expected (no error occured) {{=SPAN(T('Email : '), XML(', '.join([A(email, _title=T('Send Email'), _target='_blank', _href='mailto:%s' % email).xml() for email in row.email])

[web2py] Re: web2py with SSL is not starting

2013-04-17 Thread Massimo Di Pierro
More than the log we need to see the apache config file. Do you have a lsef signed certificate? Do you have a virtual host for post 443? Are you using the same domain as in the certificate? On Wednesday, 17 April 2013 15:05:29 UTC-5, Marko Poutiainen wrote: > > I can't seem to get HTTPS connecti

[web2py] Re: Install in hostgator

2013-04-17 Thread Diogo Munaro
Thx man! You help me a lot!! Em sábado, 14 de maio de 2011 01h21min13s UTC-3, José Eloy escreveu: > > Hello! > > Recently a customer bought a hosting plan (business) with hostgator. > I'm developing for him a web2py application, I have doubts of how to > deploy it. Somebody can help me? The app

[web2py] web2py with SSL is not starting

2013-04-17 Thread Marko Poutiainen
I can't seem to get HTTPS connection to start so that I could use the admin panel. I have been trying various things but nothing seems to work. Host name is www2.olka.fi and it works through HTTP. I do get Reloading web server config: apache2apache2: Could not reliably determine the server's

[web2py] Getting SSL to work with web2py

2013-04-17 Thread Marko Poutiainen
Sorry if this is a double post by I posted this question 10 minutes ago and still can't see the original post. I have been trying to get SSL to work with web2py so that I can access the admin panel. Now I'm running out of ideas. I attached the logs that I get when I reload Apache to this messag

[web2py] Re: Where did the auth_user table go (v. 2.4.x) that used to be in db.py

2013-04-17 Thread Anthony
Are you talking about in the "welcome" scaffolding application? In there, auth.define_tables(...) automatically defines the auth_user table (always has). If you just want to add fields, no need to manually define the whole table -- instead use auth.settings.extra_fields (see http://web2py.com/b

[web2py] Where did the auth_user table go (v. 2.4.x) that used to be in db.py

2013-04-17 Thread wdtnh
I need to modify the auth_user table to add a field. It used to be in db.py file? Where is it defined now? thanks -- --- 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

[web2py] Re: help with css

2013-04-17 Thread LightDot
Well, of course bootstrap-responsive.min.css integration is where the problem is... But it can't just be removed, welcome app being responsive, in other words mobile ready, is a widely used feature. Alan's first reply is absolutely correct in assessing the problem. I actually noticed this while

[web2py] Re: list:string type field output format

2013-04-17 Thread Anthony
Sorry, wasn't thinking -- you could do: {{=SPAN(T('Email : '), XML(', '.join([A(email, _title=T('Send Email'),_target ='_blank', _href='mailto:%s' % email).xml() for email in row.email])), _id= 'email_%s' % i)}} Anthony On Wednesday, April 17, 2013 5:12:26 PM UTC-4, 黄祥 wrote: > > thank yo

[web2py] Re: Alternative to SQLFORM for Angular

2013-04-17 Thread Alan Etkin
> My main concern is that web2py's form validation and security features are really useful but would clash with the angular way of doing > things. It seems to me that the way to get the two working together would be to create an alternative to FORM/SQLFORM/CRUD that > instead of generating HTML

[web2py] Re: help with css

2013-04-17 Thread Mark
bootstrap-responsive.min.css caused the problems. Maybe the whole bootstrap need to be re-configured. Removed response.files.append(URL('static','css/bootstrap-responsive.min.css')) from layout.html will fix most of the problems. Mark On Saturday, April 13, 2013 5:29:39 PM UTC-4, Massimo Di P

[web2py] Re: Excellent Video about web2py but no sound or subtitles

2013-04-17 Thread Rufus
I'm only 5 minutes into it, and I had to reply! It is great to be "watching over the shoulder" of a person who knows what he (or she) is doing! I can't wait to watch the rest -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubs

[web2py] Re: Can somebody hack a user tracker and download counter for us ?

2013-04-17 Thread Niphlod
/me shows Anthony some love... On Wednesday, April 17, 2013 11:29:00 PM UTC+2, Anthony wrote: > > So, the latter, then? > -- --- 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,

[web2py] Re: list:string type field output format

2013-04-17 Thread Niphlod
yep, html helpers aren't properly "strings", so they can't be joined with a simple ','.join() However, you can do it with the CAT (from conCAT) try SPAN(T('Email'), CAT([A(email) for a in emails])) On Wednesday, April 17, 2013 11:12:26 PM UTC+2, 黄祥 wrote: > > thank you so much for your hin

[web2py] Re: Can somebody hack a user tracker and download counter for us ?

2013-04-17 Thread Anthony
So, the latter, then? On Wednesday, April 17, 2013 5:07:27 PM UTC-4, smoggy wrote: > > Just saying that if there is somebody with some free time and in need of a > challenge that would be great. It would also further enhance our beloved > web2py. You people are so judgmental these days. > > Terç

[web2py] Re: Using SQLFORM.grid with large datasets

2013-04-17 Thread Niphlod
check trunk as soon as the Pull Request gets merged def test3(dbset, request_vars): ##you can retrieve the current query with ##dbset._select(), i.e. dbset is a "db(query)" object ##request_vars are the current request.vars ###so you can check for keywods etc etc etc ###c

[web2py] could web editor highlight py syntax in templates (not just html)?

2013-04-17 Thread Jurgis Pralgauskis
Hi, I thought w2p templates are very similar to PHP idea. and that was one of the reasons, why php became so popular -- starting to develop was very simple -- everything in one file. in this supposition, I thought - I can give it for (very) introductory web dev. and *if the web editor would

Re: [web2py] bootstrap interface builder

2013-04-17 Thread 黄祥
+1 -- --- 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 https://groups.google.com/groups/opt_out.

[web2py] Re: list:string type field output format

2013-04-17 Thread 黄祥
thank you so much for your hint anthony, it seems must be string type, when i try to use your hints it return an error *not work* {{=SPAN(T('Email : '), ', '.join([A(email, _title=T('Send Email'), _target='_blank', _href='mailto:%s' % email) for email in row.email]), _id='email_%s'

[web2py] Re: Can somebody hack a user tracker and download counter for us ?

2013-04-17 Thread smoggy
Just saying that if there is somebody with some free time and in need of a challenge that would be great. It would also further enhance our beloved web2py. You people are so judgmental these days. Terça-feira, 16 de Abril de 2013 22:24:03 UTC+1, Anthony escreveu: > > Are you saying you don't kno

Re: [web2py] Re: Alternative to SQLFORM for Angular

2013-04-17 Thread Richard Vézina
There is validate_and_insert() and validate_and_update(), never use them but was planning to... So I don't know if they return error that you could exploit in angular and the retroaction can become weird I don't know you may have a read about those methodes Richard On Wed, Apr 17, 2013 at 4:19 P

[web2py] Re: response.menu args

2013-04-17 Thread Robin Manoli
The second argument here tells whether this menu item is active or not. Setting this to true adds the class="web2py-menu-active" to the li of the menu-item. Unfortunately though, this class is not implemented by default in web2py, and nor is the argument set to (request.function=='index') which

[web2py] Re: Alternative to SQLFORM for Angular

2013-04-17 Thread Niphlod
on the widgets part, nobody did anything (or, in other words, even if it did, he/she didn't share with us). On the "serialize values as json" shouldn't be hard, but you must hook up your angular model with the data. Same thing goes for errors. On the "receive a json string and use those values to

[web2py] Alternative to SQLFORM for Angular

2013-04-17 Thread RHC
I have recently been exploring the possibilities of AngularJS and so far it looks like a great framework for interactive forms and general data editing. I would love to use it with web2py as I love the way web2py works and much prefer python to javascript :-) My main concern is that web2py's fo

Re: [web2py] bootstrap interface builder

2013-04-17 Thread Alec Taylor
Not bad! Also I should mention that there are quite a few players in this market; using Twitter Bootstrap as base. On Thu, Apr 18, 2013 at 3:37 AM, Massimo DiPierro wrote: > http://www.layoutit.com/ > > -- > > --- > You received this message because you are subscribed to the Google Groups > "web

Re: [web2py] bootstrap interface builder

2013-04-17 Thread Richard Vézina
Awesome! Richard On Wed, Apr 17, 2013 at 2:15 PM, Ovidio Marinho wrote: > Very,very Good +1 > > > > > Ovidio Marinho Falcao Neto > Web Developer > ovidio...@gmail.com >83 8826 9088 - Oi >83 9336 3782 - Claro >

Re: [web2py] Re: Return value from javascript to controller

2013-04-17 Thread Niphlod
ok. There was an error in your code, a double call to process() . But there was also on my end: when you do in the same function that shows the form a fast_tz_detector(), basically you trigger a POST request that "updates" the formkey associated with the form. Blame on me that use LOAD() al

Re: [web2py] Re: EmberJS is the web2py of the client! :)

2013-04-17 Thread Alec Taylor
FYI: The presenter/author has published his examples using metawidget and AngularJS to generate forms: http://files.meetup.com/4966012/Metawidget%20AngularJS%20Examples.zip On Wed, Apr 17, 2013 at 7:12 AM, Niphlod wrote: > > > On Tuesday, April 16, 2013 10:38:11 PM UTC+2, Magnitus wrote: >> >> We

[web2py] Re: SQLFORM.factory

2013-04-17 Thread Domagoj Kovač
This works: {{=form.custom.label[asset_class_attribute. asset_attribute_id.name]}} {{=form.custom.widget[asset_class_attribute. asset_attribute_id.name]}} Thanks! -- --- You received this message because you are subscribed to the Google Groups "web2py-

Re: [web2py] bootstrap interface builder

2013-04-17 Thread Ovidio Marinho
Very,very Good +1 Ovidio Marinho Falcao Neto Web Developer ovidio...@gmail.com 83 8826 9088 - Oi 83 9336 3782 - Claro Brasil 2013/4/17 Massimo DiPierro > http://www.layoutit.com/ > > -- > > ---

[web2py] Re: SQLFORM.factory

2013-04-17 Thread Domagoj Kovač
Thanks guys! I will try it. -- --- 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 https://groups.goo

[web2py] bootstrap interface builder

2013-04-17 Thread Massimo DiPierro
http://www.layoutit.com/ -- --- 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 https://groups.google

[web2py] Re: Multiple session objects being created for the same client IP

2013-04-17 Thread Massimo Di Pierro
It could be. On Wednesday, 17 April 2013 10:23:45 UTC-5, Yarin wrote: > > 10 4 Massimo I will upgrade and update you guys on what I find. I wonder > also if that bug has something to do with the mysql locking issue I > describe here, which first started manifesting itself in March, a few days

Re: [web2py] Re: AppStats doesn't work in my App. [GAE]

2013-04-17 Thread Christian Foster Howes
the appstats overhead is imposed all by things under the covers in GAE. even google recommends that you use it for testing and debugging and turn it off for production use. sorry i don't have a better answer. cfh On 4/17/13 0:05 , José Manuel López wrote: Thank you Christian!. Now it works.

Re: [web2py] Re: Return value from javascript to controller

2013-04-17 Thread Funmanhk
Hi Niphlod, As always, thanks for your help. I do not think I got an explicit error this time. However, the input is not taken. When I clicked submit, the page blink and showed me a blank "Add" page. Regards, On 17 Apr, 2013, at 23:05, Niphlod wrote: > I'll try that again verbatim in a few

Re: [web2py] Re: Python Redis Queue

2013-04-17 Thread Niphlod
does this work when queueing, e.g. a function defined in models ? Last time I checked all my "jobs" needed to be in a separate modulemaybe the method used to implement the same thing with celery can be used for that. On Wednesday, April 17, 2013 6:03:40 PM UTC+2, Ricardo Pedroso wrote: > >

Re: [web2py] Re: Python Redis Queue

2013-04-17 Thread Ricardo Pedroso
On Tue, Apr 16, 2013 at 12:26 AM, Tito Garrido wrote: > Nice! Is it working? Is there an example of application? I just put on github one example (https://github.com/rpedroso/rqdboard). It has the rq-dashboard (https://github.com/nvie/rq-dashboard) "ported" to web2py. Ricardo -- --- You rec

[web2py] Re: how to insert default value into controller

2013-04-17 Thread Alex Glaros
thanks everyone ... worked great db.Party.partyTypeID.default = 1 ## just above where the function started Alex On Wednesday, April 17, 2013 8:10:12 AM UTC-7, Anthony wrote: > > def add_new_person(): > > ## form.vars.partyTypeID.default = 1### tried this >> > > The "form" variable d

[web2py] Re: SQLFORM.factory

2013-04-17 Thread Anthony
> {{name = asset_class_attribute.asset_attribute_id.name > }} > {{=form.custom.label.name}} > {{=form.custom.widget.name}} > > {{=form.custom.label[name]}} {{=form.custom.widget[name]}} Or maybe simplify as follows: In the controller:

[web2py] Re: Multiple session objects being created for the same client IP

2013-04-17 Thread Yarin
10 4 Massimo I will upgrade and update you guys on what I find. I wonder also if that bug has something to do with the mysql locking issue I describe here, which first started manifesting itself in March, a few days after the first 'orphan records' began appearing... https://groups.google.com/d/

[web2py] Re: how to insert default value into controller

2013-04-17 Thread Anthony
> > def add_new_person(): ## form.vars.partyTypeID.default = 1### tried this > The "form" variable doesn't even exist yet. Also, form vars are just values, they are not DAL Field objects, so they do not have a "default" attribute. > db.auth_user.partyID.readable = db.auth_u

[web2py] Re: SQLFORM.factory

2013-04-17 Thread Niphlod
prepare a list of "name"s and return that to make it usable in the view then {{for nm in name:}} {{=form.custom.label['nm']}} {{=form.custom.widget['nm']}} {{pass}} On Wednesday, April 17, 2013 5:01:08 PM UTC+2, Domagoj Kovač wrote: > > Hi, > > i am trying to make a form with dinamic f

Re: [web2py] Re: Async Web3Py ?

2013-04-17 Thread Ricardo Pedroso
I'm didn't follow this discussion closed enough, probably what I have to say was already said, but ... > So essentially, if you run web2py on-top of tornado's I/O-loop, you should > be able to use these YieldPoint classes within the controller-actions. I guess not, but I may be wrong. Using web2p

Re: [web2py] Re: Return value from javascript to controller

2013-04-17 Thread Niphlod
I'll try that again verbatim in a few hours (as soon as I get my hands on a pc with python ^_^) and report back. PS: what error does the form return ? On Wednesday, April 17, 2013 2:40:25 PM UTC+2, fun man wrote: > > Hi Niplod, > > It still behaves similarly. > > 1) fast_tz returns None, > 2) t

[web2py] Re: how to insert default value into controller

2013-04-17 Thread Niphlod
wouldn't a simple db.Party.partyTypeID.default = 1 resolve all your problems ? I didn't understand if you want that one or the one in the auth_user table, but the gist should be clear enough. On Wednesday, April 17, 2013 4:58:01 PM UTC+2, Alex Glaros wrote: > > Tried 4 different places and m

Re: [web2py] how to insert default value into controller

2013-04-17 Thread Richard Vézina
You may also consider using a request, just to remind what 1 mean : db.Party.partyTypeID.default = db(db.auth_user.email == 'email').select( db.auth_user.id).first().id Richard On Wed, Apr 17, 2013 at 11:02 AM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > db.Party.partyTypeID.default

[web2py] Re: Multiple session objects being created for the same client IP

2013-04-17 Thread Massimo Di Pierro
There was a buggy version that was doing this. Could have been 2.2.1. Not sure. Please upgrade to the latest. The reason is that is was saving sessions even when data was not stored/changed. Therefore is the cookie was not returned it would start making new session files/records. On Wednesday,

Re: [web2py] how to insert default value into controller

2013-04-17 Thread Richard Vézina
db.Party.partyTypeID.default = 1 At the begining of your fucntion should work Richard On Wed, Apr 17, 2013 at 10:58 AM, Alex Glaros wrote: > Tried 4 different places and methods to get the number "1" into > field partyTypeID. What is the correct syntax? > > thanks, > > Alex Glaros > > def ad

[web2py] SQLFORM.factory

2013-04-17 Thread Domagoj Kovač
Hi, i am trying to make a form with dinamic fields and i am using SQLFORM.factory. I have a table where i have a list of fields in my form. in my controller i have: fields = [] for asset_class_attribute in asset_class_attributes: field_name = asset_class_attribute.

[web2py] how to insert default value into controller

2013-04-17 Thread Alex Glaros
Tried 4 different places and methods to get the number "1" into field partyTypeID. What is the correct syntax? thanks, Alex Glaros def add_new_person(): ## form.vars.partyTypeID.default = 1### tried this db.auth_user.partyID.readable = db.auth_user.partyID.writable = False ##

[web2py] Re: Multiple session objects being created for the same client IP

2013-04-17 Thread Anthony
I was thinking of service requests, but that shouldn't generate session entries anyway as long as the session isn't changed during the request. Anthony On Wednesday, April 17, 2013 9:29:56 AM UTC-4, Yarin wrote: > > Anthony- what type of requests would those be? Are you referring to > browsers

Re: [web2py] Re: Return value from javascript to controller

2013-04-17 Thread fun man
Hi Niplod, It still behaves similarly. 1) fast_tz returns None, 2) the "submit" button to the db was not taken, and the still ask me to fill out the form again. This is my updated controller. def test(): fast_tz = fast_tz_detector() #create a new appt form = SQLFORM(db.sometable).pro

[web2py] Re: Multiple session objects being created for the same client IP

2013-04-17 Thread Yarin
Anthony- what type of requests would those be? Are you referring to browsers with cookies disabled? For example, this is happening on my own IP, and my browser's cookies are not disabled. On Wednesday, April 17, 2013 9:26:14 AM UTC-4, Anthony wrote: > > Are clients making any kind of requests t

[web2py] Re: Multiple session objects being created for the same client IP

2013-04-17 Thread Yarin
2.2.1 On Wednesday, April 17, 2013 9:16:41 AM UTC-4, Massimo Di Pierro wrote: > > Which web2py version? > > On Wednesday, 17 April 2013 08:08:48 UTC-5, Yarin wrote: >> >> (This question stems from an issue first brought up >> here

[web2py] Re: Multiple session objects being created for the same client IP

2013-04-17 Thread Anthony
Are clients making any kind of requests that don't send cookies? On Wednesday, April 17, 2013 9:08:48 AM UTC-4, Yarin wrote: > > (This question stems from an issue first brought up > here > ) > > We store user sessions in the

Re: [web2py] Re: Async Web3Py ?

2013-04-17 Thread Arnon Marcus
Just notices, I was writing SAP instead of SPA the whole time... :) I get what you are saying - the underlying unspoken agenda here, is this : "Web2py should remain Pure-Python in it's default implementation" This places us on a discussion that is assuming a threaded-deployment, as it is also th

Re: [web2py] Re: SQLFORM create / edit / delete help (I feel like I've hit a wall)

2013-04-17 Thread Jim Steil
You can use custom forms with .grid also. No limitations there. Jim On Apr 17, 2013 8:13 AM, "Anthony" wrote: > On Tuesday, April 16, 2013 4:07:53 PM UTC-4, Trevor Overman wrote: > >> I looked at SQLFORM.grid, but to me it seemed limited to styling options. >> I may be completely wrong and just

[web2py] Re: Multiple session objects being created for the same client IP

2013-04-17 Thread Massimo Di Pierro
Which web2py version? On Wednesday, 17 April 2013 08:08:48 UTC-5, Yarin wrote: > > (This question stems from an issue first brought up > here > ) > > We store user sessions in the DB using the web2py_session_{app} table. > I

[web2py] Re: Newbie Tables Question

2013-04-17 Thread Anthony
On the client side, you can handle the UI changes using Javascript/Ajax. The problem is modeling the data in the DAL and the database. If there aren't too many distinct attributes across the types of items, you can use a single database table as usual, only populating the fields that are releva

[web2py] Re: SQLFORM create / edit / delete help (I feel like I've hit a wall)

2013-04-17 Thread Anthony
On Tuesday, April 16, 2013 4:07:53 PM UTC-4, Trevor Overman wrote: > I looked at SQLFORM.grid, but to me it seemed limited to styling options. > I may be completely wrong and just not know how to do it correctly. If you can't achieve what you want with the standard arguments to the grid method

[web2py] Re: "MySQL server has gone away" errors happening more and more with db-based sessions?

2013-04-17 Thread Yarin
Yes- I've documented this issue in a new question - please see: https://groups.google.com/d/msg/web2py/A7P4HoST-Lg/NZ3kmTTwVG0J On Wednesday, April 17, 2013 3:08:38 AM UTC-4, Niphlod wrote: > > everyone with a different unique_key ? > > On Wednesday, April 17, 2013 12:43:35 AM UTC+2, Yarin wrote

[web2py] Multiple session objects being created for the same client IP

2013-04-17 Thread Yarin
(This question stems from an issue first brought up here ) We store user sessions in the DB using the web2py_session_{app} table. Inspecting the table, we've noticed a strange pattern happening over and over again: Many of

[web2py] Re: Using SQLFORM.grid with large datasets

2013-04-17 Thread Niphlod
currently not but it is planned to be configurable (at the very minimum, cacheable). Your method BTW works only if all the table is shown, doesn't take into account a possible condition passed to the grid (such as db.table.user_id == auth.user_id) or keyword queries. I'll start working on tha

[web2py] Re: SQLFORM create / edit / delete help (I feel like I've hit a wall)

2013-04-17 Thread Anthony
> > I think I've gotten the model down now correctly. Would you have any > advice with the controller and views ? I know the way I'm doing it now with > a nested for loop and counter probably isn't the best way. Maybe there is a > much better way to do this instead of defining the edit and dele

[web2py] Old DAL bug (?) ValueError: invalid literal for int() with base 10: 'AssetTypes\\Character.png'

2013-04-17 Thread Arnon Marcus
We are using an old version of web2py in production (1.89.5), and are having issues with the DAL: if limit: return db().select(db[table].ALL,orderby=db[table][orderby],limitby=(0,limit)) File "C:\wamp\www\web2py_1_89_5\gluon\sql.py", line 3307, in select return self.parse(db, rows, sel

[web2py] Re: REF: Component + Javascript

2013-04-17 Thread Niphlod
are you sure that the button has not yet an event attached that prevents your "custom" one ? On Wednesday, April 17, 2013 12:15:03 PM UTC+2, software.ted wrote: > > I have a component am loading in a > > {{=A('Link to comp', component=URL('research', 'mycomponent.load'), > target='setting-cont

Re: [web2py] Re: REF: Component + Javascript

2013-04-17 Thread Teddy Nyambe
No luck, still quiet no activity. How can i debug jQuery? On Wed, Apr 17, 2013 at 12:20 PM, Niphlod wrote: > you're attaching a jquery event to an element that when the script is > executed is not yet present (it's loading...) > > try to rewrite your > > > jQuery('#mp_257').click(**function(

[web2py] Re: list:string type field output format

2013-04-17 Thread Anthony
You have to make a comma-separated list of A()'s instead of inserting all the email addresses in a single mailto: ', '.join([A(email, _title=T('Send Email'), _target='_blank', _href='mailto:%s' % email) for email in row.email]) Anthony On Wednesday, April 17, 2013 3:41:02 AM UTC-4,

[web2py] Re: SQLFORM create / edit / delete help (I feel like I've hit a wall)

2013-04-17 Thread 黄祥
> Field('complete_address', 'string', > compute=lambda r: '%(address)s %(city)s %(location_state)s > %(zipcode)s' % r) > > for complete_address, in terms of performance or efficiency, what is the difference between store it in table field or just format it in view side? best regards --

[web2py] Re: Newbie Tables Question

2013-04-17 Thread 黄祥
i think it can be achieve in the view part by jquery. e.g. i assume you use sqlform.grid with the table food and have the table field food_type (requires=IS_IN_SET('Pizza', 'Steak')) and field specific_food *default/food.html* {{extend 'layout.html'}} {{=grid}} jQuery(document).ready(function

[web2py] Using SQLFORM.grid with large datasets

2013-04-17 Thread Johann Spies
By large datasets I mean a database of which one of the tables contain more than 42 million records. Using SQLFORM.grid on such a dataset is very slow because the process wants to count the total number of records. I am using Postgresql. I can get an estimated size of the table by replacing coun

[web2py] Re: REF: Component + Javascript

2013-04-17 Thread Niphlod
you're attaching a jquery event to an element that when the script is executed is not yet present (it's loading...) try to rewrite your jQuery('#mp_257').click(function(){ jQuery('#test').html('Test') //alert("Test") }) to jQuery(document).on('click', '#mp_257', function(){

[web2py] Excellent Video about web2py but no sound or subtitles

2013-04-17 Thread António Ramos
http://vimeo.com/8229814 -- --- 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 https://groups.google

[web2py] Newbie Tables Question

2013-04-17 Thread Doug Girard
I want to create a form which I can add multiple 'items' of different 'types' that have different 'attributes' For example, lets use two types of food, pizza and steak You would start by selecting the type of food. Say pizza Upon selecting this type you would get more form fields, specific to t

[web2py] REF: Component + Javascript

2013-04-17 Thread Teddy Nyambe
I have a component am loading in a {{=A('Link to comp', component=URL('research', 'mycomponent.load'), target='setting-content')}} in this same view page i have a jQuery('#mp_257').click(function(){ jQuery('#test').html('Test') //alert("Test") }) The component has a button

[web2py] Customizing login form

2013-04-17 Thread Aydin S
I am trying to customize the location and appearance of the login form. I am looking for the easiest way to do this. I am using return dict(login=auth.login()) in my default.py and {{=login} in my html. I have tried couple of things posted in here, but I found them vague and not quite understan

[web2py] Re: Check if exist table (dal)

2013-04-17 Thread damufo
Hi, Thanks. My solution was: if self.table_name not in db._migrated: self.install() Best regards. On Tuesday, April 16, 2013 3:31:12 PM UTC+2, dam...@gmail.com wrote: > > > Hi, > In my init class have a install() with create table. > When creates second instance, fail. > >

[web2py] Re: list:string type field output format

2013-04-17 Thread Niphlod
then you want to have 2 separate A, one for each email! On Wednesday, April 17, 2013 9:41:02 AM UTC+2, 黄祥 wrote: > > it seems can not make it work for the link, i've tried both, but same > result > {{=SPAN(T('Email : '), A(', '.join(row.email), _title=T('Send Email'), > _target='_blank', _href='

[web2py] Re: list:string type field output format

2013-04-17 Thread 黄祥
it seems can not make it work for the link, i've tried both, but same result {{=SPAN(T('Email : '), A(', '.join(row.email), _title=T('Send Email'), _target='_blank', _href='mailto:%s' % row.email), _id='email_%s' % i)}} {{=SPAN(T('Email : '), A(db.branch.email.represent(row.email), _title=T('Send

[web2py] Re: Queries with AND in GAE

2013-04-17 Thread José Manuel López
!!! OMG . I'm developing in two languages (client and server) same time and it's giving me crazy :/ Thank you Niphlod. On Wednesday, April 17, 2013 9:00:19 AM UTC+2, Niphlod wrote: > > db((condition) & (condition)).select() > is the way to do it: you're doing > db(condition and condition).selec

Re: [web2py] Re: Return value from javascript to controller

2013-04-17 Thread Niphlod
that's exactly what I tested yesterday evening... can you please try to strip out the next=URL('index') part ? It's the only thing that is different. On Wednesday, April 17, 2013 4:14:58 AM UTC+2, fun man wrote: > > Hi Niphlod, > > I downloaded the new one, and copied the files over. Keeping my o

[web2py] Re: "MySQL server has gone away" errors happening more and more with db-based sessions?

2013-04-17 Thread Niphlod
everyone with a different unique_key ? On Wednesday, April 17, 2013 12:43:35 AM UTC+2, Yarin wrote: > > OK, now I've run into some special weirdness- I don't know if it's > related, but it makes no sense to me: > > When I run a count of session records grouped by client IP, I get some > very big

Re: [web2py] Re: AppStats doesn't work in my App. [GAE]

2013-04-17 Thread José Manuel López
Thank you Christian!. Now it works. Any clues to low the overhead? On Tuesday, April 16, 2013 6:28:30 PM UTC+2, Christian Foster Howes wrote: > > ahhh yes...i remember. given that appstats, while helpful for testing, > has a significant performance overhead (200ish ms per request i think), > a

[web2py] Re: Queries with AND in GAE

2013-04-17 Thread Niphlod
db((condition) & (condition)).select() is the way to do it: you're doing db(condition and condition).select() On Wednesday, April 17, 2013 8:52:09 AM UTC+2, José Manuel López wrote: > > I'm trying to make a very simple query: > > offersInRange= db(db.Offer.hotel == request.vars.hotel > anddb.Off