troubleshooting Question

All rows of table appearing when creating recordset

Avatar of dloj
dlojFlag for United States of America asked on
Microsoft SQL ServerWeb DevelopmentAdobe Dreamweaver
5 Comments2 Solutions406 ViewsLast Modified:
I am creating recordsets for the site I am building and when I test the advanced recordset I get all the rows of the mstr_meeting table.  Please see below.

SELECT mstr_meeting.NAME, mstr_location.BLDG_TYPE, mstr_meeting.start_time, mstr_meeting.DURATION, mstr_meeting.DAY_OF_WEEK, mstr_meeting.MEETING_NOTES, mstr_location.BUILDING_NAME, mstr_location.STREET_ADDRESS, mstr_location.CITY, mstr_location.ZIP_CODE, mstr_location.MAP_URL
FROM mstr_meeting, mstr_location
WHERE mstr_location.CITY = 'burbank'

This type of recordset has been working fine for all the cities I have been creating.  I am fairly new to Dreamweaver and have wondered if I have run into a maximum number of recordsets I can build though only one recordset per page.
I am using MySQL Server 5.1 and Dreamweaver CS5.  on a Win 7 iis server.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros