[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","Sunday"] form = SQLFORM.factory(Field("days", type='list:string', label="Weekday", requires=IS_IN_SET(weekdays, multiple=True), widget=SQLFORM.widgets.multiple.widget)) return dict(form=form) - Sebastian -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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/d/optout.
[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.com has been doing web2Py consulting bioinformatics product development for lifesciences healthcare for a few years now. Kindly add us! Thanks, Sebastian Is there a website or contact information? Which region are you located in? /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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/d/optout.
Re: [web2py] Re: IMPORTANT - WEB2PY CONSULTING
Hey Kiran, Thanks for pointing that out! Just added a link to Web2Py on my site. -Sebastian On Tuesday, March 17, 2015 at 1:44:06 PM UTC-4, Kiran Subbaraman wrote: This seems to be the site: http://10biosystems.com Also, *Sebastian*, it would be helpful if you can refer to web2py on your site too; especially since you mention the open source stack that is powering this site (http://10biosystems.com/init/default/mobile) Kiran Subbaramanhttp://subbaraman.wordpress.com/about/ 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 lifesciences healthcare for a few years now. Kindly add us! Thanks, Sebastian Is there a website or contact information? Which region are you located in? /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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+un...@googlegroups.com javascript:. For more options, visit https://groups.google.com/d/optout. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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/d/optout.
[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 companies that provide web2py consulting. This list is obsolete: http://web2py.com/init/default/support Some links are broke. Most pages do not even mention web2py. Some of them have a design that is simply not acceptable for a web development company. That list will be eliminated. IF YOU WANT TO BE LISTED please update your page to have a decent design and MENTION WEB2PY on the main site. Then respond to this thread by providing an updated link and the country were you incorporated. If you have a self-employed individual list your country of residence. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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/d/optout.
[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 added which does not exist: link href=/admin/static/_2.9.11/css/bootstrap.min.css . Is this coming from some rewrite directives? Your inputs would be much appreciated. Thanks, Sebastian The wsgi.web2py.conf file settings are as follows - WSGIScriptAlias / /opt/web-apps/web2py/wsgihandler.py Location / Order deny,allow Allow from all WSGIProcessGroup web2py /Location Directory /opt/web-apps/web2py AllowOverride None Order Allow,Deny Deny from all Files wsgihandler.py Allow from all /Files /Directory AliasMatch ^/([^/]+)/static/(.*) /opt/web-apps/web2py/applications/$1/static/$2 -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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/d/optout.
[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 Python package under the BSD license: https://pypi.python.org/pypi/pyDAL https://github.com/web2py/pydal Now you can more easily use the web2py DAL from any python app. Simply do pip install pyDAL from pydal import DAL, Field db = DAL('sqlite://storage.db') db.define_table('thing',Field('name')) db.thing.insert(name=Chair') you know the rest... ;-) Massimo -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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/d/optout.
[web2py] Re: Upgrade issues with 2.9.11
Thank you so much for that quick answer. This is why I love the web2py community!! On Wednesday, December 24, 2014 12:41:51 PM UTC-5, Niphlod wrote: since 2.1.0 (almost an year ago) we have static asset management (you can read about it here http://web2py.com/books/default/chapter/29/04/the-core?search=static_version#Static-asset-management) . you need to alter your AliasMatch ^/([^/]+)/static/(.*) /opt/web-apps/web2py/applications/$1/static/$2 directive to AliasMatch ^/([^/]+)/static/(?:_[\d]+.[\d]+.[\d]+/)?(.*) /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. 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 added which does not exist: link href=/admin/static/_2.9.11/css/bootstrap.min.css . Is this coming from some rewrite directives? Your inputs would be much appreciated. Thanks, Sebastian The wsgi.web2py.conf file settings are as follows - WSGIScriptAlias / /opt/web-apps/web2py/wsgihandler.py Location / Order deny,allow Allow from all WSGIProcessGroup web2py /Location Directory /opt/web-apps/web2py AllowOverride None Order Allow,Deny Deny from all Files wsgihandler.py Allow from all /Files /Directory AliasMatch ^/([^/]+)/static/(.*) /opt/web-apps/web2py/applications/$1/static/$2 -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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/d/optout.
[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 http://web2py.com/init/default/download Has it been fixed? Thanks for your help! -Sebastian On Monday, September 22, 2014 11:26:31 AM UTC-4, Sif Baksh wrote: How do I download the fix, I just upgraded to version 2.9.11-stable+timestamp.2014.09.15.23.35.11 Do I need to download a file? Sorry very new to web2py and was testing glyphicons today Thanks, Sif On Saturday, September 22, 2012 9:24:12 AM UTC-6, Massimo Di Pierro wrote: Just fixed in trunk. Sorry my fault. On Saturday, 22 September 2012 01:51:13 UTC-5, LightDot wrote: I took a closer look and it seems that this is caused by the css comments in the latest web2py_bootstrap.css commit. The /* */ style is the only valid comment style for css, // isn't. I reported it. Regards, Ales On Saturday, September 22, 2012 2:43:10 AM UTC+2, LightDot wrote: Same issue here, I think. I stay closer to latest trunk so I know this just happened now... the last commit to web2py_bootstrap.css seems to be it, which is just a code cleanup. Probably just a typo somewhere but I don't have time to look into the details until tomorrow. Alec, if you take the file from this commit: http://web2py.googlecode.com/hg-history/374c5ec18e9b242fad80029d82259317fb158b8c/applications/welcome/static/css/web2py_bootstrap.css you should have all the latest functionality working glyphicons. Regards, Ales On Friday, September 21, 2012 6:18:46 PM UTC+2, Alec Taylor wrote: Upgrading an old project from 2.0.1 or so to the latest trunk. I replaced my views/default and static folder with the ones from the latest welcome app. Subsequently I made my modifications to them; essentially copy and pasting blocks of code from my old layout.html to the new one, same went for my views/default/index.html page. Strangely enough none of my twitter-bootstrap icons are working. To fully test I replaced my glyphicons-*.png files in static with the latest ones from the twitter-bootstrap page, and tried once again in a view with a single line: {{=I(_class='icon-screenshot')}} Still, nothing showed up. I've also tried clearing my cache. Could you please fix the bootstrap icons? Thanks, Alec Taylor -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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/d/optout.
[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 with the CSS/JS. Any suggestions/ideas? -Sebastian -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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/d/optout.
[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: new-line character seen in unquoted field - do you need to open the file in universal-newline mode? -- --- 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: 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 exec ccode in environment File /home/www-data/web2py/applications/labcentral/models/db.py https://98.158.178.207/admin/default/edit/labcentral/models/db.py, line 615, in module auth.enable_record_versioning(db) AttributeError: 'Auth' object has no attribute 'enable_record_versioning' -Sebastian On Thursday, July 5, 2012 2:15:32 PM UTC-4, nick name wrote: On Wednesday, July 4, 2012 2:23:16 PM UTC-4, Massimo Di Pierro wrote: web2py has change since one year ago. Now you simply do: db.define_table('mytable',fields...,auth.signature) ... define more table ... auth.enable_record_versioning(db) and mytable will have a mytable_archive that works as Nick suggested. Indeed, it works beautifully, and is much simpler (and much more general) than my monkeypatching solution. Thanks, Massimo!
[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 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 exec ccode in environment File /home/www-data/web2py/applications/labcentral/models/db.py https://98.158.178.207/admin/default/edit/labcentral/models/db.py, line 615, in module auth.enable_record_versioning(db) AttributeError: 'Auth' object has no attribute 'enable_record_versioning' -Sebastian On Thursday, July 5, 2012 2:15:32 PM UTC-4, nick name wrote: On Wednesday, July 4, 2012 2:23:16 PM UTC-4, Massimo Di Pierro wrote: web2py has change since one year ago. Now you simply do: db.define_table('mytable',fields...,auth.signature) ... define more table ... auth.enable_record_versioning(db) and mytable will have a mytable_archive that works as Nick suggested. Indeed, it works beautifully, and is much simpler (and much more general) than my monkeypatching solution. Thanks, Massimo!
[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 similar work in industry and academia. Since, we do not have a life science specific focus group, - I was wondering if we could assemble a list of all life science web2py applications (open source) you have developed so that its easier for new comers to access them. - In addition, if there is interest from you, we could assemble a generic bio-web2py framework (with inbuilt libraries like BioPython and OpenBabel) that could be used as a starting point for life science application development. My intention is to popularize web2py among the life science informatics communities by providing ready to use databases and applications/frameworks. If you feel that this may be helpful for your work and sounds like something you could contribute to please let me know. Feel free to share your ideas/suggestions around this. cheers, Sebastian Jayaraj www.10biosystems.com Note: I did a quick survey of our mailing list and came up with these biology related applications (these are not on the appliances page): - CyNote : electronic lab notebook - PyMantis: life science data collaboration - Biographer: biological network editor/visualizer Let me know if there are more applications and I will add them to this list and circulate.
[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 confident of your capabilities and you will be able to sell any solution you want. Earlier this year, I had posted a note about w2p, which highlights the advantages of this light and efficient platform: https://groups.google.com/d/topic/web2py/xlIjCReudhw/discussion Good luck with your projects! -Sebastian
[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 and let me know if I am doing anything wrong - def UploadData(): CSV file upload and data processer messg = File successfully uploaded # file uploads form = SQLFORM(db.mytable,fields=['file', 'filetype'],labels={'file':T('Attach files: '), 'filetype':T('Select File Type')}, showid=False) if request.post_vars.file != None: wells = request.vars.file.file.read() ## do some processing with wells if form.accepts(request.post_vars): session.flash=T(messg) else: response.flash=T() return dict(form=form)
[web2py] Re: CRUD with custom links
Thanks Massimo. This works fine! -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] 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
[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', _class='smarttable') Let me know if you need more specific code. Thanks! -Sebastian
[web2py] SQL help
Is this query possible in web2py? SELECT * FROM `shirts` WHERE `color` IN ('red','white','blue') -Sebastian
Re: [web2py] SQL help
Thank you! This works!
[web2py] Re: SQL help
Perfect! Thanks!
[web2py] Web2py: the top notch productivity platform
!-- Note of appreciation to Massimo and team -- 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 software development business, you want to put things in your customers hands early (agile development), provide full web functionality (logins, security, https) all of which come inbuilt and the ability to work with legacy systems (Oracle, MySQL) on multiple platforms (Linux, Windows). Web2py does all of this without making you sweat and worry about library incompatibilities and platform specific issues.The range of deployments is amazing - GAE to EC2. For this alone, the team deserves a huge round of applause! The recent tool CSVstudio is a complete life saver. I recently delivered a project where I had to convert Excel files running into a few hundred columns and thousands of rows into searchable databases. Imagine doing this by hand - forget it! I initially used CloverETL (a leading enterprise ETL solution), but still had to ensure column compatibilities and fix Excel issues which were time consuming. Well, half-way into the project, client changes Excel formats, adds new files to the mix - typical scenario right? Enter CSVstudio. It not only cleans your Excel files, but recognizes column data types and the best part - it generates the Web2py model file for you. I went from Excel file to searchable web database in less than 5 minutes. This is a killer tool for application developers! I'm sure there are a number of volunteers from around the world along with Massimo who contribute to the Web2py project and I would like to say - thank you, keep up the good work and make Web2py the #1 application development platform out there! For those of you who are contemplating using this platform or need assistance deploying this within your networks (academic or commercial), feel free to talk to the mailing list or ping me for corporate specific advise. I have deployed web2py in corporate settings, hospitals and research labs successfully and would be happy to help you. There's lots of good applications like Sahana people are building with Web2py and the recent news that our mailing list traffic has overtaken Django and Ruby is indication that people are moving in the right direction. Let the work talk, not the hype. And that's where web2py is the silent assassin. -Sebastian
[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] Re: Japan
+1
[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 plugin to have. - Sebastian
[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 raw sql (MySQL). Minor issue - when crud/db admin interface checks for incomplete forms, it checks all radio buttons by default. Deleted a few records by mistake as I did not see the delete option checked. -Sebastian
[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 possible, can you recommend any other ways to accomplish the same (using crud)? Thanks, sebastian
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, can we set the browser to cache certain reusable aspects like CSS, images, etc? -Sebastian
[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 ccode in environment File /home/www-data/web2py/applications/admin/compiled/ controllers_default_change_password.py, line 1148, in module File /home/www-data/web2py/gluon/globals.py, line 96, in lambda self._caller = lambda f: f() File /home/www-data/web2py/applications/admin/compiled/ controllers_default_change_password.py, line 94, in change_password File /usr/lib/python2.5/posixpath.py, line 62, in join elif path == '' or path.endswith('/'): AttributeError: 'NoneType' object has no attribute 'endswith'
[web2py] Re: web2py 1.89.1 is OUT
Love the file search function! Nice work! -S On Nov 12, 12:09 pm, appydev appy...@gmail.com 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 bg.bra...@gmail.com 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 Mon, Nov 8, 2010 at 5:15 PM, Martín Mulone mulone.mar...@gmail.com wrote: Many Thanks branko, it's beautifull!!. The edit area has a problem with icons i think. It's not display it. 2010/11/8 mdipierro mdipie...@cs.depaul.edu You can try it here: http://web2py.com/demo_admin/default/site I think Branko did an excellent job! -- My blog: http://martin.tecnodoc.com.ar My portfolio *spanish*: http://www.tecnodoc.com.ar Checkout my last proyect instant-press:http://www.instant2press.com -- Branko Vukelić bg.bra...@gmail.com stu...@brankovukelic.com Check out my blog:http://www.brankovukelic.com/ Check out my portfolio:http://www.flickr.com/photos/foxbunny/ Registered Linux user #438078 (http://counter.li.org/) I hang out on identi.ca:http://identi.ca/foxbunny Gimp Brushmakers Guildhttp://bit.ly/gbg-group
[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 names (rather than having to type each one) b) can the wizard handle multiple select datatypes? c) ability to select data services options like csv, rss while defining the table Really like how you are constantly pushing the limits of W2P! -Sebastian On Oct 21, 6:17 pm, Anthony av201...@yahoo.com wrote: On Oct 21, 5:46 pm, Timmie timmichel...@gmx-topmail.de wrote: I also did not understand in the video how the table was pre-populated that quickly. Please explain this. http://web2py.com/book/default/chapter/12#Populating-Database-with-Du... Yet another cool web2py feature -- and it's even in the book.
[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 comment on any frameworks in java you have worked with that resemble Web2py? Thank you for your comments. -Sebastian
[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 marketing standpoint - The About section is too long and can be made shorter to capture the essence of Web2py. I feel W2P is far superior and easier to learn than comparable web frameworks and we do not need to keep comparing to frameworks like RoR or Django for acceptance. Instead we should focus on programmer productivity, ease of use, enterprise integration and gear it towards cutting edge web development. Move the comparisons to F.A.Q (why is W2p better than...) d) A list of companies/organizations using W2P should also be highlighted. People like to see who is using a software before trying it out - esp. when it comes to open source. Web2py has come a long way since the early versions and it is clearly the swiss-army-knife of existing python frameworks. Keep up the good work and keep the momentum going! -Sebastian On Oct 10, 3:07 am, Adi aditya.sa...@gmail.com wrote: Amazing work Massimo, Bruno and Martin! On Oct 10, 11:10 am, Albert Abril albert.ab...@gmail.com wrote: I suggested Bruno and Martin another concept of logo. Here's my draft design (attached). On Sun, Oct 10, 2010 at 6:54 AM, guruyaya guruy...@gmail.com wrote: I happen to like to new logo. It looks like very slick. The offers on the google docs are problematic, as they are rectangles, not squares (or even almost squares). Imagine using it as a desktop icon, or as a favicon, and I think you'll see the problem. Overall - I like the new design. After getting used to it, I'm sure no- one will miss the old one. On Oct 10, 6:01 am, Bruno Rocha rochacbr...@gmail.com wrote: I like that concept - https://docs.google.com/leaf?id=0BzPqKovYWlw-N2IwYTA0Y2EtNDNjMi00OTg1... But, the snake looks childish. the idea is very good, but snake have to be redesigned, or maybe simplified, perhaps just the snake silhouette. And, I still like the actual logo. 2010/10/10 weheh richard_gor...@verizon.net New website is good. Logo is kind of sinister looking IMHO. If we need a new logo, I would like to resubmit some prototype logos from my friend Diane Heller. I think they have potential and last year, she was willing to spend some more time on the logo (pro bono) if there was any interest. If there's interest now, I'll contact her about it again. https://docs.google.com/leaf?id=0BzPqKovYWlw-ODg1ZjE0YzgtMTQ3NC00NmM0. .. https://docs.google.com/leaf?id=0BzPqKovYWlw-MmRhNjcwNjAtM2Y4OS00ZTM1. .. https://docs.google.com/leaf?id=0BzPqKovYWlw-N2IwYTA0Y2EtNDNjMi00OTg1. .. On Oct 9, 4:07 pm, mdipierro mdipie...@cs.depaul.edu wrote: New web2py layout: http://web2py.com Thanks Bruno and Martin New demo_admin: http://web2py.com/demo_admin Massimo concepte.4.logo.web2py.png 74KViewDownload
[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\scriptsextract_mysql_models.py bio:b...@nrcf Traceback (most recent call last): File C:\Program Files (x86)\web2py\scripts \extract_mysql_models.py, line 106 , in module print mysql(m.group(3),m.group(1),m.group(2)) File C:\Program Files (x86)\web2py\scripts \extract_mysql_models.py, line 82, in mysql table_name = re.search('CREATE TABLE .(\S+). \(', sql_lines[0]).group(1) AttributeError: 'NoneType' object has no attribute 'group' Has anyone figured out how to get this script working? Thanks, S On Sep 17, 10:25 am, ron_m ron.mco...@gmail.com wrote: Program mysqldump produces a line like this for an id field `id` int(11) NOT NULL AUTO_INCREMENT, and because there is no special case processing int becomes integer. It looks like a possible solution would be to recognise AUTO_INCREMENT and for that case over ride the int translation to 'integer' replacing with 'id' instead. I am running the database created by a set of model files through the script to test the result, not exactly a legacy database but a round- trip test is a good test too. In my case the id field should be dropped because it is auto generated. That brings the question if the field is named id and is AUTO_INCREMENT should it be dropped? If the source is a legacy database then that might be okay because the legacy use is consistent with the way web2py uses the id field. Another one that would be nice is the varchar(len) could be translated to 'string', length=len in the emitted Field constructor. Another problem I see is a boolean in the model becomes a char(1) in the db which becomes a string in the extract but maybe I am pushing the envelope since my source is a model to start with. Would it be better to recognisu a char(1) as a boolean? Possibly not. At this point the script provides an initial cut at a model.py file and then some human intelligence needs to be applied to finish the result. Of course it would be nice to have nirvana which would be a 100% accurate and complete translation with all possible Field() parameters filled in for a given database which requires a lot more work. I am willing to help out but my workload is high right now. Of course it should not crash as it does for Johann right now. If you would like to provide comments on what you think is most important I can help out. Ron On Sep 17, 6:24 am, mdipierro mdipie...@cs.depaul.edu wrote: I see a problem here: Field('id','integer'), should be Field('id','id'), On Sep 9, 12:01 am, ron_m ron.mco...@gmail.com wrote: On Sep 8, 1:30 pm, mdipierro mdipie...@cs.depaul.edu wrote: So maybe tonight do you want me to go through the manual and find all the missing datatypes and try to add them to the map? I would not stop you. ;-) Here is a replacement data_type_map, it was shuffled a bit to put like types together for easier maintenance. I didn't know what to do with the YEAR type so it is commented out. I am not sure the decimal type should be mapped to integer since the DAL accepts decimal(n,M) as a field type. data_type_map = dict( varchar = 'string', int = 'integer', integer = 'integer', tinyint = 'integer', smallint = 'integer', mediumint = 'integer', bigint = 'integer', float = 'double', double = 'double', char = 'string', decimal = 'integer', date = 'date', #year = 'date', time = 'time', timestamp = 'datetime', datetime = 'datetime', binary = 'blob', blob = 'blob', tinyblob = 'blob', mediumblob = 'blob', longblob = 'blob', text = 'text', tinytext = 'text', mediumtext = 'text', longtext = 'text', ) I also fixed the remaining problem in the line match re.search so line 75 or line 87 after above dict is changed 75c87 hit = re.search('(\S+)\s+(\S+)( .*)?', line) --- hit = re.search('(\S+)\s+(\S+)(,| )( .*)?', line) this fixes the matching on lines like `description` longtext, The comma immediately after the type got included as part of the type string match in error. Here is the output for the auth_event table legacy_db.define_table('auth_event', Field('id','integer'), Field('time_stamp','datetime'), Field('client_ip','string'), Field('user_id','integer'), Field('origin','string'), Field('description','text'), migrate=False) The id field should not be printed since it will be added automatically. The varchar fields have a
[web2py] Re: Sorting alphanumeric data
Thanks Thadeus and Jonathan for your suggestions. -S On Jul 23, 10:06 pm, Thadeus Burgess thade...@thadeusb.com wrote: It is possible to create SQL functions that will represent your natural sort. You can use db.executesql() to call the function. Read the following comments in the below 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 jlund...@pobox.com wrote: On Jul 23, 2010, at 5:39 PM, DJ wrote: 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? What other kind of operations does orderby allow? (I saw field.upper and field.month). What you're looking for is a natural (as opposed to lexical) sort, which most (all?) databases lack. A common solution is to create another column to serve as a sort key. In your example, it might be A01, A02, ... A10. Or two columns, one with the leading alpha, sorted lexically, and the other with the number, sorted numerically (and a two-column major-minor sort).
[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] Re: Menu Selected option
Thanks Massimo. Yamandu, thanks for your tip. I am using the inbuilt MENU functions for now. -S On Apr 29, 8:30 am, yamandu yamandu.co...@gmail.com wrote: Well, in my app I am using accordion from jQuery plus a session var to indicate active item and som jQuery code to do the thing in the template. 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 sebastianjaya...@gmail.com wrote: 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-menu web2py-menu- horizontal')}} {{pass}} Thanks for your help! -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 jlund...@pobox.com wrote: On Apr 29, 2010, at 1:49 PM, DJ wrote: I would like to set the auth method to use any username ('tom') instead of forcing an email id ('@something.com'). How can I do this? In the latest version, call define_tables(username=True). In earlier versions you have to create the user table manually; there's a discussion in the manual. IIRC, if there's a username in the user table, it gets used by auth in preference to the email address.
[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] 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-menu web2py-menu- horizontal')}} {{pass}} Thanks for your help! -Sebastian
[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 -Javascript libraries/AJAX integration -Deployment skills on GAE or hosted linux servers using Apache Send me a brief CV, samples of your work (online if available), rate/ hr and availability. cheers, Sebastian -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
[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, Giovanni Giorgi j...@objectsroot.com wrote: Hi all, in the attempt to better knowing web2py and its community, I'd like to write some entry on my blog (gioorgi.com). I want to do a useful work for the community itself. This day I'd like to focus myself on the question: for which projects do you use web2py? I have seen the master project open sourced in the last few days posted by Asefa Debebe on 7th March (titled 'Relase of the first HL7 based on web2py framework', demo at http://web2py.com/HLv3). So, how you are using web2py? For instance, do you prefer form-entry based application (data entry, CRM,etc) or community based one (like CMS, Facebook clone etc)? ciao ciao! -- Team Leader Gioorgi.com Chief Editor -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
[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? I need a displaying framework not a calendaring server like Bedework. Thank you for your inputs. -Sebastian -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
[web2py:37054] Re: Database driven Calendar
Thanks Thadeus and Massimo. The fullcalendar app looks great in the CRM demo. Will check out the source. -Sebastian On Dec 11, 4:41 pm, mdipierro mdipie...@cs.depaul.edu wrote: It is used in here: http://web2py-crm.appspot.com/ The source is posted. Massimo On Dec 11, 2:48 pm, Thadeus Burgess thade...@thadeusb.com 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 sebastianjaya...@gmail.com wrote: ou have any recommendations for any existing calendar framework that can work with web2py? I need a displaying framework not a calendaring server like Bede -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
[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.animal.id) ), # this fails SQLField(sex, db.sex) ) after a create action, I would like the following result: animal.id = 1 animal.name = ANML-1 Is this possible? Thanks for your help! -Sebastian PS: would be nice to have 'ANML-01' with zeros padded according to id number (eg. ANML-000299) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:30541] Re: ProgrammingError: LOB variable no longer valid after subsequent fetch
Hi Massimo, Yes, you are correct. I used the TEXT datatype for an application I am building. While it works on MySQL, it throws errors on Oracle. Web2Py by default creates CLOB datatypes on Oracle when you specify TEXT in the model which causes this error. How did you fix this issue with BLOBs? I eventually had to do a work-around. I modified the Oracle datatype from CLOB to VARCHAR2 with a large character limit and changed the model definition from text to string. -Sebastian On Sep 1, 8:42 pm, mdipierro mdipie...@cs.depaul.edu wrote: OK. I know the problem. The fact is web2py does not create CLOBs so it cannot handle them. Actually this problem arises also with BLOBs and we fixed it long ago. The same fix would apply to CLOBs too but there is no way for web2py to know that a field is a CLOB since we do not provide a way to define it. I imagine you have a model that treats a legacy CLOB as text, correct? On Sep 1, 12:20 pm,DJsebastianjaya...@gmail.com wrote: Massimo, I am using - Python 2.5.2 DB Driver: cx_Oracle-5.0.1-10g.win32-py2.5 Oracle 10G Platform: Windows 2003 Server -Sebastian On Aug 29, 4:22 am, mdipierro mdipie...@cs.depaul.edu wrote: Which python version? I vaguely remember this had been addressed and the problem has gone away. Massimo On Aug 28, 2:40 pm,DJsebastianjaya...@gmail.com 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 database module. From their website,http://cx-oracle.sourceforge.net/html/lob.html Note: Internally, Oracle uses LOB locators which are allocated based on the cursor array size. Thus, it is important that the data in the LOB object be manipulated before another internal fetch takes place. The safest way to do this is to use the cursor as an iterator. In particular, do not use the fetchall() method. The exception “LOB variable no longer valid after subsequent fetch” will be raised if an attempt to access a LOB variable after a subsequent fetch is detected. It appears that Web2py DAL is using the fetchall method to retrieve the data. Kindly advise if you have any suggestions/ideas to fix this. Thanks, Sebastian --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[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 that can support ads, groups, multi-role privileges, social networking, calendar, news feeds, and file management would be great for both intranet sites and simple content driven websites. cheers, Sebastian On Sep 3, 9:18 am, mdipierro mdipie...@cs.depaul.edu wrote: I just finished the book. As far as web2py is concerned my interest now is mergingT3+KPAX+jPolite into a new modular and programmable CMS. Massimo On Sep 3, 7:49 am, Julio Monteiro jmonte...@gmail.com wrote: Hello Massimo, I didn't realizeT3was old, nice to know that it has been merged with web2py code! Is that a way I can start coding from the t3_wiki in web2py out of the box? What are the current web2py projects that you are working on? Thanks a lot! Julio Monteiro mdipierro wrote:No because it is old. 80% of theT3code is now in web2py code and written better.T3needs to be rewritten, integrated with jpolite and kpax. On Sep 2, 8:54 pm, JorgeRjorgeh...@gmail.comwrote:IsT3mentioned in the book?? On Sep 2, 8:13 pm, mdipierromdipie...@cs.depaul.eduwrote:Thanks Julio.On Sep 2, 7:22 pm, Júlio Monteirojmonte...@gmail.comwrote:Hello there!I am new to Web2py, but I am amazed at its huge power and simplicity!I developed portals using Zope/Plone for 5 years, here in Brazil. Then, last year I began to learn and develop a big project using Django. I liked Django, but after a while I realized that ORMs suck and I missed web based editing like I used to have in Zope. Recently I found Web2py and I can't stop feeling awed! I already installed it on my server and I am doing some experiments with it.Today I bumped in theT3project, looks VERY promising! I would love to start helping in a Web2py project, and I was looking for a Wiki- based one, likeT3. I need a wiki that can send notifications to people when it is edited, and, at the same time can act as a forum/ mailing list. For what I understand, looks likeT3is perfect for starting, right?Thanks for such a great framework!Monteiro --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:29808] Re: ProgrammingError: LOB variable no longer valid after subsequent fetch
Massimo, I am using - Python 2.5.2 DB Driver: cx_Oracle-5.0.1-10g.win32-py2.5 Oracle 10G Platform: Windows 2003 Server -Sebastian On Aug 29, 4:22 am, mdipierro mdipie...@cs.depaul.edu wrote: Which python version? I vaguely remember this had been addressed and the problem has gone away. Massimo On Aug 28, 2:40 pm,DJsebastianjaya...@gmail.com 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 database module. From their website,http://cx-oracle.sourceforge.net/html/lob.html Note: Internally, Oracle uses LOB locators which are allocated based on the cursor array size. Thus, it is important that the data in the LOB object be manipulated before another internal fetch takes place. The safest way to do this is to use the cursor as an iterator. In particular, do not use the fetchall() method. The exception “LOB variable no longer valid after subsequent fetch” will be raised if an attempt to access a LOB variable after a subsequent fetch is detected. It appears that Web2py DAL is using the fetchall method to retrieve the data. Kindly advise if you have any suggestions/ideas to fix this. Thanks, Sebastian --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[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, Oracle uses LOB locators which are allocated based on the cursor array size. Thus, it is important that the data in the LOB object be manipulated before another internal fetch takes place. The safest way to do this is to use the cursor as an iterator. In particular, do not use the fetchall() method. The exception “LOB variable no longer valid after subsequent fetch” will be raised if an attempt to access a LOB variable after a subsequent fetch is detected. It appears that Web2py DAL is using the fetchall method to retrieve the data. Kindly advise if you have any suggestions/ideas to fix this. Thanks, Sebastian --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:26982] Re: Oracle Errors on multiple row retrieval
Hi Massimo, Tried the db.commit and I still get the error. Not sure what is causing it. I have another SQL search query which works fine. I have included code fragments from both functions for comparison. Any help would be appreciated. Thanks. # SQL search query -- Web2py 1.56, Oracle 10g # # This code throws errors if you have more than 10 records in the results ---# # Search code for freezer if request.vars.freezer!= '1': # '1' = None s=s(db.packing.freezer==request.vars.freezer) r = db(db.freezer.id == request.vars.freezer).select (db.freezer.name) for ra in r: t = t + ' freezer=' + str(ra.name) # Search code for rack if request.vars.rack!= '1': s=s(db.packing.rack==request.vars.rack) r = db(db.rack.id == request.vars.rack).select(db.rack.name) for ra in r: t = t + ' rack=' + str(ra.name) # execute query if request.vars and t != '': rows=s.select(orderby=db.packing.name) #db.commit() total = len(rows) else: rows=[] total = len(rows) return dict(form=form,rows=rows, total=total, t=t) # -- this code works --# if request.vars.name: location = db((db.packing.freezer==db.freezer.id) (db.packing.rack==db.rack.id)) searchStr = str(request.vars.name).upper() # search query for defined fields record=location(db.freezer.name.upper().like('%'+searchStr +'%') | db.rack.name.upper().like('%'+searchStr+'%') ).select(db.freezer.name, db.rack.name) else: record = [] total=len(record) return dict(form=form,record=record, total=total, query=request.vars.name) #--end of code # On Jul 16, 4:54 pm, mdipierro mdipie...@cs.depaul.edu wrote: trydb.commit() after the first fetch. On 16 Lug, 15:07, DJ sebastianjaya...@gmail.com wrote: 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\web2py_src\web2py \gluon\restricted.py, line 98, in restricted exec ccode in environment File C:\Documents and Settings\sjayaraj\Desktop\web2py_src\web2py \applications\myapp/views/viewer/search.html, line 67, in module File C:\Documents and Settings\sjayaraj\Desktop\web2py_src\web2py \gluon\globals.py, line 84, in write self.body.write(xmlescape(data)) File C:\Documents and Settings\sjayaraj\Desktop\web2py_src\web2py \gluon\html.py, line 97, in xmlescape data = str(data) ProgrammingError: LOB variable no longer valid after subsequent fetch Version: 1.65.5 CX_Oracle docs for LOB:http://cx-oracle.sourceforge.net/html/lob.html --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[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\web2py_src\web2py \gluon\restricted.py, line 98, in restricted exec ccode in environment File C:\Documents and Settings\sjayaraj\Desktop\web2py_src\web2py \applications\myapp/views/viewer/search.html, line 67, in module File C:\Documents and Settings\sjayaraj\Desktop\web2py_src\web2py \gluon\globals.py, line 84, in write self.body.write(xmlescape(data)) File C:\Documents and Settings\sjayaraj\Desktop\web2py_src\web2py \gluon\html.py, line 97, in xmlescape data = str(data) ProgrammingError: LOB variable no longer valid after subsequent fetch Version: 1.65.5 CX_Oracle docs for LOB: http://cx-oracle.sourceforge.net/html/lob.html --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py Web Framework group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[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 excited to read about it. Or we could ask Reuven Lerner to cover it since he only does web frameworks. - Sebastian On Jun 14, 5:33 pm, mdipierro mdipie...@cs.depaul.edu wrote: ... but I am not sure I understand whether it is a positive or a negative comment. http://twitter.com/dreid/status/2109869826 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py Web Framework group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:23962] Re: Form validation causes checkbox to get selected
Thanks Massimo. Quick question, how do I get this patch? (url address) Also, can I update this patch into my current version of web2py (1.56.4) or do I need to do a full upgrade? -Sebastian On Jun 10, 10:31 pm, mdipierro mdipie...@cs.depaul.edu wrote: You are correct. I fixed it and I am uploading to trunk now (launchpad 904). Massimo On Jun 10, 5:52 pm, DJ sebastianjaya...@gmail.com 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 message (good behavior). But along with this, the checkbox fields in the form also get selected even though they were left unchecked (unwanted action). I suspect this may be a bug during form validation. Any ideas on how to get around this? Thanks for your help. -Sebastian Web2py: 1.56.4 -Code fragment -- # db().select(db.resist.ALL) = 'test1', 'test2', 'test3', 'test4' ## from DB resist_mult = ['test2', 'test3'] form=FORM(TABLE( TR(TD(Name:,_class=right),INPUT(_type=text, _size=, _name=name, value=str(a.name)+.1, requires=[IS_NOT_EMPTY (), IS_NOT_IN_DB(db, 'project.name')]), TD(Notebook:,_class=right),INPUT (_type=text,_name=notebook,_size=8, requires=IS_NOT_EMPTY()), TD(Page:,_class=right),INPUT (_type=text,_size=5,_name=page, requires=IS_NOT_EMPTY()), #BR(), TABLE( TR(Resistances:, *[TD(x.name, INPUT(_type=checkbox, name=resist_mult,_value=x.name, value=x.name in a.resist_mult)) for x in db().select(db.resist.ALL)]), ) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py Web Framework group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:23967] Re: Form validation causes checkbox to get selected
Thanks Francis. On Jun 11, 6:58 pm, Fran francisb...@googlemail.com wrote: On Jun 11, 11:33 pm, DJ sebastianjaya...@gmail.com 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.launchpad.net/~mdipierro/web2py/devel/revision/905http://bazaar.launchpad.net/~mdipierro/web2py/devel/revision/906 Also, can I update this patch into my current version of web2py (1.56.4) or do I need to do a full upgrade? You can try an incremental upgrade I think in this case, but I would consider a full upgrade soon anyway... F --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py Web Framework group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[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 action). I suspect this may be a bug during form validation. Any ideas on how to get around this? Thanks for your help. -Sebastian Web2py: 1.56.4 -Code fragment -- # db().select(db.resist.ALL) = 'test1', 'test2', 'test3', 'test4' ## from DB resist_mult = ['test2', 'test3'] form=FORM(TABLE( TR(TD(Name:,_class=right),INPUT(_type=text, _size=, _name=name, value=str(a.name)+.1, requires=[IS_NOT_EMPTY (), IS_NOT_IN_DB(db, 'project.name')]), TD(Notebook:,_class=right),INPUT (_type=text,_name=notebook,_size=8, requires=IS_NOT_EMPTY()), TD(Page:,_class=right),INPUT (_type=text,_size=5,_name=page, requires=IS_NOT_EMPTY()), #BR(), TABLE( TR(Resistances:, *[TD(x.name, INPUT(_type=checkbox, name=resist_mult,_value=x.name, value=x.name in a.resist_mult)) for x in db().select(db.resist.ALL)]), ) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py Web Framework group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[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 98, in restricted exec ccode in environment File C:/Program Files/web2py/applications/strain/views/ appadmin.html, line 35, in module {{for dt in items:}} TypeError: 'NoneType' object is unsubscriptable --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py Web Framework group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:20386] Re: Nonetype object unscriptable
Hi Massimo, This is an app I wrote on version 1.56 and saw this when I installed it on a machine running 1.59. Replacing the new version appadmin files fixed this issue. Thanks for your quick response! I recently saw your interview on PyCon (vs Django, etc.) and liked your comments/vision for Web2py. - Sebastian On Apr 23, 5:57 pm, mdipierro mdipie...@cs.depaul.edu wrote: Which app is this? This app seems to have a old appadmin file (the current one does not have that line) and I suspect there is a buggy appadmin. Move the views/appadmin.html and controllers/appadmin.py over from the welcome app. Massimo On Apr 23, 4:17 pm, DJ sebastianjaya...@gmail.com 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 session data from the app. Traceback (most recent call last): File C:\Program Files\web2py\gluon\restricted.py, line 98, in restricted exec ccode in environment File C:/Program Files/web2py/applications/strain/views/ appadmin.html, line 35, in module {{for dt in items:}} TypeError: 'NoneType' object is unsubscriptable --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py Web Framework group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[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 without the required fields, the web2py form validation shows up (cannot be empty) which is good. But the strange thing that happens, is that all the Resistance checkbox fields get selected while the other fields (Project, Source) remain intact. Any ideas/suggestions will be appreciated. TIA! !--- controller -- r = '' record = db(query).select(db.Entries.ALL) for a in record: # resist.table contains ['None', 'Amp', 'Kan', 'Str', 'Cam'] r = a.resist_genom.split('+') # contains array ['Amp','Kan'] form=FORM(TABLE( TR(TD(Name:,_class=right),INPUT(_type=text, _size=, _name=name, value=str(a.name)+.1, requires=[IS_NOT_EMPTY ()] ), TD(Notebook:,_class=right),INPUT (_type=text,_name=notebook,_size=8, requires=IS_NOT_EMPTY()), TD(Page:,_class=right),INPUT (_type=text,_size=5,_name=page, requires=IS_NOT_EMPTY()), TD(Project:,_class=right),SELECT (_size=1,_name=project,_type=select, value=a.project,*[OPTION (x.name,_value=x.id) for x in db().select (db.project.ALL)]), TD(Source:,_class=right),SELECT (_size=1,_name=source,_type=select, value=a.source,*[OPTION (x.name,_value=x.id) for x in db().select(db.source.ALL)]), )), BR(), TR(TD(Resistance:, *[TD(x.name, INPUT(_type=checkbox, _name=resist_genom,_value=x.name, value=x.name in r)) for x in db ().select(db.resist.ALL)]), ), - code shortened- !-- end controller -- --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py Web Framework group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[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 mdipie...@cs.depaul.edu 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 Kid: My train has 3 cars. They are called model, view, controller Girl: .. oh ... OK. pause Girl: I do not have a train but I have a web page with my pictures on Kid: So what? Do you have pictures of trains? Girl: No, but I like to play with others and I move faster then your train. Kid: I do not believe it! Girl: so...shall we go blow off some steam? Voice from background: Ruby... I told you not to talk to strangers! --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py Web Framework group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[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 integration with LDAP d) Integration with other open source frameworks including TinyMCE, Apache, (production deployments, etc) e) Start with a simple app that users can deploy in a few minutes and slowly add more advanced components to it. (eg. intranet, news, mashups, blogs etc.) Sorry if this looks like a big list already ;-)...once corporate dev teams get a hang of it and can deploy an enterprise app quickly, acceptance for web2py will shoot up. Good luck with this project. -Sebastian On Apr 1, 3:40 pm, TheDude officed...@gmail.com wrote: So the idea of writing a quick start jump guide is better than the in- depth version? OK then, I will get started shortly. :) It will take me quite some time to write this book, but I think it'll help the community tremendously. Massimo, if you have any insight on 1.6 (anything different coding wise from 1.59) please let me know. On Apr 1, 3:27 pm, g-man gregor...@gmail.com wrote: Nice! One 'role model' you might want to study is Obie Fernandez' The Rails Way, which goes deeply into each element of that complex framework... On Apr 1, 11:28 am, TheDude officed...@gmail.com wrote: (This isn't an April Fool's Joke) So, I've been writing a book for Web2Py, but recently came towards a new direction...we already have a great in-depth book writeen by Massimo so I was wondering... Would you guys be interested in a book for web2py like 250 pages long that goes in-depth? Or, a nice little quick start guide :D here's the thing, BOTH will be able to teach you the fundamentals that you'll need to create 80%+ web applications. One will just tell you how to do things, but then link you to the documentation page available on web2py.com for more information. Examples: (QuickStart) In order to create a table for our database, we'll need to bdefine/ b our table. code: db.define_table('tablename', SQLField('fieldname','string', notnull=True) SQLField('fieldname2','integer', notnull=True), ) Let's say we wanted to have a table reference the tablename table. db.define_table('table2', SQLField('tablename_id', db.tablename), SQLField('imafield','boolean'), ) explain how the reference key works briefly then provide a link to the DAL explantion page for all options I think the quick-start guide will really help boost the web2py community and get people started on a project. It's similar to the Dojo, but a bit different since it'll go more in-depth than the Dojo but at the same time you don't have to learn everything. :) It will skip things like What is MVC? and Why Web2Py framework etc. I believe Massimo has already full-filled that information. The book will be available online (HTML) and PDF as well as a published book. Please let me know if your thoughts. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py Web Framework group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18874] Re: Multiple checkbox - preselected syntax
Here's what I want to do - be able to show/update selected values in a multiple checkbox form. checkbox values come from a predefined table: ['A', 'B', 'C', 'D] user settings (separate field) that have been saved are: ['A', 'C'] 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 mdipie...@cs.depaul.edu 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 variables? On Mar 30, 7:00 pm,DJsebastianjaya...@gmail.com wrote: 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(Resistances:, *[TD(x.name, *[INPUT(_type=checkbox, _name=resist_mult,_value=x.name, value=status) for r in a.resist_mult.split('+')]) for x in db().select(db.resist.ALL)]), Kindly let me know if you can do this or have any other solution. thanks, Seb --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py Web Framework group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[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 denes1...@yahoo.ca wrote: On Mar 30, 7:00 pm, DJ sebastianjaya...@gmail.com wrote: 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'] Maybe something like: p=[INPUT(_type=checkbox,_name=resist_mult,_value=x,value=x in r) for x in resist] input name=resist_mult type=checkbox value=A / input checked=checked name=resist_mult type=checkbox value=B / input checked=checked name=resist_mult type=checkbox value=C / input name=resist_mult type=checkbox value=D / --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py Web Framework group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[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(Resistances:, *[TD(x.name, *[INPUT(_type=checkbox, _name=resist_mult,_value=x.name, value=status) for r in a.resist_mult.split('+')]) for x in db().select(db.resist.ALL)]), Kindly let me know if you can do this or have any other solution. thanks, Seb --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py Web Framework group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:18677] Re: creating stand-alone apps of web2py
Nice work...waiting to try it out! On Mar 27, 1:36 am, Iceberg iceb...@21cn.com wrote: Mmmm, let me say it this way. With the plugin, 1. a developer can just click to have a setup.exe as his own distribution package; 2. and the end user can run this setup.exe as every other normal Windows programs, then have an entry in the Windows Startup Menu to run web2py (each time he wants to use it), then use a browser to visit http://127.0.0.1:8000; to use the app. Well, I know I have enough talking but not showing the real work, that is not good. :-) Let's just wait some while until Massimo and me finish some final work on it. On Mar27, 1:32am, DJ sebastianjaya...@gmail.com wrote: 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 iceb...@21cn.com wrote: Hey Jude, don't be afraid... :-) I have been there and done that. In recent days I happened to work on how to build an app into a stand-alone setup.exe for Windows platform, by a single click. The work is mainly based on the free Inno Setup. I am posting the almost-finished work to Massimo for some final polishing. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py Web Framework group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[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 increased in size. Hope this helps debug this issue. regards, Sebastian On Mar 27, 11:21 am, Doug Cuthbertson doug.cuthbert...@gmail.com wrote: Has anyone else had this problem (uploading images)? Are there any debug settings for web2py or log files it can generate to help determine what's going wrong? If someone can point me in the right direction, I'll be happy to try to analyze/debug my installation. Thanks, Doug C. On Mar 26, 5:41 am, Doug Cuthbertson doug.cuthbert...@gmail.com wrote: I've tested Firefox 3.0.7 and IE 7.0. Regards, Doug C. On Mar 25, 10:38 pm, mdipierro mdipie...@cs.depaul.edu wrote: Which browser? Have you tried more than one? Massimo On Mar 25, 3:22 pm, Doug Cuthbertson doug.cuthbert...@gmail.com wrote: Massimo, Yes, I'm uploading from the admin/default/design/TestBlog page. Here's what I've tried: web2py: versions 1.58 and 1.59 binary and I even downloaded the source from SVN this afternoon and ran from that with no difference. OS: Windows XP SP3 Home Edition, and W2K3 SP2. I normally run from binary on a USB memory stick. Just for fun, I tried source on both the memory stick and from the hard drive on the W2K3 system (Python 2.5.4), with no improvement. In all cases, I used the default web server (CherryPy, right?) onhttp://localhost:8000. Regards, Doug C. On Mar 25, 3:31 pm, mdipierro mdipie...@cs.depaul.edu wrote: From your email I assume you are uploading the images via the admin/ design page. Which version of web2py are you running? Which OS? binary or source? Which web server? Massimo On Mar 25, 10:20 am, Doug Cuthbertson doug.cuthbert...@gmail.com wrote: Massimo, Thanks for the reply. When I accesshttp://localhost:8000/TestBlog/static/image2.jpg I get an image of the text http://localhost:8000/TestBlog/static/ image2.jpg. When I try other images I either get a corrupted version of the original image, or I get an image of the URL text. When I open the directory E:\web2py\applications\TestBlog\static, the images (image1.jpg and image2.jpg in this case) are there, but either they cannot be displayed in an image viewer or they are displayed as a corrupted version of the original. Regards, Doug C. On Mar 25, 10:17 am, mdipierro mdipie...@cs.depaul.edu wrote: Can you access http://localhost:8000/TestBlog/static/image2.jpg is it either a typo or the image is not there. Massimo On Mar 25, 6:24 am, Doug Cuthbertson doug.cuthbert...@gmail.com wrote: Hi Folks, I'm new to web2py. I've worked through the recipe example in the cookbook and it worked like a champ! I really like being able to create all the parts of a web application via the browser. It means never having to open a console on the web server. Very nice. Next, I tried following the instructions in how to turn a static html page into a blog in 90 seconds from the FAQ. All was going well, except that the image didn't display on the /TestBlog/default/hello web page. I've tried both versions 1.58 and 1.59 of web2py. Here's what the source view looks like from Firefox (Ctrl-U): html head title Welcome to My Blog /title /head body img src=/TestBlog/static/image2.jpg/ Please say something here! /body /html I uploaded a couple of images, so this shows the last attempt with image2.jpg as the src attribute. Has anyone seen this kind of behavior before? Thank you for any and all advice. Regards, Doug C. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py Web Framework group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[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 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py Web Framework group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[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, Sebastian --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py Web Framework group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[web2py:16812] Re: CAS vs Auth
Thank you both for the responses. I am beginning to use web2py for corporate applications and having enterprise strength authentication as a pluggable app will be very useful. On Feb 23, 8:06 am, notabene niels...@gmail.com wrote: Integrated Authentication and Authorization Infrastructure systems tend to be very complex. The standard I suppose is defined by OASIS in the Security Assertion Markup Language (SAMLhttp://en.wikipedia.org/wiki/SAML). An easy demo of the User-experience is given here:http://www.switch.ch/aai/demo/easy.html But the framework (Shibboleth) is java and quite complex. Here is a list of software supporting SAML 2.0:http://docs.feide.no/fs-0048-1.3-en.html#txt-0078-SW-alternatives On Feb 22, 6:16 am, mdipierro mdipie...@cs.depaul.edu wrote: Right now they serve two distinct purpose. CAS does single sign on but no access control Auth does basic authentication and group based access control. It would be possible to implement authentication on CAS and/or implement CAS using Auth. A more ambitious goal is to extend CAS to support 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 access control, you cannot do that with CAS. Massimo On Feb 21, 7:31 pm, DJ sebastianjaya...@gmail.com wrote: 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 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py Web Framework group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---
[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 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py Web Framework group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~--~~~~--~~--~--~---