And yet another variant SELECT * FROM [table] WHERE ‘,’+[data]+’,’ LIKE ‘%,E55555,%’ The problem though, is that what you are asking for won’t be able to use normal indexes, which means an inefficient table scan every time you query. You may want to consider breaking the comma delimited values into their own columns so you … Read more
The error arises from a simple typo. You have spaces added to the value passed for the Sid condition. However your query should be rewritten in this way string cmdText = “select Count(*) from [user] where Sid=@sid and password=@pwd”; SqlCommand cmd = new SqlCommand(cmdText, cnn) cmd.Parameters.AddWithValue(“@sid”, textBox1.Text); cmd.Parameters.AddWithValue(“@pwd”, textBox2.Text); int count = Convert.ToInt32(cmd.ExecuteScalar()); if (count … Read more
You are selecting columns, like FN, SN and Caps. I suppose that if you group by Team, at least one of those columns have more than one value in at least a group. solved How to do a group by query in c++
Fix the toggleClass call, you only need the class name, not the selector: toggleClass(‘over’) instead of toggleClass(‘p.over’). Then, you have two opening script tags: <script type=”text/javascript” language=”javascript”> <script> Remove the first one. Next, you’re binding an event listener to an element that’s not in the DOM yet at the time the script executes. Simple fix: … Read more
If you have Visual Studio 2010 you can open the project solution there and make the exe setup there without having to install an install shield. The Steps would be as follows: Click File >> ADD >> Project Select the Setup Wizard and change the fie name >> Click OK Wizard form will pop-up >> … Read more
Your if statements have more entries then a teenage girls phone. 🙂 You should invest in some structures, containers and loops. For example: const static std::string question_words[] = {“am”, “are”, “can”, “did”, “could”, “do”, “does”}; const static unsigned int word_quantity = sizeof(question_words) / sizeof(question_words[0]); //… bool is_question = false; for (unsigned int i = 0; … Read more
Use EXPLODE inside foreach <?php $yourArr = array(‘2,3′,’2,3’); $a = 0; $b =0; foreach ($yourArr as $temp) { $tempnew = explode(“,”,$temp); $a += $tempnew[0]; $b += $tempnew[1]; } echo “a = “.$a.”<br>”; echo “b = “.$b; ?> 1 solved How to Adding values of two dimnetional array in php [closed]
Despite my comment above, I wondered about the “time and space complexity”. It turned out to be trivial; this only takes 3 long integer variables and a single loop over each input digit (which can be incremented by this algorithm to use 1 more digit; and this will not cause an integer overflow). Starting from … Read more
It is as simple as: “The Shawshank’s Redemption”.replaceAll(“\\S”, ” _”); We replace all non white-space characters \S with an underscore followed by a space. This would automatically make what is a space originally, 2 spaces. Note that a trailing space will be produced. 2 solved Java replace with regex [closed]
As usual, Flexbox is our lord and saviour. Here’s your layout made with Flex. .container { width: 500px; height: 250px; display: flex; border: #00f solid 2px; } .container .side { border: #ff0 dashed 3px; flex-basis: 33%; flex-shrink: 0; /* Prevents shrinking if .four grows */ display: flex; flex-direction: column; justify-content: space-between; /* Ensures perfect spacing … Read more
In c# 4 and above you can specify default values for parameters, so it’s not necessary to specify them at the call site: public void DoIt(string text = “”) { //do something with text //do other things } and then you can call it either passing a parameter, like this: DoIt(“parameterValue”); or without passing a … Read more
string time = “09:19:30.5070000 AM”; StringBuilder sb = new StringBuilder(time); string final = sb.Remove(8, 8).ToString(); 1 solved C# remove part of string in Time
Well may be because of the following reasons ArrayList already extends AbstractList and you can extends only one class in java All the functions of Collections are static They do not want anyone to override the methods in case in was not static If one argues that they can be converted into final non static … Read more
You can’t add quality just by increasing the bitrate. It’s like an image – if you have an image that is 24px square, and increase it to 72px it’s just going to get blurry. FFMPEG or any other library has no way of knowing what data was removed when you reduced it to 16kbps (if … Read more
A C++ implementation : Without any formatting void print(int n) { for(int i=n, cl=1, cr=n*n+1; i>0; cl+=i, –i, cr-=i) { for(int j=0; j<i; ++j) cout << cl+j; for(int j=0; j<i; ++j) cout << cr+j; cout << endl; } } With dashes and stars void print(int n) { for(int i=n, cl=1, cr=n*n+1; i>0; cl+=i, –i, cr-=i) … Read more