adding a record to a query object

[Dan Farmer]

I have a query that I wish to add to in the second position. Say if I wanted
to add a second element to the object "MyQuery". How would that be done?

<cfquery name="MyQuery">
   select fristname, lastname from tbl_names
</cfquery>

Now if I wanted to add another item to the 2nd position of that query how
would this be accomplished?

here's my code. I'm not sure it's working.

<cfset MyQuery["firstname"][2] = "SomeFirstname">
<cfset MyQuery["lastname"][2] = "SomeLastname">

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---