Insert a SQL generic micro field properties-CodePudding

To achieve if the applicant is xx, the integer field shows five others display 3,
The select SQR case when SQR=23 then '3' else '5' end AS '$field12437 $from formtable_main_199 where SQR=$currentuser $
Directly prompt syntax errors (23 is staff id, $field12437 $' is an integer field)
consult

CodePudding user response:

What is error message? Try the following code

 
Select 
23 then case when SQR='3' 
The else '5' end AS '$field12437 $' 
The from formtable_main_199 where SQR=$currentuser $

CodePudding user response:

reference 1/f, sun flower reply:

what error message? Try the following code

 
Select 
23 then case when SQR='3' 
The else '5' end AS '$field12437 $' 
The from formtable_main_199 where SQR=$currentuser $

DoFieldSQL (" select case when SQR=23 then '3' else '5' end AS '$12437 $'
The from formtable_main_199 where SQR=$wfcreater $"), the result is 0, but I was 23, should display 3

CodePudding user response:

Check the data types;
Query, also found out the SQR field

 

Select the SQR, 
23 then case when SQR='3' 
The else '5' end AS '$field12437 $' 
The from formtable_main_199 where SQR=$currentuser $

refer to the second floor qixifeifei response:

Quote: reference 1/f, sunny flowers response:
error message is what? Try the following code

Select
23 then case when SQR='3'
The else '5' end AS '$field12437 $'
The from formtable_main_199 where SQR=$currentuser $

DoFieldSQL (" select case when SQR=23 then '3' else '5' end AS '$12437 $'
The from formtable_main_199 where SQR=$wfcreater $"), the result is 0, but I was 23, should display 3 to

CodePudding user response:

sunny flowers reference 3 floor response:

check data types;
Query, also found out the SQR field
 

Select the SQR, 
23 then case when SQR='3' 
The else '5' end AS '$field12437 $' 
The from formtable_main_199 where SQR=$currentuser $
Quote: refer to the second floor qixifeifei response:

Quote: reference 1/f, sunny flowers response:
what error message? Try the following code

Select
23 then case when SQR='3'
The else '5' end AS '$field12437 $'
The from formtable_main_199 where SQR=$currentuser $

DoFieldSQL (" select case when SQR=23 then '3' else '5' end AS '$12437 $'
The from formtable_main_199 where SQR=$wfcreater $"), the result is 0, but I was 23, should display 3 to

Change is successful, the select case when $wfcreater $(23231), then '5' else in '3' end as' $12437 $but if not achieve the mobile end, this can change to move the code?

CodePudding user response:

Mobile client? Never comes to mobile end to things in work

CodePudding user response:

sunny flowers reference 5 floor response:

mobile end? Never comes to mobile end to things in work

Then I don't know why on the web side show score first, and then disappear, brush out again?

CodePudding user response:

I started not as' $$12437, a fraction, flash, disappeared

CodePudding user response:

Your problem, it's certainly not the SQL code you run directly, to add delay or blank space after the exit, I don't think what you said is the problem

refer to 7th floor qixifeifei response:

I started not as' $$12437, a fraction, flash, disappeared