You can pass an string and Exec() it (or call sp_executesql)

The question is: why?!? Sounds like a security problem waiting to happen...

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <william.sze@s...>
Subject: [asp_web_howto] Dunamic No. of parameter variables


: Any idea / sample to write a stored procedure in MS SQL server to accept
: dynamic no. of parameter from ASP?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Also, you can write the sp to accept null param's.

tom mallard
seattle

-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Sunday, June 30, 2002 11:26 PM
To: ASP Web HowTo
Subject: [asp_web_howto] Re: Dunamic No. of parameter variables


You can pass an string and Exec() it (or call sp_executesql)

The question is: why?!? Sounds like a security problem waiting to happen...

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <william.sze@s...>
Subject: [asp_web_howto] Dunamic No. of parameter variables


: Any idea / sample to write a stored procedure in MS SQL server to accept
: dynamic no. of parameter from ASP?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20