Kirat The error message seems pretty clear: FactorId is an identity column. You shouldn’t set the value for FactorID yourself. Sql Server will set it for you. But if you really want to set it for some insane reason, you need to include a column list in the query like this: SET IDENTITY_INSERT facetors on INSERT … Read more
The code would look something like the code below. You need to modify the connection string and SQL as required. using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using System.Data.SqlClient; namespace ConsoleApplication58 { class Program { static void Main(string[] args) { string connStr = “Enter Your Conneciton String Here”; string SQL = “Select … Read more
proDialog = new ProgressDialog(getApplicationContext()); why getApplicationContext() because You’re trying to show a Dialog after you’ve exited an Activity. see full reason at Activity has leaked window that was originally added 1 solved Using progressDialog gives window leak error and doesn’t dismiss in Android
You can use the MAX() and MIN() function to get the ids having largest and the id having smallest discount. Select id,discount from customer where discount=(select MAX(discount) from customer) OR discount=(select MIN(discount) from customer); 3 solved select id by the min and max (sql) [closed]
Try something like this. using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Globalization; namespace ConsoleApplication59 { class Program { static void Main(string[] args) { DateTime time = DateTime.ParseExact((“26-12-2017 5:45pm”).ToUpper(),”dd-MM-yyyy h:mmtt”, CultureInfo.InvariantCulture); int dayOfWeek = (int)time.DayOfWeek; DateTime saturdaySundayMidnight = time.AddDays(-dayOfWeek).Date; TimeSpan timeOfWeek = time.Subtract(saturdaySundayMidnight); TimeSpan startTime = new TimeSpan(1,17,45,0); //Monday 5:45PM TimeSpan endTime = new … Read more
This line $link=mysqli_connect(‘host’,’username’,’password’,’database_name’); should be: $link=mysqli_connect($host,$username$,$password,$database_name); solved Why the code does not work?
<?php $url=”http://username:password@hostname:9090/path?arg=value#anchor”; var_dump(parse_url($url)); var_dump(parse_url($url, PHP_URL_SCHEME)); var_dump(parse_url($url, PHP_URL_USER)); var_dump(parse_url($url, PHP_URL_PASS)); var_dump(parse_url($url, PHP_URL_HOST)); var_dump(parse_url($url, PHP_URL_PORT)); var_dump(parse_url($url, PHP_URL_PATH)); var_dump(parse_url($url, PHP_URL_QUERY)); var_dump(parse_url($url, PHP_URL_FRAGMENT)); ?> Parse_url is what you’re searching for ! The scheme here would be “PHP_URL_PATH” I guess Some doc : http://php.net/manual/en/function.parse-url.php 2 solved PHP: How to get the page name of an url
The only difference is that the first query will return a row for each pair of rows in the table where P1.att2 > P2.att2 and P2.att1 = x, while the second query will just return one row for each row in the table where att2 is greater than in some row where att1 = x. … Read more
You’d have to convert your date string to a timestamp (milliseconds since 1-1-1970). Then you could do the same to the current date and compare the two (subtracting one from another). With the difference in milliseconds, you can calculate the amount of hours by dividing it by the amount of milliseconds that are in one … Read more
Try using xml methods, DECLARE @xml XML, @mlt_sk VARCHAR(100)=’7,11,12′, @GroupName VARCHAR(10)=’xyz’, @delimiter VARCHAR(10)=’,’ — Converting string to XML SET @xml = Cast(( ‘<X>’ + Replace(@mlt_sk, @delimiter, ‘</X><X>’) + ‘</X>’ ) AS XML) –SELECT @xml DECLARE @YOUR_TABLE AS TABLE ( VALUE VARCHAR(100) ) ——–Use nodes() method INSERT INTO @YOUR_TABLE SELECT N.value(‘.’, ‘varchar(10)’) + ‘-‘ + @GroupName … Read more
I answered my own question: I counted the values within the red circle, by using: countif (setting the criteria (so the value would count the values i wanted) and set a ranger (so it wouldn’t count anywhere else) So for the bad description, and thanks to those who gave me ideas. Niall solved How to … Read more
This is pretty simple… function reverse(tag) { var el = document.getElementById(tag); if(!el) { return alert(‘nope’); } el.innerHTML = el.innerHTML.split(”).reverse().join(”); } 1 solved how to reverse a string that is identified as an id in javascript?
You can add objects. This is just a warning that your list is not generic. To make it generic, it should be: List<String> quotes = new ArrayList<>(); solved Can’t add to an ArrayList on Android Studio? [duplicate]
I’m not completely following your question. Any IP address assigned to your computer is a real IP address which your computer uses. It may be a private IP address which can be reused in different networks, or it may be a public address which is supposed to be unique in the world (I think this … Read more
The regular expression is: ^((?!(?<ch>.)\k<ch>\k<ch>)(?!012|123|234|345|456|567|678|789|890)[0-9]){8,}$ The (?!(?<ch>.)\k<ch>\k<ch>) will check for the same character repeated thrice. Note that for the various contiguous sequences I had to put them in a list of possible sequences, (?!012|123|234|345|456|567|678|789|890). [0-9] is the character that will be accepted as valid. The {8,} is for the minimum length. 1 solved Numbers only … Read more