[web2py] Re: calling skype user though url in web

Not sure about what I'm saying right now, but I giving a wild guess: the{{=user.skype}} with space is not url encoded (does not replace space with %20). I tried the A helper just now, and it does not urlencode either (that's something that should be fixed, maybe I'll find the time for it). The thin

[web2py] Re: How to Model an 'upload' field to permit more than one attachment?

That seems weird. How would you know which one to serve? You probably want to set up an "images" table.

[web2py] Re: calling skype user though url in web

On Friday, July 29, 2011 8:33:31 PM UTC-4, pbreit wrote: > > Try {{=XML(user.skype)}} web2py templates don't escape spaces, so XML shouldn't do anything here. Check the rendered HTML source code -- if user.skype has spaces in it, then the spaces should still be there in the rendered HTML. I

[web2py] Re: Bug in virtualfields w/ session

auth.user is Storage(table_user._filter_fields(user, id=True)). The _filter_fields method of the auth_user table only selects actual table fields, not virtual fields, so auth.user will not include any virtual fields. Perhaps this should be changed. Anthony On Friday, July 29, 2011 9:05:39 PM

[web2py] Bug in virtualfields w/ session

I think I found a bug in virtualfields. I have the following controller: def posts(): user = session.auth.user n = user.name # returns None Where "person" is defined as a virtualfield on user: class Users(): def name(self): return self.users.first_name + ' ' + self.users.last

[web2py] Re: response streaming html with images

It looks like you're serving files that are already stored on disk? I would just serve them statically (if they don't need to be password-protected).

[web2py] Re: calling skype user though url in web

Try {{=XML(user.skype)}}

[web2py] Re: proper way to define a user table

Also, "extra_fields" was recently added: - auth.settings.extra_fields['auth_user'].append(Field('country')) allows to extend auth_* tables without need of definiting a custom auth_* table. Must be placed before auth.define_tables()

[web2py] fix for truncate in SQLTABLE for new implement dict

Hi, Here's a fix for truncate in SQLTABLE for "new implement dict", such that it truncates only when necessary. Line 1,469 in SQLTABLE.__init__ in sqlhtml.py - if isinstance(headers[colname]['truncate'], int): + if isinstance(headers[colname]['truncate'], int) and len(ur) > headers[colname]['t

[web2py] Re: proper way to define a user table

Why dont you do something like this? auth.settings.extra_fields['auth_user'].append(Field('country')) to add a "country" field to the user table On Jul 29, 6:06 pm, Anthony wrote: > On Friday, July 29, 2011 12:49:46 PM UTC-4, Ramos wrote: > > > do i need this line > > auth.define_tables() > > Ye

[web2py] calling skype user though url in web

hello this line of code works only if user.skype does not contais spaces Call using Skype {{=user.skype}} if the the skype username is* Bin Laden Bush* for example , skype tries to call Bin%20Laden%20Bush and of course it does not work How to resolve this issue? thank you António

[web2py] Re: A group inside a group in auth.membership

You can always write your own interface to the tables to make it easier to manage individual users. In fact you should consider doing this unless your administrator is well versed in the application's innards. Otherwise you will be answering 'how do I do this' questions from the admin forever. O

[web2py] Re: Relationship help

Do I create one big left join and then try to loop through fors blog posts and then comments, checking if the comment belongs to the post? That's pretty much how I've done similar things with a left join. Order the query by post id or post date or however you sequence them. Assuming it's post id,

Re: [web2py] Upload File via HTTP

anybody? On Jul 27, 2011 1:02 PM, "Ismael Serratos" wrote: > I found this for Django I need exactly the same but for web2py could you > help me to translate??? or to give me a hint? > > # - upload_file.py # upload binary file with > pycurl by http postc = pycurl.Cur

Re: [web2py] Re: Edit record vs View record

db.table*,*request.args[0] ;-) Richard On Wed, Jul 27, 2011 at 6:03 AM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > form= SQLFORM(db.table.request.args[0],readonly=True) > > On Jul 27, 4:43 am, António Ramos wrote: > > hello > > > > * in my controller * > > > > form= SQLFORM(db.

[web2py] Re: Introducing Grafpad!

Hey guys, I'm the friend who's been working on this with Charles. The decision to use Pyjamas came from desire to use the same language for the front- end and back-end. It has already paid off, we originally implemented both the clipping and recognition algorithms in the front-end, but later decid

[web2py] Re: crud.search() example

On Friday, July 29, 2011 12:28:45 PM UTC-4, Web2Py Freak wrote: > > its working now , thank you but how can i search just by title in > db.blogposts and get the output by viewing the blog with that > title ?? > am viewing the blogs in a {{for blog in .. Note sure what you mean. Whe

Re: [web2py] Particular Conditional Fields in Forms case

Ok here the code... Please help... I will get crazy ;-) $(document).ready(function(){ var invalidation_comment = $('#test1_invalidation_comment').val(); $('#test1_invalidation_comment__row').hide(); if($('#test1_invalidation_comment').val()) $('#test1_invalidation_comment__row').

Re: [web2py] Re: proper way to define a user table

On Friday, July 29, 2011 12:49:46 PM UTC-4, Ramos wrote: > > do i need this line > auth.define_tables() > Yes, that should come after you define your custom table(s) -- it defines any Auth tables that have not already been defined (using default table definitions). Anthony

Re: [web2py] Re: proper way to define a user table

do i need this line auth.define_tables() ? 2011/7/29 Anthony > Not sure. > > On Friday, July 29, 2011 12:03:44 PM UTC-4, Ramos wrote: > >> oops again >> i just lost all tables >> >> groups,membership,etc >> >> why? >> >> 2011/7/29 Anthony >> >> Oops, the printed book is wrong -- see the corre

[web2py] Re: crud.search() example

its working now , thank you but how can i search just by title in db.blogposts and get the output by viewing the blog with that title ?? am viewing the blogs in a {{for blog in ..

Re: [web2py] Re: multiselect with part of a table

Please is theare any chance to do this? without having to go for the 3 tables apporach? To remind you all: I have a multiselect like this one: db.py: db.define_table('instance',Field('app',db.application),Field('server',db.server),Field('type','string'),format=lambda r: '%s %s' %(db.application[r

Re: [web2py] Re: proper way to define a user table

Not sure. On Friday, July 29, 2011 12:03:44 PM UTC-4, Ramos wrote: > oops again > i just lost all tables > > groups,membership,etc > > why? > > 2011/7/29 Anthony > >> Oops, the printed book is wrong -- see the corrected version here: >> http://web2py.com/book/default/chapter/08#Customizing-Auth

Re: [web2py] Re: proper way to define a user table

oops again i just lost all tables groups,membership,etc why? 2011/7/29 Anthony > Oops, the printed book is wrong -- see the corrected version here: > http://web2py.com/book/default/chapter/08#Customizing-Auth. > > Anthony > > On Friday, July 29, 2011 11:29:35 AM UTC-4, Ramos wrote: > >> i need

[web2py] Re: proper way to define a user table

Oops, the printed book is wrong -- see the corrected version here: http://web2py.com/book/default/chapter/08#Customizing-Auth. Anthony On Friday, July 29, 2011 11:29:35 AM UTC-4, Ramos wrote: > i need to add one more field in my auth table: > > in reading the book on page 358 and 259 > > I´m n

[web2py] Re: crud.search() example

On Friday, July 29, 2011 11:44:06 AM UTC-4, Web2Py Freak wrote: > > so what to do now ?? Does this: {{form,table=crud.search(db.blogposts)}} {{=form}} {{=table}} not work for you? What are you trying to do? What problem are you having? Anthony

[web2py] Re: crud.search() example

so what to do now ??

[web2py] Re: response streaming html with images

If these transformations are constant and you want to keep the images around, I'd suggest using the static folder (or placing them in the db if more control is needed). We perform some transformations on the fly (which sounds like you *may* be doing the same) and use a controller to server them. T

[web2py] Re: self reference and inheritance

Hey, I have created an issue in google code it is issue 353. Here is the link http://code.google.com/p/web2py/issues/detail?id=353 -Eric On Jul 29, 5:18 am, Massimo Di Pierro wrote: > I have limited connectivity today. please one an issue in google code > and I will test it asap. > > On Jul 28, 1

[web2py] Re: plupload and web2py

Mr.freeze, I'm also trying to integrate plupload. I've got the javaScript working but I can't seem to connect in the controller to save off the image. Did you get that part solved? Nick On Jul 4, 11:14 am, "mr.freeze" wrote: > I just changed all references to the 'flash' class in those files

[web2py] proper way to define a user table

i need to add one more field in my auth table: in reading the book on page 358 and 259 I´m not geting it to work i get error , auth_table not defined. 1 # after 2 # auth = Auth(globals(),db) 3 4 db.define_table( 5 auth.settings.table_user_name, 6 Field('first_name', length=128, default=''), 7

[web2py] Re: existing database, can't migrate

That worked, thank you! On Jul 29, 9:25 am, Richard G wrote: > Sorry, the id type declaration should be in quotes: > > db.define_table('test', >  Field('test_id', 'id'), >  Field('name'), > migrate=False, fake_migrate=True)

Re: [web2py] Particular Conditional Fields in Forms case

I took my base code there... Thanks anyway... Just rewrite my example : I enter a new record. Later somebody check the record and valid or not if this record can be extracted or not from the DB. Imagine this person find the record valid and this person check the valid checkbox 1 week later for a

Re: [web2py] Any LDAP auth users out there?

to make w2p work with ad I had to add this line to gluon/contrib/login_methods/ldap_auth.py: ldap.set_option(ldap.OPT_REFERRALS, 0) like this: import ldap ldap.set_option(ldap.OPT_REFERRALS, 0)#LINE ADDED except Exception, e: On Thu, Jul 28, 2011 at 10:56 PM, Ismael Serratos wrote:

Re: [web2py] Re: Enforcing access control on Flash file embedded inside a view

You are missing the fact that upliad folder is pritected. Accessible only via download function. http://zerp.ly/rochacbruno Em 27/07/2011 12:37, "Jagmal" escreveu: > Does 'upload' field not just copy file over to a location and provide its > link when asked? If so, I should be able to access the

[web2py] does web2py rebuild response headers?

Google released 1.5.1 of AppEngine in June and with it a new Geolocation Header feature (http://googleappengine.blogspot.com/ 2011/06/app-engine-151-release.html) Key excerpt: App Engine will now include a header with every client request ... a best-effort attempt to identify the country from whic

Re: [web2py] Re: crud.search() example

Crud.search returns a tuple with two objects. http://zerp.ly/rochacbruno Em 29/07/2011 08:21, "Web2Py Freak" escreveu: > i tryed {{=crud.search(db.blogposts)}} > and it gives me this "(, [])" > in the page !

[web2py] Re: Enforcing access control on Flash file embedded inside a view

>>Not sure what ".swf is not a recognized extension" means in this >> context. Are you saying it is not setting up the content-type? Sorry - my ignorance and incorrect words. Actually, I should have asked another question - How do I render a view which is not HTML (again a very basic question)?

Re: [web2py] Re: Relationship help

pass the right type of object to the function girlfriend() and your problem will be solved On Fri, Jul 29, 2011 at 2:12 AM, pbreit wrote: > A startup in my office: http://theicebreak.com -- *-Furqan Rauf* *Do you love your creator? Love your fellow-beings first. -Prophet Muhammad * *http://

[web2py] Re: How to Model an 'upload' field to permit more than one attachment?

oh yes Field("foobar", "list:upload") would be very nice check google, some people already talked about it On Jul 29, 1:21 pm, António Ramos wrote: > How to Model an 'upload' field to permit more than one attachment? > thank you > > António

[web2py] Re: existing database, can't migrate

Sorry, the id type declaration should be in quotes: db.define_table('test', Field('test_id', 'id'), Field('name'), migrate=False, fake_migrate=True)

[web2py] Re: existing database, can't migrate

Web2py defaults to using an 'id' field of type sequence. In the online book they have a section called 'Legacy Databases and Keyed Tables ' Here they identify a method of setting a different field to be you primary key

[web2py] Re : Re: web2py.com/poweredby / Quality Systems

Here are some links that show plone2.5 in action http://plone.org/documentation/manual/plone-2.5-user-manual/introduction/visual-design-of-plone-web-sites http://plone.org/documentation/manual/plone-2.5-user-manual/managing-content/editing-content http://plone.org/documentation/manual/plone-2.5-us

[web2py] Re : Re: web2py.com/poweredby / Quality Systems

In fact I'm speaking about this http://www.qualitysystems.com/qs/toolbox/index.html, the tool they promote, not directly the frontend of the site (I agree with the code source) You can see that the tool they sell looks really really really like the CMS Plone2.xxx. I'm pretty sure that if someone

[web2py] existing database, can't migrate

I designed and setup a database that was created directly in Postgres, not web2py. When attempting to view the database administration tool in web2py it gives me constant errors: Jul 29 07:32:38 postgres postgres[11459]: [6-1] 2011-07-29 07:32:38 EDT testdb postgres 192.168.148.68 WARNING: ther

[web2py] How to Model an 'upload' field to permit more than one attachment?

How to Model an 'upload' field to permit more than one attachment? thank you António

[web2py] Re: crud.search() example

i tryed {{=crud.search(db.blogposts)}} and it gives me this "(, [])" in the page !

[web2py] Re: response streaming html with images

I've found that: (in httpserver.log) ..., GET, /tapir/default/test, HTTP/1.1, 200, 0.018923 ..., GET, /tapir/default/ tapir_proces_169_0_1_123_9043794a_fe13_4bf3_8c28_609408551db9test_odt.doc_html_b4fd3c9.png, HTTP/1.1, 400, 0.000671 ... GET, /tapir/default/ tapir_proces_169_0_1_123_9043794a_fe13_

Re: [web2py] Re: A group inside a group in auth.membership

In a small organization (+- 100 users) it can be dificult to manage ACLs without being able to add group to group membership. consider my company we have this groups in the maintenance department MMC (20 users) ME ( 15 users) MI ( 10 users) MD (maintenance department) (all users above) so thi

Re: [web2py] Re: Suggestion editing controllers or views

controllers are, but views aren´t! 2011/7/29 Massimo Di Pierro > The filenames are clickable. Are they not? > > On Jul 29, 4:29 am, António Ramos wrote: > > hello, i´m new here so i have some dificulties. > > > > One i think could gain some time. > > > > When i create an app i get a lot of err

[web2py] Re: A group inside a group in auth.membership

no On Jul 29, 5:14 am, António Ramos wrote: > a group is made of users but i have the need to include a group inside a > group. > > is this possible? > > thank you > > António

[web2py] Re: web2py.com/poweredby / Quality Systems

if it is listed than somebody reported it as being made with web2py. The page source contains the olf web2py_ajax.html. Why do you think it is made with Plone? On Jul 29, 4:11 am, JmiXIII wrote: > Hello, > > I was just having a look at web2py.com/poweredby and in particular Quality > Systems Tool

[web2py] Re: Suggestion editing controllers or views

The filenames are clickable. Are they not? On Jul 29, 4:29 am, António Ramos wrote: > hello, i´m new here so i have some dificulties. > > One i think could gain some time. > > When i create an app i get a lot of errors and i have to edit a view or a > model to correct the problem. > > when i see

[web2py] Re: crud.search() example

{{form,table=curd.search(db.table)}} {{=form}} {{=table}} On Jul 29, 4:18 am, Web2Py Freak wrote: > hey guys , > > anyone can give me an example on using the crud.search  ???!

[web2py] Re: Enforcing access control on Flash file embedded inside a view

Not sure what ".swf is not a recognized extension" means in this context. Are you saying it is not setting up the content-type? You have a going point. One solution (although not the most elegant) is to use routes.py to map the path (/app/static/...) into the new one (/app/controller/...). Massim

[web2py] Re: Rocket support IPv6

Since you are at it... can you check why (I think and I may be wrong) rocket responds http/1.1 even when the request is http/1.0? On Jul 28, 8:46 am, Timothy Farrell wrote: > Rocket doesn't currently support IPv6.  As I understand adding support > would not be difficult.  If I add it in, can you

[web2py] Re: return record from a query only shows field from one table

I have used both syntaxes. I have no strong preferences. On Jul 28, 11:02 am, pbreit wrote: > What was the final answer on creating compound queries like this: > > db(db.requests.product==db.products.id)(db.products.id==3).select() > > Is that acceptable or advisable? Or is the & way preferred?

[web2py] Re: self reference and inheritance

I have limited connectivity today. please one an issue in google code and I will test it asap. On Jul 28, 11:02 am, "ee...@seccuris.com" wrote: > Hey > I have a db table that has a self referencing field. I need to create > an audit table that inherits this table. In this table I also set > prima

[web2py] A group inside a group in auth.membership

a group is made of users but i have the need to include a group inside a group. is this possible? thank you António

[web2py] Re: Postgres quoted identifiers

This is a good idea. Let me give this some thought. On Jul 28, 10:35 am, Álvaro J. Iradier wrote: > Couldn't it be implemented by calling a engine-dependent method like > sql_quote(name), which in other engines would by default return the > unquoted string, but return the quoted name in mysql and

[web2py] Re: DAL db(db.table.id>1).select() diferent from db.select(db.table.id>1)

I am surprised the second works at all. It should not. I will add a check in the code to raise an exception. On Jul 28, 7:11 am, António Ramos wrote: > hello > > why > db(db.table.id>1).select() is diferent from db.select(db.table.id>1) > > the first returns what i want, the second returns all >

[web2py] Export PDF on GAE error: cannot import name HTMLMixin

Hello, I have problem when I export a pdf in GAE, the mistake is ImportError: cannot import name HTMLMixin I'm using pyfpdf in localhost I have not that problem chek my application http://nubsolution.appspot.com/ user: direc...@fraymartin.edu.pe pass: upao2011 at the matricula/report thanks

[web2py] response streaming html with images

Hello, My app is converting uploaded files to different formats (with many different system tools), and serving them back. for example, pdfs are served from controller this way: ... response.headers['Content-Type']= 'application/pdf' return response.stream(open(request.vars.url,'rb'),chunk_size=4

[web2py] Re: Speed Question

Of course, the content matters. The websites with very rich content take it longer to load. For any serious business app, it is better to avoid the high resolution images or any such matter which will make the page-loading slow. (remember the python idiom : simple is better that complex) But it de

Re: [web2py] web2py.com/poweredby / Quality Systems

On Fri, Jul 29, 2011 at 6:11 AM, JmiXIII wrote: > Hello, > > I was just having a look at web2py.com/poweredby and in particular Quality > Systems Tool: > http://www.qualitysystems.com > > It seems to me this tool is made with Plone instead of web2py did I > miss something ? > > Hello, why do

[web2py] Re: export data to OOO and Excel

@Philippe, Thanks a lot for your post. I'm interested in this. I did not understand what you mean by saying --- >"In Excel or OOo you link your spreadsheet to your URL". "Linking excel or OO sheet to url" means what? Do you want to say that an excel file to be opened by "File--Open-- "? On Jul

[web2py] Suggestion editing controllers or views

hello, i´m new here so i have some dificulties. One i think could gain some time. When i create an app i get a lot of errors and i have to edit a view or a model to correct the problem. when i see a ticket about a error in a view i´m a litle lost. *My mission is to edit the view and correct the

[web2py] crud.search() example

hey guys , anyone can give me an example on using the crud.search ???!

[web2py] web2py.com/poweredby / Quality Systems

Hello, I was just having a look at web2py.com/poweredby and in particular Quality Systems Tool: http://www.qualitysystems.com It seems to me this tool is made with Plone instead of web2py did I miss something ?

[web2py] Re: Enforcing access control on Flash file embedded inside a view

Thanks Massimo. I think it works (I tried by using response.render - is there any other way as .swf is not a recognized extension?). But, I now have a more interesting problem. This FLASH file actually depends on multiple files/folders in the same folder (including some XMLs for data, audio fil

Re: [web2py] Re: web2py/python question

OK, I´ll have to start giving this some attention and always give it a value and not use NULL as False as it is not True. Thank you for a good explanation of the problem. Kenneth On database level, NULL can be anything. DBMS defines it as an unknown value. If you query non-True records, you'

Re: [web2py] export data to OOO and Excel

Another solution : You can simply link data to a Excel/OOo spreadsheet. >From web2Py, you only need a view with a HTML table of your data. In Excel or OOo you link your spreadsheet to your URL. Advantages : - you don't have to build your Excel file in w2p (no extra module) - you can link your data

[web2py] Re: Speed Question

So the content of the website dosent effect that speed its just like when am trying the view

Re: [web2py] Re: web2py/python question

On database level, NULL can be anything. DBMS defines it as an unknown value. If you query non-True records, you'll be given only those records that have defined not-True value (since it's boolean it has to be False). NULL means "I'm not sure if this is True or False, value is missing". If you want

Re: [web2py] Re: web2py/python question

On 29.7.2011 2:05, pbreit wrote: Is it possible that you have the string "None" in the DB? No, I have NULL when looking from mysql client. Kenneth

Re: [web2py] Speed Question

It depends on your host and how large is the connection of your users. http://zerp.ly/rochacbruno Em 29/07/2011 03:18, "Web2Py Freak" escreveu: > the speed of my website when am trying any view is fast , is it going > to be in the same speed when its online ???

[web2py] Re: Relationship help

A startup in my office: http://theicebreak.com

Re: [web2py] blogs

http://labs.blouweb.com/PowerGrid/default/blog http://zerp.ly/rochacbruno Em 29/07/2011 04:10, "pbreit" escreveu: > Here's an approach: > http://web2py.com/book/default/chapter/12#Pagination

[web2py] blogs

Here's an approach: http://web2py.com/book/default/chapter/12#Pagination

[web2py] blogs

Hello ALL , am making a blogs website , how can i make like 1 2 3 4 5 6 buttons with like every number has 10 posts like here in the group ??