{"id":757,"date":"2022-08-30T15:06:40","date_gmt":"2022-08-30T15:06:40","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2013\/11\/09\/building-a-sqlite-statement-in-js-and-im-not-getting-the-full-command-i-want-collection-of-common-programming-errors\/"},"modified":"2022-08-30T15:06:40","modified_gmt":"2022-08-30T15:06:40","slug":"building-a-sqlite-statement-in-js-and-im-not-getting-the-full-command-i-want-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2022\/08\/30\/building-a-sqlite-statement-in-js-and-im-not-getting-the-full-command-i-want-collection-of-common-programming-errors\/","title":{"rendered":"Building a SQLite statement in JS and I&#39;m not getting the full command I want-Collection of common programming errors"},"content":{"rendered":"<p>If by JS you mean JavaScript, then this is not what&#8217;s happening. Here&#8217;s the jsfiddle:<\/p>\n<ul>\n<li>http:\/\/jsfiddle.net\/Ka938\/<\/li>\n<\/ul>\n<p>Try it and you will see it&#8217;s not a JS problem. The escaping is probably happening later in the process, when this gets to the server or something. Don&#8217;t know the exact details to help there.<\/p>\n<p>As a guess, if you are using PHP and (s)printf, then sending <code>%f<\/code> (where <code>f<\/code> is coming from <code>foo<\/code> example you used) is going to mean it expects a float &#8211; it would display an error, though.<\/p>\n<p>As a side note, it seems that you are sending SQL from the client to the server. If so, it&#8217;s probably a very bad idea to do this, especially if you are not doing any SQL escaping, as you are not per above. Take a look here:<\/p>\n<ul>\n<li>http:\/\/en.wikipedia.org\/wiki\/SQL_injection<\/li>\n<\/ul>\n<p>for basic details.<\/p>\n<p>I&#8217;m not familiar with webOS, but check this SOq for something that looks to be handling SQL parameters correctly:<\/p>\n<p>Definitively worth doing some more investigation about how to do this properly in webOS &#8211; Google is your friend.<\/p>\n<p id=\"rop\"><small>Originally posted 2013-11-09 22:39:13. <\/small><\/p>","protected":false},"excerpt":{"rendered":"<p>If by JS you mean JavaScript, then this is not what&#8217;s happening. Here&#8217;s the jsfiddle: http:\/\/jsfiddle.net\/Ka938\/ Try it and you will see it&#8217;s not a JS problem. The escaping is probably happening later in the process, when this gets to the server or something. Don&#8217;t know the exact details to help there. As a guess, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-757","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/757","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=757"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/757\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=757"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=757"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=757"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}