XML Web service....I think

[UKdougs]

Hi All

Just looking for a bit of a pointer. I have a website hosted on a Windows
Server. The website has been created in ASP and pulls its content from SQL
server. I have had a number of requests for me to make some content (a
listing of my latest products) available in other sites. When I update my
SQL server I would like this to automatically update all the linked sites.
How would I do this and does any one know of any tutorials that will help me
to achieve this. I can't use .net because of server restrictions. I have
never used XML and know very little about it but I think this is what I will
have to use but I may be wrong.

Any help would be appreciated.

Cheers...Doug

[Alexandru COSTIN]

Hi Doug,
A very nice approach would be to use RSS feeds to export and import
your updated information on all sites. RSS is an XML format - and has a
stardard structure -
[url]http://www.google.com/search?sourceid=navclient&ie=UTF-8&rls=GGLD,GGLD:2005-08,GGLD:en&q=what+is+rss%3F[/url]

We are providing an extension that makes exporting and importing RSS
feeds extremely easy from Dreamweaver (ASP VBScript support)

[url]http://www.interaktonline.com/go/MXRSSReader-Writer/[/url]

Alexandru

UKdougs wrote:

> Hi All
>
> Just looking for a bit of a pointer. I have a website hosted on a Windows
> Server. The website has been created in ASP and pulls its content from SQL
> server. I have had a number of requests for me to make some content (a
> listing of my latest products) available in other sites. When I update my
> SQL server I would like this to automatically update all the linked sites.
> How would I do this and does any one know of any tutorials that will help me
> to achieve this. I can't use .net because of server restrictions. I have
> never used XML and know very little about it but I think this is what I will
> have to use but I may be wrong.
>
> Any help would be appreciated.
>
> Cheers...Doug
>
>

--
InterAKT Online - Dreamweaver extensions
[url]http://www.interaktonline.com/[/url]

[UKdougs]

Hi Alexandru

Thank you for your response. I currently have a include file in my site
which contains a recordset that lists the products. How easy would it be to
make this available on other sites using your extension. Also, for the
sites wanting to include the information from my SQL server, what are the
requirements. Do they need to be hosted on a particular type of server, do
the pages have to be ASP or can they be plain HTML.

I have never worked with XML or Rss so I would appreciate your feedback.

Cheers.....Doug

"Alexandru COSTIN" <acostinREMOVE@interaktonline.com> wrote in message
news:422EC437.5060403@interaktonline.com...

> Hi Doug,
> A very nice approach would be to use RSS feeds to export and import your
> updated information on all sites. RSS is an XML format - and has a
> stardard structure -
> [url]http://www.google.com/search?sourceid=navclient&ie=UTF-8&rls=GGLD,GGLD:2005-08,GGLD:en&q=what+is+rss%3F[/url]
>
> We are providing an extension that makes exporting and importing RSS feeds
> extremely easy from Dreamweaver (ASP VBScript support)
>
> [url]http://www.interaktonline.com/go/MXRSSReader-Writer/[/url]
>
> Alexandru
>
> UKdougs wrote:

>> Hi All
>>
>> Just looking for a bit of a pointer. I have a website hosted on a
>> Windows Server. The website has been created in ASP and pulls its
>> content from SQL server. I have had a number of requests for me to make
>> some content (a listing of my latest products) available in other sites.
>> When I update my SQL server I would like this to automatically update all
>> the linked sites. How would I do this and does any one know of any
>> tutorials that will help me to achieve this. I can't use .net because of
>> server restrictions. I have never used XML and know very little about it
>> but I think this is what I will have to use but I may be wrong.
>>
>> Any help would be appreciated.
>>
>> Cheers...Doug

>
> --
> InterAKT Online - Dreamweaver extensions
> [url]http://www.interaktonline.com/[/url]

[Alexandru COSTIN]

Hi,

> Thank you for your response. I currently have a include file in my site
> which contains a recordset that lists the products. How easy would it be to
> make this available on other sites using your extension.

It would take roughly 1 minute (after the initial getting started time
that should be something like 30 minutes :)

> Also, for the
> sites wanting to include the information from my SQL server, what are the
> requirements. Do they need to be hosted on a particular type of server, do
> the pages have to be ASP or can they be plain HTML.

There are no requirements but to have ASP support (we also support PHP
and ColdFusion - and RSS feeds can also be imported from a lot of other
platforms)

> I have never worked with XML or Rss so I would appreciate your feedback.

You should check these Flash movies to understand how simple the process
is -
[url]http://www.interaktonline.com/Products/Dreamweaver-Extensions/MXRSSReader-Writer/Flash-Demos/[/url]

Sincerely,

Alexandru


--
InterAKT Online - Dreamweaver extensions
[url]http://www.interaktonline.com/[/url]

[UKdougs]

Thanks very much...looks just the ticket. I feel a purchase coming on but
before that I want to go through a basic tutorial just so I can understand
the technology I am using.

Cheers....Doug

"Alexandru COSTIN" <acostinREMOVE@interaktonline.com> wrote in message
news:422EE707.1060000@interaktonline.com...

> Hi,
>

>> Thank you for your response. I currently have a include file in my site
>> which contains a recordset that lists the products. How easy would it be
>> to make this available on other sites using your extension.

> It would take roughly 1 minute (after the initial getting started time
> that should be something like 30 minutes :)
>

>> Also, for the sites wanting to include the information from my SQL
>> server, what are the requirements. Do they need to be hosted on a
>> particular type of server, do the pages have to be ASP or can they be
>> plain HTML.

> There are no requirements but to have ASP support (we also support PHP and
> ColdFusion - and RSS feeds can also be imported from a lot of other
> platforms)
>

>> I have never worked with XML or Rss so I would appreciate your feedback.

> You should check these Flash movies to understand how simple the process
> is -
> [url]http://www.interaktonline.com/Products/Dreamweaver-Extensions/MXRSSReader-Writer/Flash-Demos/[/url]
>
> Sincerely,
>
> Alexandru
>
>
> --
> InterAKT Online - Dreamweaver extensions
> [url]http://www.interaktonline.com/[/url]

[darrel]

> I can't use .net because of server restrictions.

Bummer. This would be fairly easy to do in .net. Maybe it's easy in ASP too.

In .net, I'd do a query against the DB. I'd then use XMLwriter to write out
an XML file with that data. Then, I'd simply give the URL of that file to
whoever wants the data and let them grab it and transoform it on their end.

RSS is the same concept. Actually, I guess it's the same thing,
really...it's all XML.

-Darrel

[Julian Roberts]

Have a look at the XML section of 4guysfromrolla.com, it's pretty good. The
basic premis is that you'd write out a recordset as XML. eg

<%
Response.ContentType="text/xml"
Response.Write "<root>"
while not rs.eof
Response.Write "<mynode>" & rs("myfield") & "</mynode>"
rs.movenext
wend
Response.Write "</root>"
%>

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[UKdougs]

Thanks Everyone.

I now have a good starting point at least and know what technologies I need
to be looking at. I will give the tutorial a try and take it from there.

Thanks again....Doug


"Julian Roberts" <newsg@charon.co.uk> wrote in message
news:d0o3hb$aqh$1@forums.macromedia.com...

> Have a look at the XML section of 4guysfromrolla.com, it's pretty good.
> The basic premis is that you'd write out a recordset as XML. eg
>
> <%
> Response.ContentType="text/xml"
> Response.Write "<root>"
> while not rs.eof
> Response.Write "<mynode>" & rs("myfield") & "</mynode>"
> rs.movenext
> wend
> Response.Write "</root>"
> %>
>
> --
> Jules
> [url]http://www.charon.co.uk/charoncart[/url]
> Charon Cart 3
> Shopping Cart Extension for Dreamweaver MX/MX 2004
>
>