How to push JSON data to an array with duplicate values in java script
I have to return all the data which is present in the table_name without any removal of duplicate values, till the console i can see all the records from db , once it is pushed to an array1 then my repeated records got disappeared.
I want to return all the records.
db.query('SELECT * FROM table_name ORDER BY name', function(err, data)
if (err) return next(err);
var array = ,
array1 = ;
for (var i = 0; i < data.rows.length; i++)
if (array[data.rows[i].name]) continue;
array[data.rows[i].name] = true;
console.log(array[data.rows[i].name])// till here
array1 .push(data.rows[i])
return res.status(200).send(array1 );
);
javascript arrays postgresql duplicates push
edited Oct 12 '18 at 10:53
fiza khan
973420
asked Oct 12 '18 at 5:49
ManasaManasa
678
add a comment |
I have to return all the data which is present in the table_name without any removal of duplicate values, till the console i can see all the records from db , once it is pushed to an array1 then my repeated records got disappeared.
I want to return all the records.
db.query('SELECT * FROM table_name ORDER BY name', function(err, data)
if (err) return next(err);
var array = ,
array1 = ;
for (var i = 0; i < data.rows.length; i++)
if (array[data.rows[i].name]) continue;
array[data.rows[i].name] = true;
console.log(array[data.rows[i].name])// till here
array1 .push(data.rows[i])
return res.status(200).send(array1 );
);
javascript arrays postgresql duplicates push
edited Oct 12 '18 at 10:53
fiza khan
973420
asked Oct 12 '18 at 5:49
ManasaManasa
678
1
Change the entire function below theerrhandler toreturn data.rows.
– CertainPerformance
Oct 12 '18 at 5:50
My bad!! @CertainPerformance:) thanks
– Manasa
Oct 12 '18 at 6:00
add a comment |
I have to return all the data which is present in the table_name without any removal of duplicate values, till the console i can see all the records from db , once it is pushed to an array1 then my repeated records got disappeared.
I want to return all the records.
db.query('SELECT * FROM table_name ORDER BY name', function(err, data)
if (err) return next(err);
var array = ,
array1 = ;
for (var i = 0; i < data.rows.length; i++)
if (array[data.rows[i].name]) continue;
array[data.rows[i].name] = true;
console.log(array[data.rows[i].name])// till here
array1 .push(data.rows[i])
return res.status(200).send(array1 );
);
javascript arrays postgresql duplicates push
edited Oct 12 '18 at 10:53
fiza khan
973420
asked Oct 12 '18 at 5:49
ManasaManasa
678
I have to return all the data which is present in the table_name without any removal of duplicate values, till the console i can see all the records from db , once it is pushed to an array1 then my repeated records got disappeared.
I want to return all the records.
db.query('SELECT * FROM table_name ORDER BY name', function(err, data)
if (err) return next(err);
var array = ,
array1 = ;
for (var i = 0; i < data.rows.length; i++)
if (array[data.rows[i].name]) continue;
array[data.rows[i].name] = true;
console.log(array[data.rows[i].name])// till here
array1 .push(data.rows[i])
return res.status(200).send(array1 );
);
javascript arrays postgresql duplicates push
javascript arrays postgresql duplicates push
edited Oct 12 '18 at 10:53
fiza khan
973420
asked Oct 12 '18 at 5:49
ManasaManasa
678
edited Oct 12 '18 at 10:53
fiza khan
973420
asked Oct 12 '18 at 5:49
ManasaManasa
678
edited Oct 12 '18 at 10:53
fiza khan
973420
edited Oct 12 '18 at 10:53
fiza khan
973420
edited Oct 12 '18 at 10:53
fiza khan
973420
973420
asked Oct 12 '18 at 5:49
ManasaManasa
678
asked Oct 12 '18 at 5:49
ManasaManasa
678
asked Oct 12 '18 at 5:49
ManasaManasa
678
678
1
Change the entire function below theerrhandler toreturn data.rows.
– CertainPerformance
Oct 12 '18 at 5:50
My bad!! @CertainPerformance:) thanks
– Manasa
Oct 12 '18 at 6:00
add a comment |
1
Change the entire function below theerrhandler toreturn data.rows.
– CertainPerformance
Oct 12 '18 at 5:50
My bad!! @CertainPerformance:) thanks
– Manasa
Oct 12 '18 at 6:00
1
1
Change the entire function below the
err handler to return data.rows.– CertainPerformance
Oct 12 '18 at 5:50
Change the entire function below the
err handler to return data.rows.– CertainPerformance
Oct 12 '18 at 5:50
My bad!! @CertainPerformance:) thanks
– Manasa
Oct 12 '18 at 6:00
My bad!! @CertainPerformance:) thanks
– Manasa
Oct 12 '18 at 6:00
add a comment |
2 Answers
2
active
oldest
votes
I am not sure why you are using multiple arrays, hope this will help you
db.query('SELECT * FROM table_name ORDER BY name', function(err, data)
if (err) return next(err);
var array = ,
array1 = ;
for (var i = 0; i < data.rows.length; i++)
if (array[data.rows[i].name]) continue;
array[data.rows[i].name] = true;
array1 .push(data.rows)
return res.status(200).send(array1 );
);
answered Nov 14 '18 at 9:54
SchülerSchüler
144115
add a comment |
You are adding properties to the array variable in the first line of the loop, using the name property from data. If some other row exists with the same name, the item won't be added.
answered Oct 12 '18 at 6:01
Mario VázquezMario Vázquez
17215
1
An example or code correction will do much better.
– Rutwick Gangurde
Oct 12 '18 at 11:55
1
it seems this is rather a comment than an answer...
– Serge
Oct 12 '18 at 14:56
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f52773026%2fhow-to-push-json-data-to-an-array-with-duplicate-values-in-java-script%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
I am not sure why you are using multiple arrays, hope this will help you
db.query('SELECT * FROM table_name ORDER BY name', function(err, data)
if (err) return next(err);
var array = ,
array1 = ;
for (var i = 0; i < data.rows.length; i++)
if (array[data.rows[i].name]) continue;
array[data.rows[i].name] = true;
array1 .push(data.rows)
return res.status(200).send(array1 );
);
answered Nov 14 '18 at 9:54
SchülerSchüler
144115
add a comment |
I am not sure why you are using multiple arrays, hope this will help you
db.query('SELECT * FROM table_name ORDER BY name', function(err, data)
if (err) return next(err);
var array = ,
array1 = ;
for (var i = 0; i < data.rows.length; i++)
if (array[data.rows[i].name]) continue;
array[data.rows[i].name] = true;
array1 .push(data.rows)
return res.status(200).send(array1 );
);
answered Nov 14 '18 at 9:54
SchülerSchüler
144115
add a comment |
I am not sure why you are using multiple arrays, hope this will help you
db.query('SELECT * FROM table_name ORDER BY name', function(err, data)
if (err) return next(err);
var array = ,
array1 = ;
for (var i = 0; i < data.rows.length; i++)
if (array[data.rows[i].name]) continue;
array[data.rows[i].name] = true;
array1 .push(data.rows)
return res.status(200).send(array1 );
);
answered Nov 14 '18 at 9:54
SchülerSchüler
144115
I am not sure why you are using multiple arrays, hope this will help you
db.query('SELECT * FROM table_name ORDER BY name', function(err, data)
if (err) return next(err);
var array = ,
array1 = ;
for (var i = 0; i < data.rows.length; i++)
if (array[data.rows[i].name]) continue;
array[data.rows[i].name] = true;
array1 .push(data.rows)
return res.status(200).send(array1 );
);
answered Nov 14 '18 at 9:54
SchülerSchüler
144115
answered Nov 14 '18 at 9:54
SchülerSchüler
144115
answered Nov 14 '18 at 9:54
SchülerSchüler
144115
answered Nov 14 '18 at 9:54
SchülerSchüler
144115
144115
add a comment |
add a comment |
You are adding properties to the array variable in the first line of the loop, using the name property from data. If some other row exists with the same name, the item won't be added.
answered Oct 12 '18 at 6:01
Mario VázquezMario Vázquez
17215
1
An example or code correction will do much better.
– Rutwick Gangurde
Oct 12 '18 at 11:55
1
it seems this is rather a comment than an answer...
– Serge
Oct 12 '18 at 14:56
add a comment |
You are adding properties to the array variable in the first line of the loop, using the name property from data. If some other row exists with the same name, the item won't be added.
answered Oct 12 '18 at 6:01
Mario VázquezMario Vázquez
17215
1
An example or code correction will do much better.
– Rutwick Gangurde
Oct 12 '18 at 11:55
1
it seems this is rather a comment than an answer...
– Serge
Oct 12 '18 at 14:56
add a comment |
You are adding properties to the array variable in the first line of the loop, using the name property from data. If some other row exists with the same name, the item won't be added.
answered Oct 12 '18 at 6:01
Mario VázquezMario Vázquez
17215
You are adding properties to the array variable in the first line of the loop, using the name property from data. If some other row exists with the same name, the item won't be added.
answered Oct 12 '18 at 6:01
Mario VázquezMario Vázquez
17215
answered Oct 12 '18 at 6:01
Mario VázquezMario Vázquez
17215
answered Oct 12 '18 at 6:01
Mario VázquezMario Vázquez
17215
answered Oct 12 '18 at 6:01
Mario VázquezMario Vázquez
17215
17215
1
An example or code correction will do much better.
– Rutwick Gangurde
Oct 12 '18 at 11:55
1
it seems this is rather a comment than an answer...
– Serge
Oct 12 '18 at 14:56
add a comment |
1
An example or code correction will do much better.
– Rutwick Gangurde
Oct 12 '18 at 11:55
1
it seems this is rather a comment than an answer...
– Serge
Oct 12 '18 at 14:56
1
1
An example or code correction will do much better.
– Rutwick Gangurde
Oct 12 '18 at 11:55
An example or code correction will do much better.
– Rutwick Gangurde
Oct 12 '18 at 11:55
1
1
it seems this is rather a comment than an answer...
– Serge
Oct 12 '18 at 14:56
it seems this is rather a comment than an answer...
– Serge
Oct 12 '18 at 14:56
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f52773026%2fhow-to-push-json-data-to-an-array-with-duplicate-values-in-java-script%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Change the entire function below the
errhandler toreturn data.rows.– CertainPerformance
Oct 12 '18 at 5:50
My bad!! @CertainPerformance:) thanks
– Manasa
Oct 12 '18 at 6:00