Click here to Skip to main content
15,907,687 members

Comments by Mtag Gaming (Top 5 by date)

Mtag Gaming 11-Mar-22 3:39am View    
copy that
Mtag Gaming 10-Mar-22 16:47pm View    
dbquery("SET @num = (SELECT COUNT(*) AS num FROM dispatchersonduty); UPDATE signal100 SET signal100 = CASE WHEN @num > 0 THEN signal100 ELSE 0 END;" , false);
Mtag Gaming 10-Mar-22 15:37pm View    
okay, its in the code and I'm still getting the error
Mtag Gaming 10-Mar-22 14:35pm View    
I don't know why its there on my code I don't have a semi-colon after end

dbquery("SET @num = (SELECT COUNT(*) AS num FROM dispatchersonduty); UPDATE signal100 SET signal100 = CASE WHEN @num > 0 THEN signal100 ELSE 0 END" , false);
Mtag Gaming 10-Mar-22 9:55am View    
dbquery("SET @num = (SELECT COUNT(*) AS num FROM dispatchersonduty); UPDATE signal100 SET signal100 = CASE WHEN @num > 0 THEN signal100 ELSE 0 END", false);