2 : <CENTER><FONT SIZE="-1" COLOR="#FFFFFF"><CFOUTPUT><CFIF IsDefined("SEARCHcat")><CFSET IsDefined("SEARCHitem") AND IsDefined("SEARCHcountry") AND IsDefined("SEARCHcity") AND IsDefined("SEARCHcat")>
3 : <CFELSE>ERROR 1<CFABORT></CFIF> <CFSET #STAT1# = "OPEN"><CFSET #STAT2# = "VIP1"><CFSET #STAT3# = "NEW1"><CFSET #STAT4# = "PEND"><CFSET #STAT5# = "TRY1"></FONT><FONT SIZE="-2">
4 : </FONT><FONT SIZE="-1"><CFIF #SEARCHitem# IS "COUNTRY">.<CFQUERY DATASOURCE="#Request.DBASEdatasource#" NAME="clients">
5 : SELECT
6 : 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
|