Gossamer Forum: Products: DBMan: Customization: Combine 2 mods

Jun 28, 2000, 4:28 PM

willdeb

User (310 posts)

Jun 28, 2000, 4:28 PM

Post #1 of 53

Shortcut

Combine 2 mods

Has anyone tried to fold JPD's "Column Record Display" into Eliot's "List Records by Category (records.cgi)" I really like Elliot's mod. I find it very easy to use and is just right for what I am doing, but I would really like to be able to decide how many colums the list of records is displayed in.

If you haven't tried it, would you like to? Laugh

Will
Webmaster
FishHoo! Search Index for Fishermen
http://www.fishhoo.com/

Jun 28, 2000, 5:23 PM

JPDeni

Veteran / Moderator (8669 posts)

Jun 28, 2000, 5:23 PM

Post #2 of 53

Shortcut

Re: Combine 2 mods In reply to

I hesitate to try to modify someone else's mod, especially when it is an external script. If I get time, though, I'll take a look at it.

JPD
http://www.jpdeni.com/dbman/

Jun 28, 2000, 5:38 PM

willdeb

User (310 posts)

Jun 28, 2000, 5:38 PM

Post #3 of 53

Shortcut

Re: Combine 2 mods In reply to

Anything you can do will be appreciated.

Will
Webmaster
FishHoo! Search Index for Fishermen
http://www.fishhoo.com/

Jun 30, 2000, 11:41 AM

LoisC

Veteran / Moderator (3034 posts)

Jun 30, 2000, 11:41 AM

Post #4 of 53

Shortcut

Re: Combine 2 mods In reply to

JP:

This topic has come up before and a solution for displaying number of columns was provided by oldmoney in the following thread:

http://www.gossamer-threads.com/perl/forum/showflat.pl?Cat=&Board=DBCust&Number=11905&page=&view=&sb=&vc=1

also refered to in above thread:
http://www.gossamer-threads.com/scripts/forum/resources/Forum12/HTML/000880.html

Just thought perhaps this would save some time if you take this on.

Unoffical DBMan FAQ
http://webmagic.hypermart.net/dbman/

Jul 1, 2000, 6:11 AM

willdeb

User (310 posts)

Jul 1, 2000, 6:11 AM

Post #5 of 53

Shortcut

Re: Combine 2 mods In reply to

Thanks LoisC, but if you will notice, it was me posting in the first thread you mentioned and I kept getting partial answers and never a final solution. The second thread does not mention records.cgi at all that I can see.

The whole purpose behind this request was to take a small, very easy to set up script and make it much more functional. I know I could use it and am sure others could too.

Once again, thanks.

Will
Webmaster
FishHoo! Search Index for Fishermen
http://www.fishhoo.com/

Jul 2, 2000, 12:47 AM

JPDeni

Veteran / Moderator (8669 posts)

Jul 2, 2000, 12:47 AM

Post #6 of 53

Shortcut

Re: Combine 2 mods In reply to

I, personally, have never seen the point in using an external script. It's much easier to work within DBMan than to create a separate script that is called by SSI. Maybe part of my thinking is because I don't have access to SSI and I've learned to work around it.

What exactly do you want to do with the List Categories mod? What are the field names and what do you want your page to look like?

JPD
http://www.jpdeni.com/dbman/

Jul 2, 2000, 3:32 AM

willdeb

User (310 posts)

Jul 2, 2000, 3:32 AM

Post #7 of 53

Shortcut

Re: Combine 2 mods In reply to

I use records.cgi to display a list of State fields as you can see on http://www.fishhoo.com/.../reports/reports.htm. Right now I have the list in 2 columns but would like to break into 4. I have one more instance where I use records.cgi and am planning a 3rd.

Thanks,

Will
Webmaster
FishHoo! Search Index for Fishermen
http://www.fishhoo.com/

Jul 2, 2000, 3:55 AM

JPDeni

Veteran / Moderator (8669 posts)

Jul 2, 2000, 3:55 AM

Post #8 of 53

Shortcut

Re: Combine 2 mods In reply to

I think I got it, but I'm not sure. (Myy apologies if I've been testy. The past few days have not been very good.)

You are going to want to use the same script for two different things? Did you want to be able to pass information to the script to change the number of columns or the fields or anything?

I'm going to assume you're not for now. It's best if you make just one change and test that out and then we can continue with something else.

Make the changes in red below:

Code:

$i = 1;
$cols = 4; # Change this to the number of columns you want
$numhits = $#selectfields + 1;
print "<table>";

foreach $field (sort @selectfields) {

unless (($i-1)%($cols)) {
print "<tr>";
}

$sfield = &urlencode($field);
print qq|<$font><a href="$db_script_link_url&ID=*&$cat_name=$sfield&sb=1&so=descend">$field</a>:
<$smfont>($count{$field}) |;

if (($i-1)%($cols)==($cols-1)) {
print "</tr>\n";
}
++$i;

}

if ($numhits%$cols) {
for ($j=($cols-1);$j>=$numhits%$cols ;$j--) {
print "<td> </td>";
}
print "</tr>\n";
}
print "</table>";

I think that's right. There were some different variables I had to deal with and I'm not sure I dealt with them correctly. Smile

If your table comes out messed up, let me know and I'll see if I can figure out where I went wrong.

JPD
http://www.jpdeni.com/dbman/

Jul 2, 2000, 4:18 AM

willdeb

User (310 posts)

Jul 2, 2000, 4:18 AM

Post #9 of 53

Shortcut

Re: Combine 2 mods In reply to

Make the changes in records.cgi? Not sure where you mean to change the code.

Here is a link to the un-modified records.cgi http://www.fishhoo.com/team/1colrecordscgi.txt and this on is to one that has been modified to show 2 columns http://www.fishhoo.com/team/2colrecordscgi.txt.

Will
Webmaster
FishHoo! Search Index for Fishermen
http://www.fishhoo.com/

Jul 2, 2000, 4:27 AM

JPDeni

Veteran / Moderator (8669 posts)

Jul 2, 2000, 4:27 AM

Post #10 of 53

Shortcut

Re: Combine 2 mods In reply to

I guess I was taking the code from the script that's in the Resource Center.

In the unmodified version, remove

Code:

foreach $field (sort @selectfields) {
$sfield = &urlencode($field);
print qq|<div align=center>
<center>
<table border=0 cellpadding=0 cellspacing=0 width=600>
<tr>
<td><a href="$db_script_link_url&$&view_records=1&ID=*&$cat_name=$sfield&sb=1&so=descend">$field</a> 
</td>
</tr>
</table>
</center>
</div>|;
}

And replace it with the code I gave you above. You'll need to add "<center>" tags and stuff, but let's make sure the basic structure works first. Smile

JPD
http://www.jpdeni.com/dbman/

Jul 2, 2000, 4:51 AM

willdeb

User (310 posts)

Jul 2, 2000, 4:51 AM

Post #11 of 53

Shortcut

Re: Combine 2 mods In reply to

I made the changes only in red and it didn't work. Here's what it returned via telnet.

content-type: text/html
<tr></table>

That's all. I made the changes to the 1col text file above so you could see.

Will
Webmaster
FishHoo! Search Index for Fishermen
http://www.fishhoo.com/

Jul 2, 2000, 2:09 PM

LoisC

Veteran / Moderator (3034 posts)

Jul 2, 2000, 2:09 PM

Post #12 of 53

Shortcut

Re: Combine 2 mods In reply to

willdeb:

The only reason I referenced the above thread is so JP could find the codes already presented for the 2 and 4 column display. I did realize that you were involved in that thread, but also that you weren't able to get a working solution.

For your last question. When you are running your script from your static page you need to comment out the line:

print "Content-type: text/html\n\n";

This should only be used for testing purposes when calling the script directly.

I noticed in your file you have:

# Change this to the number of columns you want$numhits = $#selectfields + 1;print "<table>";

This is all one line, which means that:

$numhits = $#selectfields + 1;print "<table>";

is actually behind a comment from the previous line, and as such will not be used as a line of code.

Move that line to a line by itself and see if that solved your problem.

Hope this helps

Unoffical DBMan FAQ
http://webmagic.hypermart.net/dbman/

Jul 3, 2000, 7:40 PM

willdeb

User (310 posts)

Jul 3, 2000, 7:40 PM

Post #13 of 53

Shortcut

Re: Combine 2 mods In reply to

There seems to be a couple of missing post here. I'll try it again tomorrow and post the results.

Will
Webmaster
FishHoo! Search Index for Fishermen
http://www.fishhoo.com/

Jul 4, 2000, 8:41 AM

willdeb

User (310 posts)

Jul 4, 2000, 8:41 AM

Post #14 of 53

Shortcut

Re: Combine 2 mods In reply to

The latest effort for this combo mod can be seen at http://www.fishhoo.com/team/records.txt.

Now it is returning <table><tr></table> via telnet and a 500 error when executed from a browser.

More thoughts?

Will
Webmaster
FishHoo! Search Index for Fishermen
http://www.fishhoo.com/

Jul 5, 2000, 6:03 AM

willdeb

User (310 posts)

Jul 5, 2000, 6:03 AM

Post #15 of 53

Shortcut

Re: Combine 2 mods In reply to

Back to the top.

Will
Webmaster
FishHoo! Search Index for Fishermen
http://www.fishhoo.com/

Jul 5, 2000, 10:06 AM

JPDeni

Veteran / Moderator (8669 posts)

Jul 5, 2000, 10:06 AM

Post #16 of 53

Shortcut

Re: Combine 2 mods In reply to

I see the code, but I'm not sure what the problem is. There are no syntax errors in your code.

JPD
http://www.jpdeni.com/dbman/

Jul 5, 2000, 10:25 AM

willdeb

User (310 posts)

Jul 5, 2000, 10:25 AM

Post #17 of 53

Shortcut

Re: Combine 2 mods In reply to

Thank you very much for trying.

Will
Webmaster
FishHoo! Search Index for Fishermen
http://www.fishhoo.com/

Jul 5, 2000, 10:26 AM

JPDeni

Veteran / Moderator (8669 posts)

Jul 5, 2000, 10:26 AM

Post #18 of 53

Shortcut

Re: Combine 2 mods In reply to

What exactly is the problem? Maybe I can figure it out.

JPD
http://www.jpdeni.com/dbman/

Jul 5, 2000, 10:43 AM

willdeb

User (310 posts)

Jul 5, 2000, 10:43 AM

Post #19 of 53

Shortcut

Re: Combine 2 mods In reply to

This is all it is doing.

In Reply To:

Now it is returning <table><tr></table> via telnet and a 500 error when executed from a browser.

Will
Webmaster
FishHoo! Search Index for Fishermen
http://www.fishhoo.com/

Jul 5, 2000, 10:53 AM

JPDeni

Veteran / Moderator (8669 posts)

Jul 5, 2000, 10:53 AM

Post #20 of 53

Shortcut

Re: Combine 2 mods In reply to

When I looked before, I just was checking for a syntax error, which I didn't find. I didn't realize that you had taken out some rather important code.

In the post where I gave you the new code, there is blue text and red text. The blue text was what was already there and you should keep. The red text was the new stuff to add.

Put the blue text back and you'll probably have some better results.

JPD
http://www.jpdeni.com/dbman/

Jul 5, 2000, 11:53 AM

willdeb

User (310 posts)

Jul 5, 2000, 11:53 AM

Post #21 of 53

Shortcut

Re: Combine 2 mods In reply to

It's still returning a 500 error by browser and by telnet it is returning

Code:

<table><tr><a href="http://www.fis
hhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=default&ID=*&State=Alaska&sb
=1&so=descend">Alaska</a>:
(1) <a href="http://www.fish
hoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=default&ID=*&State=Arkansas&s
b=1&so=descend">Arkansas</a>:
(1) <a href="http://www.fish
hoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=default&ID=*&State=California
&sb=1&so=descend">California</a>:
(2) <a href="http://www.fish
hoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=default&ID=*&State=Canada&sb=
1&so=descend">Canada</a>:
(3) </tr>
<tr><a href="http://www.fishhoo.co
m/cgi-bin/team/reports/db.cgi?db=reports&uid=default&ID=*&State=Colorado&sb=1&so
=descend">Colorado</a>:
(1) <a href="http://www.fish
hoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=default&ID=*&State=Florida&sb
=1&so=descend">Florida</a>:
(11)
 <a href="http://www.fis
hhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=default&ID=*&State=Georgia&s
b=1&so=descend">Georgia</a>:
(2) <a href="http://www.fish
hoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=default&ID=*&State=Hawaii&sb=
1&so=descend">Hawaii</a>:
(5) </tr>
<tr><a href="http://www.fishhoo.co
m/cgi-bin/team/reports/db.cgi?db=reports&uid=default&ID=*&State=Kansas&sb=1&so=d
escend">Kansas</a>:
(1) <a href="http://www.fish
hoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=default&ID=*&State=Kentucky&s
b=1&so=descend">Kentucky</a>:
(2) <a href="http://www.fish
hoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=default&ID=*&State=Louisiana&
sb=1&so=descend">Louisiana</a>:
(2) <a href="http://www.fish
hoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=default&ID=*&State=Massachuse
tts&sb=1&so=descend">Massachusetts</a>:
(1) </tr>
<tr><a href="http://www.fishhoo.co
m/cgi-bin/team/reports/db.cgi?db=reports&uid=default&ID=*&State=Mexico&sb=1&so=d
escend">Mexico</a>:
(3) <a href="http://www.fish
hoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=default&ID=*&State=Michigan&s
b=1&so=descend">Michigan</a>:
(4) <a href="http://www.fish
hoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=default&ID=*&State=Missouri&s
b=1&so=descend">Missouri</a>:
(1) <a href="http://www.fish
hoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=default&ID=*&State=New Jers
ey&sb=1&so=descend">New Jersey</a>:
(1) </tr>
<tr><a href="http://www.fishhoo.co
m/cgi-bin/team/reports/db.cgi?db=reports&uid=default&ID=*&State=New York&sb=1&
so=descend">New York</a>:
(2) <a href="http://www.fish
hoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=default&ID=*&State=North Ca
rolina&sb=1&so=descend">North Carolina</a>:
(2) <a href="http://www.fish
hoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=default&ID=*&State=Oregon&sb=
1&so=descend">Oregon</a>:
(1) <a href="http://www.fish
hoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=default&ID=*&State=Pennsylvan
ia&sb=1&so=descend">Pennsylvania</a>:
(1) </tr>
<tr><a href="http://www.fishhoo.co
m/cgi-bin/team/reports/db.cgi?db=reports&uid=default&ID=*&State=South Carolina
&sb=1&so=descend">South Carolina</a>:
(3) <a href="http://www.fish
hoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=default&ID=*&State=Tennessee&
sb=1&so=descend">Tennessee</a>:
(1) <a href="http://www.fish
hoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=default&ID=*&State=Texas&sb=1
&so=descend">Texas</a>:
(4) <a href="http://www.fish
hoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=default&ID=*&State=Wisconsin&
sb=1&so=descend">Wisconsin</a>:
(3) </tr>
</table>

You can see the changes at http://www.fishhoo.com/team/records.txt

There may be some errors because I haven't figured out how to copy from this new board and paste into anything but one single line.

Will
Webmaster
FishHoo! Search Index for Fishermen
http://www.fishhoo.com/

Jul 5, 2000, 12:19 PM

JPDeni

Veteran / Moderator (8669 posts)

Jul 5, 2000, 12:19 PM

Post #22 of 53

Shortcut

Re: Combine 2 mods In reply to

Try the code I have in a file for you at http://www.jpdeni.com/dbman/Mods/willdeb.txt.

I guess I thought you had table cell tags already in the script. I was wrong.

JPD
http://www.jpdeni.com/dbman/

Jul 5, 2000, 12:38 PM

willdeb

User (310 posts)

Jul 5, 2000, 12:38 PM

Post #23 of 53

Shortcut

Re: Combine 2 mods In reply to

That's returning a 500 error by browser and by telnet

Code:

<table><tr><td>
<a href="http://www.fishhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=d
efault&ID=*&State=Alaska&sb=1&so=descend">Alaska</a>:
(1
)</td><td>
<a href="http://www.fishhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=d
efault&ID=*&State=Arkansas&sb=1&so=descend">Arkansas</a>:
(1
)</td><td>
<a href="http://www.fishhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=d
efault&ID=*&State=California&sb=1&so=descend">California</a>:
(2
)</td><td>
<a href="http://www.fishhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=d
efault&ID=*&State=Canada&sb=1&so=descend">Canada</a>:
(3
)</td></tr>
<tr><td>
<a href="http://www.fishhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=d
efault&ID=*&State=Colorado&sb=1&so=descend">Colorado</a>:
(1
)</td><td>
<a href="http://www.fishhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=d
efault&ID=*&State=Florida&sb=1&so=descend">Florida</a>:
(11)</td><td>
<a href="http://www.fishhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=d
efault&ID=*&State=Georgia&sb=1&so=descend">Georgia</a>:
(2
)</td><td>
<a href="http://www.fishhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=d
efault&ID=*&State=Hawaii&sb=1&so=descend">Hawaii</a>:
(5
)</td></tr>
<tr><td>
<a href="http://www.fishhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=d
efault&ID=*&State=Kansas&sb=1&so=descend">Kansas</a>:
(1
)</td><td>
<a href="http://www.fishhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=d
efault&ID=*&State=Kentucky&sb=1&so=descend">Kentucky</a>:
(2
)</td><td>
<a href="http://www.fishhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=d
efault&ID=*&State=Louisiana&sb=1&so=descend">Louisiana</a>:
(2
)</td><td>
<a href="http://www.fishhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=d
efault&ID=*&State=Massachusetts&sb=1&so=descend">Massachusetts</a>:
(1
)</td></tr>
<tr><td>
<a href="http://www.fishhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=d
efault&ID=*&State=Mexico&sb=1&so=descend">Mexico</a>:
(3
)</td><td>
<a href="http://www.fishhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=d
efault&ID=*&State=Michigan&sb=1&so=descend">Michigan</a>:
(4
)</td><td>
<a href="http://www.fishhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=d
efault&ID=*&State=Missouri&sb=1&so=descend">Missouri</a>:
(1
)</td><td>
<a href="http://www.fishhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=d
efault&ID=*&State=New Jersey&sb=1&so=descend">New Jersey</a>:
(1
)</td></tr>
<tr><td>
<a href="http://www.fishhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=d
efault&ID=*&State=New York&sb=1&so=descend">New York</a>:
(2
)</td><td>
<a href="http://www.fishhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=d
efault&ID=*&State=North Carolina&sb=1&so=descend">North Carolina</a>:
(2
)</td><td>
<a href="http://www.fishhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=d
efault&ID=*&State=Oregon&sb=1&so=descend">Oregon</a>:
(1
)</td><td>
<a href="http://www.fishhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=d
efault&ID=*&State=Pennsylvania&sb=1&so=descend">Pennsylvania</a>:
(1
)</td></tr>
<tr><td>
<a href="http://www.fishhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=d
efault&ID=*&State=South Carolina&sb=1&so=descend">South Carolina</a>:
(3
)</td><td>
<a href="http://www.fishhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=d
efault&ID=*&State=Tennessee&sb=1&so=descend">Tennessee</a>:
(1
)</td><td>
<a href="http://www.fishhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=d
efault&ID=*&State=Texas&sb=1&so=descend">Texas</a>:
(4
)</td><td>
<a href="http://www.fishhoo.com/cgi-bin/team/reports/db.cgi?db=reports&uid=d
efault&ID=*&State=Wisconsin&sb=1&so=descend">Wisconsin</a>:
(3
)</td></tr>
</table>

Will
Webmaster
FishHoo! Search Index for Fishermen
http://www.fishhoo.com/

Jul 5, 2000, 1:00 PM

JPDeni

Veteran / Moderator (8669 posts)

Jul 5, 2000, 1:00 PM

Post #24 of 53

Shortcut

Re: Combine 2 mods In reply to

The telnet looks fine. I just pasted your code into a browser and I got 4 columns of states.

The script does not have any syntax errors. I have checked that.

Are you sure that your path to Perl is correct and that you uploaded in ASCII mode? Are all of the files in the right place?

This is one reason I hesitate to work on someone else's script. I don't know the quirks of the script to know what to look for.

Do you still have your two-column script? Try using that again and see what happens.

JPD
http://www.jpdeni.com/dbman/

Jul 5, 2000, 1:57 PM

willdeb

User (310 posts)

Jul 5, 2000, 1:57 PM

Post #25 of 53

Shortcut

Re: Combine 2 mods In reply to

I did everything again just to make sure I was doing everything right and it still returns a 500 error.

Yes the 2 column still works.

This could be a very nice and simple to use little mod if we ever get the kinks worked out. If you get frustrated, I hope you will put it away and try again later.

Will
Webmaster
FishHoo! Search Index for Fishermen
http://www.fishhoo.com/

Combine 2 mods

(Page 1 of 3)