Shruthi_123
asked on
How do i get values from CFHTTP.filecontent. PLEASE HELP!!!!!!!!
I have 3 CFM pages. I am using CFHTTP POST method.This is used for displaying the member results when we search a member
PAGE 1: This is used for creating an XML
PAGE 2: This is used for invoking the method
PAGE3: This is used for displaying the results.
PAGE 1 and PAGE 2 are placed in a seperate folder inside wwwroot(web root) folder of C:. PAGE 3 is placed in a seperate folder. I am sending a HTTP request from PAGE 3 to PAGE 1.
I want to display the values like first name,last name etc.. from the CFHTTP.filecontent.
I am getting the file content only when i put a dump in PAGE 2
<CFOUTPUT><CFDUMP var=""/></CFOUTPUT>
PAGE 1: This is used for creating an XML
<CFFUNCTION name="createSiebelXML" access="public" output="false" returntype="any">
<CFARGUMENT name="nameFirst" type="string" required="No" default=""/>
<CFARGUMENT name="nameLast" type="string" required="No" default=""/>
<CFARGUMENT name="state" type="string" required="No" default=""/>
<CFARGUMENT name="organization" type="string" required="No" default=""/>
<CFARGUMENT name="zip" type="string" required="No" default=""/>
<CFSCRIPT>
var objcreateSiebelXML = XMLNew();
</CFSCRIPT>
<CFQUERY name="qrySiebelSelect" datasource="edgeGoldmanSac hs">
SELECT
distinct m.memberid,
m.nameFirst,
m.nameMiddle,
m.nameLast,
m.email,
m.memberNumber,
m.dynamicRecordID,
m.organization,
m.salutation,
b.memberTypeName,
a.address1,
a.address2,
a.address3,
a.city,
a.stprId,
s.stateCode,
a.addressname,
a.country,
a.postalcode,
a.phonework,
a.addresstypeId,
a.addressObjTypeId
FROM
members m
LEFT OUTER JOIN addresses a ON m.memberID = a.memberID
LEFT OUTER JOIN edgeMaster.dbo.stateProv s ON isnull(a.stprId,0) = s.stprId
INNER JOIN memberTypes b ON m.memberTypeId = b.memberTypeId
WHERE 0=0
<CFIF arguments.nameFirst NEQ "">
AND m.nameFirst LIKE '#arguments.nameFirst#%'
</CFIF>
<CFIF arguments.nameLast NEQ "">
AND m.nameLast LIKE '#arguments.nameLast#%'
</CFIF>
<CFIF arguments.organization NEQ "">
AND m.organization LIKE '#arguments.organization#% '
</CFIF>
<CFIF arguments.state NEQ "">
AND s.stateCode = '#arguments.state#'
</CFIF>
<CFIF arguments.postalcode NEQ "">
AND a.postalcode = '#arguments.postalcode#'
</CFIF>
AND m.statusID NOT IN (SELECT
StatusID
FROM
edgeMaster..STATUS
WHERE
StatusCode = <CFQUERYPARAM cfsqltype="CF_SQL_VARCHAR" value="deleted" />
OR StatusCode = <CFQUERYPARAM cfsqltype="CF_SQL_VARCHAR" value="inactive" />)
ORDER BY m.nameFirst
</CFQUERY>
<CFQUERY name="qryAddresstypesSelec t" datasource="edgeGoldmanSac hs">
SELECT
addresstypeId,
addressObjTypeId,
addressName,
nameFirst,
nameMiddle,
nameLast,
salutation,
organization,
address1,
address2,
address3,
city,
stprID,
postalCode,
countryID,
phoneWork,
fax,
phoneHome,
phoneCell,
phoneOther,
phonePager,
email
FROM
addresses
WHERE
memberId = <CFQUERYPARAM value="#qrySiebelSelect.me mberId#" cfsqltype="cf_sql_any"/> AND
primaryForType = 1
</CFQUERY>
<CFQUERY name="qryAddressUsageTypeS elect" datasource="edgeMaster">
SELECT
addressObjName
FROM
addressObjType
WHERE
addressObjTypeId = <CFQUERYPARAM value="#qryAddresstypesSel ect.addres sObjTypeId #" cfsqltype="cf_sql_any"/>
</CFQUERY>
<CFQUERY name="qryAddressTypeSelect " datasource="edgeGoldmanSac hs">
SELECT
addressTypeName
FROM
addressTypes
WHERE
addressTypeId = <CFQUERYPARAM value="#qryAddresstypesSel ect.addres stypeId#" cfsqltype="cf_sql_any"/>
</CFQUERY>
<CFIF qryAddresstypesSelect.reco rdcount NEQ 0>
<CFSCRIPT>
objcreateSiebelXML.XMLRoot = XmlElemNew(objcreateSiebel XML,"","PA YLOAD");
ArrayAppend(objcreateSiebe lXML.XMLRo ot.XMLChil dren, XmlElemNew(objcreateSiebel XML,"","SE ARCHRESULT "));
objcreateSiebelXML.XMLRoot .SEARCHRES ULT.XmlTex t = "#qryAddresstypesSelect.re cordcount# ";
for(intCount = 1; intCount LE qryAddresstypesSelect.reco rdcount; intCount=intCount+1)
{//Members
ArrayAppend(objcreateSiebe lXML.XMLRo ot.XMLChil dren, XmlElemNew(objcreateSiebel XML,"","ME MBER"));
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. XMLChildre n, XmlElemNew(objcreateSiebel XML,"","CO NTACTID")) ;
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. XMLChildre n, XmlElemNew(objcreateSiebel XML, "", "SALUTATION"));
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. XMLChildre n, XmlElemNew(objcreateSiebel XML, "", "FIRSTNAME"));
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. XMLChildre n, XmlElemNew(objcreateSiebel XML, "", "MIDDLEINITIAL"));
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. XMLChildre n, XmlElemNew(objcreateSiebel XML, "", "LASTNAME"));
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. XMLChildre n, XmlElemNew(objcreateSiebel XML, "", "MEMBERTYPE"));
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. XMLChildre n, XmlElemNew(objcreateSiebel XML, "", "ORGANIZATION"));
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. XMLChildre n, XmlElemNew(objcreateSiebel XML, "", "FIRMNUMBER"));
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. XMLChildre n, XmlElemNew(objcreateSiebel XML, "", "EMAILADDRESS"));
//Addresses
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. XMLChildre n, XmlElemNew(objcreateSiebel XML,"","AD DRESSES")) ;
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. ADDRESSES. XMLChildre n, XmlElemNew(objcreateSiebel XML,"","AD DRESS"));
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. ADDRESSES. ADDRESS.XM LChildren, XmlElemNew(objcreateSiebel XML,"","AD DRESSNAME" ));
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. ADDRESSES. ADDRESS.XM LChildren, XmlElemNew(objcreateSiebel XML, "", "ADDRESSUSAGETYPE"));
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. ADDRESSES. ADDRESS.XM LChildren, XmlElemNew(objcreateSiebel XML, "", "PRIMARYUSAGETYPE"));
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. ADDRESSES. ADDRESS.XM LChildren, XmlElemNew(objcreateSiebel XML, "", "ADDRESSTYPE"));
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. ADDRESSES. ADDRESS.XM LChildren, XmlElemNew(objcreateSiebel XML, "", "FIRSTNAME"));
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. ADDRESSES. ADDRESS.XM LChildren, XmlElemNew(objcreateSiebel XML, "", "LASTNAME"));
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. ADDRESSES. ADDRESS.XM LChildren, XmlElemNew(objcreateSiebel XML, "", "ORGANIZATION"));
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. ADDRESSES. ADDRESS.XM LChildren, XmlElemNew(objcreateSiebel XML, "", "ADDRESSLINE1"));
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. ADDRESSES. ADDRESS.XM LChildren, XmlElemNew(objcreateSiebel XML, "", "ADDRESSLINE2"));
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. ADDRESSES. ADDRESS.XM LChildren, XmlElemNew(objcreateSiebel XML,"","AD DRESSLINE3 "));
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. ADDRESSES. ADDRESS.XM LChildren, XmlElemNew(objcreateSiebel XML, "", "CITY"));
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. ADDRESSES. ADDRESS.XM LChildren, XmlElemNew(objcreateSiebel XML, "", "STATE"));
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. ADDRESSES. ADDRESS.XM LChildren, XmlElemNew(objcreateSiebel XML, "", "POSTALCODE"));
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. ADDRESSES. ADDRESS.XM LChildren, XmlElemNew(objcreateSiebel XML, "", "COUNTRY"));
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. ADDRESSES. ADDRESS.XM LChildren, XmlElemNew(objcreateSiebel XML, "", "WORKPHONENUMBER"));
ArrayAppend(objcreateSiebe lXML.XMLRo ot.MEMBER. ADDRESSES. ADDRESS.XM LChildren, XmlElemNew(objcreateSiebel XML, "", "EMAILADDRESS"));
//member values
objcreateSiebelXML.XMLRoot .MEMBER.CO NTACTID.Xm lText = "#trim(qrySiebelSelect.mem berId[intC ount])#";
objcreateSiebelXML.XMLRoot .MEMBER.FI RSTNAME[in tCount].Xm lText = "#trim(qrySiebelSelect.nam eFirst[int Count])#";
objcreateSiebelXML.XMLRoot .MEMBER.MI DDLEINITIA L[intCount ].XmlText = "#trim(qrySiebelSelect.nam eMiddle[in tCount])#" ;
objcreateSiebelXML.XMLRoot .MEMBER.LA STNAME[int Count].Xml Text = "#trim(qrySiebelSelect.nam eLast[intC ount])#";
objcreateSiebelXML.XMLRoot .MEMBER.ME MBERTYPE[i ntCount].X mlText = "#trim(qrySiebelSelect.mem berTypeNam e[intCount ])#";
objcreateSiebelXML.XMLRoot .MEMBER.OR GANIZATION [intCount] .XmlText = "#trim(qrySiebelSelect.org anization[ intCount]) #";
objcreateSiebelXML.XMLRoot .MEMBER.FI RMNUMBER[i ntCount].X mlText = "#trim(qrySiebelSelect.dyn amicRecord ID[intCoun t])#";
objcreateSiebelXML.XMLRoot .MEMBER.EM AILADDRESS [intCount] .XmlText = "#trim(qrySiebelSelect.ema il[intCoun t])#";
//address values
objcreateSiebelXML.XMLRoot .MEMBER.AD DRESSES.AD DRESS.ADDR ESSNAME.Xm lText = "#trim(qryAddresstypesSele ct.address name[intCo unt])#";
objcreateSiebelXML.XMLRoot .MEMBER.AD DRESSES.AD DRESS.ADDR ESSUSAGETY PE[intCoun t].XmlText = "#trim(qryAddressUsageType Select.add ressObjNam e[intCount ])#";
objcreateSiebelXML.XMLRoot .MEMBER.AD DRESSES.AD DRESS.PRIM ARYUSAGETY PE[intCoun t].XmlText = "#trim(qrySiebelSelect.add ressname[i ntCount])# ";
objcreateSiebelXML.XMLRoot .MEMBER.AD DRESSES.AD DRESS.ADDR ESSTYPE[in tCount].Xm lText = "#trim(qryAddressTypeSelec t.addressT ypeName[in tCount])#" ;
objcreateSiebelXML.XMLRoot .MEMBER.AD DRESSES.AD DRESS.FIRS TNAME[intC ount].XmlT ext = "#trim(qrySiebelSelect.nam eFirst[int Count])#";
objcreateSiebelXML.XMLRoot .MEMBER.AD DRESSES.AD DRESS.LAST NAME[intCo unt].XmlTe xt = "#trim(qrySiebelSelect.nam eLast[intC ount])#";
objcreateSiebelXML.XMLRoot .MEMBER.AD DRESSES.AD DRESS.ORGA NIZATION[i ntCount].X mlText = "#trim(qrySiebelSelect.org anization[ intCount]) #";
objcreateSiebelXML.XMLRoot .MEMBER.AD DRESSES.AD DRESS.ADDR ESSLINE1[i ntCount].X mlText = "#trim(qrySiebelSelect.add ress1[intC ount])#";
objcreateSiebelXML.XMLRoot .MEMBER.AD DRESSES.AD DRESS.ADDR ESSLINE2.X mlText = "#trim(qrySiebelSelect.add ress2[intC ount])#";
objcreateSiebelXML.XMLRoot .MEMBER.AD DRESSES.AD DRESS.ADDR ESSLINE3[i ntCount].X mlText = "#trim(qrySiebelSelect.add ress3[intC ount])#";
objcreateSiebelXML.XMLRoot .MEMBER.AD DRESSES.AD DRESS.CITY [intCount] .XmlText = "#trim(qrySiebelSelect.cit y[intCount ])#";
objcreateSiebelXML.XMLRoot .MEMBER.AD DRESSES.AD DRESS.STAT E[intCount ].XmlText = "#trim(qrySiebelSelect.sta teCode[int Count])#";
objcreateSiebelXML.XMLRoot .MEMBER.AD DRESSES.AD DRESS.POST ALCODE[int Count].Xml Text = "#trim(qrySiebelSelect.pos talcode[in tCount])#" ;
objcreateSiebelXML.XMLRoot .MEMBER.AD DRESSES.AD DRESS.COUN TRY[intCou nt].XmlTex t = "#trim(qrySiebelSelect.cou ntry[intCo unt])#";
objcreateSiebelXML.XMLRoot .MEMBER.AD DRESSES.AD DRESS.WORK PHONENUMBE R[intCount ].XmlText = "#trim(qrySiebelSelect.pho nework[int Count])#";
objcreateSiebelXML.XMLRoot .MEMBER.AD DRESSES.AD DRESS.EMAI LADDRESS[i ntCount].X mlText = "#trim(qrySiebelSelect.ema il[intCoun t])#";
}
</CFSCRIPT>
</CFIF>
<CFRETURN objcreateSiebelXML/>
</CFFUNCTION>
PAGE 2: This is used for invoking the method
<CFINVOKE component = "Siebel" method = "createSiebelXML" returnvariable = "objcreateSiebelXML">
<CFINVOKEARGUMENT name="nameFirst" value="#form.Firstname#"/>
<CFINVOKEARGUMENT name="nameLast" value="#form.Lastname#"/>
<CFINVOKEARGUMENT name="organization" value="#form.Organization# "/>
<CFINVOKEARGUMENT name="stateCode" value="#form.State#"/>
<CFINVOKEARGUMENT name="postalcode" value="#form.Zip#"/>
</CFINVOKE>
<CFSET Siebel = 'Siebel' & '_' & dateformat(now(),'YYYYMMDD ') & timeformat(now(),'HHMMSS') />
<CFFILE action="write" file="C:\Inetpub\wwwroot\S iebel\#Sie bel#.xml" output="#toString(objcreat eSiebelXML )#"/>
<CFOBJECT action="create" type="java" class="com.twmacinta.util. EncryptWBa se64MD5" name="objBase64">
<CFOBJECT action="create" type="java" class="org.apache.xerces.u tils.Base6 4" name="objBase">
<CFSET Hashcode=objBase64.getMD5H ashCode(to string(obj createSieb elXML))>
<CFSET varEncPayload=objBase64.En cryptPaylo ad(tostrin g(objcreat eSiebelXML ),0)>
<CFSET varHashCode = objBase.encode(Hashcode.ge tBytes())>
<input type="hidden" name="test" value="1"/>
PAGE3: This is used for displaying the results.
<SCRIPT language="javascript1.2">
function test()
{
document.searchCriteria.hd nLocal.val ue = 1;
document.searchCriteria.hd nnameFirst .value = document.searchCriteria.na meFirst.va lue;
document.searchCriteria.hd nnameLast. value = document.searchCriteria.na meLast.val ue;
document.searchCriteria.hd nOrganizat ion.value = document.searchCriteria.or ganization .value;
document.searchCriteria.hd nState.val ue = document.searchCriteria.st ate.value;
document.searchCriteria.hd nZip.value = document.searchCriteria.zi p.value;
document.searchCriteria.su bmit();
}
</SCRIPT>
<CFIF ISDEFINED("hdnLocal")>
<CFHTTP method="post" url="http://localhost/Siebel/dspSiebel.cfm">
<CFHTTPPARAM type="formfield" name="projectId" value="17">
<CFHTTPPARAM type="formfield" name="Firstname" value="#hdnnameFirst#">
<CFHTTPPARAM type="formfield" name="Lastname" value="#hdnnameLast#">
<CFHTTPPARAM type="formfield" name="Organization" value="#hdnOrganization#">
<CFHTTPPARAM type="formfield" name="State" value="#hdnState#">
<CFHTTPPARAM type="formfield" name="Zip" value="#hdnZip#">
</CFHTTP>
<CFDUMp var="#cfhttp.FileContent#" />
</CFIF>
I am not able seperate values from the cfhttp.FileContent
PLEASE TELL me how to retrieve seperate values like First name,last name (refer XML PART in PAGE 1) from the cfhttp.FileContent. I want to display first name,last name etc.... in the PAGE 3
PLEASE tell me a solution to display the results in PAGE 3 from PAGE 2.
PLS REPLY SOON
PAGE 1: This is used for creating an XML
PAGE 2: This is used for invoking the method
PAGE3: This is used for displaying the results.
PAGE 1 and PAGE 2 are placed in a seperate folder inside wwwroot(web root) folder of C:. PAGE 3 is placed in a seperate folder. I am sending a HTTP request from PAGE 3 to PAGE 1.
I want to display the values like first name,last name etc.. from the CFHTTP.filecontent.
I am getting the file content only when i put a dump in PAGE 2
<CFOUTPUT><CFDUMP var=""/></CFOUTPUT>
PAGE 1: This is used for creating an XML
<CFFUNCTION name="createSiebelXML" access="public" output="false" returntype="any">
<CFARGUMENT name="nameFirst" type="string" required="No" default=""/>
<CFARGUMENT name="nameLast" type="string" required="No" default=""/>
<CFARGUMENT name="state" type="string" required="No" default=""/>
<CFARGUMENT name="organization" type="string" required="No" default=""/>
<CFARGUMENT name="zip" type="string" required="No" default=""/>
<CFSCRIPT>
var objcreateSiebelXML = XMLNew();
</CFSCRIPT>
<CFQUERY name="qrySiebelSelect" datasource="edgeGoldmanSac
SELECT
distinct m.memberid,
m.nameFirst,
m.nameMiddle,
m.nameLast,
m.email,
m.memberNumber,
m.dynamicRecordID,
m.organization,
m.salutation,
b.memberTypeName,
a.address1,
a.address2,
a.address3,
a.city,
a.stprId,
s.stateCode,
a.addressname,
a.country,
a.postalcode,
a.phonework,
a.addresstypeId,
a.addressObjTypeId
FROM
members m
LEFT OUTER JOIN addresses a ON m.memberID = a.memberID
LEFT OUTER JOIN edgeMaster.dbo.stateProv s ON isnull(a.stprId,0) = s.stprId
INNER JOIN memberTypes b ON m.memberTypeId = b.memberTypeId
WHERE 0=0
<CFIF arguments.nameFirst NEQ "">
AND m.nameFirst LIKE '#arguments.nameFirst#%'
</CFIF>
<CFIF arguments.nameLast NEQ "">
AND m.nameLast LIKE '#arguments.nameLast#%'
</CFIF>
<CFIF arguments.organization NEQ "">
AND m.organization LIKE '#arguments.organization#%
</CFIF>
<CFIF arguments.state NEQ "">
AND s.stateCode = '#arguments.state#'
</CFIF>
<CFIF arguments.postalcode NEQ "">
AND a.postalcode = '#arguments.postalcode#'
</CFIF>
AND m.statusID NOT IN (SELECT
StatusID
FROM
edgeMaster..STATUS
WHERE
StatusCode = <CFQUERYPARAM cfsqltype="CF_SQL_VARCHAR"
OR StatusCode = <CFQUERYPARAM cfsqltype="CF_SQL_VARCHAR"
ORDER BY m.nameFirst
</CFQUERY>
<CFQUERY name="qryAddresstypesSelec
SELECT
addresstypeId,
addressObjTypeId,
addressName,
nameFirst,
nameMiddle,
nameLast,
salutation,
organization,
address1,
address2,
address3,
city,
stprID,
postalCode,
countryID,
phoneWork,
fax,
phoneHome,
phoneCell,
phoneOther,
phonePager,
FROM
addresses
WHERE
memberId = <CFQUERYPARAM value="#qrySiebelSelect.me
primaryForType = 1
</CFQUERY>
<CFQUERY name="qryAddressUsageTypeS
SELECT
addressObjName
FROM
addressObjType
WHERE
addressObjTypeId = <CFQUERYPARAM value="#qryAddresstypesSel
</CFQUERY>
<CFQUERY name="qryAddressTypeSelect
SELECT
addressTypeName
FROM
addressTypes
WHERE
addressTypeId = <CFQUERYPARAM value="#qryAddresstypesSel
</CFQUERY>
<CFIF qryAddresstypesSelect.reco
<CFSCRIPT>
objcreateSiebelXML.XMLRoot
ArrayAppend(objcreateSiebe
objcreateSiebelXML.XMLRoot
for(intCount = 1; intCount LE qryAddresstypesSelect.reco
{//Members
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
//Addresses
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
ArrayAppend(objcreateSiebe
//member values
objcreateSiebelXML.XMLRoot
objcreateSiebelXML.XMLRoot
objcreateSiebelXML.XMLRoot
objcreateSiebelXML.XMLRoot
objcreateSiebelXML.XMLRoot
objcreateSiebelXML.XMLRoot
objcreateSiebelXML.XMLRoot
objcreateSiebelXML.XMLRoot
//address values
objcreateSiebelXML.XMLRoot
objcreateSiebelXML.XMLRoot
objcreateSiebelXML.XMLRoot
objcreateSiebelXML.XMLRoot
objcreateSiebelXML.XMLRoot
objcreateSiebelXML.XMLRoot
objcreateSiebelXML.XMLRoot
objcreateSiebelXML.XMLRoot
objcreateSiebelXML.XMLRoot
objcreateSiebelXML.XMLRoot
objcreateSiebelXML.XMLRoot
objcreateSiebelXML.XMLRoot
objcreateSiebelXML.XMLRoot
objcreateSiebelXML.XMLRoot
objcreateSiebelXML.XMLRoot
objcreateSiebelXML.XMLRoot
}
</CFSCRIPT>
</CFIF>
<CFRETURN objcreateSiebelXML/>
</CFFUNCTION>
PAGE 2: This is used for invoking the method
<CFINVOKE component = "Siebel" method = "createSiebelXML" returnvariable = "objcreateSiebelXML">
<CFINVOKEARGUMENT name="nameFirst" value="#form.Firstname#"/>
<CFINVOKEARGUMENT name="nameLast" value="#form.Lastname#"/>
<CFINVOKEARGUMENT name="organization" value="#form.Organization#
<CFINVOKEARGUMENT name="stateCode" value="#form.State#"/>
<CFINVOKEARGUMENT name="postalcode" value="#form.Zip#"/>
</CFINVOKE>
<CFSET Siebel = 'Siebel' & '_' & dateformat(now(),'YYYYMMDD
<CFFILE action="write" file="C:\Inetpub\wwwroot\S
<CFOBJECT action="create" type="java" class="com.twmacinta.util.
<CFOBJECT action="create" type="java" class="org.apache.xerces.u
<CFSET Hashcode=objBase64.getMD5H
<CFSET varEncPayload=objBase64.En
<CFSET varHashCode = objBase.encode(Hashcode.ge
<input type="hidden" name="test" value="1"/>
PAGE3: This is used for displaying the results.
<SCRIPT language="javascript1.2">
function test()
{
document.searchCriteria.hd
document.searchCriteria.hd
document.searchCriteria.hd
document.searchCriteria.hd
document.searchCriteria.hd
document.searchCriteria.hd
document.searchCriteria.su
}
</SCRIPT>
<CFIF ISDEFINED("hdnLocal")>
<CFHTTP method="post" url="http://localhost/Siebel/dspSiebel.cfm">
<CFHTTPPARAM type="formfield" name="projectId" value="17">
<CFHTTPPARAM type="formfield" name="Firstname" value="#hdnnameFirst#">
<CFHTTPPARAM type="formfield" name="Lastname" value="#hdnnameLast#">
<CFHTTPPARAM type="formfield" name="Organization" value="#hdnOrganization#">
<CFHTTPPARAM type="formfield" name="State" value="#hdnState#">
<CFHTTPPARAM type="formfield" name="Zip" value="#hdnZip#">
</CFHTTP>
<CFDUMp var="#cfhttp.FileContent#"
</CFIF>
I am not able seperate values from the cfhttp.FileContent
PLEASE TELL me how to retrieve seperate values like First name,last name (refer XML PART in PAGE 1) from the cfhttp.FileContent. I want to display first name,last name etc.... in the PAGE 3
PLEASE tell me a solution to display the results in PAGE 3 from PAGE 2.
PLS REPLY SOON
ASKER
I have tried this. I`m not able to extract content from CFHTTP.file content. This is not workinga dn i`m getting error
You tried the CFC ?
what error are you getting?
what error are you getting?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
please read the instructions about grading.
https://www.experts-exchange.com/help.jsp#hi97
Giving someone a "C" is a black mark. I would rather you close the question with no points than give me a C, unless of course, I deserve it.
I'm glad you solved your own problem, but you have to close this question based on it's own merits. Did I provide you with good accurate infromation? Did I leave you hanging? If I provided no relevant infromation and you solved it own your own, then you can close the question without giving any points. If I provided you good information, but you needed more, you should ask for it.
https://www.experts-exchange.com/help.jsp#hi97
Giving someone a "C" is a black mark. I would rather you close the question with no points than give me a C, unless of course, I deserve it.
I'm glad you solved your own problem, but you have to close this question based on it's own merits. Did I provide you with good accurate infromation? Did I leave you hanging? If I provided no relevant infromation and you solved it own your own, then you can close the question without giving any points. If I provided you good information, but you needed more, you should ask for it.
ASKER
Ypur comments are usefull but i soved this in a different way using encryption decryption method. Thanks for ur solution. Please close my question
assuming you have read in valid XML from your CFHTTP, you can then parse it using
<cfset theXML = XMLparse(cfhttp.FileConten
Then dump theXML and you can access the various nodes like they were structure.
Here's nice little tool that may make it even easier. Download this function and call it with your fileContent, it will return a structure, then you can just use CF to walk through the structure...
http://www.anujgakhar.com/2007/11/05/coldfusion-xml-to-struct/