Re: WC Database Format

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 10336
interpreted = N
texte = Grant Hulbert wrote: > > >Our sked has about 700 classes offered over 2,400 ways: i.e., 700 > >records with VARYING total-field info per line. Some have add'l fees, > >some don't; some have prerequisites, some don't. Some are taught at any > >or all of our 5 main campuses, etc., etc. > The key here may be to step away from a single homogenous database, and start using WebCat2's relational features. > ----------Classes.db-------- > ClassID Title Professor > 0001 Math John > 0002 English Frank > 0003 Geography Tim > ---------------------------- > > ----------Prerequisites.db-------- > ClassID PreReqID > 0001 0020 > 0001 0021 > 0001 0003 > 0002 0003 > 0002 0029 > ---------------------------------- > > Notice in this case that Math (0001) has 3 prerequisites: 0020, 0021, and 0003 (Geography). English (0002) has 2 prerequisites: 0003 (Geography) and 0029 > > So when your server displays a class description from Classes.db, you embed a search that finds all the corresponding ClassIDs in the Prerequisites.db that mat > This sounds very much like the way the mainframe version is currently built; from three diff data sets, that is. I think we would be able to use recurring classIDs in three or more WC databases, matching them to each necessary, variable class detail. This clue is prolly what will get me the closest to success. Thanks! I may have to ask for help when specifying the embedded searches, pulling items in from the other dbs (lookup, etc., compared to regular search). We'll see.( I get the feeling I've bitten off more than I can chew this first time through, however 8-o ) .Dave. -- d a v i d . h e r r i m a n Internet Applications Developer Metropolitan Community Colleges Kansas City, Missouri vox: 816-759-1345 fax: 816-759-1158 http://www.kcmetro.cc.mo.us mailto:herriman@kcmetro.cc.mo.us This button pushing really wears me out -- George Jetson Associated Messages, from the most recent to the oldest:

    
  1. Re: WC Database Format (Dave Herriman 1997)
  2. Re: WC Database Format (Grant Hulbert 1997)
  3. WC Database Format (Dave Herriman 1997)
Grant Hulbert wrote: > > >Our sked has about 700 classes offered over 2,400 ways: i.e., 700 > >records with VARYING total-field info per line. Some have add'l fees, > >some don't; some have prerequisites, some don't. Some are taught at any > >or all of our 5 main campuses, etc., etc. > The key here may be to step away from a single homogenous database, and start using WebCat2's relational features. > ----------Classes.db-------- > ClassID Title Professor > 0001 Math John > 0002 English Frank > 0003 Geography Tim > ---------------------------- > > ----------Prerequisites.db-------- > ClassID PreReqID > 0001 0020 > 0001 0021 > 0001 0003 > 0002 0003 > 0002 0029 > ---------------------------------- > > Notice in this case that Math (0001) has 3 prerequisites: 0020, 0021, and 0003 (Geography). English (0002) has 2 prerequisites: 0003 (Geography) and 0029 > > So when your server displays a class description from Classes.db, you embed a search that finds all the corresponding ClassIDs in the Prerequisites.db that mat > This sounds very much like the way the mainframe version is currently built; from three diff data sets, that is. I think we would be able to use recurring classIDs in three or more WC databases, matching them to each necessary, variable class detail. This clue is prolly what will get me the closest to success. Thanks! I may have to ask for help when specifying the embedded searches, pulling items in from the other dbs (lookup, etc., compared to regular search). We'll see.( I get the feeling I've bitten off more than I can chew this first time through, however 8-o ) .Dave. -- d a v i d . h e r r i m a n Internet Applications Developer Metropolitan Community Colleges Kansas City, Missouri vox: 816-759-1345 fax: 816-759-1158 http://www.kcmetro.cc.mo.us mailto:herriman@kcmetro.cc.mo.us This button pushing really wears me out -- George Jetson Dave Herriman

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

pc (1997) [foundItems] context problem (2000) WebCat2 - [format thousands] (1997) [WebDNA] Putting '&search' into URL killing all search contexts on my sites (2010) Protect (1997) cookie question (2002) Date Range search (1997) For those of you not on the WebCatalog Beta... (1997) Creating main- and sub-category search (1997) WebCat2: Items xx to xx shown, etc. (1997) Separate SSL Server (1997) Multiple catalog databases and showcart (1997) Help formatting search results w/ table (1997) test (2006) popups, netscape vs explorer (1997) practicing safe queries.. (2000) Nesting Search Within Tag? (1997) WebCat2: Items xx to xx shown, etc. (1997) New WebCatalog site! (1997) Database Security (1998)