Problem Displaying Data ... ?

  • Thread starter Thread starter Wayne
  • Start date Start date
W

Wayne

Applies to: Microsoft FrontPage 2003, SQL Server 2000 running on Windows
Server 2003

Hi everyone,
I'm having trouble displaying data from two tables simultaneously on the
same web page and I'm not sure why, if I use the Database Results Wizard in
FrontPage and configure it to display data from just one table, everything
works fine, but when I include two or more tables it displays in the browser
as a Parser Error when I try to view that web page.

Does anyone know what Parser Error means and why it would give this error
when pulling data from two tables or more within the same database?

The database is a simple 3-table music catalogue with relationships between
all three tables (Artist, Album and Tracks) and I have tried to display just
the Artist and Album data from those two tables. The SQL Statement I've
included in Custom Query (within Database Results) is "SELECT * FROM Artist,
Album" - and FrontPage verifies the statement as correct.

I'm almost pulling my hair out trying to solve this problem. Can anyone see
something obvious that maybe I have overlooked. Any help, advice or
suggestions would be greatly appreciated.

Many thanks in advance
Wayne
 
You need a Join
See http://home.att.net/~codelibrary/FrontPage/detail.htm

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Applies to: Microsoft FrontPage 2003, SQL Server 2000 running on Windows
| Server 2003
|
| Hi everyone,
| I'm having trouble displaying data from two tables simultaneously on the
| same web page and I'm not sure why, if I use the Database Results Wizard in
| FrontPage and configure it to display data from just one table, everything
| works fine, but when I include two or more tables it displays in the browser
| as a Parser Error when I try to view that web page.
|
| Does anyone know what Parser Error means and why it would give this error
| when pulling data from two tables or more within the same database?
|
| The database is a simple 3-table music catalogue with relationships between
| all three tables (Artist, Album and Tracks) and I have tried to display just
| the Artist and Album data from those two tables. The SQL Statement I've
| included in Custom Query (within Database Results) is "SELECT * FROM Artist,
| Album" - and FrontPage verifies the statement as correct.
|
| I'm almost pulling my hair out trying to solve this problem. Can anyone see
| something obvious that maybe I have overlooked. Any help, advice or
| suggestions would be greatly appreciated.
|
| Many thanks in advance
| Wayne
|
|
 
Back
Top