Data Base connection

[asha]

Hi,<br><br>&nbsp;&nbsp;I am very new to xml,so i need your help .<br><br>My problem is,<br><br>&nbsp;&nbsp;I have to design a input form with 2 text fields and one button.here i am going to enter 2 value's and i need to store that in database.using sql statement i want to retrieve data's from a different table(here both table has a common key)I don't want to use sql wizard and stored procedure .The whole code should be in XML and i also intersted to know about ODBC connection support in XML.<br><br>Please provide a example also.<br><br>thanks in advance<br><br>&nbsp;regards<br><br>&nbsp;asha<br>&nbsp;&nbsp;&nbsp;

 

[palbano]

Dear asha,<br><br>&gt; The whole code should be in XML<br><br>I'm not even sure that is possible. The entire XML landscape is changing so fast it's hard to keep up with it and keep track of all the new products.<br><br>If there is any chance of authoring your entire solution in XML it is probably to use SQL Server 2000 which is not even released yet. Even then you would probably need some stored procedures along with the XML and that fails your criteria of the 'whole code in XML'.<br><br>Good luck<br>-pete

 

[saurabh]

Dear asha,

I guess u can write stored procedures and get the values from tables in recordsets and then u can retrieve column values from recordsets and convert them into XML.

Even I am new to XML, so i hope this will solve ur purpose to some extent.

Saurabh

 

[nsivas]

Ashu

I can write the xml for you. But u have to refer the following web pages, then learn the fundas and start coding and post ur doubts here, then we will discuss.

http://www.xml.com

and

http://www.w3.org/xml

Siva
nsivas@usa.net

 

[Avator]

Hello, asha.

IMHO under win32 there are two ways to do this (without stored procs): use ADO (latest versions, that's support XML output) for access to database or use MS SQL Server 2000 (which is not even released )

There are some ways (pretty complex) to solve problems like it (most of them implemented on Java), by using:
Oracle xSQL pages servlet (JDBC)
Coccoon of Apache Group (JDBC)
and others...
About ODBC you may see in

http://members.nbci.com/gvaughan/odbc2xml.htm

Hope it will a little helpful.
Best regards.

Avator.