You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi, i m using chosen multi select plugin in my project. it is working fine with adding new records in database table. but i m struggling with retrieving the records while i do edit. In my database table multi select values inserting with comma separator(eg: 2,3,4,). help assist me sort this issue
#3095
The text was updated successfully, but these errors were encountered:
joyalgeorgek123
changed the title
Hi, i m using chosen multi select plugin in my project. it is working fine with adding new records in database table.
Hi, i m using chosen multi select plugin in my project. it is working fine with adding new records in database table. but i m struggling with retrieving the records while i do edit. In my database table multi select values inserting with comma separator(eg: 2,3,4,). help assist me sort this issue
Jun 29, 2020
Here my question is why using for loop. No need to use loop. By default chosen multi select submit in array format accept in array on server and insert in table.
OR using Join method on server code create comma separated value and pass to procedure.
If you are passing comma separated value to your procedure then split there using split method and insert.
INSERT INTO EMPLOYEE_DETAIL
(EMPNAME,ADDRESS)
SELECT *,@address
FROM STRING_SPLIT(@EMPLOYEENAME, @Separator)
Use: STRING_SPLIT for SQL SERVER 2016 to 2019, for SQL SERVER 2014 or previous use:
SELECT split.a.value('.', 'VARCHAR(249)') AS Value FROM (SELECT Cast ('' + Replace(@Años, ',', '')+ '' AS XML) AS Data) AS A CROSS apply data.nodes ('/M') AS Split(a)
No description provided.
The text was updated successfully, but these errors were encountered: