Posts by Paulo Roberto • 1,988 points
87 posts
-
6
votes2
answers5148
viewsA: How to remove value accentuation in Mysql
The UPDATE should be completed for each letter to be replaced, the column desired: UPDATE TABLE_NAME SET COLUMN = REPLACE(COLUMN,'Š','S'); UPDATE TABLE_NAME SET COLUMN = REPLACE(COLUMN,'š','s');…
mysqlanswered Paulo Roberto 1,988 -
7
votes1
answer883
viewsA: How to convert values from one column to UPPERCASE
Use the UPPER() SELECT: SELECT UPPER(campo) FROM `tabela` UPDATE: UPDATE tabela SET campo = UPPER(campo)…
mysqlanswered Paulo Roberto 1,988 -
5
votes1
answer94
viewsA: What is Accelerated Mobile Pages (AMP)?
Google created the project called Accelerated Mobile Pages (AMP), a response to Facebook Instant Articles, Apple News, and Twitter Moments - all of the tech giants wanting to grab another piece of…
-
0
votes1
answer1460
viewsA: Grab image from database
To insert the image do the following: $db = mysqli_connect("localhost","root","","DbName"); //keep your db name $image = addslashes(file_get_contents($_FILES['images']['tmp_name'])); $query =…
-
0
votes1
answer382
viewsA: Jquery autocomplete
It’s not that easy, but it’s not a big deal either: Page where the input will be: <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />…
-
2
votes1
answer729
viewsQ: XML mapping in Excel 2013
I have a spreadsheet where on each line I register a test case and then export it to XML, then upload this xml into another system we use. The problem is that I can only do 1 to 1, I can’t fill…
-
0
votes1
answer638
viewsA: How to make a mysql query from a link
You can achieve this by passing a parameter to the page, then the PHP can take this parameter and generate the appropriate content for the reader. For example, by clicking on shirts, you can have:…
-
0
votes1
answer204
viewsQ: Material Design Layout Adjustment
I can’t get Slide to take the entire home screen area, note that half of the Section "structure" is seen on the website home, I’ve tried everything, but I’m not good with CSS, unfortunately. <div…
-
1
votes1
answer1840
viewsQ: Application Pool stopping at IIS7
I installed Redmine in IIS 7 in Windows 7 + Mysql, but whenever I try to access the local URL the page appears with error 503, I found that this is happening because the Application Pool is stopping…
-
2
votes1
answer690
viewsQ: Class to generate CPF does not print on console
I cannot print the generated Cpfs on the console. I am studying this code and do not understand the problem, can anyone help me understand and learn to use this code, please? package geraCPF; import…
javaasked Paulo Roberto 1,988 -
0
votes2
answers2429
viewsQ: Select on Oracle - Java
I’m trying to run a connection test in the database and extract some information, just Sfor study even, but I’m bumping into the following error: Exception in thread "main" java.sql.SQLException:…
-
0
votes3
answers476
viewsA: Select Oracle returning numerous times the same result
I resolved using a distinct and improving the relationship in the tables. Select distinct Sq_Transacao,T.Cd_Fase, F.ds_Fase, T.Nu_Msisdn, tec.ds_tecnologia, c.no_cliente, c.nu_cpf, T.Nu_Iccid…
-
0
votes3
answers476
viewsQ: Select Oracle returning numerous times the same result
My select works and returns the data I need, but it is returning more than 6000 times the same result. How do I get it to return the result in just 01 line. NOTE: There is only one result for this…
-
2
votes2
answers1102
viewsA: How to create an app in Phonegap using an online page?
If the app will only be for Android, there is no reason to use Phonegap, because one of the premises is that, with the same code you can create app for various platforms. You can do it in Pure Java,…
-
1
votes1
answer378
viewsQ: Parse HTML with Jsoup - Java
I am studying Jsoup library and I took the most basic example of the site and tried to build something simple, but I have this error, which does not allow me to execute the code: Default constructor…
-
0
votes1
answer23
viewsA: Increase consumption and Tab Lock, with Script that draws numbers
Make it this way that it will be faster, because it does not recreate the array. var numerosSorteados = function(){ var maximo = 60; var resultados = 6; var i, arr = []; for (i = 0; i < maximo;…
javascriptanswered Paulo Roberto 1,988 -
0
votes2
answers669
viewsA: Do not lose input text when switching pages
You can save the input value to a variable and then redeem it with some event like onchange, onclick and etc. Functional example: <html> <head> <title>Teste</title>…
-
17
votes5
answers4312
viewsA: What does Nan mean in Javascript?
Definition and Use The Nan property represents a value "Not-a-Number". This property indicates that a value is not a legal number. The Nan property is the same as the Number.Nan property It is also…
-
0
votes1
answer120
viewsA: Error classse R, Android Studio
This error, in if dealing with Android Studio, can have many causes. Giving a quick researched on the internet one perceives numerous pssoas with the same error and causes and different solutions.…
-
0
votes2
answers16357
viewsA: How to create composite primary key in SQL?
If you have two tables, the Idforte actually needs to be referenced as foreign key (Foreign Key) in TabelaFraca to then be used as a Composite Key, because until now it does not exist in the…
sqlanswered Paulo Roberto 1,988 -
2
votes3
answers2852
viewsA: Passing Javascript Variable into an Input text
That’s how it works too. var divLoginSite = document.getElementById("divLoginSite").innerHTML = window.location.href;
javascriptanswered Paulo Roberto 1,988 -
0
votes1
answer66
viewsA: Remove default Jquery mobile style
Use the property data-icon="false", she eliminates the icone. There are other ways to do this, but I consider this the easiest. <ul data-role="listview" data-icon="false">…
jquery-mobileanswered Paulo Roberto 1,988 -
0
votes1
answer1703
viewsA: Migrate Microsoft SQL to Postgres
The beginning of an export from a database to files that can be imported into Postgresql is to find and open in the SQL SERVER menu the tool IMPORT AND EXPORT DATA. After locating, you should open…
-
0
votes3
answers2268
viewsA: Site within App
Create an Android project and paste the code below and change the following line webView.loadUrl("http://www.google.com"); with the address of your website. package com.mkyong.android; import…
-
3
votes1
answer100
viewsA: It has to pass my dropdow menu to one of 3 Lines , but only when the mobile resolutions arrive
This will solve your problem, apply CSS and Jquery to your elements: <!DOCTYPE> <html> <head> <title>Responsive 3-Line Menu</title> <style type="text/css"> * {…
-
0
votes2
answers2416
viewsA: Javascript function to generate valid CNPJ
Rodrigo, here is the correct function. Put it on your file and call it She by clicking on the element with the onclick event, if you know nothing about Javascript events read this here: COMPLETE…
-
0
votes3
answers528
viewsA: Cordova/Phonegap error - Unable to start the daemon process
Well, I don’t use Phonegap/Ordova this way, I always try it on my emulator of his own http://app.phonegap.com/ But come on, you can try to delete her .gradle of C: Users directory and try again. Or:…
-
1
votes1
answer289
viewsA: Understand the eclipse error message
This happens in the installation of a certain Plugin, when downloading the dependencies of it there may be intermittence on the network and does not successfully complete the necessary Downloads, I…
eclipseanswered Paulo Roberto 1,988 -
0
votes1
answer113
viewsA: Problem with Javascriptexecutor Selenium Webdriver
The error was in using the parameter Function The correct is: ((Javascriptexecutor) driver). executeScript("doFilterOffer()", "click");
-
0
votes1
answer113
viewsQ: Problem with Javascriptexecutor Selenium Webdriver
I can’t perform the function doFilterOffer() on the page, it gives the following error Missing ; before statement , what’s the problem with this syntax below? if (driver instanceof…
-
3
votes1
answer894
viewsQ: Array without repetition
How to do not repeat data at each run? Each time I Run, he ends up repeating the dates at the time of execution, as I do for Him to draw the dates without repeating them, and when he finishes the…
-
1
votes1
answer1631
viewsQ: Loop to fill an input with multiple data - Selenium Webdriver
How to loop to scan an array and bring its data one by one and fill in the input? The picture illustrates well the problem... I need For to pass several times through the method and take the data…
-
5
votes3
answers3518
viewsQ: How to solve the problem "The main method was not found" in a Java class?
I created this Arraylist and at the moment of execution the following message appears: Error: Main method not found in class Declaracaoarray.Declaracao_array; set the main method to: public Static…
-
3
votes2
answers631
viewsQ: Problem with Arraylist
I’m learning about Array and I’m racking my brain with this code, can someone explain to me why it’s not working? This error appears The type List is not Generic; it cannot be parameterized with…
-
1
votes1
answer528
viewsQ: Show a single DIV with Ajax
I am making an ajax request for an external URL and want to show only three elements of the original website on the page I developed. But when executing the code it brings all the elements of the…
-
1
votes1
answer1770
viewsA: Creating Basic app that opens a url
You can create a Webview Mainactivity.java package com.mkyong.android; import android.app.Activity; import android.content.Context; import android.content.Intent; import android.os.Bundle; import…
-
0
votes2
answers142
viewsQ: Create App by manipulating external website
I want to create an app for a site that has no mobile version, so I need to show the user only 04 fields on the screen (login, password, sign up and ok). How can I do that It’s not my site and I…
-
0
votes1
answer226
viewsA: SQL server error: local server is inaccessible
Start the SQL service, va in Start Menu --> type services (or services), will open a list of windows services, browse the SQL SERVER service and start it. Below an example image, this is not the…
sql-serveranswered Paulo Roberto 1,988 -
0
votes2
answers282
viewsA: How to work with jQuery autocomplete?
With the example of the site, it works perfectly and does what you want At this link Example here <div class="ui-widget"> <label>Your preferred programming language: </label>…
jqueryanswered Paulo Roberto 1,988 -
3
votes2
answers118
viewsA: Website, mobile version
You can do this with Javascript or Jquery, at your discretion. <script type="text/javascript"> var url_mobile = "http://SEU_SITE_MOBILE";…
-
1
votes1
answer4663
viewsA: Javascript - Export to csv
Save the code below with this name jquery.battatech.excelexport.js /* * jQuery Client Side Excel Export Plugin Library * http://www.battatech.com/ * * Copyright (c) 2013 Batta Tech Private Limited *…
-
1
votes1
answer2996
viewsQ: Grab Content from another page with jquery
I want to create a way to open this page of Sptrans in an app, but without loading all their layout, only the fields: LOGIN, PASSWORD and REGISTER, using only HTML and JQUERY. The elements I need…
-
5
votes3
answers506
viewsA: Site locking on specific pages
Really your site is underdeveloped, missing open and close tags, put things in the right places and the error has nothing to do with jquery, has to do with good development practices that you are…
jqueryanswered Paulo Roberto 1,988 -
1
votes1
answer603
viewsA: Sequence of mp4 videos
Add the attribute "loop": "loop" (and break update this jquery ai né, this very lagged). $(function() { $("#playlist li").on("click", function() { $("#videoarea").attr({ "src":…
-
1
votes1
answer253
viewsA: Error in menu positioning ( viewed on mobile ) using Bootstrap
Your website is like this: <div class="navbar-header" style="position:absolute; z-index:2;"> <button type="button" class="navbar-toggle" data-toggle="collapse"…
menuanswered Paulo Roberto 1,988 -
1
votes3
answers292
viewsA: Validate ZIP code in Shell-Script
On this site below there are good examples. http://www.terminalroot.com.br/2015/01/shell-script-validandotele.html echo 'Informe o CEP'; read CEP echo $CEP | egrep '^[0-9]{5}[-][0-9]{3}$' &&…
-
1
votes2
answers5894
viewsA: Fastest way to count how many records I have in a MYSQL table
I believe that the easiest way is using COUNT, I use it daily and never had problems and use on large bases. The COUNT function (*) returns the number of records in a table: SELECT COUNT(*) FROM…
mysqlanswered Paulo Roberto 1,988 -
2
votes1
answer219
viewsA: Access site on mobile without being connected to network
Let’s go in pieces. Yes, It is possible to access this site Offline, since you copy the entire project into your mobile SD card and this is developed in HTML, because the mobile has the HTML…
-
0
votes2
answers2189
viewsA: How to put link in photo caption?
Try it like this: <a href="http://br.answers.yahoo.com" target="parent"><img…
html5answered Paulo Roberto 1,988 -
0
votes1
answer61
viewsA: Floating screen Cordova
Since you are using Jquerymobile with Phonegap, what you need is a Dialog. <a href="dialog.html" class="ui-shadow ui-btn ui-corner-all ui-btn-inline" data-transition="pop">Open…