> i tried this...but obviously, it adds the extra AND at the
> end...therefore
> making my statement invalid.
> WHERE <cfloop query="qryappdetails">
> <cfoutput>qryIAPeople.Listing_ID <>#listing_id# AND </cfoutput>
> </cfloop>
So re-write your code
where
<cfloop query="qryappdetails">
<cfoutput>qryIAPeople.Listing_ID <>#listing_id# </cfoutput>
<cfif qryIAPeople.recordcount is not qryIAPeople.currentrow>
<cfoutput>AND </cfoutput>
</cfif>
</cfloop>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
