Hi Seona, >> <cfif ValueList(query) CONTAINS "value">
I would tend to use something like this: <cfif ListFindNoCase(ValueList(query.column),"value",",")> If you want a case sensitive comparison, use ListFind().. Also.. The 3rd argument in the ListFindNoCase function Defaults to a comma so its actually not required.. But it Doesn't hurt. Cheers, Adam -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Seona Bellamy Sent: Thursday, 13 February 2003 4:32 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Trying to figure out the syntax of a <cfif> statement Ah, of course! Thanks for that. :) Naturally, if you loop over an empty query, it loops 0 times. *sigh* And I just remember how to check through the whole query in one if statement without using a loop: <cfif ValueList(query) CONTAINS "value"> is right, isn't it? It seems to work in the other place I used this syntax. (I really do have to read over my code from time to time...) Cheers, Seona. --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
