RE: Help with using query with [] notation

2002-05-30 Thread Shawn Grover
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

RE: Treating queries as arrays (was Help with using query with [] notation)

2002-05-29 Thread Matthew Walker
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

RE: Help with using query with [] notation

2002-05-29 Thread Dave Watts
> 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.

RE: Help with using query with [] notation

2002-05-29 Thread Timothy Heald
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

RE: Help with using query with [] notation

2002-05-29 Thread Dave Watts
> 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

RE: Help with using query with [] notation

2002-05-29 Thread Dave Watts
> 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:

RE: Help with using query with [] notation

2002-05-29 Thread Timothy Heald
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

RE: Help with using query with [] notation

2002-05-29 Thread Timothy Heald
#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

RE: Help with using query with [] notation

2002-05-29 Thread Matthew Walker
; -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

RE: Help with using query with [] notation

2002-05-29 Thread Dave Watts
> 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

Help with using query with [] notation

2002-05-29 Thread Shawn Grover
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