Question
Where is the error hiding
CFC Code:
<cffunction name="comp_extList"
access="remote"
returntype="query"
description="Get a list of employees, phone extensions, and departments">
<cfargument name="abbrCode" required="yes" />
<cfargument name="searchBox" required="no" />
<cfset searchBox = UCASE("#arguments.searchBox#") />
<cfldap name="phoneList"
server="#cfc.ldap.server#"
username="#cfc.ldap.user#@bii.corp"
password="#cfc.ldap.key#"
action="query"
filter="company=#arguments.abbrCode#"
start="dc=bii, dc=corp"
scope="subtree"
attributes="sn,givenName,telephoneNumber,department"
sort="sn ASC"
port="389" />
<cfif len(arguments.searchBox) GT 0>
<cfquery name="phoneList" dbtype="query">
SELECT *
FROM phoneList
WHERE (UPPER(givenName) LIKE '%#searchBox#%'
OR UPPER(sn) LIKE '%#searchBox#%'
OR telephoneNumber LIKE '%#searchBox#%')
AND telephoneNumber <> ''
</cfquery>
<cfelse>
<cfquery name="phoneList" dbtype="query">
SELECT sn,givenName,telephoneNumber,department
FROM phoneList
WHERE telephoneNumber <> ''
</cfquery>
</cfif>
<cfreturn phoneList>
</cffunction>
I need to pass entered information for a search, but I receive error message:
element searchbox is undefined in arguments.
<cffunction name="comp_extList"
access="remote"
returntype="query"
description="Get a list of employees, phone extensions, and departments">
<cfargument name="abbrCode" required="yes" />
<cfargument name="searchBox" required="no" />
<cfset searchBox = UCASE("#arguments.searchBox#") />
<cfldap name="phoneList"
server="#cfc.ldap.server#"
username="#cfc.ldap.user#@bii.corp"
password="#cfc.ldap.key#"
action="query"
filter="company=#arguments.abbrCode#"
start="dc=bii, dc=corp"
scope="subtree"
attributes="sn,givenName,telephoneNumber,department"
sort="sn ASC"
port="389" />
<cfif len(arguments.searchBox) GT 0>
<cfquery name="phoneList" dbtype="query">
SELECT *
FROM phoneList
WHERE (UPPER(givenName) LIKE '%#searchBox#%'
OR UPPER(sn) LIKE '%#searchBox#%'
OR telephoneNumber LIKE '%#searchBox#%')
AND telephoneNumber <> ''
</cfquery>
<cfelse>
<cfquery name="phoneList" dbtype="query">
SELECT sn,givenName,telephoneNumber,department
FROM phoneList
WHERE telephoneNumber <> ''
</cfquery>
</cfif>
<cfreturn phoneList>
</cffunction>
I need to pass entered information for a search, but I receive error message:
element searchbox is undefined in arguments.