[web2py] Re: Do you use web2py professionally?

2013-08-14 Thread Arnon Marcus
We dont have such an example. As I said, what tends to happen after awhile, is that a new separate module emearges, just for dealing with treegrid on the back-end. All handlers for even the simplest of use-cases, are then refactored into using this module, in order to avoid code-duplications. Th

[web2py] Re: File extention automatically changes when a file is uploaded

2013-08-14 Thread at
Thank you Anthony! That means it should be working in 2.4.6-stable? we've 2.4.6-stable on production server. Regards, AT On Thursday, 15 August 2013 10:55:50 UTC+5, Anthony wrote: > > Looks like there was a bug, which has now been fixed in trunk. So, the > second version will work in the next

[web2py] Re: File extention automatically changes when a file is uploaded

2013-08-14 Thread Anthony
Looks like there was a bug, which has now been fixed in trunk. So, the second version will work in the next stable release. Anthony On Thursday, August 15, 2013 1:26:18 AM UTC-4, at wrote: > > > 2.4.5 > > On Thursday, 15 August 2013 07:44:02 UTC+5, Anthony wrote: >> >> What version of web2py are

[web2py] Re: form.element remove

2013-08-14 Thread Anthony
https://code.google.com/p/web2py/source/browse/gluon/html.py#1003 On Wednesday, August 14, 2013 11:36:17 PM UTC-4, lucas wrote: > > hello one and all, > > how do you remove an element after you find it? something like > > form.element(_id="no_table_name").remove() > > or something like > > del fo

[web2py] Re: File extention automatically changes when a file is uploaded

2013-08-14 Thread at
2.4.5 On Thursday, 15 August 2013 07:44:02 UTC+5, Anthony wrote: > > What version of web2py are you using? > > On Wednesday, August 14, 2013 9:22:57 PM UTC-4, at wrote: >> >> Thanks a lot anthony, >> db(db.mytable.id==24).update(file1=db.mytable.file1.store(request.vars. >> file1)) >> works, >>

[web2py] Re: Do you use web2py professionally?

2013-08-14 Thread webpypy
Dear Arnon, I appreciate your help. I am asking for small one-table example, if your company permits. Regards, Ashraf -- --- 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, se

[web2py] form.element remove

2013-08-14 Thread lucas
hello one and all, how do you remove an element after you find it? something like form.element(_id="no_table_name").remove() or something like del form.element(_id="no_table_name") thanx in advance, lucas -- --- You received this message because you are subscribed to the Google Groups "w

[web2py] Re: File extention automatically changes when a file is uploaded

2013-08-14 Thread Anthony
What version of web2py are you using? On Wednesday, August 14, 2013 9:22:57 PM UTC-4, at wrote: > > Thanks a lot anthony, > db(db.mytable.id==24).update(file1=db.mytable.file1.store(request.vars. > file1)) > works, > > whereas > db(db.mytable.id==24).update(file1=request.vars.file1) > gives error

[web2py] Re: File extention automatically changes when a file is uploaded

2013-08-14 Thread at
Thanks a lot anthony, db(db.mytable.id==24).update(file1=db.mytable.file1.store(request.vars.file1 )) works, whereas db(db.mytable.id==24).update(file1=request.vars.file1) gives error: ('ERROR', '22001', 'value too long for type character varying(512)') PS. I'd replied to your post yesterday,

Re: [web2py] Re: How to define identical tables at once?

2013-08-14 Thread Hunt
Yea sorry... I did an absolutely awful job of explaining. In my app, I want the user to have a list of 'friends' in his/her profile that he can message and see what content they have posted (very original, night?). My plan is to have users be able to view other users content who they are NOT f

[web2py] Re: deployment to google app engine did not include my static files

2013-08-14 Thread Luca
Massimo, I have been trying to send you emails for some time without success. Is there some issue with your email? Luca On Tuesday, August 13, 2013 7:15:57 AM UTC-7, Massimo Di Pierro wrote: > > email it to me please or post a patch on github. > > On Monday, 12 August 2013 19:03:59 UTC-5, Luca

[web2py] Has the format of the auth tables changed recently? Or the format of t

2013-08-14 Thread Luca
I have recently upgraded from web2py release R-2.4.6 to the head of the branch. I am using web2py on appengine, using: from gluon.contrib.memdb import MEMDB from google.appengine.api.memcache import Client session.connect(request, response, db = MEMDB(Client())) I also have the following code

Re: [web2py] web2py on Google Drive

2013-08-14 Thread Evan Caldwell
Johann, apparently I'm not sure.. I'll check it out. Thank you. On Wednesday, August 14, 2013 6:03:43 AM UTC-6, Johann Spies wrote: > > On 13 August 2013 19:29, Evan Caldwell >wrote: > > Johann, >> >> I didn't realize you had responded. I am using MySQL >> > > > Are you sure? > > and getting th

Re: [web2py] Re: How to define identical tables at once?

2013-08-14 Thread Anthony
Another option is a list:reference field, which may work depending on how you want to be able to query friends. Anthony On Wednesday, August 14, 2013 2:11:02 PM UTC-4, Marin Pranjić wrote: > > No, that's even worse :D > > Create new table called "friendship". > > Add two fields, "user_one" and "

Re: [web2py] Re: How to define identical tables at once?

2013-08-14 Thread Richard Vézina
If you explain better what you want to acheive, we could help you better... Maybe you just need a self reference field name friend_id let you associate each user which are friends. Maybe you need a many to many relation table where you will where you can manage there friendship relation between ea

Re: [web2py] Re: How to define identical tables at once?

2013-08-14 Thread Richard Vézina
Exactly Marin example is what I was talking about... Richard On Wed, Aug 14, 2013 at 2:11 PM, Marin Pranjić wrote: > No, that's even worse :D > > Create new table called "friendship". > > Add two fields, "user_one" and "user_two" that both reference auth_user ID > field. > To get all friends, y

Re: [web2py] Re: How to define identical tables at once?

2013-08-14 Thread Marin Pranjić
No, that's even worse :D Create new table called "friendship". Add two fields, "user_one" and "user_two" that both reference auth_user ID field. To get all friends, you have to make a database join with auth_user table. db.define_table('friendship', Field('user_one', 'reference auth_user'),

Re: [web2py] Re: How to define identical tables at once?

2013-08-14 Thread Hunt
Really? So I should just add like a 1000 "friend_id" fields to auth_user? I thought there would an easier way to go about this. Thanks though Marin! On Wednesday, August 14, 2013 2:07:08 AM UTC-4, Marin Pranjić wrote: > > Don't do that. It is wrong. > Create only one new table and put everythi

[web2py] Re: conditional include question

2013-08-14 Thread Anthony
I think they're equally efficient -- the second option just moves the extra lines of code to the included view. On Wednesday, August 14, 2013 12:45:48 PM UTC-4, Annet wrote: > > Hi Anthony, > > In that case it doesn't matter which makes the second code example more > efficient. One line to inclu

[web2py] Re: conditional include question

2013-08-14 Thread Annet
Hi Anthony, In that case it doesn't matter which makes the second code example more efficient. One line to include in the containing view instead of three. Best regards, Annet -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscr

Re: [web2py] Nested LOAD() problem

2013-08-14 Thread Annet
Hi Richard, Thanks for your reply. > For example, I use Bootstrap accordion and I want to control when my component > are loading to avoid all the component to be loaded on my dashboard every time the > index page is hit. So I can't include the accordeon bootstrap html into my component > e

[web2py] Re: conditional include question

2013-08-14 Thread Anthony
No, the {{include}} and {{extend}} directives are part of the template language -- they are not Python code. So, they are processed before executing any Python code. When the template is parsed, all of the includes and extends are processed in order to build a single template string. The templa

[web2py] Re: Friendly URLs and routes.py

2013-08-14 Thread Massimo Di Pierro
You probably want a) and b) and the same time. The issue is whether you use the id for searching or the slug. I do not think there is a difference in speed (if you make an index for the slug) but you will run into problems that two users may have the same first and last name and therefore the sa

[web2py] Re: conditional include question

2013-08-14 Thread Annet
Thank you both for your replies. Try it out, but I believe those are equivalent. They should both result in > the same parsing to Python code -- the hero_shot.html view will be parsed > into Python in both cases, and the "if" statement will simply determine > whether that code actually gets exe

Re: [web2py] reference db.auth_user from other Database..

2013-08-14 Thread Carlos Correia
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Em 14-08-2013 15:23, hiro escreveu: > Without touching db.py I have created a new file in order to add another > database. > > I want to keep the auth data in the standard setup but keep other parts of my > data in a large and fast external database.

[web2py] Re: conditional include question

2013-08-14 Thread Anthony
Try it out, but I believe those are equivalent. They should both result in the same parsing to Python code -- the hero_shot.html view will be parsed into Python in both cases, and the "if" statement will simply determine whether that code actually gets executed (so, if you compile the app, both

[web2py] Re: reference db.auth_user from other Database..

2013-08-14 Thread Niphlod
nope it's not. Is it possible to cross reference the databases? If so, how? > -- --- 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...@googlegr

[web2py] Re: deployment to google app engine did not include my static files

2013-08-14 Thread dlypka
The app.yaml sample for python 2.7 on GAE has always been wrong. The regular expression accidentally omits all static files that are in subfolders below static. I had to revert that regular expression part back to the pre 2.7 app.yaml example. The all the static subfolders were back again in the

[web2py] Apache import module failure

2013-08-14 Thread mryan
Hi, I have a pretty straight forward app (AppBuilder in the log below) with a custom module (RosBridgeClient in the log below) which resides under modules, and is used by the controllers. Everything works fine using the built in server. However, once I move over to apache , it fails to import

[web2py] Re: Friendly URLs and routes.py

2013-08-14 Thread lesssugar
Thanks, Massimo. One question more. What is more efficient / faster / better: a) rewrite the URL with routes.py b) use IS_SLUG.urlify() to store the username (first_name+'-'+last_name) in the db as a computed field to generate user profile's URL ? On Monday, August 12, 2013 9:14:09 AM UTC+2, M

[web2py] reference db.auth_user from other Database..

2013-08-14 Thread hiro
Without touching db.py I have created a new file in order to add another database. I want to keep the auth data in the standard setup but keep other parts of my data in a large and fast external database. The problem I am having is that I cannot reference between the databases. in my_new_db.py

[web2py] Re: LOAD() not working

2013-08-14 Thread lesssugar
Yep, the calendar WAS the issue here I commented the calendar function in web2py.js and all works great. Didn't expect it to be the problem at all. Thank you for the hint :) On Wednesday, August 14, 2013 3:16:17 PM UTC+2, lesssugar wrote: > > I get this in console: > > Uncaught ReferenceErro

[web2py] Re: LOAD() not working

2013-08-14 Thread lesssugar
I get this in console: Uncaught ReferenceError: Calendar is not defined I'm not using the calendar, but I don;t think that's an issue here. In the views, where the LOAD doesn't work, I have small jQuery script which adds hints to labels of the fields in the form. Something like this: jQuery('

Re: [web2py] Nested LOAD() problem

2013-08-14 Thread Richard Vézina
Hello Annet, I have difficulty to understand what you are doing. Maybe, you should start to see your index page more like a container of components. What see wrong in this case is to try to have one of these component play the role of the index page container itself and contains component... But I

[web2py] Re: LOAD() not working

2013-08-14 Thread Anthony
On Wednesday, August 14, 2013 8:56:33 AM UTC-4, lesssugar wrote: > If you view the network requests in the browser developer tools and >> refresh the page, do you see a request to suggestions.load (...)? >> > > Yes, there is the request to suggestions.load in the Network tab on the > pages wher

Re: [web2py] conditional include question

2013-08-14 Thread Richard Vézina
Hello Annet, What the purpose? In theory, in the first case you page will be displayed without the layout and you may have some html error because image will not be available. In your seconde example, better to me, you will have the layout displayed but the content of your page will be skip entire

[web2py] Re: LOAD() not working

2013-08-14 Thread lesssugar
> > If you view the network requests in the browser developer tools and > refresh the page, do you see a request to suggestions.load (...)? > Yes, there is the request to suggestions.load in the Network tab on the pages where LOAD works. None suggestions.load in the same tab after refreshing

[web2py] conditional include question

2013-08-14 Thread Annet
Does it make any difference whether you do: {{if landingpage.heroShot:}} {{include 'landingpage/hero_shot.html'}} {{pass}} and in the inlcuded view: or you do: {{include 'landingpage/hero_shot.html'}} and in the included view: {{if landingpage.heroShot:}}

Re: [web2py] particular IS_IN_DB need advice

2013-08-14 Thread Richard Vézina
About represent_dict[...], I use to construct dict of id (key) / represent (value) for some table where the represent if formed from the concatation of attribute from differents tables. So instead of having to query 2 tables I just call my dict... Of course, I have to update once in a wild the dict

Re: [web2py] particular IS_IN_DB need advice

2013-08-14 Thread Richard Vézina
Great!! Thank you Anthony for clarification. That exactly what I was needing. I should have read more carefully validators section I guess. :) Richard On Tue, Aug 13, 2013 at 6:03 PM, Anthony wrote: > > I have table a that is referenced by table b, so there is a_id FK field in >> table b. B

Re: [web2py] web2py on Google Drive

2013-08-14 Thread Johann Spies
On 13 August 2013 19:29, Evan Caldwell wrote: Johann, > > I didn't realize you had responded. I am using MySQL > Are you sure? and getting the error : > no such table: auth_user > The error comes from sqlite! Anyhow your problem is that you have to have a portable database if you want to wo

[web2py] smartgrid delete button not working properly

2013-08-14 Thread hiro
Hi there.. When I am using the SQLFORM.smartgrid the delete button does not seems to work. I get the confirmation dialog, click yes, and the entry disappears, but after a refresh it is back again. I can right-click it and get the link, and pasting that into the browser deletes the entry proper

[web2py] Re: Do you use web2py professionally?

2013-08-14 Thread Arnon Marcus
This is a client-side example of instantiating a treegrid object: TreeGrid({// Object supplied defining the treegrid instance Layout:{ // Data source for grid structure, definitions and columns and usually fixed rows Url:def_url // Each Url may be of a static document, or repre

[web2py] Re: Do you use web2py professionally?

2013-08-14 Thread Arnon Marcus
Hmmm, our code is proprietary... I'll see what I can do. Basically, you load-up treegrid in the layout.html like any other javascript library (after putting it in the static folder of the app), and from then it works via ajax with jquery. You write a controller-action in web2py that you talk to

[web2py] c.r.m. source

2013-08-14 Thread andrej burja
hi i would like to examine the source code of http://web2py-crm.appspot.com/ but i can not find it on http://web2py.com/appliances/ andrej -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receivin