|
Mailing Lists
|
Home /
Groups /
ColdFusion Talk (CF-Talk)
query object error
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.Kamru Miah 06/30/09 06:49 A Could you show more of your code. This works for me.Adrian Lynch 06/30/09 07:02 A I just realised that the 'role' query form a include file is returntype="struct", and not returntype="query" - dah!Kamru Miah 06/30/09 07:13 A <cfset role.positions = "your value">Adrian Lynch 06/30/09 07:28 A Thanks - problem solved (and simpler than StuctUpdate, too!) :-)Kamru Miah 06/30/09 08:00 A 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. 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 ----- 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 <cfset role.positions = "your value"> ----- Excess quoted text cut - see Original Post for more ----- Thanks - problem solved (and simpler than StuctUpdate, too!) :-) ><cfset role.positions = "your value">
|
May 24, 2012
|
Latest Fusion Authority Articles
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||