Hi...
Am working with asp.net with
vb for a MusicProject..
In this I have playlist for particular User..ie User Selects Some Songs and clicks on AddToMyPlayList Button....
Here He can insert those songs into a new playlist or update the earlier..
the StroedProcedure is as follws: 'N' means NewPlayList and 'E' means Existing
************************************************** *************************************
CREATE PROCEDURE MUSIC_ADD_PLAYLIST
(
@PLAYLIST_NAME VARCHAR(255),
@USER_ID VARCHAR(255),
@ItemList NVARCHAR(4000),
@delimiter CHAR(1),
@FOLDERNAME VARCHAR(255) ,
@PLAYLISTTYPE CHAR(1)
)
AS
SET NOCOUNT ON
DECLARE @IDENT INT
IF @PLAYLISTTYPE = 'N'
BEGIN
INSERT INTO MUSIC_PLAYLIST
(
MUSIC_PLAYLIST_NAME,
MUSIC_PLAYLIST_USER
)
VALUES
(
@PLAYLIST_NAME,
@USER_ID
)
SELECT @IDENT=@@IDENTITY FROM MUSIC_PLAYLIST
END
IF @PLAYLISTTYPE='E'
BEGIN
SELECT @IDENT=MUSIC_PLAYLIST_ID FROM MUSIC_PLAYLIST WHERE MUSIC_PLAYLIST_USER=@USER_ID AND MUSIC_PLAYLIST_NAME=@PLAYLIST_NAME
END
DECLARE @tempItemList NVARCHAR(4000)
SET @tempItemList = @ItemList
DECLARE @i INT
DECLARE @Item NVARCHAR(4000)
SET @tempItemList = REPLACE (@tempItemList, ' ', '')
SET @i = CHARINDEX(@delimiter, @tempItemList)
WHILE (LEN(@tempItemList) > 0)
BEGIN
IF @i = 0
SET @Item = @tempItemList
ELSE
SET @Item = LEFT(@tempItemList, @i - 1)
-- INSERT INTO @IDTable(Item) VALUES(@Item)
INSERT INTO MUSIC_SONGSLIST
(Music_PlayList_Id,Music_SongName,Music_Song_Locat ion)
VALUES
(@IDENT,@ITEM,@FOLDERNAME+'\'+@ITEM)
IF @i = 0
SET @tempItemList = ''
ELSE
SET @tempItemList = RIGHT(@tempItemList, LEN(@tempItemList) - @i)
SET @i = CHARINDEX(@delimiter, @tempItemList)
END
GO
************************************************** *************************************
Here the problem is am not getting the exact result means if i add 6 songs to a playlist it is adding only 4 songs to that particular playlist..
Please help me out
Thanks in Advance,
Madhavi
Problem with StoredProcedure
