[web2py:37098] Re: sqlform view

2009-12-12 Thread __Kyo__
Thanks ^^ On 11 dic, 17:16, mdipierro wrote: > {{=SQLTABLE(rows,truncate=1000)}} > > On Dec 11, 4:10 pm, __Kyo__ wrote: > > > Hi, I use sqltable to show data, but i want to show al the field data, > > but it just shows me a part of it, like this: > > > aut

[web2py:37052] sqlform view

2009-12-11 Thread __Kyo__
Hi, I use sqltable to show data, but i want to show al the field data, but it just shows me a part of it, like this: auth_user.idauth_user.first_nameauth_user.last_name 1IvanCastillo Ponc... I'd like to show this, using sqltable: a

[web2py:36076] Re: multiple validations problem

2009-11-27 Thread __Kyo__
d On 27 nov, 01:41, mdipierro wrote: > Look into gluon.validators.IS_NOT_IN_DB > > specifically: > >     def set_self_id(self, id): >         self.record_id = id > > By settings the id of the current record you can prevent the check on > update. > > Massimo >

[web2py:36062] multiple validations problem

2009-11-26 Thread __Kyo__
Hi, i use this code in my application, it works very good when i insert a new record, but i have a little problem when i want to update a registry. For example: I have un my table inventory: product, country, quantity If i insert pencil, canada, 40 it inserts fine then if i want to insert again

[web2py:35626] Re: reportlab error

2009-11-19 Thread __Kyo__
i've got the solution for it m=[[x.id for x in consulta],[str(x.idPais) for x in consulta]] thank --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@goo

[web2py:35624] reportlab error

2009-11-19 Thread __Kyo__
By using reportlab in a system and send a variable from one function to another to generate the report I get the following error, but only in the latest version of web2py (1.71.2), I hope you can help me. this is my code: def reportePais(): form=FORM(TABLE(TR("Seleccione un País",SELECT (_ty

[web2py:35123] Re: SQLFORM problem

2009-11-11 Thread __Kyo__
I create a sqlform who contains a multicombo, and i also using the slyce of the "add link", thanks a lot for those things, however when i want to include this into the appadmin controler, i have an error. Instead of appearing in the multicombo boxes appears another form. On Nov 9, 10:35 am, mdip

[web2py:34411] Script

2009-11-02 Thread __Kyo__
Hi everyone, i have to make a form with multi combo, so if i change one the another one have to change too. I made this code, but the problem is what would be the script to change the another combo. def index(): form = SQLFORM(db.Organizacion) return dict(form=form) def prueba(): esta

[web2py:34075] Re: Searching

2009-10-29 Thread __Kyo__
uce(lambda x,y: x|y,queries) >                 records[tablename]=db(query).select() >     return dict(records) > > Do you have tables with no 'text' or 'string' fields? That could have > caused the problem. > > On Oct 29, 11:04 am,__Kyo__ wrote: > >

[web2py:34069] Re: Searching

2009-10-29 Thread __Kyo__
Hi, i have a problem running this. def index(): records = {} if request.vars.boton: key=request.vars.dato for tablename in db.tables: table=db[tablename] fields=[table[fieldname] for fieldname in table.fields] queries=[field.like('%'+key

[web2py:33995] Re: Searching

2009-10-28 Thread __Kyo__
data, the problem is i cant show it. I would apprecaite a lot if you could help me with this. Thanks in advance -- Kyo On Oct 28, 1:44 pm, mdipierro wrote: > It does not. > > can you make a concrete example of data and what you expect in the > output? > > Massimo > > On Oct 28, 1:

[web2py:33953] Re: Searching

2009-10-28 Thread __Kyo__
(db[i].ALL) >                     if string.lower(str(request.vars.dato))\ >                     in string.lower(str(m[x]))] > > And this: > >     exec('lista=db(db.%s.id.belongs(datos)).select()' % (i)) > > rewrite as > >     lista = db(db[i].id.belongs(datos)).select() > &

[web2py:33938] Searching

2009-10-28 Thread __Kyo__
Hi everyone, i have to make a searcher, i have to put in my input a letter like "a" and then i want to search this letter in all the tables that are in the database. i made this code, but the problem i have in the moment i have to show or capture the solution. Could you please help me with this?

[web2py:31234] multi combo

2009-09-17 Thread __Kyo__
here is the code: --- ---Model db = SQLDB("sqlite://db.db") db.define_table("pais", SQLField("nPais", "string", notnull=True, default=None, label="Pais")) db.define_table("provincia", SQLField("idPais", db.pais, la

[web2py:30608] Re: return and redirect

2009-09-10 Thread __Kyo__
Becouse the form created, is configured to download a pdf (return), but when I resume using the form, it needs to be updated (redirect). thanks On Sep 10, 12:50 am, Richard wrote: > why do you need to update the form? > > On Sep 10, 6:58 am, __Kyo__ wrote: > > > > > def

[web2py:30534] Re: return and redirect

2009-09-09 Thread __Kyo__
orm) Sorry the another post were incomplete and not make myself understood, apologies, the post was a mistake. Here is the function, so after donwload the pdf, i want to update my form. Thank you very much On Sep 9, 3:42 pm, mdipierro wrote: > Please explain more. I do not understand. > &g

[web2py:30532] Re: return and redirect

2009-09-09 Thread __Kyo__
m) On Sep 9, 3:42 pm, mdipierro wrote: > Please explain more. I do not understand. > > On Sep 9, 3:36 pm, __Kyo__ wrote: > > > > > A form created, is configured to download a pdf (return), but when I > > resume using the form, it needs to be updated (redirect), m

[web2py:30529] Re: return and redirect

2009-09-09 Thread __Kyo__
do this: > > if success: >     return dict() > else: >     redirect(somewhere) > > but you cannot do both at the same time. > > technically redirect raises HTTP(303) while return raises HTTP(200). > > massimo > > On Sep 9, 3:03 pm, __Kyo__ wrote: > > >

[web2py:30523] return and redirect

2009-09-09 Thread __Kyo__
Is there any way to include return and redirect at same time, in one function? --~--~-~--~~~---~--~~ 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 unsu

[web2py:29988] Re: multiple forms per page -- preventing double submission

2009-09-03 Thread __Kyo__
How do i take a text box value form another form? thanks in advance On Sep 3, 8:36 am, weheh wrote: > Yes, I've done multiple forms before but haven't tested the double > submission, yet, because the doc says that it doesn't work. You seem > to imply that it does work. Can you say definitively,

[web2py:28461] Re: Ajax problem

2009-08-12 Thread __Kyo__
Thank you very much ¡ On Aug 12, 11:34 am, mdipierro wrote: > literally you can replace "$" with "jQuery" everywhere. Sometimes with > some plugins it makes a difference. > > On Aug 12, 9:58 am, __Kyo__ wrote: > > > > > it works !! thank you.

[web2py:28439] Re: Ajax problem

2009-08-12 Thread __Kyo__
d').change(function(){ >         if($('#taxpayer_married').attr('checked')) >             $('#taxpayer_spouse_name__row').show(); >         else $('#taxpayer_spouse_name__row').hide();}); > > }); > > then try replace $ with jQuery > > On Aug

[web2py:28359] Re: Ajax problem

2009-08-11 Thread __Kyo__
I tested the code you gave me and still does not work, I also work with the same code that brings up the manual and does not work either. What can I do? Apologies for the delay. Thanks in advance --Model(this code is taken from web2py manual) db=SQLDB('sqlite://db.db') db.define_table('taxpayer'

[web2py:28064] Re: Combo problem

2009-08-05 Thread __Kyo__
I'm in the same problem , so please ... help us . On 5 ago, 16:48, Sophie wrote: > Hi i read the page and i don't understand it too much. i wrote this > code, it is working but i have this problem. the first combo is > working fine, the second appears with the correct data, when i select > the c

[web2py:27959] Ajax problem

2009-08-04 Thread __Kyo__
1.- I just want to test this code, but it doesn't run very well, it doesn't show execute the ajax function. Do i need something to run ajax code?, this code is taken from web2py manual. Model db=SQLDB('sqlite://db.db') db.define_table('taxpayer', SQLField('name'), SQLField('married','

[web2py:25507] Re: Report in pdf format

2009-07-02 Thread __Kyo__
x27;Content-Type']='application/pdf' response.headers['Content-Disposition'] = 'attachment;filename=solicitud.pdf' return response.stream(open("primer.pdf", 'rb')) thank you very much. On 2 jul, 10:35, Álvaro Justen [Turicas] wrote: > On Thu, Jul

[web2py:25492] Re: Report in pdf format

2009-07-02 Thread __Kyo__
howPage() c.save() response.headers['Content-Type']='application/pdf' response.headers['Content-Disposition'] = 'attachment;filename=solicitud.pdf' return c Álvaro Justen [ Turicas ] ha escrito: > On Wed, Jul 1, 2009 at 17:20, __Kyo__ wrote:

[web2py:25444] Report in pdf format

2009-07-01 Thread __Kyo__
I have been looking for ways to create reports in PDF using reportlab, I can create pdf but I can not do to be saved. How can you do with an RTF file or csv. Thanks in advance. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google

[web2py:24797] Re: Appadmin - query as a table

2009-06-23 Thread __Kyo__
appadmin ignores db.table.field.readable and db.table.field.writable > but it always displays the id field. > I am not sure I understand what behavior you want to change. > > Massimo > > On Jun 21, 12:06 pm, __Kyo__ wrote: > > > when I edit atablethat has fields from other

[web2py:24647] Appadmin - query as a table

2009-06-21 Thread __Kyo__
when I edit a table that has fields from other tables using appadmin, showed me the id (number) of the table, I would like to display the field name and not the id. Can you do to show me the field name using appadmin?. maybe work with a query as a table, becose I tried to export a query as a table