Sqlite Select query with where condition doesn't return any value
0
I've tried all possible formats for the select query:
var queryCust = "SELECT * FROM customers WHERE CustBarcode = '" + CustomerBarcode + "';";
or
var queryCust = "SELECT * FROM customers WHERE CustBarcode like '" + CustomerBarcode + "';";
or
var queryCust = "SELECT * FROM customers WHERE cast(CustBarcode as text) = '" + CustomerBarcode "';";
or with and without ' ' but nothing works, the query didn't return any value!
I've even tried
db.executeSql('SELECT * FROM customers WHERE CustBarcode = ?', [ CustBarcode ], function(rs) {...
but didn't worked, even when tried to convert with javascript CustBarcode to string or integer.
below is the function:
alert(queryCust);
db.executeSql(queryCust, , function(rs) {
alert(rs.rows.item(0).CustBarcode);
var DescCust = "";
if (rs.rows.item(0).Status == 'NEW'){
DescCust = rs.rows.item(0).Desc + ' ' + rs.rows.item(0).Address;
} else {
DescCust = rs.rows.item(0).CustCode + ' ' + rs.rows.item(0).Desc + ' ' + rs.rows.item(0).Address;
}
document.getElementById("custDesc").innerHTML = DescCust;
}, function(error) {
alert('SELECT SQL statement ERROR while building DescCust: ' + error.message);
});
javascript sqlite
asked Nov 20 at 16:27
Tony
530415
|
show 1 more comment
0
I've tried all possible formats for the select query:
var queryCust = "SELECT * FROM customers WHERE CustBarcode = '" + CustomerBarcode + "';";
or
var queryCust = "SELECT * FROM customers WHERE CustBarcode like '" + CustomerBarcode + "';";
or
var queryCust = "SELECT * FROM customers WHERE cast(CustBarcode as text) = '" + CustomerBarcode "';";
or with and without ' ' but nothing works, the query didn't return any value!
I've even tried
db.executeSql('SELECT * FROM customers WHERE CustBarcode = ?', [ CustBarcode ], function(rs) {...
but didn't worked, even when tried to convert with javascript CustBarcode to string or integer.
below is the function:
alert(queryCust);
db.executeSql(queryCust, , function(rs) {
alert(rs.rows.item(0).CustBarcode);
var DescCust = "";
if (rs.rows.item(0).Status == 'NEW'){
DescCust = rs.rows.item(0).Desc + ' ' + rs.rows.item(0).Address;
} else {
DescCust = rs.rows.item(0).CustCode + ' ' + rs.rows.item(0).Desc + ' ' + rs.rows.item(0).Address;
}
document.getElementById("custDesc").innerHTML = DescCust;
}, function(error) {
alert('SELECT SQL statement ERROR while building DescCust: ' + error.message);
});
javascript sqlite
asked Nov 20 at 16:27
Tony
530415
Did you try using the query in your SQL DB interface (eg phpMyAdmin)?
– Sv443
Nov 20 at 16:29
I don't have it, the table is created in phonegap application like this tx.executeSql('CREATE TABLE IF NOT EXISTS customers (CustBarcode, CustCode, Desc, Address, Long, Lat, Status)');
– Tony
Nov 20 at 16:31
then try using your query just like you created the table and see if it returns something. Also did you even write some data to the DB? Else it makes sense it can't return something because it's empty.
– Sv443
Nov 20 at 16:33
of course their is data in the table tx.executeSql('INSERT INTO customers VALUES (?,?,?,?,?,?,?)', [... and i am able to perform select * from customers it's returning results, but the problem is with the WHERE condition
– Tony
Nov 20 at 16:35
Can you tell me what exactly you get if you useSELECT * FROM customers?
– Sv443
Nov 21 at 10:52
|
show 1 more comment
0
0
0
I've tried all possible formats for the select query:
var queryCust = "SELECT * FROM customers WHERE CustBarcode = '" + CustomerBarcode + "';";
or
var queryCust = "SELECT * FROM customers WHERE CustBarcode like '" + CustomerBarcode + "';";
or
var queryCust = "SELECT * FROM customers WHERE cast(CustBarcode as text) = '" + CustomerBarcode "';";
or with and without ' ' but nothing works, the query didn't return any value!
I've even tried
db.executeSql('SELECT * FROM customers WHERE CustBarcode = ?', [ CustBarcode ], function(rs) {...
but didn't worked, even when tried to convert with javascript CustBarcode to string or integer.
below is the function:
alert(queryCust);
db.executeSql(queryCust, , function(rs) {
alert(rs.rows.item(0).CustBarcode);
var DescCust = "";
if (rs.rows.item(0).Status == 'NEW'){
DescCust = rs.rows.item(0).Desc + ' ' + rs.rows.item(0).Address;
} else {
DescCust = rs.rows.item(0).CustCode + ' ' + rs.rows.item(0).Desc + ' ' + rs.rows.item(0).Address;
}
document.getElementById("custDesc").innerHTML = DescCust;
}, function(error) {
alert('SELECT SQL statement ERROR while building DescCust: ' + error.message);
});
javascript sqlite
asked Nov 20 at 16:27
Tony
530415
I've tried all possible formats for the select query:
var queryCust = "SELECT * FROM customers WHERE CustBarcode = '" + CustomerBarcode + "';";
or
var queryCust = "SELECT * FROM customers WHERE CustBarcode like '" + CustomerBarcode + "';";
or
var queryCust = "SELECT * FROM customers WHERE cast(CustBarcode as text) = '" + CustomerBarcode "';";
or with and without ' ' but nothing works, the query didn't return any value!
I've even tried
db.executeSql('SELECT * FROM customers WHERE CustBarcode = ?', [ CustBarcode ], function(rs) {...
but didn't worked, even when tried to convert with javascript CustBarcode to string or integer.
below is the function:
alert(queryCust);
db.executeSql(queryCust, , function(rs) {
alert(rs.rows.item(0).CustBarcode);
var DescCust = "";
if (rs.rows.item(0).Status == 'NEW'){
DescCust = rs.rows.item(0).Desc + ' ' + rs.rows.item(0).Address;
} else {
DescCust = rs.rows.item(0).CustCode + ' ' + rs.rows.item(0).Desc + ' ' + rs.rows.item(0).Address;
}
document.getElementById("custDesc").innerHTML = DescCust;
}, function(error) {
alert('SELECT SQL statement ERROR while building DescCust: ' + error.message);
});
javascript sqlite
javascript sqlite
asked Nov 20 at 16:27
Tony
530415
asked Nov 20 at 16:27
Tony
530415
edited Nov 20 at 21:58
asked Nov 20 at 16:27
Tony
530415
asked Nov 20 at 16:27
Tony
530415
asked Nov 20 at 16:27
Tony
530415
530415
Did you try using the query in your SQL DB interface (eg phpMyAdmin)?
– Sv443
Nov 20 at 16:29
I don't have it, the table is created in phonegap application like this tx.executeSql('CREATE TABLE IF NOT EXISTS customers (CustBarcode, CustCode, Desc, Address, Long, Lat, Status)');
– Tony
Nov 20 at 16:31
then try using your query just like you created the table and see if it returns something. Also did you even write some data to the DB? Else it makes sense it can't return something because it's empty.
– Sv443
Nov 20 at 16:33
of course their is data in the table tx.executeSql('INSERT INTO customers VALUES (?,?,?,?,?,?,?)', [... and i am able to perform select * from customers it's returning results, but the problem is with the WHERE condition
– Tony
Nov 20 at 16:35
Can you tell me what exactly you get if you useSELECT * FROM customers?
– Sv443
Nov 21 at 10:52
|
show 1 more comment
Did you try using the query in your SQL DB interface (eg phpMyAdmin)?
– Sv443
Nov 20 at 16:29
I don't have it, the table is created in phonegap application like this tx.executeSql('CREATE TABLE IF NOT EXISTS customers (CustBarcode, CustCode, Desc, Address, Long, Lat, Status)');
– Tony
Nov 20 at 16:31
then try using your query just like you created the table and see if it returns something. Also did you even write some data to the DB? Else it makes sense it can't return something because it's empty.
– Sv443
Nov 20 at 16:33
of course their is data in the table tx.executeSql('INSERT INTO customers VALUES (?,?,?,?,?,?,?)', [... and i am able to perform select * from customers it's returning results, but the problem is with the WHERE condition
– Tony
Nov 20 at 16:35
Can you tell me what exactly you get if you useSELECT * FROM customers?
– Sv443
Nov 21 at 10:52
Did you try using the query in your SQL DB interface (eg phpMyAdmin)?
– Sv443
Nov 20 at 16:29
Did you try using the query in your SQL DB interface (eg phpMyAdmin)?
– Sv443
Nov 20 at 16:29
I don't have it, the table is created in phonegap application like this tx.executeSql('CREATE TABLE IF NOT EXISTS customers (CustBarcode, CustCode, Desc, Address, Long, Lat, Status)');
– Tony
Nov 20 at 16:31
I don't have it, the table is created in phonegap application like this tx.executeSql('CREATE TABLE IF NOT EXISTS customers (CustBarcode, CustCode, Desc, Address, Long, Lat, Status)');
– Tony
Nov 20 at 16:31
then try using your query just like you created the table and see if it returns something. Also did you even write some data to the DB? Else it makes sense it can't return something because it's empty.
– Sv443
Nov 20 at 16:33
then try using your query just like you created the table and see if it returns something. Also did you even write some data to the DB? Else it makes sense it can't return something because it's empty.
– Sv443
Nov 20 at 16:33
of course their is data in the table tx.executeSql('INSERT INTO customers VALUES (?,?,?,?,?,?,?)', [... and i am able to perform select * from customers it's returning results, but the problem is with the WHERE condition
– Tony
Nov 20 at 16:35
of course their is data in the table tx.executeSql('INSERT INTO customers VALUES (?,?,?,?,?,?,?)', [... and i am able to perform select * from customers it's returning results, but the problem is with the WHERE condition
– Tony
Nov 20 at 16:35
Can you tell me what exactly you get if you use
SELECT * FROM customers?– Sv443
Nov 21 at 10:52
Can you tell me what exactly you get if you use
SELECT * FROM customers?– Sv443
Nov 21 at 10:52
|
show 1 more comment
active
oldest
votes
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%2f53397366%2fsqlite-select-query-with-where-condition-doesnt-return-any-value%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53397366%2fsqlite-select-query-with-where-condition-doesnt-return-any-value%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
Did you try using the query in your SQL DB interface (eg phpMyAdmin)?
– Sv443
Nov 20 at 16:29
I don't have it, the table is created in phonegap application like this tx.executeSql('CREATE TABLE IF NOT EXISTS customers (CustBarcode, CustCode, Desc, Address, Long, Lat, Status)');
– Tony
Nov 20 at 16:31
then try using your query just like you created the table and see if it returns something. Also did you even write some data to the DB? Else it makes sense it can't return something because it's empty.
– Sv443
Nov 20 at 16:33
of course their is data in the table tx.executeSql('INSERT INTO customers VALUES (?,?,?,?,?,?,?)', [... and i am able to perform select * from customers it's returning results, but the problem is with the WHERE condition
– Tony
Nov 20 at 16:35
Can you tell me what exactly you get if you use
SELECT * FROM customers?– Sv443
Nov 21 at 10:52