OK, more strangeness for my database.
I want to make the Modify function automagically update the Date field in the database whenever someone actually modifies their record.
I think the &get_date function can make that happen, but do I need to create a separate function inside the html.pl or db.cgi to make this work?
Additionally, I then want to use the date to do a structured search from a link.
So, for example, when a user clicks the link to display alumni who have recently signed up, I would like to return results sorted from most recent to least most recent, but only if they have been added in the past 30 days.
Would I be better off creating a separate perl program that would search against the alumni.db and return the data in a table for this?
I would like to keep it all in the same set of dbman programs if possible in order to pass the environment from dbman to the other routines.
Jamie
------------------
James A. (Jamie) Dennis
*Certified AIX Administrator
*Certified Solaris Administrator
*Member - SAGE, USENIX
I want to make the Modify function automagically update the Date field in the database whenever someone actually modifies their record.
I think the &get_date function can make that happen, but do I need to create a separate function inside the html.pl or db.cgi to make this work?
Additionally, I then want to use the date to do a structured search from a link.
So, for example, when a user clicks the link to display alumni who have recently signed up, I would like to return results sorted from most recent to least most recent, but only if they have been added in the past 30 days.
Would I be better off creating a separate perl program that would search against the alumni.db and return the data in a table for this?
I would like to keep it all in the same set of dbman programs if possible in order to pass the environment from dbman to the other routines.
Jamie
------------------
James A. (Jamie) Dennis
*Certified AIX Administrator
*Certified Solaris Administrator
*Member - SAGE, USENIX