[web2py] Re: ordering request.vars for PayPal IPN

Hi Simon, I've got a live system working with PayPal. Here's my handler: def ipn_handler(): parameters = request.vars if len(request.vars.keys()) > 0: params = "cmd=_notify-validate&" + urllib.urlencode(parameters) headers = {"Content-type": "application/x-www-form-urlenco

[web2py] Re: MSSQL connection error

the best answer to that threat is freetds which I actually have had success from Linux but is it supported by web2py? On Thursday, July 18, 2013 5:26:33 PM UTC-7, Niphlod wrote: > > plenty of references around the web it's a PITA to connect to MSSQL > from a linux "client" but take advices

[web2py] Re: MSSQL connection error

will try. Thanks!!! On Thursday, July 18, 2013 3:30:09 PM UTC-7, Marcio Andrey Oliveira wrote: > > Hi. > > I have no experience with web2py but it seems it's not able to read some > file. > > Try to use strace command to determine what file is missing then you can > search on the net which pa

[web2py] Re: Inner join and left join in a many to many relationship

I think I've figured it out. I just needed one left join, but with the two arguments in the ON clause: query = ((db.likes.like_score!=-1) | (db.likes.like_score==None)) rows = db(query).select(db.songs.ALL, db.auth_user.id, db.likes.like_score, left=db.likes.on((db.likes.songname == db.songs

[web2py] Re: Serve images from action call or web service call

This is definitely the way, only 3 changes I made for it to work: 1. added reques object to the response 2. set attachment to False 3. send image id using vars instead of args urllib quoted, using args gave me too much trouble with slashes and plus signs return response.stream(s

[web2py] Re: Serve images from action call or web service call

-- --- 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.

Re: [web2py] real time graph

Dear Vera, In web world, "real-time" means javascript. See this [1] and this [2] questions at stackoverflow, this example [3] with node.js library and the library gRaphael [4] as starting points. [1] - http://stackoverflow.com/questions/4602755/raphael-js-and-real-time-graph [2] - http://stackove

[web2py] Re: Concatenating datetime

please don't rely on undocumented features of dal. this may work in a database but not on another one, or may stop working from one web2py release and not in another. There's no support for substrings or slices of fields or even default conversions between datetimes and string representations i

[web2py] Re: Web2py bootstrap modal with jquery datetimepicker not working after AJAX post

this is a common issue even with "tabbed" content, if you don't know how to hook up events. That's why on the default web2py.js there's a method to reinitialize all hooks between inputs and the default calendar widget... you just need to hook up in the correct way your ones. The issue (again, ha

[web2py] Re: MSSQL connection error

plenty of references around the web it's a PITA to connect to MSSQL from a linux "client" but take advices even related to other programming languages to fix the odbc driver "bugs" and "intricacies", like http://stackoverflow.com/questions/10728290/mssql-servers-native-odbc-driver-for-linux-

Re: [web2py] Re: Mobile and Tablets detection

I get the "tell me more" argument, but if you fire up web2py and just try it, you'll find those things on your own if you just use request.user_agent(). You can even find out that the scaffolding application make use of this by default inspecting request.user_agent().is_mobile flag to render a

[web2py] Re: weird bug with redis

seems a more general problem within the os than a bug with web2py and redis. although I'm a heavy user of redis, I never encountered that error. this http://askubuntu.com/questions/142508/how-to-fix-5-no-address-associated-with-hostname-error-while-updating is just a reference on a similar error

[web2py] real time graph

hi everyone, I need some help, does anyone have examples on how to do a "real time graph". What I need is a graph to constantly show random numbers, I´m using matplotlib I already have this info: from Antonis Tzorvas an idea for a "real-time approach" graph you have to go with gifs generated b

[web2py] Re: MSSQL connection error

Hi. I have no experience with web2py but it seems it's not able to read some file. Try to use strace command to determine what file is missing then you can search on the net which package contains the missing file. You can try something like strace -o output.txt or strace -p -o output.t

[web2py] Re: REF: Displaying a Virtual Field in SQLFORM.grid throws an exception....

Hi, i have just created a small patch to get virtual fields working with SQLFORM.grid. Let me know when it doesn't work for you. I have tested it only with my mysql db and without db options like left join, group, etc .. A pull request is on the way. Have fun using virtual field in you grid!

Re: [web2py] Re: better calendar.js?

I don't think so but you could set the autocomplete attribute of date inputs in your form to off by adding in the related controller: inp_dates = form.elements('input', _class='date') for inp_date in inp_dates: inp_date['_autocomplete'] = 'off' Il giorno giovedì 18 luglio 2013

[web2py] Re: better calendar.js?

On Wednesday, July 17, 2013 8:28:14 PM UTC+2, Annet wrote: > > I had a look at the datetime picker, I miss the month and year menus and > the week of the year. Month and year menus appear if you click on the "mmm " ("Julho 2013" as it shows in the first demo example). First click shows mont

Re: [web2py] Re: better calendar.js?

So it should be an update to the widget, right? -Jim On Thu, Jul 18, 2013 at 4:24 PM, Paolo Caruccio wrote: > Well, the automplete is a | attribute and therefore you > could set in HTML code > > ... > > > or > > > > w3c documentation: > > for the form > > http://www.w3.org/TR/2012/CR-html5-

Re: [web2py] Re: better calendar.js?

Well, the automplete is a | attribute and therefore you could set in HTML code ... or w3c documentation: for the form http://www.w3.org/TR/2012/CR-html5-20121217/forms.html#attr-form-autocomplete for the input http://www.w3.org/TR/2012/CR-html5-20121217/forms.html#the-autocomplete-attrib

[web2py] Re: Web2py bootstrap modal with jquery datetimepicker not working after AJAX post

Hi, I had the same problem. I've used this workaround. _onclick="jQuery(this).datepicker();jQuery(this).datepicker('show');" Am Donnerstag, 18. Juli 2013 17:43:50 UTC+2 schrieb Remco K: > > Hi all, > > I have a SQLFORM inserted into a modal (requested as a LOAD file), which > includes a datetimep

[web2py] Improved SMARTHUMB

Hello, I just publish an improved version of SMARTHUMB here : http://www.web2pyslices.com/slice/show/1666/improved-smarthumb Has Bruno says, I think it should go in contrib/imageutils.py Thanks Richard -- --- You received this message because you are subscribed to the Google Groups "web2p

[web2py] Re: How do I pass a query object to a different controller?

Hi, you can use a dialog widget from jquery ui to pop up the form. Would be a nicer solution. Best regards Dmitri Husti Am Donnerstag, 18. Juli 2013 10:50:27 UTC+2 schrieb Sarbjit singh: > > Now all the problems are solved, with problem remaining. Here is what I > did to solve the problem : > >

[web2py] Re: Web2py bootstrap modal with jquery datetimepicker not working after AJAX post

Is your calendar.css in your app the same as in welcome? There was an update to it lately. I had the same problem and the calendar is popping up, but it is behind the modal dialog. Had to change the z-index of that element. A search of the group should reveal the fix. -Jim On Thursday, Jul

Re: [web2py] Re: better calendar.js?

that may work for 1 browser but I can't require that all users of the app turn off auto-complete. On Thu, Jul 18, 2013 at 3:03 PM, Paolo Caruccio wrote: > How to Turn Off Form > Autocompletion

[web2py] Re: better calendar.js?

How to Turn Off Form Autocompletion Il giorno giovedì 18 luglio 2013 21:46:46 UTC+2, Jim S ha scritto: > > I have no idea what version my cal

[web2py] Re: ordering request.vars for PayPal IPN

OK, I think I have stumbled on a solution. Which I thought would be useful to share here. Playing with request.env, I noted that this too was Storage. Hence: request.env.query_string appears to give me exactly what I need. i.e. it is essentially the "raw" string of vars. Unaltered and in the o

[web2py] Re: Web2py bootstrap modal with jquery datetimepicker not working after AJAX post

Hi Massimo, I use the latest sources -- --- 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://

[web2py] MSSQL connection error

this is my URI db = DAL('mssql://sa:rms123@192.168.1.40/SQLEXPRESS/HQ') this is the error I get: Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'SQL Server' : file not found (0) (SQLDriverConnect)") I have pyodbc and all installed.. I tried changing the pool_size to 20.

[web2py] Re: better calendar.js?

I have no idea what version my calendar.js is. Is that something that can just be overwritten whenever you do an update of web2py? Also, has this been addressed in more recent versions of web2py? -Jim On Thursday, July 18, 2013 2:30:58 PM UTC-5, Willoughby wrote: > > I believe you can override

[web2py] Re: Is there an issue with my web2py install? "can't pickle function objects"

I'm encountering this a lot too, where admin produces that exception frequently. I'm using R-2.5.1. When I remove all files from admin/sessions the error goes away. -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from thi

[web2py] Re: Concatenating datetime

>>> rows = db(db.updatelog).select(db.updatelog.updated[:10], db.updatelog.cnt.sum(), groupby=db.updatelog.updated.year()|db.updatelog.updated.month()|db.updatelog.updated.day()) >>> print rows "SUBSTR(updatelog.updated,1,(11 - 1))",SUM(updatelog.cnt) 2013-07-12 00:00:00,12 2013-07-13 00:00:00,14

[web2py] Re: Errors after upgrade

This sounds like the same problem that I reported at https://code.google.com/p/web2py/issues/detail?id=1580 If it is would you please add a comment there. Perhaps we can get someone interested in fixing the problem. I looked at the code involved but I don't understand all the complications of w

[web2py] Re: better calendar.js?

I believe you can override that (it's a browser feature) with HTML5: http://www.w3.org/wiki/HTML/Elements/input/text On Thursday, July 18, 2013 1:32:47 PM UTC-4, Jim S wrote: > > My main complaint with the current datetime picker is that you can get in > situations where (in Firefox at least) yo

[web2py] Re: Implementing the download action in the manual's "images" tutorial application

(Sorry, I live on the East Coast and it was very late here when we last corresponded. I'm awake again.) Yes, you have indeed answered the question, and I appreciate your prompt, courteous and highly informative input VERY much! Actually, at one point earlier as stuff wasn't working as I expect

[web2py] Re: Inject HTML in field definition

Thanks, Massimo. That's a big help! -- --- 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://g

[web2py] Concatenating datetime

I'm seeing unexpected results when trying to groupby and concatenate datetime fields; >>> db.define_table('updatelog', ... Field('sourcename','string'), ... Field('firstseen','datetime'), ... Field('lastseen','datetime'), ... Field('cnt','integer'), ... Field('updated','datetime') ... )

[web2py] Re: better calendar.js?

My main complaint with the current datetime picker is that you can get in situations where (in Firefox at least) you can have a dropdown of previous entries appear over the calendar itself. See attached screen shot. -Jim On Wednesday, July 17, 2013 1:28:14 PM UTC-5, Annet wrote: > > I had a lo

[web2py] Re: Mobile and Tablets detection

vince, thank you for answering me. Regards. On Wednesday, July 17, 2013 3:12:47 PM UTC-3, Marcio Andrey Oliveira wrote: > > Hi. > > I'm wondering whether exists a python project that detect mobiles and > tables that be as good and as up to date as http://mobiledetect.net/ > > Thanks. > -- ---

Re: [web2py] Inject HTML in field definition

db_mydb.my_table.location.represent = lambda value, row: XML(''%s' % value ) On Thursday, 18 July 2013 11:37:57 UTC-5, Woody wrote: > > Hmm. I'm having a lot of trouble figuring out how to use 'represent'. > Let's try a different approach. Let's say I want to do this: > > db_mydb.my_ta

[web2py] Re: Radio Buttons layout problem with trunk

Thanks! :-) On Thursday, 18 July 2013 11:16:12 UTC-5, Paolo Caruccio wrote: > > I answered to a specific question but you are right: the code should go in > web2py_bootstrap.css in order to solve the conflict. Anyway we have to > check that the patch doesn't break anything else. Therefore please

[web2py] ordering request.vars for PayPal IPN

Hello, I would be sure that someone has come across this already. I hope so. I am writing a handler for PayPal IPN. Actually, a little easier that I thought it would be except for one issue: - request.vars creates a Storage object, but the key:value pairs are not in the same sequence as they are

Re: [web2py] Re: Mobile and Tablets detection

fyi request.user_agent().is_mobile will return false for ipod touch now. On Thursday, July 18, 2013 9:43:10 PM UTC+8, Marcio Andrey Oliveira wrote: > > Niphlod, I'm fairly new to web2py (I'm reading the official book but I'm > still on page #160 of 614 pages) and I'm trying to collect the most >

Re: [web2py] Inject HTML in field definition

Hmm. I'm having a lot of trouble figuring out how to use 'represent'. Let's try a different approach. Let's say I want to do this: db_mydb.my_table.location.represent = lambda "something") And the "something" I want to output would be XML('' + row.location + '') Now, how would I cre

[web2py] Re: Radio Buttons layout problem with trunk

I answered to a specific question but you are right: the code should go in web2py_bootstrap.css in order to solve the conflict. Anyway we have to check that the patch doesn't break anything else. Therefore please give me a bit of the time and I will open an issue ticket on the issue tracker tog

[web2py] Re: Pass python list back to controller

Hi, If I understood correctly, you could use 'session' to save the list, so you don't have to pass it back and forth to the controller. E.g. session.serials = [] and then session.serials.append(x) Ykä On Thursday, July 18, 2013 6:55:52 PM UTC+3, Kyle Flanagan wrote: > > What's the best way to

[web2py] Re: Deadlock found when trying to get lock; try restarting transaction

i do not know which function actually causing this problem. the application we testing are mostly select query so most likely it's from the web2py session update query. in pymysql/connection.py def commit(self): ''' Commit changes to stable storage ''' try: self

Re: [web2py] current.db = db

On 18 Jul 2013, at 8:32 AM, Massimo Di Pierro wrote: > It is safe if used as current is intended to be used (within functions called > within the same thread). > > This is not done by default because you may have > > > db1 = DAL() > db2 = DAL() > my_other_db = DAL() > etc. Well,

[web2py] Re: Radio Buttons layout problem with trunk

Should this go in web2py_bootstrap.css? On Thursday, 18 July 2013 10:51:15 UTC-5, Paolo Caruccio wrote: > > Please put the following code in your custom css file (or in the bottom of > web2py_bootstrap.css if you are using the welcome app scaffolding): > > .generic-widget input[type='radio'] {mar

[web2py] Re: crud - update only one field

oops. yes. I edited it for posterity. On Thursday, 18 July 2013 10:48:15 UTC-5, lesssugar wrote: > > Although, I guess in the last line it should be > > record.update_record(fieldname = request.vars.fieldname) > > instead of > > record.update_record(fieldname = record.fieldname) > > Cheers! > > On

[web2py] Pass python list back to controller

What's the best way to pass a Python list back to the controller, i.e. keep the list object persistent between calls? The list could get quite large so I'm not sure if request.args or request.vars is appropriate for it (well the items in the list)? The code below is a mockup of what I'm trying t

[web2py] Re: Web2py bootstrap modal with jquery datetimepicker not working after AJAX post

Which web2py version? On Thursday, 18 July 2013 10:43:50 UTC-5, Remco K wrote: > > Hi all, > > I have a SQLFORM inserted into a modal (requested as a LOAD file), which > includes a datetimepicker from Jquery. This is working well until i submit > my form and get a result back from my form valid

[web2py] Re: Radio Buttons layout problem with trunk

Please put the following code in your custom css file (or in the bottom of web2py_bootstrap.css if you are using the welcome app scaffolding): .generic-widget input[type='radio'] {margin:-1px 0 0 0; vertical-align:middle ;} .generic-widget input[type='radio'] + label {display:inline-block; margin

[web2py] Re: crud - update only one field

Although, in the last line should be record.update_record(fieldname = request.vars.fieldname) instead of record.update_record(fieldname = record.fieldname) Cheers! On Thursday, July 18, 2013 5:31:10 PM UTC+2, Massimo Di Pierro wrote: > > record = db(db.tablename.id==id).select().first() > form

Re: [web2py] current.db = db

Ok, Maybe flag this thread with google group as kind of "accept answer" or something could be useful for orthers Thanks Richard On Thu, Jul 18, 2013 at 11:32 AM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > It is safe if used as current is intended to be used (within functions > c

[web2py] Web2py bootstrap modal with jquery datetimepicker not working after AJAX post

Hi all, I have a SQLFORM inserted into a modal (requested as a LOAD file), which includes a datetimepicker from Jquery. This is working well until i submit my form and get a result back from my form validator. After clicking on the datetime field again i don't see the datetimepicker anymore. I

[web2py] Re: crud - update only one field

Exactly what I needed. Thanks. On Thursday, July 18, 2013 5:31:10 PM UTC+2, Massimo Di Pierro wrote: > > record = db(db.tablename.id==id).select().first() > form = SQLFORM.factory(Field('fieldname',default = record.fieldname)) > if form.process().accepted: > record.update_record(fieldname = re

Re: [web2py] current.db = db

It is safe if used as current is intended to be used (within functions called within the same thread). This is not done by default because you may have db1 = DAL() db2 = DAL() my_other_db = DAL() etc. On Thursday, 18 July 2013 09:49:42 UTC-5, Richard wrote: > > Hello, > > Is it saf

[web2py] Re: crud - update only one field

record = db(db.tablename.id==id).select().first() form = SQLFORM.factory(Field('fieldname',default = record.fieldname)) if form.process().accepted: record.update_record(fieldname = record.fieldname) On Thursday, 18 July 2013 09:19:17 UTC-5, lesssugar wrote: > > I have a table with 8 fields. I

[web2py] Re: Composite Unique Key

What problem are you trying to solve? On Thursday, 18 July 2013 08:32:07 UTC-5, Apoorve Mohan wrote: > > Hello All > > Please guide me on how to create a "composite unique key". > > -- > Thanks and Regards > > Apoorve > -- --- You received this message because you are subscribed to the Google

[web2py] Re: best advice for checking/unchecking all INPUT checkboxes with certain pattern in name

This is easy with JS. jQuery("#select_all").click(function() { var checkedStatus = this.checked; jQuery("input[type=checkbox]").each(function() { this.checked = checkedStatus; }); }); On Thursday, 18 July 2013 06:59:42 UTC-5, lucas wrote: > > hello, > > i have a fairly complex f

Re: [web2py] current.db = db

Avoid passing db to class in modules because I found strange to pass so much args to class... I use to do it because I wasn't know if it was thread safe... There is this post on stackoverflow : http://stackoverflow.com/questions/11959719/web2py-db-is-not-defined Richard On Thu, Jul 18, 2013 at 1

Re: [web2py] current.db = db

On 18 Jul 2013, at 7:49 AM, Richard wrote: > Is it safe to do : > > from gluon import current > current.db = db > > And if so, why is db not already available in current by default? > Why do you want to do that? -- --- You received this message because you are subscribed to the Google Grou

Re: [web2py] current.db = db

Why you want to do this? El jueves, 18 de julio de 2013 10:49:42 UTC-4, Richard escribió: > > Hello, > > Is it safe to do : > > from gluon import current > current.db = db > > And if so, why is db not already available in current by default? > > Thanks > > Richard > -- --- You received this me

[web2py] current.db = db

Hello, Is it safe to do : from gluon import current current.db = db And if so, why is db not already available in current by default? Thanks Richard -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and st

[web2py] weird bug with redis

Hello, I have encountered a weird bug using Redis. I understand it would be too complicated to get detailed help (software is running to supervise a machine), but I'm looking for cues on where to look. Here is the problem: I use redis to share variables between processes. After a while, I get t

[web2py] crud - update only one field

I have a table with 8 fields. I need to create crud.update form only for one of them. There are at least two ways to do it: 1. setting readable / writable attributes of the rest 7 fields to False (rather tedious) 2. or something like this: for f in db.tablename.fields: if f != 'myfield':

[web2py] Re: Errors after upgrade

on google app engine i had a module called utils that started to conflict with a module of the same name in the gluon directory with the updated importer. there is no web2py module called utility that i see, but still you might check for module name collusion. cfh On Tuesday, July 16, 2013 4:

Re: [web2py] Re: Mobile and Tablets detection

Niphlod, I'm fairly new to web2py (I'm reading the official book but I'm still on page #160 of 614 pages) and I'm trying to collect the most possible information that I think relevant for what I'm planning to do. Even if I had read entirely book I believe that not all information about web2py will

[web2py] Re: Deadlock found when trying to get lock; try restarting transaction

> the sample from you didn't work. Can you post the new error output? -- --- 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.c

[web2py] Composite Unique Key

Hello All Please guide me on how to create a "composite unique key". -- Thanks and Regards Apoorve -- --- 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 web2p

Re: [web2py] Inject HTML in field definition

Ok, I see 2 possibility why it not working. 1) Cause you use TABLE(), you should try SQLTABLE or SQLFORM.gris. 2) LOAD(), since component strip all the style it may be possible that you can't see your stuff. You can try to just embed your table in a view without LOAD() like that {{=table}} see wha

[web2py] best advice for checking/unchecking all INPUT checkboxes with certain pattern in name

hello, i have a fairly complex form and under the form is a sublist of names with checkboxes next to them. and then there is another sublist with a different set of names. what is your best advice to check or uncheck all names under each sublist of names without submitting back to the webserv

[web2py] Re: How do I pass a query object to a different controller?

Now all the problems are solved, with problem remaining. Here is what I did to solve the problem : In the view for search2, I added the code as : {{extend 'layout.html'}} This is the default/search2.html template {{if results.update_form:}} {{=results}} {{elif results.view_form:}} {{=results}} {

[web2py] Re: Implementing the download action in the manual's "images" tutorial application

Normally if you have https://www.google.com/images/srpr/logo4w.png"; /> This instructs your browser to download and show the image logo4w.png. In your case works the same way but the URL is not https://www.google.com/images/srpr/logo4w.png but ///download/ >From the point of view of the s

[web2py] Radio Buttons layout problem with trunk

I took the welcome app (trunk version), added the following model: db.define_table("toets_radio", Field('yesno', requires=IS_IN_SET([(0, 'No'), (1, 'Yes')]), widget = SQLFORM.widgets.radio.widget)) And it produced this view there the radio button and the label are

[web2py] Re: Implementing the download action in the manual's "images" tutorial application

It seems that I am trying to understand exactly what the "download" action is intending to do, because I thought that it would provide some sort of a method/link/URL for a visitor to download the uploaded image currently being displayed, and that this method/link/URL would have something to do

[web2py] Re: Implementing the download action in the manual's "images" tutorial application

I am not sure I fully understand. Are you trying to do this? On Thursday, 18 July 2013 01:20:48 UTC-5, REM wrote: > > Hello, folks. > > I started back at the top of the manual again and I am understanding much > more by progressing slowly and with copious notes. So far, so good. > > However,

[web2py] Re: Is there an issue with my web2py install? "can't pickle function objects"

I missed the part is a bug about admin. Than it's not one of your projects. It is my responsibility. :-( Which web2py version? I will look into this asap. On Wednesday, 17 July 2013 13:47:33 UTC-5, Joe Magaro wrote: > > Hi Mossimo - Where would I look for this? I haven't done sessions in my > ap

[web2py] Re: How do I pass a query object to a different controller?

Just to be clear on exception (crash) : On clicking search, pickle error is seen if the url is like : http://127.0.0.1:8000/sampleapp/default/search2/edit/customer/2?_signature=... If it is simple : (first time search which works) : http://127.0.0.1:8000/sampleapp/default/search2 But no ed