New Topic/Question
Reply
Hi, I am working on a sharepoint aspx page where i need to select multiple values from a listbox and insert them into the table . I am using a sql datasource which runs an insertquery something like: Insert into mentornotecategory values[noteid,category] select max(noteid) from table2,@category . it runs fine when i have only one selected value but i need to make it work for multiple selections keeping noteid the same and different category depending upon selection from listbox.
can anybody help. Thanks
4 Replies - 1306 Views - Last Post: 26 August 2012 - 06:34 AM
Rate Topic:
MultiQuoteReplies To: Using listbox to enter multiple values with same id into the sql table
#3
sahilwest
- New D.I.C Head
Reputation: 0
- Posts: 3
- Joined: 23-August 12
Re: Using listbox to enter multiple values with same id into the sql table
Posted 25 August 2012 - 12:02 PM
Nakor, on 24 August 2012 - 06:08 PM, said:
so all of the selections should have the exact same note id?
Yes they should have the same noteid but different category according to selection from list box
Was This Post Helpful?
0
#5
sahilwest
- New D.I.C Head
Reputation: 0
- Posts: 3
- Joined: 23-August 12
Re: Using listbox to enter multiple values with same id into the sql table
Posted 26 August 2012 - 06:34 AM
Nakor, on 25 August 2012 - 03:14 PM, said:
can you show the code you're using for the entire process right now?
Sure let me get to work tomorrow I will post the code
Was This Post Helpful?
0
Page 1 of 1
|
|
| 