Parse formated list

2003-07-03 Thread jeremy
I have a list of days in a month being returned from a query. Example record set would be 2,19,19,21,27 Number between 1 and 31. I then loop through this query with the code below which generates a list var that looks like 19,19,21,27 when outputted. CFLOCK Scope=Session Type=Exclusive

RE: Parse formated list

2003-07-03 Thread A.Little
You could use listfind() instead in your cfif query - this then won't find the incorrect matches that you're getting at the moment. Alex -Original Message- From: jeremy [mailto:[EMAIL PROTECTED] Sent: 03 July 2003 14:16 To: CF-Talk Subject: Parse formated list I have a list

RE: Parse formated list

2003-07-03 Thread webguy
(list, substring [, delimiters ]) WG -Original Message- From: jeremy [mailto:[EMAIL PROTECTED] Sent: 03 July 2003 14:16 To: CF-Talk Subject: Parse formated list I have a list of days in a month being returned from a query. Example record set would be 2,19,19,21,27 Number between 1 and 31

RE: Parse formated list

2003-07-03 Thread Andre Mohamed
You would use ListFind not ListContains because ListContains looks at elements to see if they contain the specified substring. -Original Message- From: webguy [mailto:[EMAIL PROTECTED] Sent: 03 July 2003 14:29 To: CF-Talk Subject: RE: Parse formated list This ??? ListContains(list

RE: Parse formated list

2003-07-03 Thread jeremy
Yes I tried listcontains and it did the exact same thing as my cfif using contains did. I'll give listfind() a try. -Original Message- From: Andre Mohamed [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 9:30 AM To: CF-Talk Subject: RE: Parse formated list You would use ListFind