[web2py] Re: Mobile and Tablets detection

2013-07-18 Thread Niphlod
ok, you're fond of that php library. But did you take a closer look to what you have right in web2py using request.user_agent() ? web2py uses gluon/contrib/user_agent_parser.py to fill up those fields and it does the exact same thing! Il giorno giovedì 18 luglio 2013 01:05:11 UTC+2, Marcio

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

2013-07-18 Thread REM
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, I have come across a bit of a puzzling issue with the latter part of the images tutorial. After creating the dbases, uploading

Re: [web2py] Re: Mobile and Tablets detection

2013-07-18 Thread Angelo Compagnucci
Hi Marcio, I'm planning to grow the supported mobile devices list in web2py, but the support right now is fairly extensive. I got the user agent strings here http://www.useragentstring.com/pages/Mobile%20Browserlist/ and added at least one of the devices for each family to the unit test of

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

2013-07-18 Thread Sarbjit singh
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

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

2013-07-18 Thread Massimo Di Pierro
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 apps

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

2013-07-18 Thread Massimo Di Pierro
I am not sure I fully understand. Are you trying to do this? a href={{=URL('download', args=image.file)}}img width=200px src={{=URL('download', args=image.file)}} //a 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

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

2013-07-18 Thread REM
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] Radio Buttons layout problem with trunk

2013-07-18 Thread Johann Spies
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

2013-07-18 Thread Massimo Di Pierro
Normally if you have img width=200px src=https://www.google.com/images/srpr/logo4w.png; / This instructs your browser to download and show the image logo4w.png. In your case img width=200px src={{=URL('download', args=image.file)}} / works the same way but the URL is not

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

2013-07-18 Thread Sarbjit singh
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'}} h1This is the default/search2.html template/h1 {{if results.update_form:}} {{=results}} {{elif results.view_form:}}

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

2013-07-18 Thread lucas
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

Re: [web2py] Inject HTML in field definition

2013-07-18 Thread Richard Vézina
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

[web2py] Composite Unique Key

2013-07-18 Thread Apoorve Mohan
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

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

2013-07-18 Thread Alan Etkin
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

Re: [web2py] Re: Mobile and Tablets detection

2013-07-18 Thread Marcio Andrey Oliveira
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

[web2py] Re: Errors after upgrade

2013-07-18 Thread Christian Foster Howes
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

[web2py] crud - update only one field

2013-07-18 Thread lesssugar
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] weird bug with redis

2013-07-18 Thread dederocks
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

[web2py] current.db = db

2013-07-18 Thread Richard
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

Re: [web2py] current.db = db

2013-07-18 Thread Eduardo Cruz
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 message because

Re: [web2py] current.db = db

2013-07-18 Thread Jonathan Lundell
On 18 Jul 2013, at 7:49 AM, Richard ml.richard.vez...@gmail.com 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

Re: [web2py] current.db = db

2013-07-18 Thread Richard Vézina
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

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

2013-07-18 Thread Massimo Di Pierro
This is easy with JS. input type=checkbox id=select_all/ script jQuery(#select_all).click(function() { var checkedStatus = this.checked; jQuery(input[type=checkbox]).each(function() { this.checked = checkedStatus; }); }); /script On Thursday, 18 July 2013 06:59:42 UTC-5, lucas

[web2py] Re: Composite Unique Key

2013-07-18 Thread Massimo Di Pierro
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 Groups

[web2py] Re: crud - update only one field

2013-07-18 Thread Massimo Di Pierro
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

Re: [web2py] current.db = db

2013-07-18 Thread Massimo Di Pierro
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 safe

[web2py] Re: crud - update only one field

2013-07-18 Thread lesssugar
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 =

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

2013-07-18 Thread Remco K
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.

Re: [web2py] current.db = db

2013-07-18 Thread Richard Vézina
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 called

[web2py] Re: crud - update only one field

2013-07-18 Thread lesssugar
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 =

[web2py] Re: Radio Buttons layout problem with trunk

2013-07-18 Thread Paolo Caruccio
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;

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

2013-07-18 Thread Massimo Di Pierro
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 validator.

[web2py] Pass python list back to controller

2013-07-18 Thread Kyle Flanagan
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

[web2py] Re: crud - update only one field

2013-07-18 Thread Massimo Di Pierro
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 Thursday,

[web2py] Re: Radio Buttons layout problem with trunk

2013-07-18 Thread Massimo Di Pierro
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']

Re: [web2py] current.db = db

2013-07-18 Thread Jonathan Lundell
On 18 Jul 2013, at 8:32 AM, Massimo Di Pierro massimo.dipie...@gmail.com 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 =

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

2013-07-18 Thread vince
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:

[web2py] Re: Pass python list back to controller

2013-07-18 Thread Ykä Marjanen
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: Radio Buttons layout problem with trunk

2013-07-18 Thread Paolo Caruccio
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

Re: [web2py] Inject HTML in field definition

2013-07-18 Thread Woody
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('span style=color:#EB0F0F' + row.location +

Re: [web2py] Re: Mobile and Tablets detection

2013-07-18 Thread vince
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

[web2py] Re: Radio Buttons layout problem with trunk

2013-07-18 Thread Massimo Di Pierro
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

2013-07-18 Thread SimonD
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

Re: [web2py] Inject HTML in field definition

2013-07-18 Thread Massimo Di Pierro
db_mydb.my_table.location.represent = lambda value, row: XML('span style=color:#EB0F0F'%s/span' % 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

[web2py] Re: Mobile and Tablets detection

2013-07-18 Thread Marcio Andrey Oliveira
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. -- --- You

[web2py] Re: better calendar.js?

2013-07-18 Thread Jim S
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

[web2py] Concatenating datetime

2013-07-18 Thread Alex W
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: Inject HTML in field definition

2013-07-18 Thread Woody
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

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

2013-07-18 Thread REM
(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

[web2py] Re: better calendar.js?

2013-07-18 Thread Willoughby
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) you

[web2py] Re: Errors after upgrade

2013-07-18 Thread Frederick Yankowski
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

[web2py] Re: Concatenating datetime

2013-07-18 Thread Alex W
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: Is there an issue with my web2py install? can't pickle function objects

2013-07-18 Thread Frederick Yankowski
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 this

[web2py] Re: better calendar.js?

2013-07-18 Thread Jim S
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] MSSQL connection error

2013-07-18 Thread greenpoise
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

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

2013-07-18 Thread Remco K
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

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

2013-07-18 Thread SimonD
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

[web2py] Re: better calendar.js?

2013-07-18 Thread Paolo Caruccio
How to Turn Off Form Autocompletionhttps://developer.mozilla.org/en-US/docs/Mozilla/How_to_Turn_Off_Form_Autocompletion?redirectlocale=en-USredirectslug=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

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

2013-07-18 Thread Jim Steil
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 paolo.carucci...@gmail.comwrote: How to Turn Off Form

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

2013-07-18 Thread Jim S
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,

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

2013-07-18 Thread Dmitri Husti
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 : In

[web2py] Improved SMARTHUMB

2013-07-18 Thread Richard
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

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

2013-07-18 Thread Dmitri Husti
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 datetimepicker

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

2013-07-18 Thread Paolo Caruccio
Well, the automplete is a form | input attribute and therefore you could set in HTML code form name=form1 id=form1 method=post autocomplete=off action=... /form or input type=text name=myfield autocomplete=off w3c documentation: for the form

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

2013-07-18 Thread Jim Steil
So it should be an update to the widget, right? -Jim On Thu, Jul 18, 2013 at 4:24 PM, Paolo Caruccio paolo.carucci...@gmail.comwrote: Well, the automplete is a form | input attribute and therefore you could set in HTML code form name=form1 id=form1 method=post autocomplete=off action=...

[web2py] Re: better calendar.js?

2013-07-18 Thread LightDot
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 months,

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

2013-07-18 Thread Paolo Caruccio
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

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

2013-07-18 Thread tospecht
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!

[web2py] Re: MSSQL connection error

2013-07-18 Thread Marcio Andrey Oliveira
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 command -o output.txt or strace -p

[web2py] real time graph

2013-07-18 Thread Vera Moreira
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 by

[web2py] Re: weird bug with redis

2013-07-18 Thread Niphlod
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

Re: [web2py] Re: Mobile and Tablets detection

2013-07-18 Thread Niphlod
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: MSSQL connection error

2013-07-18 Thread Niphlod
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

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

2013-07-18 Thread Niphlod
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,

[web2py] Re: Concatenating datetime

2013-07-18 Thread Niphlod
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

Re: [web2py] real time graph

2013-07-18 Thread José Ricardo Borba
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] -

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

2013-07-18 Thread Diego Carvallo
-- --- 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: Serve images from action call or web service call

2013-07-18 Thread Diego Carvallo
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

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

2013-07-18 Thread Mark Li
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 ==

[web2py] Re: MSSQL connection error

2013-07-18 Thread greenpoise
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 package

[web2py] Re: MSSQL connection error

2013-07-18 Thread greenpoise
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