1
Answer

Read comma delimited value from sql and retrieve folder

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)