Re: IIF help

2006-04-16 Thread Rick Root
Mingo Hagen wrote: no quotes in the first argument. thanks everyone.. the quotes were the issue. Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237846 Archives:

RE: IIF help

2006-04-14 Thread Everett, Al \(NIH/NIGMS\) [C]
Try this: cfset request.dirsep = iif(FindNoCase(windows,server.os.name),de(/),de(\)) Al Everett (Contractor) DIGICON Corporation National Institute of General Medical Science Information Resources Management Branch [EMAIL PROTECTED] 301.594.4082 -Original Message- From: Rick Root

Re: IIF help

2006-04-14 Thread Douglas Knudsen
cfset request.dirsep = iif(lcase(server.os.name) contains 'windows','/','\') try that, eh? Also, no need for DE(), just use all teh quotes luke! ' foo ' like that DK On 4/14/06, Rick Root [EMAIL PROTECTED] wrote: I always have trouble using IIF... Why doesn't this work? cfset

Re: IIF help

2006-04-14 Thread Mingo Hagen
iif( lcase(server.os.name) contains 'windows', de( \ ), de( / ) ) no quotes in the first argument. -- Met vriendelijke groet / Kind regards Mingo J. Hagen. E-Line Websolutions B.V.Herenweg 160 2101 MT Heemstede phone: +31620 775444 fax: +3123 5471920 fax [mingo]: +3184

RE: IIF help

2006-04-14 Thread Andy Matthews
Rick... It appears you've got quotes around your expression. Remove those and you should be good. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Rick Root [mailto:[EMAIL

RE: IIF() HELP!!!

2001-10-31 Thread Mike Townend
AFAIK the IIF tag evaluates both the true and the false sections as the function is processed... The best thing to do would be cfparam the variable and check to see if it contains data. CFPARAM NAME=FORM.classCodeID DEFAULT= #IIF(Len(FORM.classCodeID), DE(#FORM.classCodeID#), DE(ALL))#

RE: IIF() HELP!!!

2001-10-31 Thread Tyler M. Fitch
I ran into this just yesterday. The issue seems to be that since this is a CF function and not a tag it processes it inside out. Not the same as a CFIF where it will skip elements of the if statement should it be false. The IIF prepares the two DE arguments before it evaluates it's conditional

Re: IIF() HELP!!!

2001-10-31 Thread James Sleeman
Ok, it's not a problem as such, just the way functions work... before IIF can be run (before any function can be run) all the arguments must be resolved, the second argument in your example may not be resolved because FORM.classCodeID may not exist. The correct way to write this...

RE: IIF Help

2001-10-23 Thread Philip Arnold - ASP
Can someone Please help me with this one. #iif((dateformat(i, mm-dd-yy) eq (dateformat(qrygetusers1.we_date, mm-dd-yy)), de(checked), de())# #iif((dateformat(i, mm-dd-yy) eq (dateformat(qrygetusers1.we_date, mm-dd-yy)), de(checked), de())# With the quotes around the dateformat, you're

RE: IIF Help

2001-10-21 Thread Bill Holloway
I'd do a dateCompare() or a dateDiff() rather than messing with the dateFormat(). Something like: #iif( NOT dateCompare(i, qrygetusers1.we_date), DE('checked'), DE('')# HTH, Bill -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 17, 2001 6:22 AM

Re: IIF Help

2001-10-21 Thread James Sleeman
At 02:22 AM 10/18/2001, you wrote: Can someone Please help me with this one. #iif((dateformat(i, mm-dd-yy) eq (dateformat(qrygetusers1.we_date, mm-dd-yy)), de(checked), de())# what was with the extra quotes and brackets ? this looks better... #iif(dateformat(i, mm-dd-yy) eq