[ic] Field Value: Length Of Time

[Ryan Hertz]

At 03:01 PM 4/23/02 -0700, Jim Webster wrote:
>I'd like to create a script or something that automatically changes the
>value of a field after a certain period of time.
>
>Example
>
>Database:Table:Column:Member Value: Yes
>
>Then after 30 days... (script switches value)
>
>Database:Table:Column:Member Value: No
>
>I don't know much about UNIX or CronJobs, etc.  If this is something I can
>do in IC/MySQL, great!  If not, can someone please contact me in regards to
>possibly contracting this piece of work.
>
>I can provide more details about our hosting/technology.

Do you really want a field with Yes/No?  In order to change the value after 
30 days you'd have to have a column with the expiration or starting 
date.  Then at that point I'm sure you could come up with a query to find 
all the expired records?  If you can get that far you could easily build an 
IC page to remove those records, or do some other action to them.  At that 
point it would be easy to get cron to lynx request the page to make the 
magic happen every night.  Or you could write everything in Perl.  :-)

Oh, and I'm not sure if it is possible/a good idea to use spaces in your 
column names, either.