sql type not recognized: "

[d_arc9]

HI... I am new to database applications but am learning really fast. I am using
the master/detail option in dreamwMX04. When I create my recordset I use the
advanced option and type this in - when hit the test button it works fine.
**NOTE** I am performing a join associating the writers with the stories they
wrote //code SELECT content.id, content.header, content.teaser, content.body,
writers.f_name, writers.l_name, writers.email FROM content, writers WHERE
content.writers_id=writers.writers_id When the recordset is created I hit the
master/detail option and no matter what options I choose I get - sql type not
recognized:' - then I hit ok. It then creates the pages (aster and detail)...
it all seems to work fine but the authors of the articels are not matching the
stories they've written. Any help is greatly appreciated. THX DR

[BillB]

I find SQL debugging to the single biggest pain in the a** going. I just the
other day bought Interakt's Query Builder (QuB) extension and it takes all
the head aches out SQL construction. Try the Free Demo. The full extension
is a $100 but well worth every penny.
[url]http://www.interaktonline.com/Products/Dreamweaver-Extensions/QuB/Overview/[/url]


--
Bill
Real Estate Web Sites Made Easy
[url]www.DataPacks.com[/url]


"d_arc9" <webforumsuser@macromedia.com> wrote in message
news:d1t80f$gpu$1@forums.macromedia.com...

> HI... I am new to database applications but am learning really fast. I am
> using
> the master/detail option in dreamwMX04. When I create my recordset I use
> the
> advanced option and type this in - when hit the test button it works fine.
> **NOTE** I am performing a join associating the writers with the stories
> they
> wrote //code SELECT content.id, content.header, content.teaser,
> content.body,
> writers.f_name, writers.l_name, writers.email FROM content, writers WHERE
> content.writers_id=writers.writers_id When the recordset is created I hit
> the
> master/detail option and no matter what options I choose I get - sql type
> not
> recognized:' - then I hit ok. It then creates the pages (aster and
> detail)...
> it all seems to work fine but the authors of the articels are not matching
> the
> stories they've written. Any help is greatly appreciated. THX DR
>

[d_arc9]

?