@Mat'sMug look at this fiddle it looks like MySQL coerces an empty string to 0 automagically when casting it to decimal, so perhaps your whole case statement is not needed
You didn't give a terrible amount of code to be reviewed, and I am not really proficient in concurrency and the like but I still got a few points I want to make.
But enough of introduction let's jump into the code:
public class RWLockWrapper implements AutoCloseable {
Wonderful, concise and...
select
cast('316.73' as decimal(10,2))
+cast('0' as decimal(10,2))
+cast('770' as decimal(10,2))
-cast('2.25' as decimal(10,2))
-cast('0' as decimal(10,2))
-cast('13.24' as decimal(10,2))
-cast('2.86' as decimal(10,2))
-cast('15.15' as decimal(10,2)) Result
I just don't understand how fully grown adults can use .NET C# for SE, without any shame?
Have they any idea how dumb it is to use Microsoft to develop anything?
@skiwi not possible. this will be based on your origin/core-improvements. BUT, did you fetch from origin first? Because origin/core-improvements might be out of date.
I'm creating tool to add new virtualhost on UNIX-box.
One of tasks is to add a new user and database to MariaDB (aka MySQL) server.
In fact - this my first 'real' attempt to use OOP.
Here is class, which I created for it:
class mysqlUserDb:
warnings.filterwarnings('error')
def _...
The recommended way to avoid sqs injection attack are to use parameters.
Also I can recomend you to create a store procedure instead of using dynamic SQL.
You can pass your dropdowns indexes as parameters to your SP and use the old trick of using it as conditional on the where clause
Your selec...
It looks that I have just over-edited my own (first!) answer and got a comment:
Please try to keep the edits down to a minimal now. Thanks!
I was wondering what has just happened, searched a bit and found this question here:
... Every time you edit,
your question is bumped to the fron...
> Instead, the database will likely need to convert the varchar column to nvarchar for this query (which is a widening conversion that is guaranteed not to lose information). The problem is that it will need to do this for every row in your table.
^^ this is scary that a DBMS would be allowed to do that instead of throwing an error...
As of today, auto-CW conversion for posts has been disabled, therefore this request is now technically considered status-completed.
The full announcement can be viewed here. The first paragraph outlining this change is as follows:
No More Community Wiki Auto-Conversion
We have removed ...
@200_success sorry I didn't get back to you sooner about this. I saw new users giving less meaty answers and didn't pay much attention to the dates of their posting. I thought rather than let a bunch of people come in and post sub-par answers I would protect the question. do I need to revisit "When to Protect a question?"
https://gist.github.com/Sarahbravo/4e8104480b5285314f37
That is my code. It compiles, but nothing happens when it runs--I worry it is an issue with loading the txt files. Can someone take a look for me? I just don't know what's wrong...
Weird. How is it that if I have an ArrayList of one class, but I pass in an object of a different class for ArrayList.contains(), the program still displays the correct results? All it tells me in the tooltip that my call is suspicious.
No, I'm not actually keeping this code in my program. I was just testing it out.
How sweet of my wife... I walked into my office, and found on my desk a copy of Mostly Harmless - The fifth book in the increasingly inaccurately named Hitchhikers Trilogy
Yes, the type information of the argument to contains is just 'Object, and one null object always compares as equals to another null object, regardless of their type.
@rolfl if you were interviewing someone for a java job, what's a sort of "if you don't know this, don't bother continuing with the interview" question you might ask them?
i ask with an interview coming up, and a cursory knowledge of java
@rolfl It turns out that I had left some other code in, hence why it still seemed to work. facepalm I guess it's a good thing that this is a partner assignment.
You didn't give a terrible amount of code to be reviewed, and I am not really proficient in concurrency and the like but I still got a few points I want to make.
But enough of introduction let's jump into the code:
public class RWLockWrapper implements AutoCloseable {
Wonderful, concise and...
I just don't understand how fully grown adults can use .NET C# for SE, without any shame?
Have they any idea how dumb it is to use Microsoft to develop anything?
The recommended way to avoid sqs injection attack are to use parameters.
Also I can recomend you to create a store procedure instead of using dynamic SQL.
You can pass your dropdowns indexes as parameters to your SP and use the old trick of using it as conditional on the where clause
Your selec...
It looks that I have just over-edited my own (first!) answer and got a comment:
Please try to keep the edits down to a minimal now. Thanks!
I was wondering what has just happened, searched a bit and found this question here:
... Every time you edit,
your question is bumped to the fron...
As of today, auto-CW conversion for posts has been disabled, therefore this request is now technically considered status-completed.
The full announcement can be viewed here. The first paragraph outlining this change is as follows:
No More Community Wiki Auto-Conversion
We have removed ...
https://gist.github.com/Sarahbravo/4e8104480b5285314f37
That is my code. It compiles, but nothing happens when it runs--I worry it is an issue with loading the txt files. Can someone take a look for me? I just don't know what's wrong...
