Posts by Edgar Muniz Berlinck • 4,569 points
94 posts
-
3
votes4
answers238
viewsA: Variable feed within variable
You can use a little more ES6 if you want to leave your code more Fancy. const outputMessage = message => `<div class="bot_mensagens">${message || 'Olá'}</div>`;…
-
0
votes1
answer2398
viewsA: Synchronize two Mysql databases
You must work with Mysql Replication, which consists of a 1 master database where inclusions are made and several slave banks for reading. This mechanism is interesting for load balance, data…
mysqlanswered Edgar Muniz Berlinck 4,569 -
1
votes3
answers2525
viewsA: How can I insert multiple lines once only using Sql?
Go to your sqlite and make a query that manages the querys: select 'insert into ..... values ('+Campo+','..... from sua tabela.... The result must have the'load script' Another option is to export…
sql-serveranswered Edgar Muniz Berlinck 4,569 -
2
votes5
answers676
viewsA: Individual methods or parameters in Mysql queries?
This is not a simple answer, but in terms of performance the gain is derisory. There is no cake recipe, but you can use a function only and use a filter with the in clause (). An example from the…
phpanswered Edgar Muniz Berlinck 4,569 -
1
votes1
answer1074
viewsA: Dynamic form and send to mysql via jquery and ajax
Your problem can be solved by using the correct selector to get the value of the field you need. To pick by name you can use for example: document.querySelectorAll("input[name=nomeAqui]") This will…
-
0
votes2
answers343
viewsA: How to use a ready database on Android with Sqlite
Look, I’ve done something similar but I don’t know if it’ll help, but come on: Feed the database manually using JSON I did the load in the database using a service. This service returned a paged…
-
0
votes2
answers1048
viewsA: Conflicting Signature Error
The signature usually stays in the project folder, but just uninstall the mobile app that will work.
androidanswered Edgar Muniz Berlinck 4,569 -
0
votes1
answer225
viewsA: How to increment the varchar() code field automatically in Mysql?
Let product_ID as auto_increment and make a Trigger of after insert. So you can ride the product_codev as you see fit. Now if I can give you a suggestion, I think this product_codev could be mounted…
-
1
votes1
answer43
viewsA: Logcat window in Webstorm 10
After a lot of research I found an alternative solution: The sdk itself offers a GUI called Monitor, located in %android_sdk_path% tools monitor.exe. It offers a satisfactory view for me and…
-
1
votes1
answer43
viewsQ: Logcat window in Webstorm 10
I’m even embarrassed to ask you this, but come on: I use Webstorm 10 to develop my applications using Cordova and for months I’ve been looking for minimal functionality and I just can’t find it: The…
-
4
votes1
answer801
viewsA: Access database in Openshift
I work with Openshift. I’ll explain to you what happens and how I usually work on this kind of thing. Openshift has some variables to make your life easier. $OPENSHIFT_MYSQL_DB_HOST,…
-
1
votes1
answer51
viewsA: Adware in my project
Visual Studio doesn’t show advertisements or things like that on your projects, so it’s a problem on your PC. I suggest you run a Spybot and review the extensions installed in your Browser. If you…
visual-studio-2013answered Edgar Muniz Berlinck 4,569 -
4
votes1
answer803
viewsA: How to use parse.com?
Parse is a cloud sdk for fast application development. With it you can store data, send notifications, emails, control installations and a lot more things the app needs. It is not necessary to store…
-
1
votes1
answer1298
viewsA: Is there a way to create a repository on Github with an already developed project?
You can add a new origin to your git. For this use the command git add origin remotenovo url-do-seu-novo-repositorio. Then just commit and push to the new repository: git push -u remotenovo master…
-
1
votes3
answers183
viewsA: Return the difference between the last two records
In Mysql you can do so: select event_type, count_event_type, (select value from events events_2 where events_2.event_type = events.event_type order by time desc limit 0,1) - (select value from…
-
1
votes1
answer901
viewsA: Function for popular Ttreeview only adds Childs to the first Node
You need to save the parent node reference, use the variable Tables that you created. Var Tables: TTreeNode; Root : TTreeNode; I: Integer; begin TreeView1.Items.BeginUpdate; //Incluir Root Root :=…
-
1
votes1
answer919
viewsA: How to limit heap size in a JVM 8?
According to the documentation, you can do this using the parameter -XX:MaxHeapSize.…
-
1
votes1
answer336
viewsA: Mount SQL to generate a dataset and popular a Treeview
Well first let’s query: You part with tbDataId and make a Join with tbProject. Tbdatid has one or more projects and a tbProject belongs to one and only one tbDataId. Then according to your template…
-
1
votes4
answers2204
viewsA: Multiple items in a Mysql column
To store the address in a single column and then extract the information you must ensure that any and all addresses are stored in the same pattern. You can, for example, use some sort of separator…
-
2
votes1
answer608
viewsA: JVM. What is the difference between Metaspace and permgen?
The main difference between the two is that Metaspace increases its size according to use while permgen has fixed size. It is possible to set a maximum size for Metaspace, but not possible cause…
-
3
votes2
answers1068
viewsA: 2 Foreign key in one field
Cannot create a foreign key that points to two different tables. What you can do is denormalize, that is to join, the tables Atleta and AtletaF and create some criteria in this new table to define…
mysqlanswered Edgar Muniz Berlinck 4,569 -
1
votes2
answers87
viewsA: Nodejs/Phonegap/Cordova tablet
I’m not sure I understand your question, but if all your Vices are on the same network (in case connected to the 3g network of your phone) you can run the app using the command phonegap serve + the…
-
2
votes1
answer346
viewsA: SQL LIMIT always returns the same last 3 records
This happens pq the LIMIT will return only the first 3 records. You can give a order by id desc, but it will bring you back forward. This is the easiest way to solve your problem. To solve the…
-
2
votes3
answers1630
viewsA: Mount a single string with multiple strings from a Java Arraylist
Or you can make a loop: String listString; for (String s : list) { listString += s + " "; } Or you can use Stringutils, which is on Commons-lag listString = StringUtils.join(list, " ");…
-
4
votes3
answers334
viewsA: Error using LIKE to search by name
An AND is missing "WHERE\n" + " Pessoa.Tipo = 2 **AND**" + " Pessoa.Nome LIKE ? ");
-
3
votes1
answer1369
viewsA: How to log in and maintain the session?
I use to Cookies, LocalStorage or the SessionStorage to do this kind of thing. The LocalStorage and the SessionStorage are HTML5 features and are very simple to work with. If you want the session to…
-
7
votes3
answers515
viewsA: Company can monitor everything employee does on work computer?
An employment contract is a service contract between an employer and a contractor. I have been through this a few times and I have called my lawyer on this issue. What happens is that there are very…
-
2
votes2
answers316
viewsA: Completing form with AJAX and Mysql
There is, usually I do so: function ajax(url, params, complete) { var xhr = CriaRequest(); // Não sei oq isso faz, estou seguindo seu padrão xhr.open("GET", url, true); xhr.onreadystatechange =…
-
1
votes2
answers114
viewsA: Insert Mysql error
This is happening because you are trying to insert an invalid value into your COD_PUBLI_VINCU foreign key. So The first thing you should do is take the zero value of the option: <option value=""…
-
0
votes3
answers1451
viewsA: View Oracle database data via Mysql
You can use Federated Tables via Perl Dbix::Myserver proxy reference download The link you sent (which I cited as a reference) coincidentally is the best reference there is to do this, so the best…
-
7
votes1
answer1481
viewsA: Should I limit the size of VARCHAR columns for performance?
varchar is dynamically allocated, if I have a var char of 30 positions and write a value with only 10 it will only occupy 10 positions. This is valid for most of the market sgbds (MSSQL, Oracle,…
-
1
votes3
answers2208
viewsA: Create database on server via mysql-Workbench (.mwb) template via command line
My answer may not be satisfactory for you. I’ve been working with Mysql Workbench since beta and I’ve never seen anything like this. I don’t think that’s even possible. One thing I usually use is…
-
1
votes1
answer160
viewsA: Extract HTML value
If the field at all times comes formatted like this: Rua - cep - setor - Cidade - Estado You can use PHP’s explode function $endereco = explode ( '-' , endereco ); $cidade = $endereco[2]; $estado =…
-
2
votes4
answers15572
viewsA: What is the super() function for;
When we work with inheritance to superclass is the class we inherited and the sub class is the class we inherit from the superclass. The subclass can override superclass methods and of course…
-
3
votes1
answer1135
viewsA: Problem with "phonegap run android"
This is not an error. I recommend using the command cordova run android, he’s more verbose. Something very important is that your device is in active developer mode.
apache-cordovaanswered Edgar Muniz Berlinck 4,569 -
3
votes2
answers2901
viewsA: Can iOS apps made in Phonegap be compiled in Windows?
I work professionally with Phonegap, so I can answer this question for you. Can’t do it without a Mac. But why? Phonegap uses the concept of webview. It creates a standard directory stricture and we…
-
9
votes3
answers627
viewsA: Optimize Java method using the Scopes concept
Something very important about scope is how long your objects will remain in the heap (Memory area where the JVM allocates objects). It is not interesting that an object remains in memory beyond…
-
2
votes1
answer5899
viewsA: How to run external linked Javascript
Create a . js file, for example data.js; Inside the file, create a function that returns what you want; She must look something like this: function dataExtenso() { /// Todo o seu processamento…
javascriptanswered Edgar Muniz Berlinck 4,569 -
18
votes2
answers4157
viewsA: What are <head> meta tags and what are they for?
Meta tags are very important for two things: SEO, ie: Search engines; The way your browser will interpret it. When we talk about SEO, its use is of paramount importance so that your website can be…
-
4
votes3
answers3350
viewsA: Add event to multiple elements without being inside a for loop
The alternative passed by the link is already the best alternative, which is to declare a function function click(param) { ... } and pass on their reference to the desired elements: for (var i=0;…
-
1
votes1
answer98
viewsA: Eclipse Helios Svn and VPN Client
It is very likely that you are connected to a proxy server. Check whether this proceeds and configure your eclipse using the menu Preferences -> Network Connections.
-
0
votes2
answers3385
viewsA: How to open a server file with javascript?
It’s possible, but it’s not elementary. As already mentioned, JS runs on the client, so you should do a service that gets the name of the file you want to open and returns its content. This service…
javascriptanswered Edgar Muniz Berlinck 4,569 -
5
votes1
answer1770
viewsA: Xampp as an enterprise solution for a web server with php applications
Xampp is a facilitator that installs php, apache and mysql, leaving you free to perform any extra configuration. This is good for facilitating the assembly of a development environment, but is not a…
-
1
votes1
answer84
viewsA: Parse SDK for Windows Phone 8.1
Unfortunately at the moment Parse is not supported by windows phone 8.1. To work with the platform we must use windows phone sdk 8. On parse’s website there is a project Quickstart that can be used…
-
1
votes1
answer84
viewsQ: Parse SDK for Windows Phone 8.1
I’m creating a Windows Phone 8.1 project using Visual Studio Community 2012. This app should integrate with the backend provided by Parse. Well, I tried to follow this tutorial, but I noticed that…
-
0
votes1
answer32
viewsA: It is possible to modify the header comment of a file in Pydev
Go on Window click on Preferences > Pydev > Publisher. Look for (Code) Templates and change the values listed in Comments.…
-
1
votes1
answer121
viewsA: Possible causes for a Session Leak
What can cause this kind of problem in JSF applications is the following: Managedbeans with a life cycle defined as Applicationscope or Sessionscoped which are not properly treated. Phaselistener…
-
1
votes1
answer872
viewsA: Insert into mysql database
You are including the user and then validating the information. As the friend said in the comments, call the function cadastraUsuario() after verification <?php include('conecta.php');…
-
2
votes2
answers137
viewsA: Save temporary data to the array or query the database
You should measure what is most important in your system and what are the consequences of each decision. Check the data bank ensures that your system will not suffer from possible inconsistencies…
logicanswered Edgar Muniz Berlinck 4,569 -
2
votes4
answers1574
viewsA: Database and transaction control in value transactions
I read excellent answers. Just to show another approach I would like to suggest the following: I would model this way: Usuário id | Nome Transação id | usuario_id | valor | data | data_processamento…