Send Dictionary Object to Stored procedure?

[Shahid Juma]

Hi,

I was wondering before I proceed much further whether it is possible to pass
in the Dictionary object (Scripting.Dictionary) from ASP to a stored
procedure in SQL Server. Any sample sites or simple code examples would be
really great.

Thanks,
Shahid

[Ray Costanzo [MVP]]

I think you'd have to pull the values of out your dictionary object and pass
them.

Ray at home

"Shahid Juma" <sh*****************@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

Hi,

I was wondering before I proceed much further whether it is possible to
pass
in the Dictionary object (Scripting.Dictionary) from ASP to a stored
procedure in SQL Server. Any sample sites or simple code examples would be
really great.

Thanks,
Shahid

[Shahid Juma]

How about arrays? Can arrays be passed? The dictionary object has functions
that return the values as arrays.

Shahid

"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:%2****************@TK2MSFTNGP10.phx.gbl...

I think you'd have to pull the values of out your dictionary object and pass them.

Ray at home

"Shahid Juma" <sh*****************@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

Hi,

I was wondering before I proceed much further whether it is possible to
pass
in the Dictionary object (Scripting.Dictionary) from ASP to a stored
procedure in SQL Server. Any sample sites or simple code examples would be really great.

Thanks,
Shahid

[Ray Costanzo [MVP]]

Nope. You can join an array and then split it again in your stored
procedure, example:
http://vyaskn.tripod.com/passing_arr...procedures.htm

Ray at home

"Shahid Juma" <sh*****************@hotmail.com> wrote in message
news:eb*************@tk2msftngp13.phx.gbl...

How about arrays? Can arrays be passed? The dictionary object has
functions
that return the values as arrays.

Shahid

"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:%2****************@TK2MSFTNGP10.phx.gbl...

I think you'd have to pull the values of out your dictionary object and

pass

them.

Ray at home

"Shahid Juma" <sh*****************@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

> Hi,
>
> I was wondering before I proceed much further whether it is possible to
> pass
> in the Dictionary object (Scripting.Dictionary) from ASP to a stored
> procedure in SQL Server. Any sample sites or simple code examples would be > really great.
>
> Thanks,
> Shahid
>
>

[Aaron [SQL Server MVP]]

SQL Server does not understand what dictionary objects or arrays are. You
will have to flatten them into strings in order to pass them to a stored
procedure. One way is through comma-delimited lists:
http://www.aspfaq.com/2248

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Shahid Juma" <sh*****************@hotmail.com> wrote in message
news:#c**************@TK2MSFTNGP11.phx.gbl...

Hi,

I was wondering before I proceed much further whether it is possible to pass in the Dictionary object (Scripting.Dictionary) from ASP to a stored
procedure in SQL Server. Any sample sites or simple code examples would be
really great.

Thanks,
Shahid

[Bob Barrows [MVP]]

Shahid Juma wrote:

Hi,

I was wondering before I proceed much further whether it is possible
to pass in the Dictionary object (Scripting.Dictionary) from ASP to a
stored procedure in SQL Server. Any sample sites or simple code
examples would be really great.

Thanks,
Shahid

In addition to Aaron and Ray's suggestions, Erland has several other options
in his article about Arrays and Lists here:

http://www.sommarskog.se/index.html

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.