[web2py] Multiple select options not displayed

Hi, I'm wondering if there's a problem with my multi-select syntax. I'm not able to see the drop down options when I try this on the latest web2py (2.12.13). See code example below: def multi(): """ multi Module """ weekdays = ["Monday","Tuesday","Wednesday","Thursday","Friday","Saturday

Re: [web2py] Re: IMPORTANT - WEB2PY CONSULTING

; On Tue, 17-03-2015 11:09 PM, Dave S wrote: > > > > On Monday, March 16, 2015 at 6:57:54 PM UTC-7, DJ wrote: >> >> Hi Massimo, >> >> 10Biosystems.com has been doing web2Py consulting & bioinformatics >> product development for life

[web2py] Re: IMPORTANT - WEB2PY CONSULTING

Hi Dave, We are based in New York City since 2009. www.10biosystems.com -Sebastian On Tuesday, March 17, 2015 at 1:39:00 PM UTC-4, Dave S wrote: > > > > On Monday, March 16, 2015 at 6:57:54 PM UTC-7, DJ wrote: >> >> Hi Massimo, >> >> 10Biosystems.

[web2py] Re: IMPORTANT - WEB2PY CONSULTING

Hi Massimo, 10Biosystems.com has been doing web2Py consulting & bioinformatics product development for lifesciences & healthcare for a few years now. Kindly add us! Thanks, Sebastian On Sunday, February 15, 2015 at 5:21:36 PM UTC-5, Massimo Di Pierro wrote: > > We need to update the list of co

[web2py] Re: Upgrade issues with 2.9.11

?(.*) > /opt/web-apps/web2py/applications/$1/static/$2 > > > On Wednesday, December 24, 2014 4:43:35 PM UTC+1, DJ wrote: >> >> Hello, >> >> I wanted to share an issue that has come up after upgrading to 2.9.11 on >> CentOS.6.6/Apache. >> >>

[web2py] Re: happy holidays everybody

Congrats Massimo and happy holidays! On Wednesday, December 24, 2014 8:48:18 AM UTC-5, Massimo Di Pierro wrote: > > I wish a happy holidays to everybody in this community. > > As a Christmas present and mostly the work of Giovanni Barillari we have > re-released the web2py DAL as a separate Pytho

[web2py] Upgrade issues with 2.9.11

Hello, I wanted to share an issue that has come up after upgrading to 2.9.11 on CentOS.6.6/Apache. a) First the existing applications broke after the upgrade b) Admin interface would not load up properly (no icons and unable to login) In the served html pages, an additional folder _2.9.11 is ad

[web2py] Re: Bootstrap icons don't work with latest web2py?

I'm having trouble seeing the icons on the admin page - I also downloaded the latest version from the website: 2.9.11-stable+timestamp.2014.09.15.23.35.11 Has it been fixed? Thanks for your help! -Sebastian On Monday, September 22, 2014 11:26:31 AM UT

[web2py] HTML multiple select attribute bug in 2.9.11?

Just migrated code from an older version web2py app to the latest code structure (js, css, etc.). The Multiple select box does not show up in the form. I get a disabled dropdown button. The same old app (without js, css updates) works totally fine on the 2.9.11 version. I think this has to do

[web2py] AppAdmin: CSV import bug

Not able to upload data using CSV import tool, get the following error (perhaps, web2py csv import tool needs to read it in using 'rU' option?) - Running Version 2.5.1, Python 2.7, MacOSX. Tested it using a csv file exported out using appadmin's Export/Import tool. Unable to parse CSV file:

[web2py] Re: Audit for all tables, independent of CRUD; and transaction rollback.

Thanks. Will check that out. On Friday, July 13, 2012 7:10:49 PM UTC-4, Massimo Di Pierro wrote: > > You need web2py trunk. > > > On Friday, 13 July 2012 16:07:18 UTC-5, DJ wrote: >> >> Hello, >> >> I have been trying to get auditing to work but run into t

[web2py] Re: Audit for all tables, independent of CRUD; and transaction rollback.

Hello, I have been trying to get auditing to work but run into the error below. W2P version: 1.99.7 / Mysql 5.0 Any recommendations on how to fix this? 1. 2. 3. 4. 5. 6. 7. Traceback (most recent call last): File "/home/www-data/web2py/gluon/restricted.py", line 205, in restricted exe

[web2py] Life science computing and Bioinformatics

Dear Web2py Users, I would like to reach out to all bioinformatics/chem-informatics/life science informatics people using web2py. I have been using web2py since 2009 to implement life science applications and databases in biotechs and universities. I am sure there are a number of you doing simi

[web2py] Browser back button: Reloading database results

Hello W2People, This may be a simple setting that I am unaware of - how does one retain the database search results when you click the Back Button on the browser without having to refresh the page and confirming? Thank you, Sebastian

[web2py] Re: web2py received 2011 BOSSIE Award by InfoWorld.com

Congratulations to Massimo and the rest of the team! Incredible work!!! -Sebastian

[web2py] Re: web2py for freelance work

Hi there, I get this question all the time. End of the day, what matters most to clients is rapid deployment and low cost of software maintenance in addition to nailing their requirements. I have deployed Web2Py in companies and top hospitals across the US, within their corporate IT groups. Be

[web2py] Re: File upload bug?

Does anyone have experience processing a file's contents (eg. csv) during upload? Thanks, Sebastian

[web2py] File upload bug?

Would like you help on with this file upload issue. I am trying to read the contents of a file and process it during file upload (without making any changes to the file). When I try to read the file contents during an upload, the uploaded file has no contents (it is empty). See function below

[web2py] Re: CRUD with custom links

Thanks Massimo. This works fine! -Sebastian

[web2py] Re: CRUD with custom links

Hi Massimo, Here's a snippet of my code: ids = [1, 2, 3, 4, 5] # I tried something like this but it does not work # db.myTable.id.represent = lambda value: A(myID, _href=URL (r=request, c='default', f='viewDetail', args=myID)) form = crud.select(db.myTable, db.myTable.id.belongs(ids), _id='myid

[web2py] CRUD with custom links

Hi there, What is the easiest way to generate customized links on the output of a CRUD select? I want to be able to specify the column and my URL with arguments. -Sebastian

Re: [web2py] Re: SQL help

Thanks all. I was looking for the SQL IN operator in web2py. It is called "belongs" as marin and pbreit mentioned.

[web2py] Re: SQL help

Perfect! Thanks!

Re: [web2py] SQL help

Thank you! This works!

[web2py] SQL help

Is this query possible in web2py? SELECT * FROM `shirts` WHERE `color` IN ('red','white','blue') -Sebastian

[web2py] Web2py: the top notch productivity platform

I have been using web2py for the past few years and I feel it is one the Python world's hidden gems. While most people argue about Django and the like, what matters most when it comes to application development is deployment speed, reliability and low cost of maintenance. If you are in the so

[web2py] Re: Bug in Dal: import for csv

Same issues here - I installed the latest version for a project and I am not able to import csv files from web2py command line. Does import_from_csv work in the older versions? -Seb

[web2py] NicEdit Upload Files

Hello web2py users, I was wondering if anyone has had success with integrating file upload feature from NicEdit with web2py (possibly into static or uploads folder). There are a couple of sites that show people doing it with plain python or django. I think it will be a very useful tool or plugi

[web2py] Re: Japan

+1

[web2py] Re: Upgrading to web2py_win_1.91.6 caused a problem: Massimo, help!

I see similar problems with DAL in version 1.92.1 (Linux, MySQL). DAL needs to be fixed. -Sebastian

[web2py] Re: web2py 1.92.1 is OUT

I am seeing some issues with admin and CRUD after upgrade - happens only for one table. Updating a table through the admin interface does not work - no values are sent to database; but I get a 'Done' message. Likewise for the CRUD action in a controller. Database update works when executed in

[web2py] CRUD onaccept - get inserted record id?

Hi there, I would like to perform another database transaction using crud.settings.create_onaccept soon after a CRUD create action using the newly created record id. That is, does CRUD create return the ID of the new record for downstream processing? If so, how do I get it? If this is not p

Re: [web2py] Gzip compression of javascript to speed up website

Thank you all for your suggestions.

[web2py] Gzip compression of javascript to speed up website

Hi there, I was using Chrome's audit tool to see how I can increase my application speed. One of recommendations Chrome suggests is that I gzip javascript files (jquery, others) to decrease loading time. Can the web2py server be set to serve zipped content based on the incoming browser? Also,

[web2py] Admin password change 1.88.2

Can't change admin password in new version. See traceback below.. -- VERSION web2py™ Version 1.88.2 (2010-10-29 23:04:43) Python Python 2.5.2: /usr/bin/python TRACEBACK Traceback (most recent call last): File "/home/www-data/web2py/gluon/restricted.py", line 188, in restricted exec

[web2py] Re: web2py 1.89.1 is OUT

Love the file search function! Nice work! -S On Nov 12, 12:09 pm, appydev wrote: > Really beautiful!

[web2py] Re: new admin in trunk

Branko, New UI looks awesome! Nice work. -Sebastian On Nov 8, 11:48 am, Branko Vukelic wrote: > Edit area has its own styles which I couldn't touch even though I > wanted to... I'll check out trunk tonite and see if I get the same > thing. > > What browser are you using? > > > > > > > > > > On

[web2py] Re: web2py wizard (alpha) is here

Massimo, The wizard is awesome! I was going to post a question about a UI to generate tables when you seemed to have read my mind :-) Here are some thoughts/features that will be really nice to have - a) would it possible to have a drop down of datatypes that we can pick from when entering field

[web2py] Web2py like clone in Java?

Hello web2py people, I was in a discussion recently telling my friend how great Web2Py was for programmer productivity with all the inbuilt features (server, CRUD, auth). We were wondering if there was anything similar in Java? Quick google search brought me to Tapestry and Wicket. Can any of you

[web2py] Re: please help us test new web site

Dear Web2py Team, Love the new site. Very clean and elegant, with quick access to the relevant links. Couple of items I would like to mention - a) The Home, About, Download tabs do not look crisp (Win 7, viewed through Firefox and Chrome) b) The new logo looks great c) This is more from a marketi

[web2py] Re: plugin legacy mysql: generates web2py code to access your mysql legacy db

The legacy database to Web2py conversion would be a great add-on. I get the following errors when I tried this script on a database with tables having primary key 'id' set to autoincrement. C:\Program Files (x86)\web2py\scripts>extract_mysql_models.py bio:b...@nrcf Traceback (most recent call last

[web2py] Re: Sorting alphanumeric data

elow link for examples on > performing this with postgresql. > > http://www.postgresql.org/docs/8.0/interactive/queries-order.html > > -- > Thadeus > > On Fri, Jul 23, 2010 at 8:01 PM, Jonathan Lundell wrote: > > On Jul 23, 2010, at 5:39 PM, DJ wrote: > > >&

[web2py] Sorting alphanumeric data

Hello, I have sorting problem with a column in the database (string) that stores alphanumeric data. The data is A1, A2, A3..A10, A11, A12. When I sort by column type, I get A1, A10, A11, A12 but I would like to get A1, A2, A3...A10, A11, A12. Is there anything I can try with orderby="columntype"?

[web2py] Cannot compile: there are errors in your app:

I checked for file permissions and they look fine. No special files in my app apart from javascript files and the regular web2py files. Version: 1.77.3 running on Ubuntu 8, python 2.5.2 Any pointers? -Sebastian

[web2py] Re: Login without using email id

Thanks Jon. That did it! I love the quick responses on this mailing list ...and ofcourse Web2py rocks!! On Apr 29, 4:58 pm, Jonathan Lundell wrote: > On Apr 29, 2010, at 1:49 PM, DJ wrote: > > > I would like to set the auth method to use any username ('tom') > > in

[web2py] Re: Menu Selected option

t; It worked fine to my case. I tried to figure out the web2py way to do > this thought better to do my way. > Altough would be better do it simply. > > On 28 abr, 16:50, DJ wrote: > > > Hi all, > > > There has been some discussion on this previously and I believe >

[web2py] Login without using email id

Dear all, I would like to set the auth method to use any username ('tom') instead of forcing an email id ('t...@something.com'). How can I do this? thanks, Sebastian

[web2py] Menu Selected option

Hi all, There has been some discussion on this previously and I believe Massimo has included a menu-selected option in MENU. What's the best way to display a menu with the current item selected? Default code example: {{if response.menu:}} {{=MENU(response.menu, _class =

[web2py] Web2py programmer needed

Hello Web2Py Users, I am looking for an experienced web2py programmer to work on a short- term project (4-6 weeks). Project involves enhancing an existing scientific product developed with web2py with new features. You should have: - Excellent python programming skills - MySQL, Oracle experience

[web2py] Re: Where do you use web2py?

I use it to develop research applications in biotechnology - eg. discovering new bacteria, tracking scientific data, identifying potential drugs. Web2py integrates beautifully with third-party tools and scientific packages leading to efficient and agile product development. On Mar 12, 5:42 am, "Gi

[web2py:37054] Re: Database driven Calendar

 pm, Thadeus Burgess wrote: > > > I would suggest jquery fullcalendar. It acts similar to google calendar. > > >http://arshaw.com/fullcalendar/ > > > -Thadeus > > > On Fri, Dec 11, 2009 at 2:45 PM, DJ wrote: > > > ou have any recommendations for a

[web2py:37048] Database driven Calendar

Hello all, I would like to build an application that displays a calendar showing events for each day/week. These events are stored in a database that is accessed by web2py. (similar to Google calendar) Do you have any recommendations for any existing calendar framework that can work with web2py?

[web2py:33601] Database - auto update field

Hi there, There must be a simple way to do this, but I can't seem to figure it out. I would like a field (name) to populate itself automatically when a database record is created. # test table db.define_table("animal", SQLField("name","string",length=20,notnull=True,default="ANML-" + str(db.

[web2py:30544] Re: T3 rocks!

Massimo, This would be an excellent addition to the appliances web2py already has. I was recently trying out GAE and set up a test site using T3. The installation was dead simple and T3 worked really well. With minimal effort I was able to set up - http://fightalzheimers.appspot.com Having a CMS

[web2py:30541] Re: ProgrammingError: LOB variable no longer valid after subsequent fetch

t; it. > > I imagine you have a model that treats a legacy CLOB as text, correct? > > On Sep 1, 12:20 pm,DJ wrote: > > > Massimo, > > > I am using - > > > Python 2.5.2 > > DB Driver: cx_Oracle-5.0.1-10g.win32-py2.5 > > Oracle 10G > > Platform: W

[web2py:29808] Re: ProgrammingError: LOB variable no longer valid after subsequent fetch

gt; > On Aug 28, 2:40 pm,DJ wrote: > > > Hi, > > > I get this error while retrieving CLOB data types from Oracle. This is > > also seen with the Web2Py admin interface when it tries to display all > > data rows. I am using the cx_oracle python dat

[web2py:29602] ProgrammingError: LOB variable no longer valid after subsequent fetch

Hi, I get this error while retrieving CLOB data types from Oracle. This is also seen with the Web2Py admin interface when it tries to display all data rows. I am using the cx_oracle python database module. >From their website, http://cx-oracle.sourceforge.net/html/lob.html Note: Internally, Orac

[web2py:26982] Re: Oracle Errors on multiple row retrieval

end of code # On Jul 16, 4:54 pm, mdipierro wrote: > trydb.commit() after the first fetch. > > On 16 Lug, 15:07, DJ wrote: > > > Hi there, > > > I get these errors when I run a search query (retrieve multiple rows), > > but not when I do a single row re

[web2py:26667] Oracle Errors on multiple row retrieval

Hi there, I get these errors when I run a search query (retrieve multiple rows), but not when I do a single row retrieval (such as viewing a record). Any suggestions or methods to get around this? -Sebastian Traceback (most recent call last): File "C:\Documents and Settings\sjayaraj\Desktop\w

[web2py:24172] Re: this made me laugh

He's probably referring to high-speed jet engines ;-) I would take it as a compliment! Web2Py rocks and it's a matter of time before more people realize this. On this note Massimo, have you considered writing an article introducing Web2py on Linux Journal? I am sure a lot of readers would be exc

[web2py:23967] Re: Form validation causes checkbox to get selected

Thanks Francis. On Jun 11, 6:58 pm, Fran wrote: > On Jun 11, 11:33 pm, DJ wrote: > > > Thanks Massimo. Quick question, how do I get this patch? (url address) > > http://bazaar.launchpad.net/~mdipierro/web2py/devel/revision/904 > > But also > see:http://bazaar.laun

[web2py:23962] Re: Form validation causes checkbox to get selected

now (launchpad > 904). > > Massimo > > On Jun 10, 5:52 pm, DJ wrote: > > > Hello, > > > I see a strange behavior when I try to validate a FORM. If there is a > > required field that is left empty Web2PY throws a "Cannot be empty" > > error

[web2py:23856] Form validation causes checkbox to get selected

Hello, I see a strange behavior when I try to validate a FORM. If there is a required field that is left empty Web2PY throws a "Cannot be empty" error message (good behavior). But along with this, the checkbox fields in the form also get selected even though they were left unchecked (unwanted act

[web2py:21403] Re: Coooooool!

This interface looks great! Nice work Massimo. Works fine on Firefox but am seeing issues on IE 8. -Seb On May 1, 4:39 am, Ted G wrote: > I'm having a problem using upload fields within forms that are used > within jDiv containers. Testing edit() below by itself provides a form > that I can su

[web2py:20386] Re: Nonetype object unscriptable

from the > welcome app. > > Massimo > > On Apr 23, 4:17 pm, DJ wrote: > > > Help! Anyone knows why this is happening? Installed a new app on MySQL > > and I get these errors when I try to access the admin interface to > > view the database. I have removed any s

[web2py:20379] Nonetype object unscriptable

Help! Anyone knows why this is happening? Installed a new app on MySQL and I get these errors when I try to access the admin interface to view the database. I have removed any session data from the app. Traceback (most recent call last): File "C:\Program Files\web2py\gluon\restricted.py", line

[web2py:19615] Checkbox gets selected during field validation

Hi there, I am not sure if I am doing anything wrong with my controller code. Here's the behavior - User tries to submit a form and has to enter atleast 3 fields (Name, Notebook, Page). Other fields like Project, Source and Resistance are pre-selected from database. When the user tries to submit

[web2py:18988] Re: Web2Py Conference

this is hilarious! you should make a cartoon out of this (like your superman!) On Apr 1, 3:51 pm, mdipierro wrote: > The new commercial is on TV now: > > A kid is playing with a train and says "Hi, I am Ruby on Rails" > A hot but professionally dressed girl comes in a says: "Hi, I am > web2py" >

[web2py:18950] Re: Writing a Book

Go for it! Here are some ideas that might help make it more enterprise friendly - a) Simple install instructions, including how to make it run as a service (now in Alter Ego) b) Database connections and gotchas to look out for with dbs like Oracle c) Simple authentication (Auth, CAS, etc) and int

[web2py:18879] Re: Multiple checkbox - preselected syntax

Thanks Denes! Your code suggestion worked for me. All I needed to do was the 'x in r' and it worked like a charm! :-) On Mar 30, 10:25 pm, DenesL wrote: > On Mar 30, 7:00 pm, DJ wrote: > > > I would like someone to help me with the syntax. I want to show pre- > > s

[web2py:18874] Re: Multiple checkbox - preselected syntax

So when user wants to update his settings, I want to show A, C as selected; while B and D as unselected. Thanks! On Mar 30, 8:28 pm, mdipierro wrote: > Sorry I do not understand what this is supposed to do. Can you explain > it in words. Could you also provide sample values for all the &

[web2py:18820] Multiple checkbox - preselected syntax

I would like someone to help me with the syntax. I want to show pre- selected values in a multiple checkbox form and want to insert this "if condition" in my FORM stmt. resist = ['A', 'B', 'C', 'D'] r = ['B', 'C'] if r == a.name: status="True" # condition to be included #FORM stmt TR("Resistanc

[web2py:18679] Re: Trouble with images

Hi all, I am having similar issues with image uplaods. (web2py source 1.59, XP Pro, Firefox3.0.7). I used the example of the metal-lock.jpg from CAS. It shows up file in the CAS static folder, but when I save it to disk, and upload it to a new app, its shows up corrupted. The new file has increas

[web2py:18677] Re: creating stand-alone apps of web2py

Let's just wait some while until Massimo and me > finish some final work on it. > > On Mar27, 1:32am, DJ wrote: > > > Ice, > > > This is great! Something I have been looking forward to. Will this > > allow a user to click and install the web2py application

[web2py:18646] Re: creating stand-alone apps of web2py

Ice, This is great! Something I have been looking forward to. Will this allow a user to click and install the web2py application without having to start the server each time they want to use it? Keep me posted on this. Appreciate your efforts! -Seb On Mar 25, 10:16 am, Iceberg wrote: > Hey Jud

[web2py:17564] Preselect in Drop Down

Hello, Any ideas on how to preselect a condition in the following case? SELECT(_size="1",_name="project",_type="select", *[OPTION (x.name,_value=x.id) for x in db().select(db.project.ALL)]) basically want to do selected="selected" if x.name == "Test" Thanks a lot for helping! cheers, Sebastia

[web2py:17542] CRUD form customization

Hi there, I am looking to customize the form returned by the CRUD function calls. I have done this with SQLFORM previously by specifying form variables - TR, TD, etc.. Whats the best way to do this with the new CRUD? Thanks very much! - Sebastian --~--~-~--~~~---~--~-

[web2py:16812] Re: CAS vs Auth

upport distributed group > > based access control. The CAS protocol does not provide that > > functionality so we either have to invent a new protocol or do some > > literature search on the topic and look for existing standard. > > Whatever we do if you need group based acce

[web2py:16682] CAS vs Auth

Hi there, I have used CAS previously for single-sign and it worked well. Whats recommended now? Auth or CAS? I would like to have authentication to do record level edit/updates and have the same user login for multiple apps? Can I do this in Auth? Thanks, Sebastian --~--~-~--~~