JavaScript Sqlite - Simple way of storing single result in a var
0
I've been trying to store a single row result (in this case being ID) in a variable, so that it can be used elsewhere. I've got the following, but it's not passing it through.
var muteid =
con.each("SELECT max(id) as id from full_track", function(err, row) {
console.log(row.id);
});
const logembed = new discord.RichEmbed()
//.setTitle("User Muted")
.setAuthor(message.author.username, message.author.avatarURL)
.setDescription(`${tomute.user.tag} has been muted for ${ms(ms(mutedtime))}`)
.addField(`**Reason:** ${mutedreason}`, `aa`)
.setFooter(`ID: ${muteid}`)
.setTimestamp()
.setColor(3447003)
javascript sqlite
asked Nov 17 '18 at 0:09
ah1ah1
168
add a comment |
0
I've been trying to store a single row result (in this case being ID) in a variable, so that it can be used elsewhere. I've got the following, but it's not passing it through.
var muteid =
con.each("SELECT max(id) as id from full_track", function(err, row) {
console.log(row.id);
});
const logembed = new discord.RichEmbed()
//.setTitle("User Muted")
.setAuthor(message.author.username, message.author.avatarURL)
.setDescription(`${tomute.user.tag} has been muted for ${ms(ms(mutedtime))}`)
.addField(`**Reason:** ${mutedreason}`, `aa`)
.setFooter(`ID: ${muteid}`)
.setTimestamp()
.setColor(3447003)
javascript sqlite
asked Nov 17 '18 at 0:09
ah1ah1
168
What does "it's not passing it through" mean? Are you getting an error message?
– Marc
Nov 17 '18 at 0:13
var muteid is simply undefined - the console.log will return the correct result however
– ah1
Nov 17 '18 at 0:17
Can you provide more context? Where are you defining this variable? Sounds like it's in a different scope than where you're trying to use it.
– AnonymousSB
Nov 17 '18 at 0:18
Updated my original query
– ah1
Nov 17 '18 at 0:20
add a comment |
0
0
0
I've been trying to store a single row result (in this case being ID) in a variable, so that it can be used elsewhere. I've got the following, but it's not passing it through.
var muteid =
con.each("SELECT max(id) as id from full_track", function(err, row) {
console.log(row.id);
});
const logembed = new discord.RichEmbed()
//.setTitle("User Muted")
.setAuthor(message.author.username, message.author.avatarURL)
.setDescription(`${tomute.user.tag} has been muted for ${ms(ms(mutedtime))}`)
.addField(`**Reason:** ${mutedreason}`, `aa`)
.setFooter(`ID: ${muteid}`)
.setTimestamp()
.setColor(3447003)
javascript sqlite
asked Nov 17 '18 at 0:09
ah1ah1
168
I've been trying to store a single row result (in this case being ID) in a variable, so that it can be used elsewhere. I've got the following, but it's not passing it through.
var muteid =
con.each("SELECT max(id) as id from full_track", function(err, row) {
console.log(row.id);
});
const logembed = new discord.RichEmbed()
//.setTitle("User Muted")
.setAuthor(message.author.username, message.author.avatarURL)
.setDescription(`${tomute.user.tag} has been muted for ${ms(ms(mutedtime))}`)
.addField(`**Reason:** ${mutedreason}`, `aa`)
.setFooter(`ID: ${muteid}`)
.setTimestamp()
.setColor(3447003)
javascript sqlite
javascript sqlite
asked Nov 17 '18 at 0:09
ah1ah1
168
asked Nov 17 '18 at 0:09
ah1ah1
168
edited Nov 17 '18 at 0:20
ah1
asked Nov 17 '18 at 0:09
ah1ah1
168
asked Nov 17 '18 at 0:09
ah1ah1
168
asked Nov 17 '18 at 0:09
ah1ah1
168
168
What does "it's not passing it through" mean? Are you getting an error message?
– Marc
Nov 17 '18 at 0:13
var muteid is simply undefined - the console.log will return the correct result however
– ah1
Nov 17 '18 at 0:17
Can you provide more context? Where are you defining this variable? Sounds like it's in a different scope than where you're trying to use it.
– AnonymousSB
Nov 17 '18 at 0:18
Updated my original query
– ah1
Nov 17 '18 at 0:20
add a comment |
What does "it's not passing it through" mean? Are you getting an error message?
– Marc
Nov 17 '18 at 0:13
var muteid is simply undefined - the console.log will return the correct result however
– ah1
Nov 17 '18 at 0:17
Can you provide more context? Where are you defining this variable? Sounds like it's in a different scope than where you're trying to use it.
– AnonymousSB
Nov 17 '18 at 0:18
Updated my original query
– ah1
Nov 17 '18 at 0:20
What does "it's not passing it through" mean? Are you getting an error message?
– Marc
Nov 17 '18 at 0:13
What does "it's not passing it through" mean? Are you getting an error message?
– Marc
Nov 17 '18 at 0:13
var muteid is simply undefined - the console.log will return the correct result however
– ah1
Nov 17 '18 at 0:17
var muteid is simply undefined - the console.log will return the correct result however
– ah1
Nov 17 '18 at 0:17
Can you provide more context? Where are you defining this variable? Sounds like it's in a different scope than where you're trying to use it.
– AnonymousSB
Nov 17 '18 at 0:18
Can you provide more context? Where are you defining this variable? Sounds like it's in a different scope than where you're trying to use it.
– AnonymousSB
Nov 17 '18 at 0:18
Updated my original query
– ah1
Nov 17 '18 at 0:20
Updated my original query
– ah1
Nov 17 '18 at 0:20
add a comment |
1 Answer
1
active
oldest
votes
0
Simply put your code into your con.each handler where you put the console.log
var muteid, logembed = ;
con.each("SELECT max(id) as id from full_track", function(err, row) {
console.log(row.id);
muteid = row.id;
logembed[muteid] = new discord.RichEmbed()
//.setTitle("User Muted")
.setAuthor(message.author.username, message.author.avatarURL)
.setDescription(`${tomute.user.tag} has been muted for ${ms(ms(mutedtime))}`)
.addField(`**Reason:** ${mutedreason}`, `aa`)
.setFooter(`ID: ${muteid}`)
.setTimestamp()
.setColor(3447003);
});
answered Nov 17 '18 at 0:25
EricLavaultEricLavault
2,3191325
Thanks, how would I expose the muteid to code outside of the con.each handler?
– ah1
Nov 17 '18 at 0:50
It should stay accessible outside the scope of the function (it is declared outside).
– EricLavault
Nov 17 '18 at 1:50
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
});
}
});
draft saved
draft discarded
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%2f53346966%2fjavascript-sqlite-simple-way-of-storing-single-result-in-a-var%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
Simply put your code into your con.each handler where you put the console.log
var muteid, logembed = ;
con.each("SELECT max(id) as id from full_track", function(err, row) {
console.log(row.id);
muteid = row.id;
logembed[muteid] = new discord.RichEmbed()
//.setTitle("User Muted")
.setAuthor(message.author.username, message.author.avatarURL)
.setDescription(`${tomute.user.tag} has been muted for ${ms(ms(mutedtime))}`)
.addField(`**Reason:** ${mutedreason}`, `aa`)
.setFooter(`ID: ${muteid}`)
.setTimestamp()
.setColor(3447003);
});
answered Nov 17 '18 at 0:25
EricLavaultEricLavault
2,3191325
Thanks, how would I expose the muteid to code outside of the con.each handler?
– ah1
Nov 17 '18 at 0:50
It should stay accessible outside the scope of the function (it is declared outside).
– EricLavault
Nov 17 '18 at 1:50
add a comment |
0
Simply put your code into your con.each handler where you put the console.log
var muteid, logembed = ;
con.each("SELECT max(id) as id from full_track", function(err, row) {
console.log(row.id);
muteid = row.id;
logembed[muteid] = new discord.RichEmbed()
//.setTitle("User Muted")
.setAuthor(message.author.username, message.author.avatarURL)
.setDescription(`${tomute.user.tag} has been muted for ${ms(ms(mutedtime))}`)
.addField(`**Reason:** ${mutedreason}`, `aa`)
.setFooter(`ID: ${muteid}`)
.setTimestamp()
.setColor(3447003);
});
answered Nov 17 '18 at 0:25
EricLavaultEricLavault
2,3191325
Thanks, how would I expose the muteid to code outside of the con.each handler?
– ah1
Nov 17 '18 at 0:50
It should stay accessible outside the scope of the function (it is declared outside).
– EricLavault
Nov 17 '18 at 1:50
add a comment |
0
0
0
Simply put your code into your con.each handler where you put the console.log
var muteid, logembed = ;
con.each("SELECT max(id) as id from full_track", function(err, row) {
console.log(row.id);
muteid = row.id;
logembed[muteid] = new discord.RichEmbed()
//.setTitle("User Muted")
.setAuthor(message.author.username, message.author.avatarURL)
.setDescription(`${tomute.user.tag} has been muted for ${ms(ms(mutedtime))}`)
.addField(`**Reason:** ${mutedreason}`, `aa`)
.setFooter(`ID: ${muteid}`)
.setTimestamp()
.setColor(3447003);
});
answered Nov 17 '18 at 0:25
EricLavaultEricLavault
2,3191325
Simply put your code into your con.each handler where you put the console.log
var muteid, logembed = ;
con.each("SELECT max(id) as id from full_track", function(err, row) {
console.log(row.id);
muteid = row.id;
logembed[muteid] = new discord.RichEmbed()
//.setTitle("User Muted")
.setAuthor(message.author.username, message.author.avatarURL)
.setDescription(`${tomute.user.tag} has been muted for ${ms(ms(mutedtime))}`)
.addField(`**Reason:** ${mutedreason}`, `aa`)
.setFooter(`ID: ${muteid}`)
.setTimestamp()
.setColor(3447003);
});
answered Nov 17 '18 at 0:25
EricLavaultEricLavault
2,3191325
answered Nov 17 '18 at 0:25
EricLavaultEricLavault
2,3191325
answered Nov 17 '18 at 0:25
EricLavaultEricLavault
2,3191325
answered Nov 17 '18 at 0:25
EricLavaultEricLavault
2,3191325
2,3191325
Thanks, how would I expose the muteid to code outside of the con.each handler?
– ah1
Nov 17 '18 at 0:50
It should stay accessible outside the scope of the function (it is declared outside).
– EricLavault
Nov 17 '18 at 1:50
add a comment |
Thanks, how would I expose the muteid to code outside of the con.each handler?
– ah1
Nov 17 '18 at 0:50
It should stay accessible outside the scope of the function (it is declared outside).
– EricLavault
Nov 17 '18 at 1:50
Thanks, how would I expose the muteid to code outside of the con.each handler?
– ah1
Nov 17 '18 at 0:50
Thanks, how would I expose the muteid to code outside of the con.each handler?
– ah1
Nov 17 '18 at 0:50
It should stay accessible outside the scope of the function (it is declared outside).
– EricLavault
Nov 17 '18 at 1:50
It should stay accessible outside the scope of the function (it is declared outside).
– EricLavault
Nov 17 '18 at 1:50
add a comment |
draft saved
draft discarded
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.
draft saved
draft discarded
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%2f53346966%2fjavascript-sqlite-simple-way-of-storing-single-result-in-a-var%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
What does "it's not passing it through" mean? Are you getting an error message?
– Marc
Nov 17 '18 at 0:13
var muteid is simply undefined - the console.log will return the correct result however
– ah1
Nov 17 '18 at 0:17
Can you provide more context? Where are you defining this variable? Sounds like it's in a different scope than where you're trying to use it.
– AnonymousSB
Nov 17 '18 at 0:18
Updated my original query
– ah1
Nov 17 '18 at 0:20