This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--_=_NextPart_001_01BFEAAC.DB4262B0
Content-Type: text/plain;
charset="iso-8859-1"
shouldn't this work?:
iif(IsDate(form.thedate),
PROTECTED]' [EMAIL PROTECTED]
Date: Monday, July 10, 2000 2:25 PM
Subject: RE: IIf() and DE confusion
This message is in MIME format. Since your mail reader does not
understand
this format, some or all of this message may not be legible.
--_=_NextPart_001_01BFEAAC.DB4262B0
Content-Type: text/plain
#IIF(IsDate(form.thedate), 'CreateODBCDate(form.thedate)', '''NULL''')#
Note the use of single and multiple quotes here in place of DE. Using DE
instead will look like one of these:
#IIF(IsDate(form.thedate), 'CreateODBCDate(form.thedate)', DE('NULL'))#
#IIF(IsDate(form.thedate),
Sorry, missed the use in the wrap. The code would actually be:
CFSET thedate=IIF(IsDate(form.thedate), 'CreateODBCDate(form.thedate)',
'''NULL''')
or
CFSET thedate=IIF(IsDate(form.thedate), 'CreateODBCDate(form.thedate)',
DE('NULL'))
CFSET thedate=IIF(IsDate(form.thedate),
: Monday, July 10, 2000 3:16 PM
Subject: Re: IIf() and DE confusion
#IIF(IsDate(form.thedate), 'CreateODBCDate(form.thedate)', '''NULL''')#
Note the use of single and multiple quotes here in place of DE. Using DE
instead will look like one of these:
#IIF(IsDate(form.thedate), 'CreateODBCDate
Dinowitz [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Monday, July 10, 2000 3:16 PM
Subject: Re: IIf() and DE confusion
#IIF(IsDate(form.thedate), 'CreateODBCDate(form.thedate)', '''NULL''')#
Note the use of single and multiple quotes here in place of DE. Using DE
instead
6 matches
Mail list logo