baseportal | ||
Start | ||
baseportal message board | |
Welcome to the baseportal message board... Please read the FAQ.
|
Selected message: | To the list |
Message from Kelly on 10/3 2003, 06:06 +00:00 EMail: theonering@thegateroom.com Re: Working with multiple databases - how to manipulate fieldsIt's been a challenge, believe me. But very satisfying when you get something to work! |
|
All messages from this thread: | To the list |
Message from kelly on 9/23 2003, 19:31 +00:00 EMail: theonering@thegateroom.com WWW: baseportal.com/baseportal/TheOneRing/Story_archives/Story Working with multiple databases - how to manipulate fieldsI have two databases with a relation. db=Archive # this database contains story details i.e. Author, Title db=Story # this database contains the story contents with multiple chapters i.e. Title, Chapter_numbers, Story Note: The entry in db=Archive for "Title" only occurs once. The entry in db=Story for "Title" occurs multiple times depending on the number of chapters in the story. For example, db=Archive Author Title ------------------------ TheOneRing Dark Patches Kelly Test db=Story Author Title Chapter_numbers Story --------------------------------------------------- TheOneRing Dark Patches 1 (Contents of chapter 1) TheOneRing Dark Patches 2 (Contents of chapter 2) Kelly Test 1 (Contents of chapter 1) Question: How do I allow the reader to select the story Title in db=Archive, then code it to find the Title in db=Story and output each chapter of the story? The code below works, but the sort is hardcoded as "Title~=D". I need to make the "Title~=D" variable somehow depending on the story the reader wants to read. Database=Archive
Database=Story
Warning: I'm a perl novice. Could probably write what I need in Fortran, though ;) |
Message from Kelly on 9/28 2003, 22:31 +00:00 EMail: theonering@thegateroom.com Okay, I got itFinally figure out the URL browse, Get_next stuff, and creating multiple templates. Lots of trial and error, though. |
Message from Christoph Bergmann on 9/30 2003, 04:08 +01:00 EMail: info@baseportal.com Re: Working with multiple databases - how to manipulate fields> Warning: I'm a perl novice. Could probably write what I need in Fortran, though ;) You are not the first person who learns Perl because of baseportal ,-)) |
|
Messages from 3300 to 3450: | To the input form |
> Working with multiple databases - how to manipulate fields from kelly on 9/23 2003, 19:31 +00:00 Okay, I got it from Kelly on 9/28 2003, 22:31 +00:00 Re: Working with multiple databases - how to manipulate fields from Christoph Bergmann on 9/30 2003, 04:08 +01:00 |
Re: Working with multiple databases - how to manipulate fields from Kelly on 10/3 2003, 06:06 +00:00 |
<< Newest messages | < Newer messages | To the input form | Older messages > | Oldest messages >> |
© baseportal.com. All rights reserved. Terms of use |