I haven't done much with binding, but can possibly offer some advice...
Presumably, you have an existing method that returns a query with all of the
columns from the table.
You can go one of two routes that I can think of...
1) create a new method that only queries the table for the single column
you're looking for. You can even get creative and pass in the column name
as an argument so that you can return a specific column.
2) create a new remote method that calls your existing method (the one that
returns all columns), and within that new method, do a QoQ (or if the query
only returns a single record, you can do myQuery.columnName[1] and return
that. The only drawback here is that you're still running a SELECT * when
all you really need is one specific column. But if you're only returning a
single record, the overhead shouldn't be noticeable.
On Mon, Apr 12, 2010 at 11:13 AM, Chad Baloga wrote:
>
> I am fairly new to CFCs and binding and have only used query returns with 1
> column. I was wondering how to bind to a cfinput with a certain column when
> my query is selecting * from a table.
>
> Thanks
>
>
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332846
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
