Try this: DECLARE @SUM VARCHAR(50)=’33.90′; SELECT CAST(CAST(LEFT(@SUM,CHARINDEX(‘.’,@SUM,0)-1) AS INT)+ CAST(SUBSTRING(@SUM,CHARINDEX(‘.’,@SUM,0)+1,LEN(@SUM)) AS INT)/60 AS VARCHAR(10))+’.’+ CAST(CAST(SUBSTRING(@SUM,CHARINDEX(‘.’,@SUM,0)+1,LEN(@SUM)) AS INT)%60 AS VARCHAR(10)) result: 34.30 1 solved How to convert the Varchar of sum to time using sql server 2008 [closed]
The short answer: #a.+#((([A-Za-z]{3,9}:(?:\/\/)?)(?:[\-;:&=\+\$,\w]+@)?[A-Za-z0-9\.\-]+|(?:www\.|[\-;:&=\+\$,\w]+@)[A-Za-z0-9\.\-]+)((?:\/[\+~%\/\.\w\-_]*)?\??(?:[\-\+=&;%@\.\w_]*)#?(?:[\.\!\/\\\w]*))?) This will match any character except line breaks in the content section, and should match any url. NOTE: You will have to escape all backslashes in the given regex to represent it as a java String literal. Sources for the url regex: What is the best regular expression to check if … Read more
This part is pretty easy because you’re able to run LINQ queries on IEnumerable<T> – in other words, anything that you can do a foreach loop on is something that you can query. And there are a great many ways to do that. First, however, I’m assuming that you already know the schema for the … Read more
Try this EDITED let myArray = NSMutableArray() var image:UIImage! var nimages = 0 for(;;nimages++){ let nameOfImg_ = entity.attribute let imageName = String(format: “name%@number%lu.jpg”, arguments: [nameOfImg_,(nimages + 1)]) if((NSBundle.mainBundle().pathForResource(imageName, ofType: nil)) != nil){ image = UIImage(contentsOfFile: NSBundle.mainBundle().pathForResource(imageName, ofType: nil)!) myArray.addObject(image!) }else{ break } } entity.attribute must be a String 12 solved Swift 2 get the number … Read more
Use Count with Order by Select Count(pro_id) as total From table Group by vendor_id Order by Count(pro_id) 2 solved How to get maximum number of products matched vendors list. But i don’t want to check same products again [closed]
Using no external modules and only the count, although there would be some redundancy using dict comprehension: d = {itm:L.count(itm) for itm in set(L)} If you are allowed to use external modules and do not need to implement everything on your own, you could use Python’s defaultdict which is delivered through the collections module: #!/usr/bin/env … Read more
Load all the contacts in array list or string array and then use AutoCompleteTextView for adding search functionallity Gett all contacts like this as expalined here public ArrayList<PhoneContactInfo> getAllPhoneContacts() { Log.d(“START”,”Getting all Contacts”); ArrayList<PhoneContactInfo> arrContacts = new ArrayList<PhoneContactInfo>(); PhoneContactInfo phoneContactInfo=null; Uri uri = ContactsContract.CommonDataKinds.Phone.CONTENT_URI; Cursor cursor = context.getContentResolver().query(uri, new String[] {ContactsContract.CommonDataKinds.Phone.NUMBER,ContactsContract.CommonDataKinds.Phone.DISPLAY_NAME,ContactsContract.CommonDataKinds.Phone._ID}, null, null, ContactsContract.CommonDataKinds.Phone.DISPLAY_NAME + … Read more
func is always calling itself. There is no stopping condition. Each call creates a new stack frame, until the call stack is full and StackOverflowError is thrown. Recursive methods should always have a stopping condition. For example – n < 0 : public static int func(int n){ int result; if (n >= 0) result = … Read more
I believe this does what you want… arr = [[2,6,8],[1,4,7],[3,3,4],[2,4,9],[3,3,7]] foo = lambda arr, evenOdd, noDoubles: [ i for i in arr if not (evenOdd and (all(k % 2 == 1 for k in i) or all(k%2 == 0 for k in i))) and not (noDoubles and (len(i) != len(set(i))))] print(foo(arr, False, False)) print(foo(arr, True, … Read more
Simple remove(b1.c_str()); call c_str() to get a pointer to a C string from a C++ string. 1 solved making function accept the path that’s inside the string variable
Both will give the same result, but I’d choose the | always, because you are dealing with bits, not numbers. In order to understand why they are equivalent you first have to understand binary numbers and binary maths: var b = 0b0011; //binary 0011 Ok, lets do something similar to your code: var s = … Read more
You created a new empty list and iterated by its elements (there are none). If this method must calculate what you want, use this: public static double q1(ArrayList<String> input1){ double sum1 = 0; for (String s1: input1){ sum1 += s1.length(); //Line 6 } return Math.pow(sum1, 3); } solved Why won’t my method store the length … Read more
The way I see it, your code would be O(n) if it wasn’t for the a.pop(0) part. Since lists are implemented as arrays in memory, removing an element at the top means that all elements in the array need to moved as well. So removing from a list is O(n). You do that in a … Read more
Let’s look at each error in you code. Firstly x=o; Did you mean 0 ( zero ) or a variable o or the character ‘o’. If it was 0 ( zero ) or ‘o’ ( character ) or a variable ( having a value greater than or equal to 10 ) , then the loop … Read more
new entity(“entityName”) means “create an instance of entity in the free store and return a pointer to that instance”. Since a pointer to an entity is not the same as an entity, you cannot initialise an entity with that value unless you have yet another constructor. The way to do what you want is entity … Read more