is this possible, or i am missing something here
thanks for any help
<script language="Javascript">
function GetStates(pos)
{
var objHTTP = new ActiveXObject("Microsoft.XMLHTTP");
var szURL = "do_xml.cfm";
var szHttpMethod = "GET";
var szRequest = "AdjustPosition Position='";
szRequest += pos;
szRequest += "'></AdjustPosition>";
objHTTP.Open(szHttpMethod, szURL, false);
objHTTP.Send(szRequest);
var szReply = objHTTP.ResponseText;
var szxml = objHTTP.ResponseXML;
alert(szReply);
alert(szxml)
}
</script>
<INPUT TYPE="bUTTON" name="CLICK ME" value="CLICK ME"
ONCLICK="GetStates('1')">
the result page which passes XML
do_xml.cfm
<cfobject type="COM" name="MyConn" class="ADODB.Connection" action="CREATE">
<cfobject type="COM" name="MyRecordset" class="ADODB.Recordset"
action="CREATE">
<cfobject type="COM" name="MyStream" class="ADODB.Stream" action="CREATE">
<CFSCRIPT>
DSNtemp = "DRIVER={SQL
Server};UID=sa;PWD=123;DATABASE=sample;SERVER=127.0.0.1;";
MyConn.Open("#DSNtemp#", "", "", -1);
SQL= "SELECT * FROM users";
MyRecordset = MyConn.Execute(SQL,0,8);
if (MyRecordset.Recordcount NEQ 0) {
MyRecordset.Save(MyStream, 1);
}
</CFSCRIPT>
i need the output as a XML file for data binding purposes...
cheers.
_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
-----------------------+
cf-xml mailing list
list: [EMAIL PROTECTED]
admin: [EMAIL PROTECTED]
home: http://torchbox.com/xml
