Link to home
Start Free TrialLog in
Avatar of Dier02
Dier02Flag for Australia

asked on

Dreamweaver, Spry and an Access database

I want to add text and images to an acess 2010 database and have these linked to a spry accordian menu in Dreamweaver so that the accordian is dynamic.  How do I do this?
Avatar of Jason C. Levine
Jason C. Levine
Flag of United States of America image

Hi again Dier02,

Can you be more specific about how you expect the application to work?
Avatar of Dier02

ASKER

I want to be able to change what shows up in the Spry by linking each section of the accordion menu to a database item - the picture is linked to a picture item in an access database and the text can be changed in a table entry.  Does that sound right?
Do you have PHP, Perl, or Coldfusion?

You would write a loop to create the tabs for your menu from a DB query using a scripting language.

Another option could be to use XML files instead of an access database and to create the tabs / content using
spry data regions.

Avatar of Dier02

ASKER

The latter sounds good but how would I do that?
Here is a tutorial on XML:
http://www.w3schools.com/xml/default.asp

Its very similar to HTML with tags, but XML will not work at all unless ALL your tags match up.

Here is a link to Adobe's sample on XML & Spry Data Regions:
http://labs.adobe.com/technologies/spry/articles/data_set_overview/

Note: You can export from Excel to XML format & I am pretty sure you can save your data from Access directly into an XML file as well.  

Lemme know if you have any Q's.
ASKER CERTIFIED SOLUTION
Avatar of stu215
stu215
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial