Hi,
I have added a new DBMan modification to the Resources section (It should appear in a day or so) and I am looking for "Beta Testers" to give it a good working over and help me iron out any bugs or potential problems.
This mod is used to add records with unlimited fields by submitting multiple add pages.
Please try my demo at http://www.uniopp.com/cgi-local/beta/db.cgi
There are 5 pages with 252 fields and you only need to input one field as I have the others preset.
Add and modify your records as many times as you like!!!
Try and install your own version and let me know how it goes. The Mod is located at
http://www.uniopp.com/dbman/multipage.txt
Any feedback would be much appreciated.
Thank you.
Simon.
jai@uniopp.com

Hi,
I tested it today, but no record of me is shown in your database.

Is it of course using validate-mod?

Pit

Hi Pit,
Thank you for testing my demo.
I am not using the validate mod and all records should be added after the 5th page is submited.
I take it that you logged on using the name Mikki.
Your record was in the database file but it was missing one page of fields. It was counted in the number of search pages found but it was not listed with the others. If you followed the "next" link your page was displayed after the entry named "10".
For some reason this one corupt entry was stopping others from being able to add so I had to delete it (Sorry).
Every one who was trying to add got a duplicate key error.
Thank you for uncovering this problem.
Now for a reason and solution??????
According to the log record you logged, disconnected from your IP and then reconnected and continued submiting the pages.It also seems that you somehow added more than 5 pages. Did you hit the next page button more than once??
I would appreciate it if you could describe what you did so I can try to find out what happend.
Thanks again for your input.
Simon.

It probably doesn't have anything to do with the mod itself, but there is a problem with your table tags on your demo, which means that the records don't show up for folks using Netscape.

Otherwise, it looks really good. Of course, I didn't try to "break" it. I just wanted to see how it worked.

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

Thanks for trying it out.
Did you get a chance to look at any of the script?
I'm interested to know if I went about things the right way.
What do I need to do to make the tables show up in all browsers?
Thank you.
Simon.

In sub html_record_long, you need to add a </table> tag at the end.

Actually, I did see the "short" list. It was "add success" that was a blank page. This should be fixed when you add the </table> tag, though.

There's an awful lot of code there to look at! What I saw looked fine. And, of course, the proof of whether it's any good is whether it works -- and it seems to work great.

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

Thank you.
It seems to always be the easy ones that are hard to find!!
I added the closing table tag to html_record_long and that fixed half the problem. Netscape users can now see the long record but they still can't see the add success.
There is somthing wrong in the html_record. I deleted a closing </td> after the last table column but that didn't change anything.
Any ideas??
Thank you.
Simon.

You can do one of two things.

In sub html_add_success, change

&html_record(&get_record($in{$db_key}));

to

&html_record_long(&get_record($in{$db_key}));

Or you can change

&html_record(&get_record($in{$db_key}));

to

The first one will give you the long display after a record is added. The second one will fill out the table tags for the short display after a record is added.

You'll probably also need to put this in sub html_modify_success.

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

Thanks that did the trick!!!!!
Now I think Netscape users should be OK.
If you get a chance, I would appreciate it if you could try and "Break" my Mod. I would like to get it bug free for everyone (and of course myself).
Thanks.
Simon.

I noticed after downloading and condensing the file somewhat that you have:

|; &html_footer; print qq|
</td></tr></table></center></form>
</body></html> |;

It probably doesn't really make a difference, but I would close off the table and form prior to the display of the footers.

such as:

</td></tr></table></center></form> |;
&html_footer;
print qq|</body></html> |;

This may make it easier to adapt for those using format.pl rather then entering the body tags on each page.

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

Thanks for your input.
Do you mean in the html_add_form or the html_modify_form
or both????
Any other advice would be most welcomed.
Thank you.
Simon.

I'm sorry I can't remember now, but it seemed to be for several of the page outputs. I'm sure if you do a search within your script for the footers, you will find them all.

I think it may have been in both?

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