Skip to main content
Participant
November 20, 2009
Question

cfhttp - Works in CF8 not CF9

  • November 20, 2009
  • 1 reply
  • 415 views

Hello,

This works fine in CF8 but doesn't in CF9

<cfhttp
       method="Get"
       url="#Tamino_server#?_xql=count(/UCC_Forms[//Record/Acknowledgement/FileStatus[@Status='NOStatus']%20and%20//Header/Filer/ReturnUserID='#userid#'])"
      username="#Tamino_userid#" password="#Tamino_password#"
      resolveurl="yes">

<cfset UCC_Forms=#cfhttp.FileContent#>

*******************************************************************************************************************************************************

A dump of cfhttp.fileContent with CF9 is...


      count(/UCC_Forms[//Record/Acknowledgement/FileStatus[@Status=&apos;NOStatus&apos;]
      and :80//Header/Filer/ReturnUserID=&apos;MyNameHere&apos;])Error parsing the XQL queryUnexpected token : found

CF9 adds the port thus the problem, but...

CF8 dump works fine giving...

      count(/UCC_Forms[//Record/Acknowledgement/FileStatus[@Status=&apos;NOStatus&apos;]
      and //Header/Filer/ReturnUserID=&apos;MyNameHere&apos;])XQL Request processing0XQL Request processed

It does not matter if the resolveurl is set to yes or no.   Any suggestions would be greatly appreciated.

Randy

    This topic has been closed for replies.

    1 reply

    BKBK
    Community Expert
    Community Expert
    November 21, 2009

    <cfset queryString = urlEncodedFormat("_xql=count(/UCC_Forms[//Record/Acknowledgement/FileStatus[@Status='NOStatus']%20and%20//Header/Filer/ReturnUserID='#userid#'])")>

    <cfhttp method="Get" url="#Tamino_server#?#queryString#" username="#Tamino_userid#" password="#Tamino_password#" resolveurl="yes">