Is there a limit to the number of fields one can create in DBMAN? I have a genealogy database I would like to convert from HTML tables to DBMAN format, and it looks like I am going to need about 100 fields.

TIA

Jamie


------------------
James A. (Jamie) Dennis
*Certified AIX Administrator
*Certified Solaris Administrator
*Member - SAGE, USENIX

I don't think there's a limit, Jamie. Might make your database kinda big, but as far as I know you can have as many fields as you want. Please let us know when you have the genealogy db up and running. I'd love to see it!



------------------
JPD

No limit, but boy is it going to be ugly to do the HTML as well as the config file.

Cheers,

Alex

Alex

You're right there. The HTML WILL be ugly!

I do have a weirdness problem with the Genealogy application. I have fields defined for Date of Birth for ancestors, and I get a bad date format message when I try to submit an entry. I don't see what I am doing wrong, but I probably had a brain cramp or something.

Here is a copy of what I have done.

Thanks

Jamie
----------------------------------
Date => [12, 'date', -1, 15, 1, &get_date, ''],
Ancestor_1 => [13, 'alpha', 40, 255, 0, '', ''],
Ancestor_1_DOB => [14, 'date', 15, 15, 0, '', ''],
Spouse_1 => [15, 'alpha', 40, 255, 0, '', ''],
Spouse_1_DOB => [16, 'date', 15, 15, 0, '', ''],
Location_1 => [17, 'alpha', 40, 255, 0, '', ''],
Ancestor_2 => [18, 'alpha', 40, 255, 0, '', ''],
Ancestor_2_DOB => [19, 'date', 15, 15, 0, '', ''],
Spouse_2 => [20, 'alpha', 40, 255, 0, '', ''],
Spouse_2_DOB => [21, 'date', 15, 15, 0, '', ''],
Location_2 => [22, 'alpha', 40, 255, 0, '', ''],
Ancestor_3 => [23, 'alpha', 40, 255, 0, '', ''],
Ancestor_3_DOB => [24, 'date', 15, 15, 0, '', ''],
Spouse_3 => [25, 'alpha', 40, 255, 0, '', ''],
Spouse_3_DOB => [26, 'date', 15, 15, 0, '', ''],
Location_3 => [27, 'alpha', 40, 255, 0, '', ''],
Ancestor_4 => [28, 'alpha', 40, 255, 0, '', ''],
Ancestor_4_DOB => [29, 'date', 15, 15, 0, '', ''],
Spouse_4 => [30, 'alpha', 40, 255, 0, '', ''],
Spouse_4_DOB => [31, 'date', 15, 15, 0, '', ''],
Location_4 => [32, 'alpha', 40, 255, 0, '', ''],




------------------
James A. (Jamie) Dennis
*Certified AIX Administrator
*Certified Solaris Administrator
*Member - SAGE, USENIX

Hi jdennis,

This is a tracing tip that has helped me quite a bit before. I might tell you what is wrong with the date.

Add
while ( ($key, $value) = each %in) {
print " \n IN $key = $value\n OUT ";

at the end of "sub parse_form" in your db.pl file. Before the

return %in;

This will print out the values that you are passing along every time you hit the submit button.

Cheers
-JO

Upps,

I choped of the last }

Again the end of the sub should look like this:

while ( ($key, $value) = each %in) {
print " \n IN $key = $value\n OUT "; }

return %in;
}

Cheers
-JO

Do you plan on sorting by date? If not, I'd recommend just using 'alpha' fields. This will make things quite a bit easier and probably faster too.

Also, this is really screaming relational database. =) Depending on what you want to do with the data, you might be better off using an SQL server and some custom scripting.

But, as to the date problem, try turning on $db_debug to see what the form values are (similiar to what Jamie suggested).

Let me know how it goes!

Cheers,

Alex