I got this figured out. I simply built a loop that will assemble the
string as I need it. Works like a champ.
<CFIF get_in_range_postals.recordcount eq 1>
<CFOUTPUT query="get_in_range_postals">
<CFSET criteria_string = "#criteria_string# AND
(custom3:#zipcode#)">
</CFOUTPUT>
<CFELSEIF get_in_range_postals.recordcount GT 1>
<CFLOOP query="get_in_range_postals" startrow="1" endrow="1">
<CFSET criteria_string = "#criteria_string# AND
(custom3:#zipcode#">
</CFLOOP>
<CFLOOP query="get_in_range_postals" startrow="1">
<CFSET criteria_string = "#criteria_string# OR
custom3:#zipcode#">
</CFLOOP>
<CFSET criteria_string = "#criteria_string# )">
</CFIF>
--
Open BlueDragon Public Mailing List
http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon
mailing list - http://groups.google.com/group/openbd?hl=en
!! save a network - please trim replies before posting !!
