Re: Web pages from a database

Hi Hank

What the RFP specifies is static pages generated by a simple procedure from
the database, when it has been updated. Updates are not very frequent. The
site has to sit on the servers of a county council, and the museum service
doesn't have rights to change or access very much.

Equally, their IT department enforce that access shall be used - so one
wouldn't want to do anything that relied on their services if it could be
avoided.

Andrew Armstrong


----- Original Message -----
From: "Hank Marquardt" <hmarq(at)yerpso.net>
To: "Andrew Armstrong" <andrew(at)wisca.co.uk>
Cc: <hwg-techniques(at)hwg.org>
Sent: Thursday, January 24, 2002 2:54 PM
Subject: Re: Web pages from a database


> Hi Andrew, you really want something like PHP or ASP here -- you'd have
> *one* page that you'd pass something like a museumID ... that page would
> have database hooks in it to get that particular record and show the
> page.
>
> Access is definitely not what I'd use, but you said you have no choice
> in that matter -- no VB needed -- unless I've completely misread the
> request, you are posting on the Web, correct?
>
> On Thu, Jan 24, 2002 at 11:54:57AM -0000, Andrew Armstrong wrote:
> > I have been asked to tender for a job where some pages are to be
generated
> > from information held in an Access database. I don't have any choice
about
> > the database - it will simply hold information about museums - opening
> > times, address, contact details and so on.
> >
> > The plan is that every time that the database is updated, someone can
carry
> > out a siomple procedure to generate new copies of the information pages
for
> > the specific museums.
> >
> > Has anyone any ideas? I have limited database experience, and am just
> > starting to learn Visual Basic. My guess is that I need to make a
template,
> > then to write a Visual Basic program to query the database and place
> > information in the template at the appropriate point.  In order to do
this I
> > would clearly have to learn some more stuff, so if it isn't the best
> > approach I don't want to waste too much time.
> >
> > If I do need to learn more about databases and Visual Basic, I would
> > appreciate any pointers as to what to concentrate on first so I don't
spend
> > a long time floundering around.
> >
> > Andy
> >
> >
>
> --
> Hank Marquardt <hank(at)yerpso.net>
> http://web.yerpso.net
> GPG Id: 2BB5E60C
> Fingerprint: D807 61BC FD18 370A AC1D  3EDF 2BF9 8A2D 2BB5 E60C
> *** Web Development: PHP, MySQL/PgSQL - Network Admin: Debian/FreeBSD
> *** PHP Instructor - Intnl. Webmasters Assn./HTML Writers Guild
> *** Beginning PHP -- Starts January 7, 2002
> *** See http://www.hwg.org/services/classes
>
>

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA