Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: How to save/retrieve a dictionary object in SQLServer


Message #1 by kfernand@w... on Mon, 12 Aug 2002 22:18:44
See whether you could help me here:
I want to save/retrieve a dictionary object created in VBScript code in a 
field of a DB table.....similar to what MS Site Server(Commerece) does for 
the OrderForm. Usually table field/data type used here is OLEObject.
I know how to create the dictionary object and populate. I could save to 
DB too (insert gave an error, but getting a recordeset and adding a new 
record- then assigning the dictionary object using Set DIDN't GIVE AN 
ERROR! Whether it worked?... Only way I could test is retrieving it back.
I pulled the recordset using usual means, and use:
           Set  objDiction = rsRow("DicObject")

where rsRow is the recordset. But does not seem to get anywhere when I 
use to acess the populated fields in the dictionary object- No erros 
are given!
I have a hunch (from my C++ background) that I should type-cast the
reference to dictionary type, but this is VBScript- there are no types.
Could anybody who done this type of work pl help me?

  Return to Index