Re: Database question

You can also manipulate Access databases utilizing a DSN on the server, IDC
and HTX files. Your idc files contain the SQL and the results are returned
via an HTX file which is nothing more than HTML with the field names
embedded in the page. The page is generated dynamically when the query
results are returned. Of course this requires IIS to be running on the
server.

Jim Springer


----- Original Message -----
From: Jeff Bonner <cyberhq(at)idt.net>
To: Michael Heliker <mheliker(at)ncrel.org>; <hwg-techniques(at)hwg.org>
Sent: Friday, January 14, 2000 10:17 AM
Subject: Re: Database question


> If you have Cold Fusion on your server, it can manipulate Access databases
> directly, from what I understand.  It's also pretty flexible and lets you
do a
> lot of neat tricks.
>
> You just embed these 'Cold Fusion Markup Language (CFML)' tags in your
existing
> HTML, and the server parses them and can even regenerate the HTML to
include
> your database results.  (This is a fairly simplified description. <G>)
The only
> other way I know of to use Access databases is with ASP.
>
> Any other solution would be, IMHO, pretty complex and ugly.  For example,
to use
> just a simple flatfile database, you'd need God knows what kind of CGI,
which I
> am in no mood to program.  <G>  I found very few turnkey solutions too,
for both
> NT and Unix servers.
>
> I'm working on an Access/Cold Fusion database right now.  You might also
check
> this mailing list's archives for responses to my previous question as well
> (topic:  "Web Database How-To?").
>
> Good luck!
>
> Michael Heliker wrote:
>
> > Hello,
> >
> > I am 'unlearned' in the ways of database. I have been given the task of
> > creating a database of participants for an upcoming institute that we
are
> > facilitating. I am the Web developer/designer for the institute.
> >
> > The idea is to have the participants register in a form and when that is
> > submitted...to have that data be entered into a database. This file
would
> > then potentially be published on the Web site as well. The last
institute we
> > facilitated, this same list was in HTML...pain in the butt...
> >
> > Now, I can do this in Filemaker Pro or Access. These are the two options
> > right now that can work and fit within our timeframe. I was hoping that
one
> > of you wonderful people could give me a little insight as to which
method
> > would be better suited to my needs.
> >
> > I don't know the pros and cons of these two apps very well.
> >
> > Thanks in advance,
> >
> > michael "inconceivable" heliker

HWG hwg-techniques mailing list archives, maintained by Web Professional Association - IWA