Fixtures-list ?

Last post 08-09-2008, 12:58 PM by Phil Factor. 1 replies.
Sort Posts: Previous Next
  •  08-02-2008, 2:07 AM Post number 65921

    Fixtures-list ?

    I need to create a Fixtures-list for a club's web-site. I am the only person permitted to alter the list, but it must have these features:

    1. Text- and fill-colours of my choice for different records, so as to indicate the type of fixture.

    2. Date-sorting.

    3. Links to (a) email-addresses and (b) urls.

    4. Automatically hiding fixtures whose date is now in the past.

    Excel does 1 - 3, but not 4. Sites such as ListPhile do 2, 3(b) and 4, but not 1 or 3(a).

    Is there any way of achieving what I want, perhaps with SQL ?

    Operating-system: OS X 10.4.11
  •  08-09-2008, 12:58 PM Post number 67021 in reply to post number 65921

    Re: Fixtures-list ?

    You could certainly do it in SQLServer, but you'd need to get a separate front-end for it.  I suspect that you'd be much better off using Excel to do this. You can script Excel to do no. 4.

    When you've developed the system in Excel for a while, then you can get stuck into writing something slicker in SQL Server, but you would then have to develop a nice front-end for it in the website. That will take quite a bit of work. You could, of course, generate the Excel spreadsheet directly from SQL Server, but you'd have your own inputting of data to consider. For the sort of volumes of data you are thinking of, it isn't a big deal, you could use Access as a front-end, but it is something you need to consider.
View as RSS news feed in XML