Gossamer Forum
(Advanced Search)
for
Home : Products : DBMan : Customization :

Spreadsheet3 Mod Not Listing Fields

Jul 23, 2006, 1:33 PM
ewramos
Novice (12 posts)
Jul 23, 2006, 1:33 PM
Post #1 of 5
Views: 3497
Shortcut
Quote Reply
Spreadsheet3 Mod Not Listing Fields
I am trying to get this Spreadsheet3 Mod to work but am having a strange problem. Only 1 column of data is showing up. Please see this page;
http://www.edward-ramos.net/...ords=1&Record_ID=*

The DB only has 4 data fields;

Code:
%db_def = (
Record_ID => [0, 'numer', 5, 8, 1, '', ''],
Products => [1, 'alpha', 40, 255, 1, '', ''],
Manufacturer => [2, 'alpha', 0, 60, 1, '', ''],
URL => [3, 'alpha', 40, 255, 1, 'http://', '^http://']
);

Here is my html.pl file;
http://www.edward-ramos.net/...gi-bin/dbman/html.pl

Here is my default.cfg file;
http://www.edward-ramos.net/...in/dbman/default.cfg

I can see all my data with the 'vanills' html.pl file so I know everything is working. Any ideas?

Ed 8-)
Jul 23, 2006, 5:41 PM
JPDeni
Veteran / Moderator (8669 posts)
Jul 23, 2006, 5:41 PM
Post #2 of 5
Views: 3440
Shortcut
Quote Reply
Re: [ewramos] Spreadsheet3 Mod Not Listing Fields In reply to
You need to save your html.pl file and default.cfg file as .txt files so they can be seen. Or upload them as attachments to your post.


JPD
----------------------------------------------------
JPDeni's DBMan-ual
How to ask questions the smart way.
Jul 23, 2006, 6:27 PM
ewramos
Novice (12 posts)
Jul 23, 2006, 6:27 PM
Post #3 of 5
Views: 3436
Shortcut
Quote Reply
Re: [JPDeni] Spreadsheet3 Mod Not Listing Fields In reply to
Wasn't thinking... Sorry. Here they are...

Don't know if the attachment thing worked, so here is a link;
www.edward-ramos.net/PMS/cgi-bin/default.cfg.txt
www.edward-ramos.net/PMS/cgi-bin/default.db.txt
www.edward-ramos.net/PMS/cgi-bin/html.pl.txt

Last edited by:

ewramos: Jul 23, 2006, 6:35 PM
Jul 23, 2006, 7:26 PM
JPDeni
Veteran / Moderator (8669 posts)
Jul 23, 2006, 7:26 PM
Post #4 of 5
Views: 3416
Shortcut
Quote Reply
Re: [ewramos] Spreadsheet3 Mod Not Listing Fields In reply to
You need to have the field names exactly the same in html.pl as they are in the .cfg file.

Code:

sub html_record {
my (%rec) = @_;
# Replace FieldName below with the names of the fields you want to display. Create as many table cells as you wish, one for each field.
print qq| <TD>$rec{'Record_ID'}</TD><TD>$rec{'Products'}</TD><TD>$rec{'Manufacturer'}</TD><TD>$rec{'URL'}</TD> |;
}


JPD
----------------------------------------------------
JPDeni's DBMan-ual
How to ask questions the smart way.
Jul 23, 2006, 8:52 PM
ewramos
Novice (12 posts)
Jul 23, 2006, 8:52 PM
Post #5 of 5
Views: 3417
Shortcut
Quote Reply
Re: [JPDeni] Spreadsheet3 Mod Not Listing Fields In reply to
DUH!

I was under the mistaken understanding that the referenced section of code was for defining columnheaders.

Thank you so much for the help. I have been working at this ALL weekend. I have installed the mod at least 4 times.