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";

...


}