Welcome Guest, Not a member yet? Register   Sign In
update_batch is not working !
#1

Hi there ,

I am facing a problem with update batch function

 it is showing the following query which is error !!

i am using the 3.1.2


Code:
UPDATE `sd_settings` SET

`s_setting` = CASE
WHEN `s_setting` =  THEN 'default_lang'
WHEN `s_setting` =  THEN 'reg_mode'
WHEN `s_setting` =  THEN 'site_offline'
WHEN `s_setting` =  THEN 'refresh'
WHEN `s_setting` =  THEN 'login_token'

ELSE `s_setting` END,

`s_value` = CASE
WHEN `s_setting` =  THEN 'ar'
WHEN `s_setting` =  THEN 'all'
WHEN `s_setting` =  THEN '0'
WHEN `s_setting` =  THEN '66'
WHEN `s_setting` =  THEN 'r34zn16'

ELSE `s_value` END
WHERE `s_setting` IN(,,,,)


can anyone help please ?


Messages In This Thread
update_batch is not working ! - by khashabawy - 12-04-2016, 11:23 AM
RE: update_batch is not working ! - by ajdunn - 12-04-2016, 10:04 PM
RE: update_batch is not working ! - by khashabawy - 12-05-2016, 12:51 AM
RE: update_batch is not working ! - by 330Root - 12-05-2016, 02:05 PM
RE: update_batch is not working ! - by matrox445 - 12-09-2016, 06:09 AM
RE: update_batch is not working ! - by Narf - 12-12-2016, 05:21 AM



Theme © iAndrew 2016 - Forum software by © MyBB