Hi guys!
I having a problem I don´t know how to solve. I have tow different
sites (made in webware) and hava two different modules to access two
different database.
The first site database was designed using the SQLObject´s createTable
method. I have one table called cidade and another one called estado.
The second site database was designed to another person, the database
name convention is too strange. The cidade id is not called id or
cidade_id, it is called cidaauct. So I need to specify each column´s
name.
The problem is that the webware are caching the Cidade class (I think),
I have put a _cacheValues=False on the class without sucess (I put in
all class), so I think the focus is the webware. If I acess the second
site first and then the first site there is no problem, but if I try to
access the first and then the second, the column estado_id is not
found, i think when the sqlobject is trying to make the join.
How can I specify to webware (if the problem is with webware), that
Site1.Database1.Estado is not equal Site2.Database2.Estado, or anything
like this?
Does anyone have such problem?
thanks for the attention, I will list the two classes code follow:
File: Site1.Database1
...
__CONNECTION__='mysql://...'
class Cidade(SQLObject):
_connection=__CONNECTION__
_cacheValues=False
nome=StringCol(length=50)
estado=ForeignKey('Estado')
class Estado(SQLObject):
_connection=__CONNECTION__
_cacheValues=False
nome=StringCol(length=50)
sigla=StringCol(length=2, alternateID=True)
cidades=MultipleJoin('Cidade')
...
File: Site2.Database2
...
CONNECTION='mysql://...'
class Cidade(SQLObject):
_connection=CONNECTION
_idName='codicida'
_cacheValues=False
nome=StringCol(dbName='desccida')
estado=ForeignKey('Estado', dbName='codiesta')
class Estado(SQLObject):
_connection=CONNECTION
_idName='codiesta'
_cacheValues=False
nome=StringCol(dbName='descesta')
sigla=StringCol(dbName='siglesta', length=2, alternateID=True)
cidades=MultipleJoin('Cidade')
...
=====
--
Michel Thadeu Sabchuk
Curitiba/PR
______________________________________________________________________
Yahoo! Mail - agora com 100MB de espaço, anti-spam e antivírus grátis!
http://br.info.mail.yahoo.com/
-------------------------------------------------------
This SF.Net email sponsored by Black Hat Briefings & Training.
Attend Black Hat Briefings & Training, Las Vegas July 24-29 -
digital self defense, top technical experts, no vendor pitches,
unmatched networking opportunities. Visit www.blackhat.com
_______________________________________________
Webware-discuss mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/webware-discuss
