Databases an XML (Online Subject)

[EJ Will]

Ok i've searched with a few search engines and have found nothing that i can understand fully (i am fiairly new to XML and ASP)

If anyone here can write a small tutorial or post directly here how i can...

1. Write a structured XML form, and in each section get a field in a MS Access database. To make it easier the database table is called 'Table1'.

2. Then after i have got that i won't to then be able to post it on a web page. ( I realise that this could be a lengthy answer and don't expect anyone to answer it)

I'd appreciate any help or what so ever

Cheers and Regards,
Will

[Clarksy]

Not sure why you want to use XML here? Standard HTML forms and ASP will do the trick. I cant see a use for XML in this situation.

How much ASP / Database knowledge do you have? Have you written any ASP code that works with a database? this will help me give you a better answer.

[AlastairM]

This will save an ADO recordset into an XML DOM object or to an XML file. You could then either loop through each of the DOM nodes or apply an XSLT transform to it.

Although like clarksy says, you don't need XML for this, give us a bit more info...

you might get a bit of help here:
http://www.4guysfromrolla.com/webtech/xml.shtml

cheers

alastair


dim objConn
dim rsResultSet
dim objXML
dim objXSLT
const adPersistXML = 1

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open <<your DSN or connection string>>

Set rsResultSet = objConn.execute("<<your SQL>>")


set objXML = server.createObject("MSXML2.DOMDocument.4.0")
rsResultSet.Save objXML, adPersistXML

'or use
'rsResultSet.save "<<file path>>", adPersistXML
'to save to a file on the server

'write out the xml to the browser
response.write("<textarea style=""width:300px;height:300px"">" & objXML.xml & "</textarea>")

rsResultSet.close
Set rsResultSet = Nothing

objConn.Close
Set objConn = Nothing

set objXML = nothing

[EJ Will]

Thanks for the replys and link :)

I wanted to know how to use the XML because of it's ability to be used to present data in a programme's. (Using it with Visual Basic is ideally what i'm after)

My knowledge in ASP is extremely low, XML i'm ok, I know a small bit about it.

Cheers and Regards,
Will

[Edit] Ahhh sorry I worded my second question wrong, what i meant was to get a specific field to show up in my html (changing to asp obviously). It will be like a news page, but I do not need to have any news managment rubbish you can get with things like phpNuke

The site in which this will be placed is at: www.spankclan.cjb.net/home.htm at the moment (later to be moved once completed. (Ignore the spelling mistakes ;) )

[Edit2] I think I have asked for something a bit more than i can chew :P But that site is very good... cheers again.

[EJ Will]

Ok I obviously sound confused now... which is not far from the truth but i believe I have enough information to maybe do some basic things.

I was wondering if one of you guys could make a page, which required a password which allows the entry of scores (lets say for a football game). The scores are then stored in an access database which can then be viewed on a table in another page (which can be viewed by everyone).

Comments in the source would be much appreciated so as I can learn from it.

Thanks in advanced.

Regards,
Will