House of Fusion
Search over 2,500 ColdFusion resources here
  
Home of the ColdFusion Community

Mailing Lists
Home /  Groups /  ColdFusion Talk (CF-Talk)

query object error

  << Previous Post |  RSS |  Sort Oldest First |  Sort Latest First |  Subscribe to this Group Next >> 
Top  |   Reply  |   Original Post  |   RSS Feed  |   Subscribe to this Group
Author:
Kamru Miah
06/30/2009 06:49 AM

I am using CF8 and I have a query object (with 1 record) called 'role' with the following 4 column names: groups, positions, role and teams. I wish to work around a problem by inserting a value ('homeCla') to the 'positions' column/cell. Using <cfset Temp = QuerySetCell(role, 'positions', 'homeCla')> gives me the following error (note that cfdump does show the query exists!): 'The object (coldfusion.runtime.Struct) is not an query object.' Any ideas how I can over come this problem please? Thanks in anticipation.

Top  |   Parent  |   Reply  |   Original Post  |   RSS Feed  |   Subscribe to this Group
Author:
Adrian Lynch
06/30/2009 07:02 AM

Could you show more of your code. This works for me. Oh and you don't need to assign to a temp var when using QuerySetCell. Adrian ----- Excess quoted text cut - see Original Post for more -----

Top  |   Parent  |   Reply  |   Original Post  |   RSS Feed  |   Subscribe to this Group
Author:
Kamru Miah
06/30/2009 07:13 AM

I just realised that the 'role' query form a include file is returntype="struct", and  not returntype="query" - dah! So now the question is, how do I insert a value to the 'positions' cell of the structure, please? >Could you show more of your code. This works for me. > >Oh and you don't need to assign to a temp var when using QuerySetCell. > >Adrian

Top  |   Parent  |   Reply  |   Original Post  |   RSS Feed  |   Subscribe to this Group
Top  |   Parent  |   Reply  |   Original Post  |   RSS Feed  |   Subscribe to this Group
Author:
Kamru Miah
06/30/2009 08:00 AM

Thanks - problem solved (and simpler than StuctUpdate, too!) :-) ><cfset role.positions = "your value">


<< Previous Thread Today's Threads Next Thread >>

Search cf-talk

May 24, 2012

<<   <   Today   >   >>
Su Mo Tu We Th Fr Sa
     1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31     

Designer, Developer and mobile workflow conference