My only hesitation was defining the table twice and THATs SOLVED !!!
Thanks a ton !
On Nov 25, 11:57 am, mdipierro <[EMAIL PROTECTED]> wrote:
> If I understand...
>
> #create two connections
> db1=SQLDB(...)
> db2=SQLDB(...)
>
> #define the tables twice (perhaps using the following trick)
> db1.define_table('mytable',....)
> db2.define_table('mytable',db1.mytable)
>
> then use db1 for select and db2 for update, insert, etc.
>
> Massimo
>
> On Nov 25, 1:52 am, vihang <[EMAIL PROTECTED]> wrote:
>
> > Hi,
>
> > I am working on a small project that requires me to direct certain
> > queries to certain database connections. That is, simply put, all
> > select queries to one database connection and update, insert queries
> > to another. Can this be done in web2py without making mods to the DAL
> > code?
>
> > Cheers
> > Vihang
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
