Passing one row of a query to a function

> myQuery.getRow(), but
> using undocumented functions make me nervous.

I absolutely agree, as a standard "caveat emptor" sort of thing. Which is
a shame because there's a wealth of functionality "under the hood" which is
far more useful than the "official" approach to things.

To be honest, I treat the whole "that stuff is 'not supported'" and "it
could change in future versions" thing with a liberal amount of salt.

1) I didn't find the support from Macromedia very accessible in the first
place, and have no reason to think it will be any different with Adobe.
Other than in emergencies (that'd be once, in eight years), I have never
used official support;

2) I've been watching a lot of the "undocumented" stuff for a few versions
(like since 6.1), and it all still works;

3) I've had more problem with "fixes" to CFML issues breaking workarounds
of the same than I have with using undocumented code. Obviously that's
because I have 1000 lines of "normal" code to every line of "undocumented"
code I use, but still.

Basically when one changes version of software, there's a chance your code
will stop working. It doesn't seem any more risky to me to use
undocumented features than documented ones.

Food for thought, if nothing else.

:-)

--
Adam

Adams suggestion is pretty neat - I didn't know about myQuery.getRow(), but using undocumented functions make me nervous. If you really wanted to accomplish this using standard CF functions you could do something like this:

1) Dynamically retrieve a list of columns using qMyQuery.ColumnList
2) Loop over columns and retrieve column values for the current row using qMyQuery[ColumnListItem][Row]
3) Using the above techniques, build a CF structure where each key is a column in the query and the key value is the query field/row value
4) Pass the results of (3) into a UDF.

But that seems like a lot of work.

You can do this:

myQuery.getRow(n)

where n is the *zero* indexed row reference.

This will return an object of type coldfusion.sql.imq.Row, which has a
method getColumn(), which likewise takes a zero-indexed reference to the
column you want.

Pls note: this is "leveraging" the internal workings of CF, and is not
documented, encouraged or supported by Adobe. However it does what you
want.

I've tested it on CFMX7.0.2 and CF8.

To be honest, I'd simply pass the whole query (which is done by reference,
so there's not much overhead there), and the row you want as two separate
arguments, then using query["column"][row] notation to access the bits you
want.

--
Adam

quote:

---

Originally posted by: mthyvold
I want to pass a query into a function one row at a time in the same way you could pass an array to a function one row at a time. I've read that queries are just CF structures under the hood so I believe it should be possible. I just don't know the syntax to reference a single query row (and all it's variables).

I don't want to pass the whole query to the variable because I would like to do the looping outside the function. The idea is to simplify and standardize the formatting and arrangement of several variables (columns) in a UDF and keep the syntax to use the function simple. Therefore, I'd like to avoid having to do stuff like convert the query to an array. That would defeat the goal of keeping it simple.

Thanks
Magnus

---

Your plan of sending one row at a time will not achieve your objective of keeping the syntax to call the function simple.

one way would be:
<cfoutput query="yourquery">
call your function here: it will be called for each query row
</cfoutput>

another way would be using array notation: queryname.columnname[rownumber]
you will have to reference and pass each query column individually like
that, so if you want to pass a full query row use the first method

hth

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/