RE: Web pages from a database

by "Brett Errington" <brett(at)opensearch.com>

 Date:  Fri, 25 Jan 2002 09:20:30 +0800
 To:  <hwg-techniques(at)hwg.org>
 In-Reply-To:  binbosexc001
  todo: View Thread, Original
Being as your site is hosted on asp server which should mean that it's
Microsoft's IIS right? Well anyway how bout u just use IIS's indexing
system (for the life of me I can't remember the actual name at the
moment). Basically it keeps a searchable index on all text in the
directory or directories that you specify. You don't even need a
database to do this. It's up to you I guess.

Later,
Brett

"That's a pain that will shorely linger, and that's no lie" - Ed Grimley

-----Original Message-----
From: owner-hwg-techniques(at)hwg.org [mailto:owner-hwg-techniques(at)hwg.org]
On Behalf Of Barlow, Maureen (REI)
Sent: Friday, 25 January 2002 12:17 AM
To: 'hwg-techniques(at)hwg.org'
Subject: RE: Web pages from a database

Here I go again with a related question!  Similar to Andrew, I am a
beginner
when it comes to databases.  One of my projects is to build a knowledge
base
on our company intranet, for documents relating to a global company-wide
project.  I am beginner-to-intermediate with ASP, but I do not know VB
at
all (save for some VBScript, which I know is related, but different).

I was thinking I could use ASP and XML (also a beginner at this) to
create
the searchable knowledge base.  Hank, you mention below that Access is
not
what you'd use.  I don't know what I'd use, so what is your suggestion?
I
was initially thinking of Excel as a database of the documents.

Any thoughts would be appreciated.

TIA,

Maureen


-----Original Message-----
From: Hank Marquardt [mailto:hmarq(at)yerpso.net] 
Sent: Thursday, January 24, 2002 9:54 AM
To: Andrew Armstrong
Cc: hwg-techniques(at)hwg.org
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

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