42 : '%#SEARCHcity#%' ) AND (ACCT_status = '#STAT1#' OR ACCT_status =
43 : '#STAT2#' OR ACCT_status = '#STAT3#' OR ACCT_status = '#STAT4#' OR
44 : ACCT_status = '#STAT5#') ORDER BY COMPANY_name </CFQUERY> <CFELSEIF #SEARCHitem# IS "CITY">....<CFQUERY DATASOURCE="#Request.DBASEdatasource#" NAME="clients">
45 : SELECT
46 : ID,FILE_created,FILE_changed,FILE_email1,FILE_notice_type,ACCT_type,ACCT_status,ACCT_date_in,ACCT_balance,ACCT_start,ACCT_termMOS,COMPANY_name,COMPANY_firstname,COMPANY_lastname,COMPANY_addr,COMPANY_city,COMPANY_state,COMPANY_country,URL_1
|