April 24th, 2003, 07:54 AM
Join Date: Apr 2003
Location: Shimonoseki / JAPAN
Time spent in forums: 4 m 4 sec
Reputation Power: 11
I cannot use variable to call a member of recordset. Plz look
Lets say I have created a Recordset named MySET.
And I have a value passed from a form: Request.Form.Key(1)
Response.Write MySET("member") --> Prints George to screen
Response.Write Request.Form.Key(1) --> Prints member to screen
Val = Request.Form.Key(1)
Response.Write Val ---> Prints member to screen
Response.Write Myset(Val) ---> Returns This error:
ADO Could not find the object in the collection corresponding to the name or ordinal reference requested by the collection.
Now we are sure that value of the Val is "member" Why is this not working?
I am going to go mad!!! Please help!
Sweet smell of a great sorrow lies over the land. Plumes of smoke rise, merge into the leaden sky. A man lies and dreams of green fields and rivers, but awakes to a morning with no reason for waking. He's haunted by the memory of lost paradise. In his youth or dream, he can't be precise. He's chained forever to a world that's departed. It's not enough, it's not enough.