How to Add extra data in result set of cfquerry?

hey iam getting error when i use the QuerySetCell to add new row to it ...........

You'll have to use an array and the function queryAddColumn. An example follows.

Suppose I have a result set called myQuery. There are 5 rows in it. I wish to add 2 new columns to the query, on the fly. The column names are username(type varchar) and userID(type integer)

<!--- Create array corresponding to column username--->
<cfset usernameArray = ArrayNew(1)>
<cfset usernameArray[1] = "angelo@myDomain.com">
<cfset usernameArray[2] = "bkbk@myDomain.com">
<cfset usernameArray[3] = "carla@myDomain.com">
<cfset usernameArray[4] = "chris@myDomain.com">
<cfset usernameArray[5] = "mike@myDomain.com">

<!---
The next line adds the new column, username, to the query. That's it. Done.

The array indices correspond to the row numbers in the query.
The function queryAddColumn returns the column number for the newly added column
(in case you'll need it, which you usually wont ).
--->
<cfset columnNumber = queryAddColumn(myQuery, "username", "VarChar", usernameArray)>

<!--- Now, do the same for the next new column, userID  --->
<cfset userIDArray = ArrayNew(1)>
<cfset userIDArray[1] = "23">
<cfset userIDArray[2] = "121">
<cfset userIDArray[3] = "9">
<cfset userIDArray[4] = "76">
<cfset userIDArray[5] = "44">

<cfset columnNumber = queryAddColumn(myQuery, "userID", "integer", userIDArray)>