Building a Newsroom Intranet

Web-to-database software
Some acronyms to know
  • CGI--Common Gateway Interface
    Requires you to write a CGI script or get a database application like: FoxWeb; Cold Fusion; Internet Database Connectivity (IDC); Iq/Liveweb

  • ODBC--Open DataBase Connectivity
    Microsoft's utility for linking different brands of databases (Oracle, Sybase, etc.)

  • SQL--Structured Query Language
    Sample SQL Statement
    SELECT DISTINCTROW Test.Name, Test.Address, Test.City, Test.State, Test.Telephone
    FROM Test
    WHERE (Test.Name Like [Enter Name] & "*")
    ORDER BY Test.Name;

  • Slide 6a3