Posts by Andre Mesquita • 1,114 points
74 posts
-
1
votes3
answers3932
viewsA: How do you configure phpmyadmin on linux?
By default, apt-get install phpmyadmin installs and create a file /etc/apache2/conf. d/phpmyadmin.conf. Contents page is on /usr/share/phpmyadmin/ Take a look: /etc/apache2/conf. d/phpmyadmin.conf #…
-
0
votes2
answers1086
viewsA: Regular expression to detect the credit card flag when there are specific characters in the number
Marcus, to validate the credit card number, I use Algorithm Luhn. Follow the class: public static class Luhn { public static bool LuhnCheck(this string cardNumber) { return…
regexanswered Andre Mesquita 1,114 -
4
votes1
answer233
viewsA: Automatically upload one server instance on Amazon if the other drops
In the EC2 of Amazon Webservices you can create the instance with 2 types of disks. Physical disks (EBS) and Discos Efêmeros. Physical disks are the Magnetic Disk and SSD. The ephemeral disk is a…
awsanswered Andre Mesquita 1,114 -
0
votes2
answers251
viewsA: Connection to Servers on Amazon
Julio, accessing SQL Server and/or Mysql need not necessarily access the server console. You need a console. SQL Server by default operates on port 1433. Most of the time I use Microsoft SQL…
-
1
votes1
answer931
viewsA: Grab the selected item from the Select2 plugin and make a Submit
Adriano, take a look at my answer on: /a/108564/21263 Note the javascript callback. When returning the values, it must fill in Hidden field with the client code. In the MVC, Hidden field will be…
-
0
votes2
answers895
viewsA: Convert sql server data format
You can try using: SELECT CONVERT(VARCHAR(10),GETDATE(),110) There are other options at: http://www.w3schools.com/sql/func_convert.asp…
sql-serveranswered Andre Mesquita 1,114 -
3
votes3
answers7306
viewsA: Check if a process is not running and then run it
You can create a shell script that returns how many processes are running. Of course Else can be deleted. #!/bin/sh # Verificacao se servico esta online qtde=$(ps aux | grep "mysqld" | wc -l) if…
-
4
votes4
answers426
viewsA: Contest question: logic error and semantic error?
I agree with you. There’s only one semantic error. At no time of the question are given the values of N1 and N2, so the execution of the algorithm will stop to receive the value of N1 and there will…
-
1
votes2
answers57
viewsA: How do I add files that were uploaded to the git repository?
The best way for you to do this would be to use Github API. You need: Create the archive in the repository; Send the file to the repository; Commit.…
gitanswered Andre Mesquita 1,114 -
5
votes2
answers3629
viewsA: Error trying to remove a temporary table
Wagner, you need to test if it exists before deleting. IF EXISTS(SELECT [name] FROM tempdb.sys.tables WHERE [name] like '#temp%') BEGIN DROP TABLE #temp; END;
-
0
votes1
answer362
viewsA: The type or namespace name 'Ajaxcontroltoolkit' could not be found in the global namespace (are you Missing an Assembly Reference?
You need to declare in your configuration: <packages> <package id="AjaxControlToolkit" version="8.0.0.0" targetFramework="net45" /> </packages>
-
1
votes1
answer848
viewsA: Problems with Mysql Server for OS X
It may be competition. In this case, I suggest you kill all mysqld processes and start again. Take a look at this article that indicates the procedure: https://stackoverflow.com/a/34662343/2788478…
-
0
votes2
answers71
viewsA: Select random with Sqlserver (mssql)
Try to load the random index before and assign it to the string of the command. <?php $indiceRandomico = rand(5, 15); $sql ="SELECT * FROM Tabela where campo=‘algum' order by ”. $indiceRandomico;…
-
1
votes1
answer787
viewsA: Allow typing inside a Dropdownlist and run the search
Follow a statement from Select2. Don’t forget to create a new method in Patientecontroller called jsonLoadSelect2. Statement: $("#ddlPacientes").select2({ allowClear: true, ajax: { type: 'GET', url:…
asp.net-mvcanswered Andre Mesquita 1,114 -
0
votes1
answer72
viewsA: Show string in excel without single quote
Try to send the simple quote at the beginning of the string.…
c#answered Andre Mesquita 1,114 -
0
votes2
answers282
viewsA: Error entering in batch using Oraclecommand
Rodrigo, why don’t you use foreach to fill in primitive types, or pass a string array to a stored Procedure? Take a look at what the foreach would look like: OracleConnection con = new…
-
1
votes2
answers214
viewsA: Cakephp version 1.3.15 Error 500
Fabricio, error 500 is an internal error of the server. You have to see what is in the log. When I develop php I always choose to do it on linux. My indication would be virtualization. I suggest you…
-
0
votes2
answers17302
viewsA: Add more fields in form dynamically in Jquery
Why not use X to include a numeral to a name: var nome = 'Texto'+$x $(wrapper).append('<div><input type="text" name="$nome"/><a href="#"…
-
2
votes2
answers46
viewsA: Error searching page data with AJAX
See if it helps: $(document).ready(function(){ $('#executaAjax').click(function(){ $.ajax({ type: "GET", url: "ajax.php", async: true, dataType: 'json', success:(function(data){…
-
1
votes2
answers32357
viewsA: Numeric mask for date field in Javascript
Uses jQuery. Must meet what you want. <script src="//code.jquery.com/jquery-2.1.4.min.js"></script> <script…
javascriptanswered Andre Mesquita 1,114 -
0
votes2
answers1051
viewsA: Job created on SSIS does not work on SQL SERVER AGENT
I wrote the same as in Rodrigão’s comment on his stackoverflow question.com. https://stackoverflow.com/a/34794737/2788478…
-
3
votes2
answers513
viewsA: Monetize Windows Forms C#?
Leonardo, why don’t you mount advertising images and display them in a Panel (or panels), changing each Timer event. You can read an XML from anywhere on the internet with all the images and store…
-
2
votes8
answers26648
viewsA: How to backup Mysql Database Diaries?
In Amazon server instances aws (ec2), I adapted my own solutions to avoid having to pay for other software. In the solution for windows, I implemented in C# using the library aws.net. For linux, I…
-
1
votes1
answer360
viewsA: How to get information from a . CPL?
An output is to use the file properties. If you take the file properties as cpl, it will come something like "Control Panel Item" however, if you copy the CPL by changing the extension to DLL, you…