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