7 Replies Latest reply on Jun 7, 2006 1:00 PM by BKBK

    Problem with ListChangeDelims()

    Daniel_Eng
      I can't get CF to return the results that I want... is there anything wrong with this code?

      <cfif isDefined('form.ICNumber')>
      <cfquery name="findRegistrant" datasource="registrationdb" dbtype="odbc">
      SELECT partner.*
      FROM partner
      WHERE 'ListChangeDelims(partner.ICNumber,"","-")' = '#ListChangeDelims(AppendICNumber,"","-")#'
      </cfquery>
      </cfif>