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.