tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "mike jackson" <mjack...@cdi-hq.com>
Subject RE: Getting pretty far off topic here
Date Tue, 01 Apr 2003 23:42:18 GMT
1) Just to be sure, databases or tables?  Or since it's Oracle, do you
mean different Schemas?  If it's different schemas then I'd create
synonyms into a new schema for each of the different data sources
(tables / schemas / databases whatever).

2) Sounds like you need a rule processor.  If it were me I'd look at
what's common between the different card types, and figure out how to
determine which card type you are working with.  Then based on the card
type you have a rules engine, which may or may not load custom code for
that card type.  

Then again this sounds like you have a really elaborate need here, it's
not going to be really easy to point you in a direction unless we have a
better picture of what is going on.

--mikej
-=-----
mike jackson
mjackson@cdi-hq.com

-----Original Message-----
From: Sandra Patricia Hunter [mailto:redbirdofthesouth@shaw.ca] 
Sent: Tuesday, April 01, 2003 3:34 PM
To: 'Tomcat Users List'
Subject: Getting pretty far off topic here

I am stumped about how to manage a process.
 
Here is what I need to do:
I have several "cards". Each card accesses specific data from the
database.
Each card accesses a different collection of data from different
attributes
of different tables. 
For the user to work with the data (add, update, delete, search) the JSP
file must display the appropriate text boxes and drop down boxes for the
data relevant to that card. This will be different for each card. 

There will be new cards created that will have their own collection of
data.
The number of possible new cards is relatively infinite. That is why I
can't
do a specific JSP file for each card type: the card types that exist now
may
disappear and new ones may appear.

How do I store the names of fields that are relevant to that card so
that I
can access them when I need to display data about that particular card?
How
do I create new files of relevant fields when I create new cards?

I originally stored an SQL string that selects the relevant fields with
the
table that holds other information about the card type. But what do I do
with it then? How do I take that SQL string and turn it into text boxes
and
labels and drop down boxes?

Is there a better way of doing this that someone can think of?

Sandra Patricia Hunter
Systems Development and Web Design 
 


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message