Problem with Multiple rows retrieval from mySQL and save it some variable

[Dejavu]

Scenario:

Code:

SELECT param.parameter_name, op.parameter_value FROM t_automation_parameters AS param, t_automation_op AS op WHERE op.parameter_id = param.parameter_id AND op.order_id = (received_order_id)

Need to use the above query for mysql db which wud give me multiple rows and 2 columns. A key value kind of pairing.

e.g. Key”Manu”, Value”123456789”
Key”Adi”, Value”987654321”

I need to store it some variables but the key value pairing shud be intact and den wud work on the data and again need to update them in the DB.

[basanth27]

Use Dictionary objects.

Code:

set objGeneralDictionary=CreateObject("Scripting.Dictionary") objGeneralDictionary.Add "Item", "Key"