[web2py] Re: MSSQL to CSV

2011-05-18 Thread DenesL
On May 18, 5:02 pm, Massimo Di Pierro wrote: > db.define_table('yourtable',Field(...),,migrate=True,fake_migrate=True) why not just ...,migrate=False) ? what does that combo provide?

[web2py] Re: MSSQL to CSV

2011-05-18 Thread mart
ok, got it! thanks again :) On May 18, 5:02 pm, Massimo Di Pierro wrote: > ERRATA: > > > > > > > > > db=DAL('mssql://...') > > db.define_table('yourtable',Field(...),,migrate=True,fake_migrate=True) > > print str(db(db.yourtable).select()) # outputs the CSV

[web2py] Re: MSSQL to CSV

2011-05-18 Thread Massimo Di Pierro
ERRATA: > db=DAL('mssql://...') > db.define_table('yourtable',Field(...),,migrate=True,fake_migrate=True) > print str(db(db.yourtable).select()) # outputs the CSV

[web2py] Re: MSSQL to CSV

2011-05-18 Thread mart
ok, that's sounds like a good idea (btw - dal is worth gold!) Thanks for the help Massimo! :) On May 18, 4:43 pm, Massimo Di Pierro wrote: > If you know the mssql table structure, you can create a quick web2py > model: > > db=DAL('mssql://...') > db.define_table('yourtable',Field(...),) > pr

[web2py] Re: MSSQL to CSV

2011-05-18 Thread Massimo Di Pierro
If you know the mssql table structure, you can create a quick web2py model: db=DAL('mssql://...') db.define_table('yourtable',Field(...),) print str(db(db.yourtable).select()) # outputs the CSV On May 18, 3:32 pm, mart wrote: > Hi, > > there's this MSSQL server running remotely, and I would