August 6, 2004 at 12:17 am
Hi,
I am selecting a group of items from a listbox.How to pass those values as an array to the stored procedure
with regds,
kr
August 6, 2004 at 2:08 am
I passed the Ids of the listbox options as a VARCHAR and had a function to take that delimited list and return it as a table.
I could then join the resulting table to retrieve/update/delete records.
August 6, 2004 at 10:16 am
if the values are in a list box, then put them in a small table
and have the stored procedure just join to the table.
One example would be
create table ListSelect (
Item varchar(10), UseMe bit )
When they select an item in the list box, toggle the Useme field
and your stored procedure would
select * from maintable
inner join ListSelect on ListSelect.Item = MainTable.item and useme = 1
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply