AIL PROTECTED]]
Sent: Wednesday, May 29, 2002 8:12 PM
To: CF-Talk
Subject: RE: Help with using query with [] notation
Hey Dave,
I have waited for a while for this :) You can do this:
myQuery['col_id']['rowNumber']
On CF 4.5 on Solaris at least. It als
f a numeric column
#ArrayToList(MyQuery["MyField"])# seems to be identical to
#ValueList(MyQuery.MyField)#
Curious!
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 30 May 2002 2:42 p.m.
> To: CF-Talk
> Subject: RE: Help w
> I am sorry, I was bad there. I am just so in awe of you that
> it was nice to think I knew someting for once :)
No need to apologize - I'm sure you know many things I don't know! Anyway,
you didn't insult me or anything like that, so don't worry.
Dave Watts, CTO, Fig Leaf Software
http://www.
Your right, I do need to get out more, but I still have som much to learn!!
Tim
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 10:39 PM
To: CF-Talk
Subject: RE: Help with using query with [] notation
> I have waited for a while for t
> and you can even write
>
> #ArrayMax(MyQuery["FieldName"])#
>
> if FieldName is a numeric column. Cool huh?
That is pretty cool, and I haven't seen that before. However, I suspect it
may not work in versions of CF prior to 4.5.1, so if you're writing code
that may run on an old server, be car
> I have waited for a while for this :)
That probably means you need to get out more!
> You can do this:
>
> myQuery['col_id']['rowNumber']
Yes, you certainly can. However, if you omit the array position, you'll get
an error - at least, that's been my experience. That is, if you do this:
ect * from guestbook
#getStuff[i][ii]#
#getStuff['cFirstName'][3]#
Tim
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 10:05 PM
To: CF-Talk
Subject: RE: Help with using query with [] notation
> I know it's possible to
#getStuff['cFirstName'][3]#
Tim
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 10:05 PM
To: CF-Talk
Subject: RE: Help with using query with [] notation
> I know it's possible to do something like this:
> My
; -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 30 May 2002 2:05 p.m.
> To: CF-Talk
> Subject: RE: Help with using query with [] notation
>
>
> > I know it's possible to do something like this:
> > MyQuery["FieldN
> I know it's possible to do something like this:
> MyQuery["FieldName"] (I know it's probably wrong, but
> serves the purpose here)
For the record, you can't do that, but you can do this:
MyQuery.FieldName[i]
to reference the column value at row i.
> The CF Documentation does mention th
I know it's possible to do something like this:
MyQuery["FieldName"] (I know it's probably wrong, but serves the
purpose here)
The CF Documentation does mention this somewhere, but doesn't really go into
detail. Does anyone know of any good links, articles, or resources that
describe this i
11 matches
Mail list logo