Dier02
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?
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.
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.
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Can you be more specific about how you expect the application to work?