FP and Relational Databases

[TSEROOGY]

Would like to incorporate a relational database into my
web site.

The basic FrontPage features for incorporating an Access
database are pretty straightforward. However, I'd like to
use an existing database that employs several joins with
other databases.

I made one quick attempt at this, only to find that
there's more involved than expected.

As it appears I need to spend a little more time learning
about using databases in FP, does FP offer any "shortcut"
features for incorporating more developed databases? What
are the does and don'ts in building a relational database
that is web friendly?

Although I have little trouble in writing all the script
out, it sure would be nice to utlize an FP feature to
make the job less tedious and then modify where necessary.

Best regards,
TSEROOGY

 

[MD WebsUnlimited.com]

Hi,

I believe the term "databases" is being used loosely here in the context of
"joins". A join is the convergence of different tables rows based upon a
common field or fields values. There are two types of join inner joins and
outter joins. The join verb is used in SQL to tell the database, comprised
of tables, which tables to join.

The SQL statement used to join tables in the database would be used in FP to
produce the record set. There is nothing in FP to hinder this usage.

 

[TSEROOGY]

Thanks, Mike,
"Databases" wasn't used loosely, it was used incorrectly.
As you correctly point out, I should have stated "tables"
in referring to the joins.

As this is the first time I'm venturing off into FP using
a database with more than a simple or flat table, do you
have any words of warning on the construction of the
tables and the associated joins?

Again, thanks for the reply.

Best regards,
TSEROOGY