47 : FROM ADTable WHERE (PROP_type LIKE '%#type1#%' OR PROP_type LIKE '%#type2#%' OR PROP_type LIKE '%#type3#%')
48 : AND (AD_status = '#stat1#' OR AD_status = '#stat2#' OR AD_status =
49 : '#stat3#' OR AD_status = '#stat4#') AND (Mid(PROP_desc_1,6,4) LIKE '#SEARCHyear#') ORDER BY Mid(PROP_desc_1,2,2),Mid(PROP_desc_1,4,2)</CFQUERY>
50 : <CFQUERY DATASOURCE="#Request.DBASEagents#" NAME="Admin444">
51 : SELECT ID,ACCT_status,ACCT_type
|