RE: FN-FORUM sql server and xml

date posted 1st December 2001 07:50

Hi Dave,
Did some stuff on that about a year ago using SQL Server and XML to get
orders for processing in a Dutch warehouse from a Californian server
basically for a "very well know brand of electronic guitars" You can pass
queries in as straight SQL (modified for internet of course) as well as
calling stored procedures. Never tried it with Netscape but I guess it
would depend on how Netscape processes xml! The request code is supposed to
be browser independent and I was calling it from VB apps on a desktop......

Mark Anderson
01202 775483
07802 404838 mob
Web Development and database design
[EMAIL REMOVED]
http://www.anderson.uk.com

-----Original Message-----
From: [EMAIL REMOVED]
[EMAIL REMOVED] Behalf Of David Eckersall
Sent: 01 December 2001 01:12
To: [EMAIL REMOVED]
Subject: FN-FORUM sql server and xml


spending my friday night being a spod instead of an alcoholic and i started
looking at sql server and xml combined and im pretty impressed.

has anyone been using this? it just does away with so much shit, you call an
xml file like so:

http://www.mysite.com/shop.xml?rectype=albums

the xml file calls an xsl file and sql server and just outputs it to your
browser:




SELECT * FROM RECORDCOLLECTION WHERE rectype=? FOR XML RAW



does anyone know if netscape can call an xml page like this? its this sort
of thing that speeds development up like anything!


============================================================

* Free listing for freelancers
* Free to advertise jobs
* Free jobs distribution service
* Free database of 5000 freelancers

Freelancers and Freelance Jobs:
http://www.freelancers.net

Forum FAQs:
http://freelancers.netrickery.com

To unsubscribe please email:
[EMAIL REMOVED]

If you have difficulties unsubscribing please email:
[EMAIL REMOVED]