Export XML from MySQL/MSSQL CS4

Report · Nov 10, 2008

Hi

Does Dreamweaver CS4 have a simple way to export database tables to XML? Would be nice to automate this to use with SPRY.

Thanks

Report · Nov 10, 2008

Not automatic, but here you go:

http://labs.adobe.com/technologies/spry/samples/utils/query2xml.html

--
Ken Ford
Fordwebs, LLC
Adobe Community Expert - Dreamweaver/ColdFusion
Adobe Certified Expert - Dreamweaver CS3
Adobe Certified Expert - ColdFusion 8
http://www.fordwebs.com
http://www.cfnoob.com

"NoNickNamesLeft" <webforumsuser@macromedia.com> wrote in message
news:gf9bbh$sca$1@forums.macromedia.com...
> Hi
>
> Does Dreamweaver CS4 have a simple way to export database tables to XML?
> Would be nice to automate this to use with SPRY.
>
> Thanks

Report · Nov 10, 2008

Ken:

Can't you then use the script as the datasource name, rather than writing
the XML file and using its filename? In otherwords, can't you just use this
as a dynamic datasource?

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================

"Ken Ford - *ACE*" <newsgroups2@fordwebs.com> wrote in message
news:gf9c9d$87$1@forums.macromedia.com...
> Not automatic, but here you go:
>
> http://labs.adobe.com/technologies/spry/samples/utils/query2xml.html
>
> --
> Ken Ford
> Fordwebs, LLC
> Adobe Community Expert - Dreamweaver/ColdFusion
> Adobe Certified Expert - Dreamweaver CS3
> Adobe Certified Expert - ColdFusion 8
> http://www.fordwebs.com
> http://www.cfnoob.com
>
>
> "NoNickNamesLeft" <webforumsuser@macromedia.com> wrote in message
> news:gf9bbh$sca$1@forums.macromedia.com...
>> Hi
>>
>> Does Dreamweaver CS4 have a simple way to export database tables to XML?
>> Would be nice to automate this to use with SPRY.
>>
>> Thanks
>

Report · Nov 10, 2008

Yes, the OP would just select the file as their data file, then it would be
automatic.

--
Ken Ford
Fordwebs, LLC
Adobe Community Expert - Dreamweaver/ColdFusion
Adobe Certified Expert - Dreamweaver CS3
Adobe Certified Expert - ColdFusion 8
http://www.fordwebs.com
http://www.cfnoob.com

"Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
news:gf9enk$3cp$1@forums.macromedia.com...
> Ken:
>
> Can't you then use the script as the datasource name, rather than writing
> the XML file and using its filename? In otherwords, can't you just use
> this as a dynamic datasource?
>
> --
> Murray --- ICQ 71997575
> Adobe Community Expert
> (If you *MUST* email me, don't LAUGH when you do so!)
> ==================
> http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
> http://www.dwfaq.com - DW FAQs, Tutorials & Resources
> ==================
>
>
> "Ken Ford - *ACE*" <newsgroups2@fordwebs.com> wrote in message
> news:gf9c9d$87$1@forums.macromedia.com...
>> Not automatic, but here you go:
>>
>> http://labs.adobe.com/technologies/spry/samples/utils/query2xml.html
>>
>> --
>> Ken Ford
>> Fordwebs, LLC
>> Adobe Community Expert - Dreamweaver/ColdFusion
>> Adobe Certified Expert - Dreamweaver CS3
>> Adobe Certified Expert - ColdFusion 8
>> http://www.fordwebs.com
>> http://www.cfnoob.com
>>
>>
>> "NoNickNamesLeft" <webforumsuser@macromedia.com> wrote in message
>> news:gf9bbh$sca$1@forums.macromedia.com...
>>> Hi
>>>
>>> Does Dreamweaver CS4 have a simple way to export database tables to XML?
>>> Would be nice to automate this to use with SPRY.
>>>
>>> Thanks
>>
>

Report · Nov 10, 2008

Are you referring to the script "file" (PHP) or the data "file" (XML)
though - that's my question.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================

"Ken Ford - *ACE*" <newsgroups2@fordwebs.com> wrote in message
news:gf9fk2$4gc$1@forums.macromedia.com...
> Yes, the OP would just select the file as their data file, then it would
> be automatic.
>
> --
> Ken Ford
> Fordwebs, LLC
> Adobe Community Expert - Dreamweaver/ColdFusion
> Adobe Certified Expert - Dreamweaver CS3
> Adobe Certified Expert - ColdFusion 8
> http://www.fordwebs.com
> http://www.cfnoob.com
>
>
> "Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
> news:gf9enk$3cp$1@forums.macromedia.com...
>> Ken:
>>
>> Can't you then use the script as the datasource name, rather than writing
>> the XML file and using its filename? In otherwords, can't you just use
>> this as a dynamic datasource?
>>
>> --
>> Murray --- ICQ 71997575
>> Adobe Community Expert
>> (If you *MUST* email me, don't LAUGH when you do so!)
>> ==================
>> http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
>> http://www.dwfaq.com - DW FAQs, Tutorials & Resources
>> ==================
>>
>>
>> "Ken Ford - *ACE*" <newsgroups2@fordwebs.com> wrote in message
>> news:gf9c9d$87$1@forums.macromedia.com...
>>> Not automatic, but here you go:
>>>
>>> http://labs.adobe.com/technologies/spry/samples/utils/query2xml.html
>>>
>>> --
>>> Ken Ford
>>> Fordwebs, LLC
>>> Adobe Community Expert - Dreamweaver/ColdFusion
>>> Adobe Certified Expert - Dreamweaver CS3
>>> Adobe Certified Expert - ColdFusion 8
>>> http://www.fordwebs.com
>>> http://www.cfnoob.com
>>>
>>>
>>> "NoNickNamesLeft" <webforumsuser@macromedia.com> wrote in message
>>> news:gf9bbh$sca$1@forums.macromedia.com...
>>>> Hi
>>>>
>>>> Does Dreamweaver CS4 have a simple way to export database tables to
>>>> XML? Would be nice to automate this to use with SPRY.
>>>>
>>>> Thanks
>>>
>>
>

Report · Nov 10, 2008

Murray *ACE* wrote:
> Are you referring to the script "file" (PHP) or the data "file" (XML)
> though - that's my question.

You can use the PHP file as the direct data source, as long as the PHP
file outputs XML headers.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

Report · Nov 10, 2008

Thanks - that's what I was asking. It looks like the PHP code in the link
given by Ken was doing that. Did you check it?

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
==================

"David Powers" <david@example.com> wrote in message
news:gfa0ts$qot$2@forums.macromedia.com...
> Murray *ACE* wrote:
>> Are you referring to the script "file" (PHP) or the data "file" (XML)
>> though - that's my question.
>
> You can use the PHP file as the direct data source, as long as the PHP
> file outputs XML headers.
>
> --
> David Powers, Adobe Community Expert
> Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
> Author, "PHP Solutions" (friends of ED)
> http://foundationphp.com/

Report · Nov 10, 2008

Murray,

Yes, if you use that code from the link I gave you can use that PHP file as
the datasource.

--
Ken Ford
Fordwebs, LLC
Adobe Community Expert - Dreamweaver/ColdFusion
Adobe Certified Expert - Dreamweaver CS3
Adobe Certified Expert - ColdFusion 8
http://www.fordwebs.com
http://www.cfnoob.com

"Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
news:gfa783$5q3$1@forums.macromedia.com...
> Thanks - that's what I was asking. It looks like the PHP code in the link
> given by Ken was doing that. Did you check it?
>
> --
> Murray --- ICQ 71997575
> Adobe Community Expert
> (If you *MUST* email me, don't LAUGH when you do so!)
> ==================
> http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
> http://www.dwfaq.com - DW FAQs, Tutorials & Resources
> ==================
>
>
> "David Powers" <david@example.com> wrote in message
> news:gfa0ts$qot$2@forums.macromedia.com...
>> Murray *ACE* wrote:
>>> Are you referring to the script "file" (PHP) or the data "file" (XML)
>>> though - that's my question.
>>
>> You can use the PHP file as the direct data source, as long as the PHP
>> file outputs XML headers.
>>
>> --
>> David Powers, Adobe Community Expert
>> Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
>> Author, "PHP Solutions" (friends of ED)
>> http://foundationphp.com/
>