Gossamer Forum
Home : Products : DBMan : Customization :

Limit number of records / insert list into html

Quote Reply
Limit number of records / insert list into html
So far I have only found the possibility to limit the number of records per user. I would like to limit the number of records for other fields.

Students should be able to register for a course, when there are 20 students, it is not possible any more to add new entries. Can anyone help me with this??

Another question is: how can I insert a list of results into a html-page? This doesn't work:
<!--#exec cgi="db.cgi?db=register&uid=default"-->

Thanks a lot for your help!!

Last edited by:

richard36: Oct 12, 2002, 5:54 PM
Quote Reply
Re: [richard36] Limit number of records / insert list into html In reply to
I don't recall a mod which would limit by a specific record value. But there was a thread regarding using " first-come-first-served basis" you may want to search on that to locate the thread. This way you could make a note on the add form that only up to 20 will be registered, and if someone drops out you will still have a record for an alternate for that course??

As far as your list, how are you generating the list. You would need to provide an explaination of what you are wanting to list. You may need to create a subroutine which creates the list for you .. that you could then call from a static page. There are various threads referenced for using SSI within the FAQ noted below.

Unoffical DBMan FAQ
http://redundantcartridge.com/dbman/
Quote Reply
Re: [LoisC] Limit number of records / insert list into html In reply to
hello!

thank you ever so much for your prompt reply! as for the limited records, I will probably have to create several dbases - I think it should be possilbe to restrict the number of total entries - but so far I only found possibilities to limit entries per user.

is it possible at all with dbman to insert data into a static html page? what I want to do is to create a webpage and then put the results (from different dbases) into this page - the principle would be similar to counters etc.
but maybe I have to write such a page within the **html.pl; but if I need different dbases (for different courses) I probably couldn't create a list with all registrations - what I would need is:

Course A
teacher, date, time ect.
<list with registered students>

Course B
teacher, date.....
<list >

thanks in advance for your help! currently I use the dbman program as a sort of results-service for HotPotatoes (if this could be of any interest for you)
Quote Reply
Re: [richard36] Limit number of records / insert list into html In reply to
limiting the number of records now works, I have found out here:

http://www.gossamer-threads.com/perl/gforum/gforum.cgi?post=85138#85138

I have tried as well the code from your page, but it seems that I got mixed up with the html-code on the page