[Solved] How I solve this questions?

by

You have to use GROUP BY command : SELECT id_unit, COUNT(*) FROM order_amount GROUP BY id_unit; Results : id_unit COUNT(*) kg 40 m3 30 pal 30 After if you want to display for each order your script will be : SELECT m.id_order, (select count(*) from order_amount m2 where m2.id_order = m.id_order and m2.id_unit=”kg”) as num_kg, … Read more

[Solved] ACCEPT ELEMENTS IN A LINKED LIST IN ASCENDING ORDER,but the display function prints the smallest number instead of the whole linked list

by

ACCEPT ELEMENTS IN A LINKED LIST IN ASCENDING ORDER,but the display function prints the smallest number instead of the whole linked list solved ACCEPT ELEMENTS IN A LINKED LIST IN ASCENDING ORDER,but the display function prints the smallest number instead of the whole linked list

[Solved] In Python find and extract only required info [closed]

by

>>> data = “”” ============================ coaza077-cor-01> show module Status and Counters – Module Information Chassis: 2900-24G J9049A Serial Number: SG748KI09F Slot Module Description Serial Number —– —————————————- ————– coaza077-cor-01> exit Do you want to log out [y/n]? y ============================= “”” >>> chasis = data.split(‘Chassis:’)[1].split(‘Serial’)[0].strip() >>> serial = data.split(‘Serial Number:’)[1].split()[0].strip() >>> >>> print chasis 2900-24G J9049A … Read more

[Solved] Is a = b == c possible to write in c#?

by

Yes, but why didn’t you just try it? And not only is it possible to write it, but it’s actually legal C#. It will assign the value of the boolean expression b == c to the variable a, which I’m assuming you declared, implicitly or explicitly, as bool. Stylistically, I prefer to see a = … Read more

[Solved] Local function definitions are illegal

by

main is the entry point function for a console app. It must be in global scope. You cant nest functions inside of other functions anyway. Try something more like this instead: BOOL CBasicApp::InitInstance() { typedef BOOL (__stdcall *pFunc)(); HMODULE hMod = LoadLibrary(“dbgghelp.dll”); if (!hMod) { printf(“Error loading dbgghelp.DLL\n”); return FALSE; } pFunc pf = GetProcAddress(hMod, … Read more

[Solved] string matching using regular expressions in java

by

I think this one should do the trick: ^(?!000|666|9\d{2})\d{3}-\d{2}-\d{4}$ Edit: I find the negative look-ahead syntax in this thread. Edit 2: Here is a little code snippet for those who want to test it: import java.util.Scanner; import java.util.regex.Matcher; import java.util.regex.Pattern; public class Main { public static void main(String[] args) { Pattern pattern = Pattern.compile(“^(?!000|666|9\\d{2})\\d{3}-\\d{2}-\\d{4}$”); Scanner … Read more

[Solved] Dynamic Char Allocation [closed]

by

You are not managing your buffers correctly, not even close. In fact, there are a LOT of mistakes in your code. Every one of your sizeof() calls is wrong. You are leaking buffer, tmp, and data on every loop iteration. You are using strcat() incorrectly. And worse, you are processing binary audio data using string … Read more

[Solved] swift if statement

by

Something like the following? if message.ReceiverId != self.loggedInUserUid { var newVariable = message.ReceiverId } else if message.senderId != self.loggedInUserUid { var newVariable = message.senderId } 0 solved swift if statement

[Solved] Java File.renamTo not working

by

first of all, you should use the path separator / . It’s work on Windows, Linux and Mac OS. This is my version of your problem to rename all files into a folder provide. Hope this will help you. I use last JDK version to speed up and reduce the code. public class App { … Read more