SQL Query?

[LiquidD333]

I am creating a dynamic site that pulls records from an Access database. These
records are downloaded from an ftp site and I use a VB programs to extract and
insert the records. I can call just about every record detail possible but one
and it has completely stopped me. Hopefully I dont lose anyone.
Database *Purchase* has a bunch of tables in it and 1 query. One of the tables
is called "Feature" and another one is called "For Sale".

Table "Feature" has 2 columns - Feature and Value.
"Feature" = 1-20 and "FValue"= Battery, Elect, Solar, etc
This is a reference table.
In DWMX, I can create a recordset that shows this:

SELECT Fvalue
FROM Feature
WHERE Code = MMColParam (MMColParam = Request.QueryString("Fvalue")
If I enter a default value of 1 it will show me "battery" and so on if I
change the value- Easy enough there

Now this is the part I can't figure out.

Table "For Sale" has many columns one of which says "ftrPower" and in that
column has values such as 1, 13, 52 that correspond to the FValue in table
"Feature". Sometimes it is even separated by commas if there are many features.

What I' m trying to accomplish is this:
ftrPower = Fvalue so it will look like this "Powered By: BATTERY" instead of
"Powered By: 13"

How can I change in DWMX to show my customers "fValue" values instead of it
showing the 1, 13, 52? I know this can be done, because I have seen it in the
past, I'm just stumped by this.

Thanks alot

[Lionstone]

You'd join the tables, except that your decision to use a list instead of
properly modeling the relationship with a third table will make your join
impossible. If one "for sale" can be powered by many types of power, and a
single type of power is used for many different "for sale"s, then you have a
many to many relationship. The third table is nothing more than two
columns - "for sale" ID and the ID of the power source.

If you are going to use a list anyway, store the descriptions, not the IDs.


"LiquidD333" <webforumsuser@macromedia.com> wrote in message
news:d6nfvd$2b6$1@forums.macromedia.com...

>I am creating a dynamic site that pulls records from an Access database.
>These
> records are downloaded from an ftp site and I use a VB programs to extract
> and
> insert the records. I can call just about every record detail possible
> but one
> and it has completely stopped me. Hopefully I dont lose anyone.
> Database *Purchase* has a bunch of tables in it and 1 query. One of the
> tables
> is called "Feature" and another one is called "For Sale".
>
> Table "Feature" has 2 columns - Feature and Value.
> "Feature" = 1-20 and "FValue"= Battery, Elect, Solar, etc
> This is a reference table.
> In DWMX, I can create a recordset that shows this:
>
> SELECT Fvalue
> FROM Feature
> WHERE Code = MMColParam (MMColParam = Request.QueryString("Fvalue")
> If I enter a default value of 1 it will show me "battery" and so on if I
> change the value- Easy enough there
>
> Now this is the part I can't figure out.
>
> Table "For Sale" has many columns one of which says "ftrPower" and in that
> column has values such as 1, 13, 52 that correspond to the FValue in table
> "Feature". Sometimes it is even separated by commas if there are many
> features.
>
> What I' m trying to accomplish is this:
> ftrPower = Fvalue so it will look like this "Powered By: BATTERY" instead
> of
> "Powered By: 13"
>
> How can I change in DWMX to show my customers "fValue" values instead of
> it
> showing the 1, 13, 52? I know this can be done, because I have seen it in
> the
> past, I'm just stumped by this.
>
> Thanks alot
>