Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
0

Access MDB database directly from Spry?

New Here ,
Jan 20, 2009 Jan 20, 2009

Copy link to clipboard

Copied

Hi,
I'm new using Dreamwaver, and I saw the tutorials about the Spry flexibility displaying data from XML or HTML.
The question is, what I need to do use Spry with MDB files? (Using ASP and a MS Access file).

I have seen some samples with ColdFusion converting the data "on the fly" to XML... if that the case... what about the definition of your files on design time... I mean, you don't have the XML definition to start using the Spry Insert Table....

Any tips & tricks are welcome!

Thanks in advance.
BFMG
TOPICS
Server side applications

Views

378
Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jan 21, 2009 Jan 21, 2009

Copy link to clipboard

Copied

LATEST
BFMG wrote:
> I have seen some samples with ColdFusion converting the data "on the fly" to
> XML... if that the case... what about the definition of your files on design
> time... I mean, you don't have the XML definition to start using the Spry
> Insert Table....

To generate an XML file from a database, you'd use the server language to create the XML from your data. Here is a page that lists out how to do this for ColdFusion, PHP, and ASP VBScript:
http://labs.adobe.com/technologies/spry/samples/utils/query2xml.html

What you do is create an XML file, and then create a Spry dataset from that XML file. In CS4 you can use the Spry dataset wizard. The wizard also offers several layout options, but you're not limited to what it generates, but it does make for a decent starting point. In the end, the designing is done in the page that pulls in the XML file.

You can also create a dataset yourself. If you download the Spry package there is a DataSet Explorer that you can use to test and play around with your locally generated XML files (either .xml or .asp files that output XML). Within the ZIP, it's at samples/data_region/DataSetExplorer.html

Here's the online version:
http://labs.adobe.com/technologies/spry/samples/data_region/DataSetExplorer.html
Note: You cannot use the online version to access local files, and your local copy can only access XML files on the same server. So if you're working from localhost, then any remote XML files cannot be accessed by the DataSet Explorer. This is a limitation of Ajax, not in Spry (although Spry inherits this limitation)

Also, posting Spry questions in the Spry forum will probably get you better end results:
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid=72&catid=602



--
Danilo Celic
| http://blog.extensioneering.com/
| WebAssist Extensioneer
| Adobe Community Expert

Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines