Skip to main content
A
ACI_CF
Participant
October 28, 2009
Question

xmlsearch needs exact text to return anything

  • October 28, 2009
  • 1 reply
  • 448 views

How do you create a wildcard search using xmlsearch? Or a search that will return records matching some of the words entered in the query (in other words the query does not require the exact text to be entered to return the record.)? For example, if I want to search for "Network Support Technician" I cannot enter "Network Support" and get the results to come up, I'll have to enter "Network Support Technician" to get any results.  (code is below)

<cfhttp url="http://www.server/webpage.cfm" method="GET">
</CFHTTP>


<CFSet xml=CFHTTP.FileContent>
<CFSet xmlDoc = XMLParse(xml)>


<cfset results = XMLSearch(xmlDoc, "//job[TITLE_STRING='#form.JobTitle#']")/>    

This topic has been closed for replies.

1 reply

A
Adam Cameron.
Inspiring
October 28, 2009

xpath 1.0 supports a range of string functions.  It's perhaps an idea to have a read through this: http://www.w3.org/TR/xpath.  Or perhaps if you want something slightly less impenetrable: http://www.w3schools.com/XPath/xpath_functions.asp.

--

Adam

A
ACI_CFAuthor
Participant
October 28, 2009

I ended up going with another method over the xmlsearch for this. I've included the code below

<CFSet xml=CFHTTP.FileContent>
<CFSet xmlDoc = XMLParse(xml)>
<cfset jobs = xmldoc.root.XmlChildren>
<cfset size = ArrayLen(jobs)>

<!--- create a query object with the job data --->
<cfset myquery = QueryNew("JobID, Title") >
<cfset temp = QueryAddRow(myquery, #size#)>
<cfloop index="i" from = "1" to = #size#>
    <cfset temp = QuerySetCell(myquery, "JobID",
        #xmldoc.root.job.jobpostingid_int.XmlText#, #i#)>
    <cfset temp = QuerySetCell(myquery, "Title",
        #LCase(xmldoc.root.job.TITLE_STRING.XmlText)#, #i#)>

</cfloop>

<!--- Select entries with the Title name starting with N and dump the result --->
<cfquery name="ImqTest" dbType="query">
   SELECT JobID, Title
   FROM myquery

where Title LIKE '#LCase(form.JobTitle)#%'

</cfquery>

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices