Given the trouble most people seem to have with the relational mod, I'm almost afraid to ask this question, but here goes...
I have the relational mod working. When calling a long record on the primary DB by Userid, I get the relevant short record listings from the secondary DB for the same Userid... no probs whatsoever.
I have made a couple small changes to primary.pl sub html_record to make this work... basically commenting out the nh and mh variables in $long_url (don't need 'em), and making sure a valid Userid is written to the primary short display if there is a partial match or list all. So far so good...
$long_url =~ s/Userid=(\w+|\*)/Userid=$rec{'Userid'}/;
$long_url =~ s/Userid=&/Userid=$rec{'Userid'}&/;
The problem is that when I search the DB on any field other than Userid (the common field between the DBs), I either get NO short record listings from the secondary DB or ALL short record listings from the secondary DB.
Basically, if anyone has an relational implementation where they can successfully search on any field other than the common DB field, I would be most appreciative of pointers...
------------------
The Immuatable Order of Modding
-=-=-=-=-=-=-=-
1. Read the FAQ, 2. Search the board, 2a. Search the board again, 3. ask the question, 4. back-up, 5. experiment, 6. rephrase question (or better yet, post solution to original question)
[This message has been edited by oldmoney (edited February 28, 2000).]
I have the relational mod working. When calling a long record on the primary DB by Userid, I get the relevant short record listings from the secondary DB for the same Userid... no probs whatsoever.
I have made a couple small changes to primary.pl sub html_record to make this work... basically commenting out the nh and mh variables in $long_url (don't need 'em), and making sure a valid Userid is written to the primary short display if there is a partial match or list all. So far so good...
Code:
# $long_url = "$db_script_url?$long_url&nh=$record_number&mh=1"; $long_url =~ s/Userid=(\w+|\*)/Userid=$rec{'Userid'}/;
$long_url =~ s/Userid=&/Userid=$rec{'Userid'}&/;
The problem is that when I search the DB on any field other than Userid (the common field between the DBs), I either get NO short record listings from the secondary DB or ALL short record listings from the secondary DB.
Basically, if anyone has an relational implementation where they can successfully search on any field other than the common DB field, I would be most appreciative of pointers...
------------------
The Immuatable Order of Modding
-=-=-=-=-=-=-=-
1. Read the FAQ, 2. Search the board, 2a. Search the board again, 3. ask the question, 4. back-up, 5. experiment, 6. rephrase question (or better yet, post solution to original question)
[This message has been edited by oldmoney (edited February 28, 2000).]
