I'm *really* new to ASP databases, with only one working page using it
to my credit. I'm trying to do a second page which has data passed to it
from my first page, and I'm  and having a heck of a time getting it to
work. I can't see a thing wrong with my code. Spelling is correct on all
variables, because I just double-checked that. The page is blowing up on
the Open statement. Here's a portion of my code. Can you help before I
go bald from tearing my hair out over this? Thanks!

<%
Dim varAlbumID
Dim oRStrks
varAlbumID = Request.QueryString("AlbumID")

Set oRStrks=Server.CreateObject("ADODB.recordset")

sqltext = "SELECT tblAlbums.AlbumID AS albumid,tblAlbums.Title AS
albumtitle,"
sqltext = sqltext & "tblAlbums.ArtistID AS
artistid,tblAlbums.Total_Playing_Time AS totaltime,"
sqltext = sqltext & "tblTracks.TrackID AS trackid,tblTracks.Title AS
tracktitle,"
sqltext = sqltext & "tblTracks.Duration AS tracktime,tblTracks.Composer
AS composer,"
sqltext = sqltext & "tblArtists.Artist AS artist,tblArtist.The FROM
tblTracks "
sqltext = sqltext & "INNER JOIN tblArtists ON tblAlbums.ArtistID 
tblArtists.ArtistID "
sqltext = sqltext & "INNER JOIN tblAlbums ON tblTracks.AlbumID 
tblAlbums.AlbumID "
sqltext = sqltext & "WHERE albumid=varAlbumID ORDER BY trackid;"
oRStrks.open sqltext, "DSN=CDTrust"


~8^) Pat Wong (ICQ #61070813)
http://www.napathon.com/
-------------------------------------------------------------------
"You can't talk to a man with a shotgun in his hand."
Smackwater Jack by Carole King
-------------------------------------------------------------------

hi pat,

not an exact solution but a trick that u must use very often

after u generate the Query in the sqlText variable use this line

response.write(sqltext)
cut and paste the query displayed in ur database and look for errors

also might help if u used the same technique to verify if the value is
passed properly from the previous page
response.write(AlbumID)


hth,
ajax

----- Original Message -----
From: "Pat Wong" <vinyl-junkie@n...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, August 29, 2002 8:16 AM
Subject: [asp_databases] Newbie Here - ASP Page Won't Display


> I'm *really* new to ASP databases, with only one working page using it
> to my credit. I'm trying to do a second page which has data passed to it
> from my first page, and I'm  and having a heck of a time getting it to
> work. I can't see a thing wrong with my code. Spelling is correct on all
> variables, because I just double-checked that. The page is blowing up on
> the Open statement. Here's a portion of my code. Can you help before I
> go bald from tearing my hair out over this? Thanks!
>
> <%
> Dim varAlbumID
> Dim oRStrks
> varAlbumID = Request.QueryString("AlbumID")
>
> Set oRStrks=Server.CreateObject("ADODB.recordset")
>
> sqltext = "SELECT tblAlbums.AlbumID AS albumid,tblAlbums.Title AS
> albumtitle,"
> sqltext = sqltext & "tblAlbums.ArtistID AS
> artistid,tblAlbums.Total_Playing_Time AS totaltime,"
> sqltext = sqltext & "tblTracks.TrackID AS trackid,tblTracks.Title AS
> tracktitle,"
> sqltext = sqltext & "tblTracks.Duration AS tracktime,tblTracks.Composer
> AS composer,"
> sqltext = sqltext & "tblArtists.Artist AS artist,tblArtist.The FROM
> tblTracks "
> sqltext = sqltext & "INNER JOIN tblArtists ON tblAlbums.ArtistID 
> tblArtists.ArtistID "
> sqltext = sqltext & "INNER JOIN tblAlbums ON tblTracks.AlbumID 
> tblAlbums.AlbumID "
> sqltext = sqltext & "WHERE albumid=varAlbumID ORDER BY trackid;"
> oRStrks.open sqltext, "DSN=CDTrust"
>
>
> ~8^) Pat Wong (ICQ #61070813)
> http://www.napathon.com/
> -------------------------------------------------------------------
> "You can't talk to a man with a shotgun in his hand."
> Smackwater Jack by Carole King
> -------------------------------------------------------------------
>
>
>

Good point. Actually, I had already done the things you suggested and
should have included that with my original post. The value that is
getting passed to this page is getting there and is correct. With regard
to the Select itself, here is the result of the Response.Write that I
put in the code (see below) to see what that looked like. I've indented
as appropriate to enhance the readability. Is there something that jumps
out at you from this? Sure doesn't for me. I should also mention that I
commented out all the code below the Open statement except the closing
%> and HTML tags and got the same result - no page display. Any and all
suggestions are welcome. Thanks!

SELECT tblAlbums.AlbumID AS albumid,
               tblAlbums.Title AS albumtitle,
               tblAlbums.ArtistID AS artistid,
               tblAlbums.Total_Playing_Time AS totaltime,
               tblTracks.TrackID AS trackid,
               tblTracks.Title AS tracktitle,
               tblTracks.Duration AS tracktime,
               tblTracks.Composer AS composer,
               tblArtists.Artist AS artist,
               tblArtist.The FROM tblTracks
    INNER JOIN tblArtists ON tblAlbums.ArtistID = tblArtists.ArtistID
    INNER JOIN tblAlbums ON tblTracks.AlbumID = tblAlbums.AlbumID
    WHERE albumid=varAlbumID ORDER BY trackid;


| hi pat,
|
| not an exact solution but a trick that u must use very often
|
| after u generate the Query in the sqlText variable use this line
|
| response.write(sqltext)
| cut and paste the query displayed in ur database and look for errors
|
| also might help if u used the same technique to verify if the value is
| passed properly from the previous page
| response.write(AlbumID)
|
|
| hth,
| ajax
|
| ----- Original Message -----
| From: "Pat Wong" <vinyl-junkie@n...>
| To: "ASP Databases" <asp_databases@p...>
| Sent: Thursday, August 29, 2002 8:16 AM
| Subject: [asp_databases] Newbie Here - ASP Page Won't Display
|
|
| > I'm *really* new to ASP databases, with only one working page using
it
| > to my credit. I'm trying to do a second page which has data passed
to it
| > from my first page, and I'm  and having a heck of a time getting it
to
| > work. I can't see a thing wrong with my code. Spelling is correct on
all
| > variables, because I just double-checked that. The page is blowing
up on
| > the Open statement. Here's a portion of my code. Can you help before
I
| > go bald from tearing my hair out over this? Thanks!
| >
| > <%
| > Dim varAlbumID
| > Dim oRStrks
| > varAlbumID = Request.QueryString("AlbumID")
| >
| > Set oRStrks=Server.CreateObject("ADODB.recordset")
| >
| > sqltext = "SELECT tblAlbums.AlbumID AS albumid,tblAlbums.Title AS
| > albumtitle,"
| > sqltext = sqltext & "tblAlbums.ArtistID AS
| > artistid,tblAlbums.Total_Playing_Time AS totaltime,"
| > sqltext = sqltext & "tblTracks.TrackID AS trackid,tblTracks.Title AS
| > tracktitle,"
| > sqltext = sqltext & "tblTracks.Duration AS
tracktime,tblTracks.Composer
| > AS composer,"
| > sqltext = sqltext & "tblArtists.Artist AS artist,tblArtist.The FROM
| > tblTracks "
| > sqltext = sqltext & "INNER JOIN tblArtists ON tblAlbums.ArtistID 
| > tblArtists.ArtistID "
| > sqltext = sqltext & "INNER JOIN tblAlbums ON tblTracks.AlbumID 
| > tblAlbums.AlbumID "
| > sqltext = sqltext & "WHERE albumid=varAlbumID ORDER BY trackid;"
| > oRStrks.open sqltext, "DSN=CDTrust"
| >
| >
| > ~8^) Pat Wong (ICQ #61070813)
| > http://www.napathon.com/
| > -------------------------------------------------------------------
| > "You can't talk to a man with a shotgun in his hand."
| > Smackwater Jack by Carole King
| > -------------------------------------------------------------------
| >
| >
| >
|
|
|

Try...but first what is varAlbumID ..a input by the user or a field in
one of the tables..unique fields do not need qualification..non-unique
do...this also assumes you have all 3 pieces to get data back (an Album,
a Track and an Artist)..is that true all the time??

SELECT tblAlbums.AlbumID AS albumid,
               tblAlbums.Title AS albumtitle,
               tblAlbums.ArtistID AS artistid,
               tblAlbums.Total_Playing_Time AS totaltime,
               tblTracks.TrackID AS trackid,
               tblTracks.Title AS tracktitle,
               tblTracks.Duration AS tracktime,
               tblTracks.Composer AS composer,
               tblArtists.Artist AS artist,
               tblArtist.The
FROM tblTracks
WHERE tblAlbums.ArtistID =3D tblArtists.ArtistID
AND tblTracks.AlbumID =3D tblAlbums.AlbumID
AND tblAlbums.AlbumID =3D varAlbumID
ORDER BY trackid;


-----Original Message-----
From: Pat Wong [mailto:vinyl-junkie@n...]
Sent: Thursday, August 29, 2002 8:24 AM
To: ASP Databases
Subject: [asp_databases] Re: Newbie Here - ASP Page Won't Display


Good point. Actually, I had already done the things you suggested and
should have included that with my original post. The value that is
getting passed to this page is getting there and is correct. With regard
to the Select itself, here is the result of the Response.Write that I
put in the code (see below) to see what that looked like. I've indented
as appropriate to enhance the readability. Is there something that jumps
out at you from this? Sure doesn't for me. I should also mention that I
commented out all the code below the Open statement except the closing
%> and HTML tags and got the same result - no page display. Any and all
suggestions are welcome. Thanks!

SELECT tblAlbums.AlbumID AS albumid,
               tblAlbums.Title AS albumtitle,
               tblAlbums.ArtistID AS artistid,
               tblAlbums.Total_Playing_Time AS totaltime,
               tblTracks.TrackID AS trackid,
               tblTracks.Title AS tracktitle,
               tblTracks.Duration AS tracktime,
               tblTracks.Composer AS composer,
               tblArtists.Artist AS artist,
               tblArtist.The FROM tblTracks
    INNER JOIN tblArtists ON tblAlbums.ArtistID =3D tblArtists.ArtistID
    INNER JOIN tblAlbums ON tblTracks.AlbumID =3D tblAlbums.AlbumID
    WHERE albumid=3DvarAlbumID ORDER BY trackid;


| hi pat,
|
| not an exact solution but a trick that u must use very often
|
| after u generate the Query in the sqlText variable use this line
|
| response.write(sqltext)
| cut and paste the query displayed in ur database and look for errors
|
| also might help if u used the same technique to verify if the value is

| passed properly from the previous page
| response.write(AlbumID)
|
|
| hth,
| ajax
|
| ----- Original Message -----
| From: "Pat Wong" <vinyl-junkie@n...>
| To: "ASP Databases" <asp_databases@p...>
| Sent: Thursday, August 29, 2002 8:16 AM
| Subject: [asp_databases] Newbie Here - ASP Page Won't Display
|
|
| > I'm *really* new to ASP databases, with only one working page using
it
| > to my credit. I'm trying to do a second page which has data passed
to it
| > from my first page, and I'm  and having a heck of a time getting it
to
| > work. I can't see a thing wrong with my code. Spelling is correct on
all
| > variables, because I just double-checked that. The page is blowing
up on
| > the Open statement. Here's a portion of my code. Can you help before
I
| > go bald from tearing my hair out over this? Thanks!
| >
| > <%
| > Dim varAlbumID
| > Dim oRStrks
| > varAlbumID =3D Request.QueryString("AlbumID")
| >
| > Set oRStrks=3DServer.CreateObject("ADODB.recordset")
| >
| > sqltext =3D "SELECT tblAlbums.AlbumID AS albumid,tblAlbums.Title AS
| > albumtitle," sqltext =3D sqltext & "tblAlbums.ArtistID AS
| > artistid,tblAlbums.Total_Playing_Time AS totaltime,"
| > sqltext =3D sqltext & "tblTracks.TrackID AS trackid,tblTracks.Title 
AS
| > tracktitle,"
| > sqltext =3D sqltext & "tblTracks.Duration AS
tracktime,tblTracks.Composer
| > AS composer,"
| > sqltext =3D sqltext & "tblArtists.Artist AS artist,tblArtist.The 
FROM
| > tblTracks " sqltext =3D sqltext & "INNER JOIN tblArtists ON
| > tblAlbums.ArtistID =3D tblArtists.ArtistID "
| > sqltext =3D sqltext & "INNER JOIN tblAlbums ON tblTracks.AlbumID =3D
| > tblAlbums.AlbumID "
| > sqltext =3D sqltext & "WHERE albumid=3DvarAlbumID ORDER BY trackid;"
| > oRStrks.open sqltext, "DSN=3DCDTrust"
| >
| >
| > ~8^) Pat Wong (ICQ #61070813)
| > http://www.napathon.com/
| > -------------------------------------------------------------------
| > "You can't talk to a man with a shotgun in his hand." Smackwater
| > Jack by Carole King
| > -------------------------------------------------------------------
| >
| >
| > ---
| > Change your mail options at http://p2p.wrox.com/manager.asp or to
| > unsubscribe send a blank email to
| >
|
|
| ---
| Change your mail options at http://p2p.wrox.com/manager.asp or to
| unsubscribe send a blank email to
|

Ron, your post forced me to do something I should have done to begin
with - make a list of tables and fields within the tables to make sure I
caught them all. I did that at first to help provide a little more
information about the Access data structure to post here, then
discovered some fields were missing from my Select statement! I fixed
that, but the code still blows up on the open statement. Anyway, I hope
this will help explain a bit more. I'm going crazy with this!

Here are the tables and fields used from each:

Table Name - tblAlbums
Fields are:
    AlbumID - unique to this table
    Artist ID - unique to this table
    Title
    Total_Playing_Time

Table Name - tblArtists
Fields are:
    ArtistID - unique to this table
    Artist
    The

Table Name - tblTracks
Fields are:
    AlbumID - unique to this table
    TrackID
    Title
    Duration
    Composer


Here's the code as it sits now:

sqltext = "SELECT tblAlbums.AlbumID,"
sqltext = sqltext & "tblAlbums.ArtistID,"
sqltext = sqltext & "tblAlbums.Title AS albumtitle,"
sqltext = sqltext & "tblAlbums.Total_Playing_Time AS albumtime,"

sqltext = sqltext & "tblArtists.ArtistID,"
sqltext = sqltext & "tblArtists.Artist AS artist,"
sqltext = sqltext & "tblArtists.The AS artist_the,"

sqltext = sqltext & "tblTracks.AlbumID,"
sqltext = sqltext & "tblTracks.TrackID AS trackid,"
sqltext = sqltext & "tblTracks.Title AS tracktitle,"
sqltext = sqltext & "tblTracks.Duration AS tracktime,"
sqltext = sqltext & "tblTracks.Composer AS composer FROM tblTracks "

sqltext = sqltext & "INNER JOIN tblAlbums ON tblAlbums.AlbumID 
tblTracks.AlbumID "
sqltext = sqltext & "INNER JOIN tblArtists ON tblAlbums.ArtistID 
tblTracks.ArtistID "
sqltext = sqltext & "WHERE tblTracks.AlbumID = " & varAlbumID & " ORDER
BY trackid;"

oRStrks.open sqltext, "DSN=CDTrust"


And last but not least, here's the way the Select statement displays
when I put a Response.Write before the Open statement:

SELECT tblAlbums.AlbumID,tblAlbums.ArtistID,tblAlbums.Title AS
albumtitle,tblAlbums.Total_Playing_Time AS
albumtime,tblArtists.ArtistID,tblArtists.Artist AS artist,tblArtists.The
AS artist_the,tblTracks.AlbumID,tblTracks.TrackID AS
trackid,tblTracks.Title AS tracktitle,tblTracks.Duration AS
tracktime,tblTracks.Composer AS composer FROM tblTracks INNER JOIN
tblAlbums ON tblAlbums.AlbumID = tblTracks.AlbumID INNER JOIN tblArtists
ON tblAlbums.ArtistID = tblTracks.ArtistID WHERE tblTracks.AlbumID 
1078 ORDER BY trackid;


As before, any and all suggestions are welcome. Thanks!

----- Original Message -----
From: "Drew, Ron" <RDrew@B...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, August 29, 2002 7:50 AM
Subject: [asp_databases] Re: Newbie Here - ASP Page Won't Display


Try...but first what is varAlbumID ..a input by the user or a field in
one of the tables..unique fields do not need qualification..non-unique
do...this also assumes you have all 3 pieces to get data back (an Album,
a Track and an Artist)..is that true all the time??

(snip)

|
| > I'm *really* new to ASP databases, with only one working page using
it
| > to my credit. I'm trying to do a second page which has data passed
to it
| > from my first page, and I'm  and having a heck of a time getting it
to
| > work. I can't see a thing wrong with my code. Spelling is correct on
all
| > variables, because I just double-checked that. The page is blowing
up on
| > the Open statement.

~8^) Pat Wong (ICQ #61070813)
http://www.napathon.com/
-------------------------------------------------------------------
"You can't talk to a man with a shotgun in his hand."
Smackwater Jack by Carole King
-------------------------------------------------------------------

hey PAT,

I believe ur using Access. Cut and paste this queryin the db query window
and verify output

if it works then change ur code:

SELECT
tblAlbums.AlbumID,tblAlbums.ArtistID,tblAlbums.Title AS
albumtitle,tblAlbums.Total_Playing_Time AS
albumtime,tblArtists.ArtistID,tblArtists.Artist AS artist,tblArtists.The
AS artist_the,tblTracks.AlbumID,tblTracks.TrackID AS
trackid,tblTracks.Title AS tracktitle,tblTracks.Duration AS
tracktime,tblTracks.Composer AS composer
FROM tblArtists INNER JOIN
(tblAlbums INNER JOIN tblTracks ON tblAlbums.AlbumID = tblTracks.AlbumID)
ON
tblArtists.ArtistID = tblTracks.ArtistID
where tblTracks.AlbumID = 1078
ORDER BY tblTracks.TrackID

whats diff : the line containing the "FROM" Clause onwards have been
slightly changed

tell me the outcome
ajax®

----- Original Message -----
From: "Pat Wong" <vinyl-junkie@n...>
To: "ASP Databases" <asp_databases@p...>
Sent: Friday, August 30, 2002 8:11 AM
Subject: [asp_databases] Re: Newbie Here - ASP Page Won't Display


> Ron, your post forced me to do something I should have done to begin
> with - make a list of tables and fields within the tables to make sure I
> caught them all. I did that at first to help provide a little more
> information about the Access data structure to post here, then
> discovered some fields were missing from my Select statement! I fixed
> that, but the code still blows up on the open statement. Anyway, I hope
> this will help explain a bit more. I'm going crazy with this!
>
> Here are the tables and fields used from each:
>
> Table Name - tblAlbums
> Fields are:
>     AlbumID - unique to this table
>     Artist ID - unique to this table
>     Title
>     Total_Playing_Time
>
> Table Name - tblArtists
> Fields are:
>     ArtistID - unique to this table
>     Artist
>     The
>
> Table Name - tblTracks
> Fields are:
>     AlbumID - unique to this table
>     TrackID
>     Title
>     Duration
>     Composer
>
>
> Here's the code as it sits now:
>
> sqltext = "SELECT tblAlbums.AlbumID,"
> sqltext = sqltext & "tblAlbums.ArtistID,"
> sqltext = sqltext & "tblAlbums.Title AS albumtitle,"
> sqltext = sqltext & "tblAlbums.Total_Playing_Time AS albumtime,"
>
> sqltext = sqltext & "tblArtists.ArtistID,"
> sqltext = sqltext & "tblArtists.Artist AS artist,"
> sqltext = sqltext & "tblArtists.The AS artist_the,"
>
> sqltext = sqltext & "tblTracks.AlbumID,"
> sqltext = sqltext & "tblTracks.TrackID AS trackid,"
> sqltext = sqltext & "tblTracks.Title AS tracktitle,"
> sqltext = sqltext & "tblTracks.Duration AS tracktime,"
> sqltext = sqltext & "tblTracks.Composer AS composer FROM tblTracks "
>
> sqltext = sqltext & "INNER JOIN tblAlbums ON tblAlbums.AlbumID 
> tblTracks.AlbumID "
> sqltext = sqltext & "INNER JOIN tblArtists ON tblAlbums.ArtistID 
> tblTracks.ArtistID "
> sqltext = sqltext & "WHERE tblTracks.AlbumID = " & varAlbumID & " ORDER
> BY trackid;"
>
> oRStrks.open sqltext, "DSN=CDTrust"
>
>
> And last but not least, here's the way the Select statement displays
> when I put a Response.Write before the Open statement:
>
> SELECT tblAlbums.AlbumID,tblAlbums.ArtistID,tblAlbums.Title AS
> albumtitle,tblAlbums.Total_Playing_Time AS
> albumtime,tblArtists.ArtistID,tblArtists.Artist AS artist,tblArtists.The
> AS artist_the,tblTracks.AlbumID,tblTracks.TrackID AS
> trackid,tblTracks.Title AS tracktitle,tblTracks.Duration AS
> tracktime,tblTracks.Composer AS composer FROM tblTracks INNER JOIN
> tblAlbums ON tblAlbums.AlbumID = tblTracks.AlbumID INNER JOIN tblArtists
> ON tblAlbums.ArtistID = tblTracks.ArtistID WHERE tblTracks.AlbumID 
> 1078 ORDER BY trackid;
>
>
> As before, any and all suggestions are welcome. Thanks!
>
> ----- Original Message -----
> From: "Drew, Ron" <RDrew@B...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Thursday, August 29, 2002 7:50 AM
> Subject: [asp_databases] Re: Newbie Here - ASP Page Won't Display
>
>
> Try...but first what is varAlbumID ..a input by the user or a field in
> one of the tables..unique fields do not need qualification..non-unique
> do...this also assumes you have all 3 pieces to get data back (an Album,
> a Track and an Artist)..is that true all the time??
>
> (snip)
>
> |
> | > I'm *really* new to ASP databases, with only one working page using
> it
> | > to my credit. I'm trying to do a second page which has data passed
> to it
> | > from my first page, and I'm  and having a heck of a time getting it
> to
> | > work. I can't see a thing wrong with my code. Spelling is correct on
> all
> | > variables, because I just double-checked that. The page is blowing
> up on
> | > the Open statement.
>
> ~8^) Pat Wong (ICQ #61070813)
> http://www.napathon.com/
> -------------------------------------------------------------------
> "You can't talk to a man with a shotgun in his hand."
> Smackwater Jack by Carole King
> -------------------------------------------------------------------
>
>
>

Your code was close. I finally got my page to work (!) with the
following as far as the Join goes:

sqltext = sqltext & "FROM (tblArtists INNER JOIN tblAlbums ON
tblArtists.ArtistID = "
sqltext = sqltext & "tblAlbums.ArtistID) LEFT JOIN tblTracks ON
tblAlbums.AlbumID = "
sqltext = sqltext & "tblTracks.AlbumID "
sqltext = sqltext & "WHERE tblTracks.AlbumID =" & varAlbumID & " ORDER
BY trackid;"

I should explain something. The database I'm using was created by some
purchased software, which uses Access as the back end to it. I didn't
realize it, but there was a query already built within that back end
database that I could draw upon to do my SQL for my ASP page. I'm still
too new to this stuff to really understand exactly why this code works.
Gotta study it some.

Anyway, many thanks to everyone for your help! It is *very* much
appreciated. I have some other stuff I want to do with my ASP pages that
I'm sure I'll need some help with after I've worked with it a bit. This
group sure is a nice resource to draw on. Thanks again!

p.s. - In case anyone's interested, the first ASP-database page I
created is here:
http://www.napathon.com/Blues.asp

The linked pages on each of the table lines were what I was having such
heartburn over.


| hey PAT,
|
| I believe ur using Access. Cut and paste this queryin the db query
window
| and verify output
|
| if it works then change ur code:
|
| SELECT
| tblAlbums.AlbumID,tblAlbums.ArtistID,tblAlbums.Title AS
| albumtitle,tblAlbums.Total_Playing_Time AS
| albumtime,tblArtists.ArtistID,tblArtists.Artist AS
artist,tblArtists.The
| AS artist_the,tblTracks.AlbumID,tblTracks.TrackID AS
| trackid,tblTracks.Title AS tracktitle,tblTracks.Duration AS
| tracktime,tblTracks.Composer AS composer
| FROM tblArtists INNER JOIN
| (tblAlbums INNER JOIN tblTracks ON tblAlbums.AlbumID 
tblTracks.AlbumID)
| ON
| tblArtists.ArtistID = tblTracks.ArtistID
| where tblTracks.AlbumID = 1078
| ORDER BY tblTracks.TrackID
|
| whats diff : the line containing the "FROM" Clause onwards have been
| slightly changed
|
| tell me the outcome
| ajax®

(snip)

| > Here are the tables and fields used from each:
| >
| > Table Name - tblAlbums
| > Fields are:
| >     AlbumID - unique to this table
| >     Artist ID - unique to this table
| >     Title
| >     Total_Playing_Time
| >
| > Table Name - tblArtists
| > Fields are:
| >     ArtistID - unique to this table
| >     Artist
| >     The
| >
| > Table Name - tblTracks
| > Fields are:
| >     AlbumID - unique to this table
| >     TrackID
| >     Title
| >     Duration
| >     Composer

~8^) Pat Wong (ICQ #61070813)
http://www.napathon.com/
-------------------------------------------------------------------
"You can't talk to a man with a shotgun in his hand."
Smackwater Jack by Carole King
-------------------------------------------------------------------