I am trying to modify a query on my server side (node.js) that looks like this:
var http = require('http');
var query = "SELECT * FROM Users WHERE Email='Test.User@TestUser.com'";
This is the hardcoded query. I'm trying to do something like this (email being a variable pulled in from an input text area in an HTML doc):
var http = require('http');
var query = "SELECT * FROM Users WHERE Email=" + "'" + email + "'";
I'm using JQuery to handle the request like this from a javascript file:
$.ajax({
url: "http://127.0.0.1:8000/",
type: "POST",
success: function(dataRcvd) {
alert(dataRcvd);
}
If I figure out how to do this I can dynamically update the var query
with different SQL queries/stored procedures.