Hello,

I been looking for this answer with no luck -

Is there an easy way to insert a new field in a populated database (like a perl script that will add the delimiters to tne end of each existing line?)

And if so, what is the risk of messing up everything by adding a new field?

I currently have about 8200 records in my db.

Thanks in advance!

-digitalsea
http://www.digital-sea.com/

Did you search? In the Resource Section, find "Update fields in either category or links database."


Leonard
aka PerlFlunkie

Thanks for your quick reply. I did search but all I got was people asking how to use the code (not the code itself).

I was thinking of adding the field to the end of links.def, so it would be field 12. Have you ever added an additional field to a database that contained many links? Did it work perfectly or were there issues with the templates seeing the new field?

-digitalsea
http://www.digital-sea.com/

I have used that script to add a field in between 5 & 6, I think, in a db of several hundred entries. It works, once you figure out the rather obscure instructions... Make a backup of your file! Remember to make required changes in links.def, should be no problem.


Leonard
aka PerlFlunkie