db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Husek, Paul" <Paul.Hu...@pfizer.com>
Subject Dynamic table name
Date Fri, 17 Jun 2005 18:44:34 GMT
Hello,

 

 

I need to query a table who's structure is constant but who's name changes
depending on the date and time of day (e.g. Dynamic_06171120 or
Dynamic_06171450).  I've defined a table in Torque schema with the proper
layout but I'm wondering how I can dynamically change the table name of this
base class so it queries the proper table.  I'm thinking about something
like:

 

Criteria c=new Criteria();

c.setTableName("Dynamic_06171450");

c.add(DynamicPeer,ID ,10);

List l=DyanmicPeer.doSelect( c );

 

Can anything like this be done?

 

Thanks!

 


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message