baseportal
Start

baseportal message board

Welcome to the baseportal message board...

Please read the FAQ.

 
 Selected message: To the list 
    Message from TheOneRing on 12/18 2003, 16:22 +00:00
    EMail: theonering@thegateroom.com WWW: geocities.com/theonering_stargate

    Still need help but isolated the issue


      The problem seems to be the spaces in the database. I resaved the titles as "Conspiracy Series, The" and "Sun's Love, The" but this is just a work around. There will be other issues that come up if I don't get the search resolved.

      Help!

      TOR

    Your reply:

    Name: EMail: WWW:
    Subject:
    Text:
    Timezone:

    Post a new message


 All messages from this thread: To the list 
    Message from TheOneRing on 12/18 2003, 05:38 +00:00
    EMail: theonering@thegateroom.com WWW: geocities.com/theonering_stargate

    Can't get the "get" call correct


      I have two databases; one named "Archive" and one named "Story". They have a relation -- each has the common field "Title". The "Archive" database lists each story title only once with author and other fields. The "Story" database may use the title from "Archive" several times depending on the number of chapters in the story. Each chapter receives an entry with the Title field.

      For example,
      "Archive" field "Title" equals "The Conspiracy"
      "Story" has three "Title" fields that equal "The Conspiracy" because the story "The Conspiracy" has three chapters.

      In theory, I think the get_next call below should use Title==$Title to find all fields in "Story" called "The Conspiracy" but when I try this, I get nothing returned.

      If I use Title~=$Title I get exactly what I want returned until I added a story with a title of "The Sun". The ~= always causes "The Conspiracy" to be returned due to alphabetical order.

      Any ideas? I don't know why Title==$Title doesn't work -- it does work in a URL call but not in the get_next.

      <perl>
      get;
      while(get_next)
      {
      get "Title~=$Title&Link==*&Chapter_number==*&sort=", "Story";
      ...

      }

     Post a reply

    Message from TheOneRing on 12/18 2003, 16:22 +00:00
    EMail: theonering@thegateroom.com WWW: geocities.com/theonering_stargate

    Still need help but isolated the issue


      The problem seems to be the spaces in the database. I resaved the titles as "Conspiracy Series, The" and "Sun's Love, The" but this is just a work around. There will be other issues that come up if I don't get the search resolved.

      Help!

      TOR

     Post a reply


    Message from Christoph Bergmann on 12/23 2003, 03:58 +01:00
    EMail: info@baseportal.com

    Re: Can't get the "get" call correct


      Can you please give me the call to the page so I can take a look at it...?
     Post a reply

 Messages from 2850 to 3000: To the input form 
<< Newest messages | < Newer messages | To the input form | Older messages > | Oldest messages >>


Back to the homepage

© baseportal.com. All rights reserved. Terms of use



baseportal.com