Re: Iif() and StructKeyExist()

2003-02-23 Thread Jann VanOver
On 2/20/03 1:17 PM, "Aidan Whitehall" <[EMAIL PROTECTED]> wrote: > I've got an array of structures and am looping through them and writing > several queries on the fly. However, I can't hit on just the right > combination of quotation marks to stop it throwing an error. > > Does anyone know how t

RE: Iif() and StructKeyExist()

2003-02-22 Thread Aidan Whitehall
> I don't think you can use IIF in this case as IIF has > a habit of evaluating both results regardless of > whether it resolves to true or false. Even if > proximity doesn't exist, it will still evaluate > values[i]["proximity"]. Yeah, that's how it's starting to look. Well, thanks for the confir

RE: Iif() and StructKeyExist()

2003-02-21 Thread mark brinkworth
I don't think you can use IIF in this case as IIF has a habit of evaluating both results regardless of whether it resolves to true or false. Even if proximity doesn't exist, it will still evaluate values[i]["proximity"]. Cheers > > I've got an array of structures and am looping > through them

RE: Iif() and StructKeyExist()

2003-02-21 Thread David Collie (itndac)
would work Could be wrong... my 2 secs worth -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: 20 February 2003 21:18 To: CF-Talk Subject: Iif() and StructKeyExist() I've got an array of structures and am looping through them and writing several queries on the

Iif() and StructKeyExist()

2003-02-20 Thread Aidan Whitehall
I've got an array of structures and am looping through them and writing several queries on the fly. However, I can't hit on just the right combination of quotation marks to stop it throwing an error. Does anyone know how to write it correctly, outputting either null or the value surrounded by apos