Monday, December 29, 2003, 8:17:20 PM, you wrote:
JEV> A shorter form for CF Code could be:
JEV> <cfif NOT listFindNoCase("string1,string2,string3,string4",1)>
JEV> blah
JEV> </cfif>
JEV> This says, "if 1 does not match any strings in the list"
JEV> If your strings could have commas, use a different delimiter -- like the |
JEV> here:
JEV> <cfif NOT listFindNoCase("string1|string2|string3|string4",1,"|")>
JEV> -----Original Message-----
JEV> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
JEV> Sent: Sunday, December 28, 2003 11:25 AM
JEV> To: CF-Talk
JEV> Subject: Fwd: Re[2]: OR NEQ cfif statement
JEV> Dave forget my last
JEV> email. The statement should be:
JEV> <cfif string1 NEQ 1 AND string2 NEQ 1 AND string3 NEQ 1 AND string4 NEQ
1>>CheckErgebnis = ' '</cfif>
JEV> It works now.
JEV> Uwe
JEV> This is a forwarded message
JEV> From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
JEV> To: Dave Watts <[EMAIL PROTECTED]>
JEV> Date: Sunday, December 28, 2003, 7:38:38 PM
JEV> Subject: OR NEQ cfif statement
JEV> ===8<==============Original message text===============
JEV> Dave, I get the following error by trying:
JEV> <cfif string1 NEQ 1 OR string2 NEQ 1 OR string3 NEQ 1 OR string4 NEQ
1>>CheckErgebnis = ''</cfif>
JEV> It means: missing operator in _expression_ ''Failure' CheckErgebnis = '''.
JEV> Any ideas ?
JEV> Uwe
JEV> ODBC Error Code = 37000 (Syntax error or access violation)
JEV> [Microsoft][ODBC Microsoft Access Driver] Syntaxfehler (fehlender Operator)
JEV> in Abfrageausdruck ''Failure' CheckErgebnis = '''.
JEV> The error occurred while processing an element with a general identifier of
JEV> (CFQUERY), occupying document position (26:3) to (26:68).
JEV> Date/Time: 12/28/03 19:39:46
JEV> Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR
JEV> 1.1.4322)
>>> The statement <cfif (string1 OR string2 OR string3 OR
>>> string4) NEQ 1>CheckErgebnis = ''</cfif>
>>> is causing some problems (sometimes) because from time
>>> to time I get a syntax error in the update-statement.
DW>> That's not valid syntax in CF. When building a compound Boolean
JEV> condition
DW>> with the logical operators AND or OR, you must have a complete Boolean
DW>> condition before and after your logical operator:
DW>> <cfif string1 NEQ 1 OR string2 NEQ 1 ...
DW>> Dave Watts, CTO, Fig Leaf Software
DW>> http://www.figleaf.com/
DW>> phone: 202-797-5496
DW>> fax: 202-797-5444
DW>>
JEV>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
