Hi JPDeni,

I was trying to use the 'List category and count' mod from your list of MODs at http://www.jpdeni.com/.../listcategories5.txt. My problem is the the field to be used is called "$Class_of" I have used this so as to be able to change this to "Class of" using the HTML globals in the html.pl file.

When I change the field to $Class_of I get an error and asked to start debugging. Is there any way to around this problem.

Thanks in advance

FHN

You should be able to just change the example of "Category" to your field name "Class_of" and have it work just fine.

I'm assuming you didn't mean that you used the $ in your field name.

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/

Hi LoisC,

actually I did use the "$Class_of" along with the $ sign. I thought it was quite creative. The reason I used it was because I wanted that the display to read "Class of" along with the space inbetween and this seemed to be a good way to do it not that I knew any other way. I am using the html.pl to autogenerate.

Any way out of this ?

If you want to display text before the output of the category lists insert that within the print statement:

print qq|Class of <A HREF="$db_script_link_url .... &view_records=1">$option</A> ($count{$option})<BR>|;

You shouldn't add it within the actual coding used to create the category list.

I would also highly recomment your creating your own forms and not using autogenerate as you are really limiting yourself to using the many available mods.

If you visit JPDeni's site you can use her configurator which will help you to create your html_record_form and html_record displays. Then just modify the output to suit your needs. http://www.jpdeni.com/dbman

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/

Hi LoisC,

Thanks for your help and advice. I am in the process of changing over to the format as you suggested. I am now using the "user firendly html" file. I am using the list catogories mod given at http://www.jpdeni.com/.../listcategories5.txt This for "Category names come from the records - witout the Validate records".

Here is what I am trying to do. I am running an alumni database and wanted to give an year wise list on number on reccords in the db. I wanted the list to be in vertical columns with 10 categories(years) in each column. I am not using a select field so only those years which have a record neet to be listed.

Is there any way to do this. Thanks in advance.

FHN

There was a thread that provided codes to create 2 columns.
This just divides the list in half, so you can't really set which years would be displayed in which column but may provide what you are looking for.

The thread reference is:

Subject: Category Select List tweak
Dan Kaplan 10-Sep-00
Thread: http://gossamer-threads.com/p/104666

in both the forum and the FAQ.

If the url isn't correct just search by the Subject.

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/

Hi LoisC,

Thanks for the prompt response. I did see the mod that you are refering to, however I am looking for multiple columns. In the alumni list if there is one preson each from 70 batches then it will mean 2 columns of 35 each. I would like them to be 7 columns of 10 each irrespective of the continuity. I was not able to replicate the formatting here so I am attaching a .doc file I hope it will clarify what I want.

Thanks again.

FHN

Sorry, but I didn't want to download your .doc file to check it out. The following thread gives some ideas on displaying categories in more than 1 column is:

Topic: Kinder & Gentler Elliot
willdeb February 23, 2000

I think there was one other thread but I can't remember now who gave the coding and didn't see it in my original FAQ files. I may have added it to the FAQ if you haven't searched there yet.

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/

Hi LoisC,

Thanks for the suggestion and the direction but I am not using the records.cgi. I am only using the list category mod in the userfriendly html. I dont know any perl but I would try and see if I can understand the logic with any luck I will still have a running db. Would it be possible for you to take a look at the db. I understand you may have more pressing matters. I can send you a login/password by email if you have the time.

Thanks in advance

FHN

Sure I can look at your database. Send me a private message via the forum.

The records.cgi is just the list categories and give a count mod put into a file to use with SSI. The coding is the same or the original used from JPDeni's coding.

I'll try and look for the other thread some more in my notes where someone added the ability to use numerous columns, but I have searched already and didn't locate it.

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/

I finally located the reference to easily defining the number of columns you want to use to display the category lists after hours of searching.

It was not within a specific thread reference but rather within a mod called: Show Records in Table v1.0

http://www.fishhoo.com/mods/showtblcgi.txt

This version is for using SSI to show the category list with counts, but the coding is very much the same between the two and can easily be changed to any of JPDeni's versions.

Hope this helps

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/

Thanks LoisC,

I decided to go with the the drop down list for the categories. It saves some space and the page is smaller so it will probably load quicker on dialup connections( a majority of my users are still on the slower dialups).

Thanks again for your help .

FHN