[web2py:14982] join 3 tables & import it into a new table

2009-01-14 Thread somebody
scenario: I have 3 tables in a db(table1, table2,table3) - in table1 = has table1Col.id - in table2 = has table2Col.id and table1Col (from table1.table1Col.id) and other entities - in table3 = has table3Col.id and table2Col (from table2.table2Col.id) and other entities means. table2 has

[web2py:13332] Re: zip a file

2008-12-10 Thread somebody
> your data should go in private, let web2py handle the stuff in the > other folders. > > Massimo > > On Dec 10, 10:26 pm, somebody <[EMAIL PROTECTED]> wrote: > > > > > if form.accepts(request.vars,session): > >         for table in db.tables: > >

[web2py:13329] zip a file

2008-12-10 Thread somebody
if form.accepts(request.vars,session): for table in db.tables: rows=db(db[table].id).select() print rows open(str(os.sep).join([os.getcwd(), 'applications', request.application, 'databases', table+'.csv']),'w').write(str(d

[web2py:12917] import from csv file

2008-12-04 Thread somebody
when i want to import a csv file, i found that it will not overlap the existing same table's value. for example. in my db, I have table.db with table.id (with existing value of 1 and 2) and table.name when i empty table.db and import table.db, the table.id become 3 and 4 rather th

[web2py:12892] upload a folder

2008-12-03 Thread somebody
can I upload a folder / copy a whole folder to another directory?? --~--~-~--~~~---~--~~ 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 unsubsc

[web2py:/] AttributeError: 'dict' object has no attribute 'append'

2008-12-02 Thread somebody
wad is e meaning of AttributeError: 'dict' object has no attribute 'append' thanks --~--~-~--~~~---~--~~ 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@googlegroup

[web2py:12695] zip file

2008-11-30 Thread somebody
any guideline if i want to create a text file and in the sametime,a zip text file also been created? and how if I wan to create a input type "file" with button summit to zip a selected file? thanks --~--~-~--~~~---~--~~ You received this message because you are s

[web2py:12587] Re: create a drop down list in form

2008-11-27 Thread somebody
thanks On Nov 27, 10:40 pm, DenesL <[EMAIL PROTECTED]> wrote: > See this > thread:http://groups.google.com/group/web2py/browse_thread/thread/b34a263236... > > On Nov 27, 2:47 am, somebody <[EMAIL PROTECTED]> wrote: > > > > > in normal FORM not SQLFORM- Hi

[web2py:12586] select all tables in sql

2008-11-27 Thread somebody
if db_items.accepts(request.vars,formname='form_one): rows=db(db.items.id).select() print rows db(db.items.id).select() = is just to select the "items" table in db. how if i want to select all the tables in db?? i tried those but failed 1. dba(dba).select () 2. dba.select() anyo

[web2py:12549] Re: create a drop down list in form

2008-11-26 Thread somebody
in normal FORM not SQLFORM --~--~-~--~~~---~--~~ 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 [EM

[web2py:12548] Re: create a drop down list in form

2008-11-26 Thread somebody
in normal FORM not SLQFORM --~--~-~--~~~---~--~~ 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 [EMAI

[web2py:12547] create a drop down list in form

2008-11-26 Thread somebody
Is it possible to create a drop down list which listed sql value in form without any button.. jus pure drop down list.. i have a a drop down list but do not know for what reason there is a summit button which i do not want.. thanks --~--~-~--~~~---~--~~ You receiv

[web2py:12546] Re: input type

2008-11-26 Thread somebody
so i cannot choose my own directory to save my file.. ok --~--~-~--~~~---~--~~ 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 fro

[web2py:12543] input type

2008-11-26 Thread somebody
input type "file" is to choose a file to be uploaded then wad input type is used to select a directory where a file wan tto be saved to? Thanks --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" g

[web2py:12436] Re: have multiple button summits which work on different things in a form

2008-11-24 Thread somebody
thank --~--~-~--~~~---~--~~ 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 [EMAIL PROTECTED] For mo

[web2py:12429] have multiple button summits which work on different things in a form

2008-11-23 Thread somebody
def form(): form=FORM(TABLE(""), TR(" ",INPUT (_name="submit1",_type="submit",_value="SUBMIT")), TR(" ",INPUT (_name="submit2",_type="submit",_value="SUBMIT")), TR("",INPUT(_name="submit3", _type="submit",_value="SUBMIT")), TR(" ",INPUT(_name

[web2py:11949] Re: create a web2py application which function as sending email

2008-11-16 Thread somebody
Is it possible that I add an upload fuction so the email sent will attach with an uploaded file? On Nov 17, 1:33 pm, somebody <[EMAIL PROTECTED]> wrote: > Thank alot.. > missed that page hahaaa > > On Nov 17, 1:08 pm, mdipierro <[EMAIL PROTECTED]> wrote: > >

[web2py:11948] Re: create a web2py application which function as sending email

2008-11-16 Thread somebody
Thank alot.. missed that page hahaaa On Nov 17, 1:08 pm, mdipierro <[EMAIL PROTECTED]> wrote: > http://mdp.cti.depaul.edu/appliances/default/show/10 > > On Nov 16, 10:54 pm, somebody <[EMAIL PROTECTED]> wrote: > > > > > can we create an application in web2py t

[web2py:11947] Re: Cannot import from CSV file

2008-11-16 Thread somebody
hi are u creating a new module/controller which allow you to export SQL table value and save them as text file? I know that web2py has build in CSV but i want to create a new controller which allow you to export choosenSQL table value and save them as text file? can you help? thanks On Nov 5, 8:

[web2py:11946] Re: export sql statement and tables'values save as text file

2008-11-16 Thread somebody
count with _count, delete > with _delete and update with _update > > not sure I answered the question. > > Massimo > > On Nov 12, 7:15 am, somebody <[EMAIL PROTECTED]> wrote: > > > > > export sql statement and tables'values save as

[web2py:11943] create a web2py application which function as sending email

2008-11-16 Thread somebody
can we create an application in web2py to send an email? any help? --~--~-~--~~~---~--~~ 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 unsubscr

[web2py:11732] export sql statement and tables'values save as text file

2008-11-12 Thread somebody
export sql statement and tables'values save as text file in web2py. any guidance? thanks --~--~-~--~~~---~--~~ 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@googl