every needs a good tool :-) On Thu, Jun 30, 2011 at 11:04 PM, Bryan Stevenson < br...@electricedgesystems.com> wrote:
> > Yes I was ;-) > > ...and don't forget to read my whole post....here's the piece you > missed... > > > ....but it's sort of > > > > cheating because you do it using functions....you can't set it directly > > > as was shown in this thread. > > > So I already stated I was being a tool....I try and do that so others don't > need to point it out ;-) > > Happy Almost Canada Day!! > > cheers > > > On Thu, 2011-06-30 at 22:59 +0100, Russ Michaels wrote: > > > That is just being Pedantic Bryan :-) > > > > clearly it was meant you cannot do > > <cfset query.column = value> > > > > > > > > On Thu, Jun 30, 2011 at 10:48 PM, Bryan Stevenson < > > br...@electricedgesystems.com> wrote: > > > > > > > > Well there is a slight nuance there.....you can use CFET to set the > > > value of a column in a specific row of a query....but it's sort of > > > cheating because you do it using functions....you can't set it directly > > > as was shown in this thread. > > > > > > <cfset myQuery = queryNew("column1")> > > > <cfset x = queryAddRow("myQuery")> > > > <cfset x = querySetCell("myQuery","column1","blah blah blah")> > > > > > > There I set the value of a column in a query to blah blah blah using > > > CFSET ;-) > > > > > > ...and my example code may have some syntax issues, bu ya get the gist. > > > > > > OK...back under my rock now! > > > > > > Cheers > > > -- > > > > > > > > > Bryan Stevenson B.Comm. > > > VP & Director of E-Commerce Development > > > Electric Edge Systems Group Inc. > > > phone: 250.480.0642 > > > fax: 250.480.1264 > > > cell: 250.920.8830 > > > e-mail: br...@electricedgesystems.com > > > web: www.electricedgesystems.com > > > > > > Notice: > > > This message, including any attachments, is confidential and may > contain > > > information that is privileged or exempt from disclosure. It is > intended > > > only for the person to whom it is addressed unless expressly authorized > > > otherwise by the sender. If you are not an authorized recipient, please > > > notify the sender immediately and permanently destroy all copies of > this > > > message and attachments. > > > Please consider the environment before printing this e-mail > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346014 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm