Pauldohert said:
If this is the case, you should be able to connect via ODBC and syncronise your data. I don't use SQL Server, so I wouldn't be much use there.
Pauldohert said:
Can you run queries against "RAW" XML data - ie have a XML file with 1000 names in it, but then have a webpage that then shows contacts based on conatct names with surname starting with A etc. Or do I need to actaully populate the web db for this kind of thing.
Simple answer is yes you can! You can do quite a lot with XML; export any table in your DB to XML and open the result up in notepad; I am sure it will make sense. Then take a look at the W3 Schools XSLT Tutorials, as always they are an excellent resource;
http://www.w3schools.com/xsl/default.asp
You can query for particular data, group, sort and many other things. If you combine this with CSS your options increase; this morning I have been using CSS to create simple graphs on the fly from XML data with just a few lines of CSS and XSLT.
Pauldohert said:
(The workings of the webpage ASP are not my concern at this point) - just need to get the data there so it can be displayed however is chosen.
Ideally what would happen is automatically each night the local db would update the web db.
Thanks - and I apologise again for my ignornace of this subject.
LOL, no problem. Jack of All Trades, Master of None me! Again, ASP is something I know nothing about. I tend to go with the "path of least resistance" personally, but I use XML on an intranet rather than the internet, but it may end up being the easiest way to publish your data. Sorry I couldn't be of any more help.