Jieha Lee

Jieha Lee

  • 1.5k
  • 186
  • 9k

Read comma delimited value from sql and retrieve folder

May 20 2019 1:25 AM
How to retrieve audio record in specific folder based on fileName(in sql server) which is the records save as comma delimited value and indicate file name in folder(example: 100,0,0,1,5 indicate 100.wav, 0.wav, 0.wav, 1.wav, 5wav) and after the audio being play the status change into '1'
 
 
id   |    fileName    |     Date      |  Status
1    | 100,0,0,1,5   |  14-05-19  |      1
2    | 100,0,0,2,5   |  14-05-19  |      1
3    | 100,1,0,1,2   |  19-05-19  |      0
4    | 100,1,1,1,5   |  19-05-19  |      0
5    | 200,1,0,1,1   |  19-05-19  |      0
 
 
Thanks

Answers (1)