Posts by usersantos • 765 points
55 posts
-
2
votes1
answer201
viewsQ: Capture file creation date
I am implementing an FTP file upload tool on the web, I use the input type file. POST is done via Javascript, but wanted to know how to know the date of creation of the source file. Ex.: file.exe…
javascriptasked usersantos 765 -
0
votes1
answer40
viewsQ: php data filtering and Count
Good is the following I have a web app where graphics Gero, however I liked to filter data and do coutagens, I have only data in a comic, so I have already exported and to avoid q app slow I was…
phpasked usersantos 765 -
1
votes1
answer58
viewsQ: Is it possible to create a Chord Diagram chart using the D3 library?
It is possible to create a chart in Chord using the library d3? Follows graph data structure in format JSON: {"links": [ { "id": "11", "color": "#d96500\r\n\r\n", "source": "Norte ", "target":…
-
-2
votes2
answers53
viewsQ: how to structure php nodes
I needed the nodes to stay in this format: "name": "Baixo Alentejo", "color": "#f0e68d\r\n" $nodes[]='name:'.$row['name'] ." ".'color:'.$row['color'] ; With this code, you’re giving me: "name:Baixo…
phpasked usersantos 765 -
0
votes0
answers41
viewsQ: tilte Sankey D3.js change color
I am making a Sankey diagram on D3.js wondering if I can use static colors for nodes(rectangles) and change the link title to the title aspect var anoid = document.getElementById("anos").value; var…
javascriptasked usersantos 765 -
0
votes0
answers54
viewsQ: query to get percentage
I’m making a query to get percentage by zone but it’s not working very well for me select nuts3_res_1amc.id as id ,nuts3_res_1amc.localidade as source, nuts3_trab.localidade as target ,nuts3_trab.id…
postgresqlasked usersantos 765 -
0
votes0
answers27
viewsQ: select query in a database
good is the following I am to stir here with some data, I have a table with data of the censuses. Tables First table where you have the data . Fields residencia_nut3, work values 112, 180 values…
postgresqlasked usersantos 765 -
1
votes1
answer46
viewsQ: Sankey D3.js problem diagram with large data
someone can tell me why I can’t read this json and show on Sankey I have to use D3.js if you put in less data it works json list http://pastebin.com/p3mzVb2m…
d3.jsasked usersantos 765 -
0
votes1
answer102
viewsQ: generate a php json
hello I have a problem I believe you can help me, is the following need to have a json of this genus { "nodes":[ {"name":"Barry"}, {"name":"Frodo"}, {"name":"Elvis"}, {"name":"Sarah"},…
-
0
votes0
answers51
viewsQ: Only get the bank’s final value
I’m using the php with Pdo to query a database in postgress. Is there any way that when you do the query, show the result without having to enter the table name, since select is unique? select…
-
2
votes1
answer68
viewsQ: how to send parameters in D3.json to php
good there is some way to send D3 parameters to make a request to php. I have a search form that will send data to php in post form I wanted and return the result in json…
d3.jsasked usersantos 765 -
0
votes2
answers28774
viewsQ: How to check if a checkbox is javascript checked
I have a problem I need to check if a checkbox is selected. I happen to have a form with values that are loaded by ajax requests to the server. after having the data loaded is that he should check…
javascriptasked usersantos 765 -
-1
votes1
answer37
viewsQ: formultario filters php
I am doing a platform in php with html and ajax requests, I have two years . Whenever I change year it keeps the previous data there is some way to erase the data that is the datalist
phpasked usersantos 765 -
-1
votes2
answers433
viewsQ: How to put a default php option Selected
Boa wanted that if the year was 2012 paste the value with Selected is possible to do? $ano[] = "<option value='$row[ano]'/>"
phpasked usersantos 765 -
0
votes1
answer401
viewsQ: Grouping data by age
good I have a database that contains professions , people , and sex wanted to group by age group and by profession and sex and make a calculation of the same. problem repeats me several tracks for…
postgresqlasked usersantos 765 -
0
votes5
answers100
viewsA: Copy a word from a column to the end
SOLUTION declare @nam varchar(300) set @nam='Almeida,José Costa Santos ' select right(@nam, len(@nam)-charindex(',',@nam)) + ' ' +left(@nam, charindex(',',@nam)-1) as frist…
-
1
votes5
answers100
viewsQ: Copy a word from a column to the end
I have several records in sql for example almedia,jose costa santos and I want to change the value to: jose costa santos almeida In other words, I want to take the last name at the beginning (before…
-
0
votes0
answers78
viewsQ: save a pdf to my machine
I have a code on a server that, when running, I want him to download a file to the client machine. In this case when running this, it just copies the file to the server. $local_file = 'output.rar';…
phpasked usersantos 765 -
1
votes4
answers2091
viewsA: How to send variables via ajax/php
good here you are search is a form accao is the one you can send more if you want var accao = {"action": "enviadados"}; var data = $("#pesquisa").serialize() + "&" + $.param(accao); $.ajax({…
-
0
votes1
answer44
viewsQ: how to connect to an ftp server
I have this code I wanted to connect to ftp. Through the browser I can, but the code tells me you can’t log in. Follow the code, I hid the data: $ftp_server = "" ; $ftp_user_name = "" ;…
-
2
votes1
answer63
viewsQ: remove sql zeros
I have a field EUW010598260, and needed you to stay EUW1598260 I need to remove a specific field SQL: SELECT 'EUW' + substring(campo,patindex('%[^EUW0 ]%',campo + ' ') ,len(campo)) AS campo1 ,campo2…
sqlasked usersantos 765 -
-2
votes1
answer528
viewsQ: datatables format field
Good, I needed a hint: how do I get the surrender of datatables to show me only the date of the row below, and to format the following value for the €? "mrender": function ( data, type, row ) {…
asked usersantos 765 -
1
votes2
answers90
viewsA: postgres sql Insert into
already solved 'INSERT INTO concelho(id,censo,concelho)´SELECT "CONCELHO","CENSO","CONCELHO_DSG"FROM dblink('dbname=meu_db host=meu_hostuser=meu_user…
postgresqlanswered usersantos 765 -
1
votes2
answers90
viewsQ: postgres sql Insert into
I have to copy data from two databases to a new one, it happens that when copied new data these already exist but there are new ones that are not inserted. The query I have at the moment is this:…
postgresqlasked usersantos 765 -
1
votes0
answers242
viewsQ: how to insert into the sql Where Insert postgres
I am entering data in a table in postgres, it happens that I have a fields that do not exist in the referenced table and then the error when trying to insert a record that does not exist. I need to…
postgresqlasked usersantos 765 -
5
votes3
answers223
viewsQ: Multiple pages with a different id
I have several PHP pages , with different names of course. I wish I had something like this home.php?id=0, on the following page is named after cliente.php I wish when I have the home opened by…
phpasked usersantos 765 -
0
votes2
answers409
viewsA: Convert date format
here is php good :) make a explode the original string then contact everything and forms a single string or then in java script. <?php $str = 'one,two,three,four'; // zero limit…
phpanswered usersantos 765 -
9
votes1
answer4061
viewsQ: Webservice Delphi Soap with authentication
I’m using Delphi to read a web service from an insurance company. It happens to come in XML format in SOAP. I import the WSDL I can get the methods. But to connect to the Web Service I have to send…
-
2
votes5
answers9719
viewsQ: Copy data from one database to another postgress
How do I copy data from a database table to another database table in postgress It’s possible to do something like? INSERT INTO V(ID,D,S) VALUES(SELECT ID,D,S FROM D.A)…
postgresqlasked usersantos 765 -
0
votes0
answers57
viewsQ: how to read a web service in Soap using parameters?
I need to send parameters to a web service made in Soap. where I have to send a login, pass and domain of the web service, after that I have to use a header where I send the token to use the…
web-serviceasked usersantos 765 -
2
votes1
answer634
viewsQ: How to add a dynamic footer in Wordpress?
I’m making a site in Wordpress and wanted to know if there are any plugin that makes a footer run, and I can change the content of the footer in the backoffice. I don’t have code because I don’t…
-
1
votes1
answer636
viewsQ: how to show and hide a div
good I have this code that was supposed to give to show and hide a debt but it does not work me. ` <div class="btn-group custom-btn-group" data-toggle="buttons"> <label class="btn…
javascriptasked usersantos 765 -
0
votes1
answer435
viewsQ: google Graphical software
I’m getting a json where I store the following fields, but the graph gives me equal colors and should not $table = array() $rows = array(); $table['cols'] = array( array('label' => 'Nome', 'type'…
javascriptasked usersantos 765 -
0
votes1
answer42
viewsQ: is not checking whether a button is checked or not
if (document.getElementById("circular_select").checked === true) { piechart(); } if (document.getElementById("barras_select").checked === true)…
jqueryasked usersantos 765 -
2
votes0
answers663
viewsQ: dynamically jquery tabs
good is the following I’m using datatables and when I click a value opens a modal. just wanted to put this open on a new tab and don’t know how to do. would for example tab main clients where I have…
bootstrap-3asked usersantos 765 -
0
votes2
answers329
viewsQ: how to change the date using datatables
I have a datatables that has a date field. I intend to change that same field from 2012-05-01 00:00:00.000 to 2012-05-01. It is possible?
asked usersantos 765 -
2
votes1
answer244
viewsQ: Error opening jar on command line
I have the following code and am using a library to list the citizen card fields. When I try to run in the DOS it doesn’t work. import java.io.*; import pteidlib.*; public class main { public String…
javaasked usersantos 765 -
5
votes1
answer10995
viewsQ: How to read a json file using Delphi
Good not being a pro in delphi want to read a file json and extract fields. http://www.nif.pt/? json=1&q=509442013…
-
2
votes3
answers92
viewsQ: Error in sql server
No sql como faço para fazer um select com espaço e sem espaços? That is, when I have a pass of the genus '123456' and '123456', the last one with space happens to be done in the query and I have…
-
0
votes1
answer170
viewsQ: update PDO is not updating me
I’m having trouble doing an update not working me I am using PDO. the queries works in prefection. code I have in the script that receives the form data <script> function update() { var data =…
phpasked usersantos 765 -
1
votes1
answer74
viewsQ: php calls by ajax
I have a PHP file that returns a Json. This PHP file is called by Ajax, I have no functions in the PHP file. I receive the variables by POST in the PHP file... Everything is working, but now I want…
-
2
votes0
answers83
viewsQ: doubt if fields
I have a form where the user can search for a date range, or by id, name, nif I have the following code: $("#pesquisa").on("submit", function (event) { event.preventDefault(); var key =…
jqueryasked usersantos 765 -
0
votes1
answer383
viewsA: Join repeated results - PHP
good try to be clearer, can not comment. want to use combobox with values is? why do so $cli[$Row['client']][] = $Row;? the correct form is $Rows['table name'] = $Row; or $Rows[] = $Row; to take all…
-
4
votes3
answers42573
viewsQ: Calculate difference between two dates to validate date fields
I needed to find a mechanism to limit a search no longer than 3 months. I have two dates, I want to validate if they are within the defined parameters. have this code() I am using type date and…
-
0
votes3
answers2581
viewsA: jquery datatables requested from the server with parameters
php **`** $rows = array(); $table =array(); foreach ($result as $row) { $rows[] = $row; } $table['data'] = $rows; echo json_encode($table); ` have this code js`** $( "#pesquisa" ).on( "submit",…
jqueryanswered usersantos 765 -
0
votes3
answers2581
viewsQ: jquery datatables requested from the server with parameters
I have a search form where I put the NIF to do a search. Using datatables to fill in the information that is returned by echo json . have this code in javascript the data.id sends the id to php .…
jqueryasked usersantos 765 -
1
votes1
answer693
viewsQ: Delete session value from a variable
I have a button reset to delete values from a form. It turns out that I wanted to delete the session variable in PHP and I can’t do it, it can be by jQuery. This is the code I have:…
-
0
votes0
answers358
viewsQ: search datatables
good ones needed a help.. I’m using the datatables. I have a search form that when clicking will fetch run a php file , where send by parameters the search data , some fields can go in null. the php…
asked usersantos 765 -
1
votes0
answers255
viewsQ: modal poupop bootstrap
I’m wearing a modal from bootstrap. I call the modal after clicking on a onclick, that modal is on a page the part happens is that the button close-up does nothing for me. var btAbrir =…
twitter-bootstrapasked usersantos 765 -
1
votes1
answer85
viewsQ: how to open a new page by clicking an element in a table
how do I select an Row in datatables and open the content in more detail for an ID. I have a table with the following structure name ,id , address ,user. with values . When clicking to open a…
asked usersantos 765