The aliases you give are for the output of the query – they are not available within the query itself. You can either repeat the expression: SELECT neededfield, CONCAT(firstname, ‘ ‘, lastname) as firstlast FROM users WHERE CONCAT(firstname, ‘ ‘, lastname) = “Bob Michael Jones” or wrap the query SELECT * FROM ( SELECT neededfield, … Read more
An in statement will be parsed identically to field=val1 or field=val2 or field=val3. Putting a null in there will boil down to field=null which won’t work. (Comment by Marc B) I would do this for clairity SELECT * FROM tbl_name WHERE (id_field IN (‘value1’, ‘value2’, ‘value3’) OR id_field IS NULL)
This works: switch (true) { case liCount == 0: setLayoutState(‘start’); var api = $(‘#UploadList’).data(‘jsp’); api.reinitialise(); break; case liCount<=5 && liCount>0: setLayoutState(‘upload1Row’); var api = $(‘#UploadList’).data(‘jsp’); api.reinitialise(); break; case liCount<=10 && liCount>5: setLayoutState(‘upload2Rows’); var api = $(‘#UploadList’).data(‘jsp’); api.reinitialise(); break; case liCount>10: var api = $(‘#UploadList’).data(‘jsp’); api.reinitialise(); break; } The only thing necessary is switch(true){…} and for … Read more
Python 3.3 and above Python 3.3 introduced contextlib.ExitStack for just this kind of situation. It gives you a “stack”, to which you add context managers as necessary. In your case, you would do this: from contextlib import ExitStack with ExitStack() as stack: if needs_with(): gs = stack.enter_context(get_stuff()) # do nearly the same large block of … Read more
one way to do this would be to use indexing with .loc. Example In the absence of an example dataframe, I’ll make one up here: import numpy as np import pandas as pd df = pd.DataFrame({‘c1’: list(‘abcdefg’)}) df.loc[5, ‘c1’] = ‘Value’ >>> df c1 0 a 1 b 2 c 3 d 4 e 5 … Read more
Conditionals work if they’re structured correctly, I ran into this issue and figured it out. For conditionals, the tag before else has to be paired with the end tag of the previous if otherwise the statements will evaluate separately and produce an error. ERROR! <% if(true){ %> <h1>foo</h1> <% } %> <% else{ %> <h1>bar</h1> … Read more
Your first step in these kinds of problems is always to make a logic table. A | B | Result ——————- T | T | do action C T | F | … F | T | do action C F | F | do action C Once you’ve made the table, the solution is … Read more
From http://www.sitepoint.com/javascript-truthy-falsy/ The following values are always falsy: false 0 (zero) 0n (BigInt zero) “” (empty string) null undefined NaN (a special Number value meaning Not-a-Number!) All other values are truthy, including “0” (zero in quotes), “false” (false in quotes), empty functions, empty arrays ([]), and empty objects ({}). Regarding why this is so, I … Read more
Not in the traditional sense, but you can use classes for this, if you have access to the HTML. Consider this: <p class=”normal”>Text</p> <p class=”active”>Text</p> and in your CSS file: p.normal { background-position : 150px 8px; } p.active { background-position : 4px 8px; } That’s the CSS way to do it. Then there are CSS … Read more