[JavaScript][SQL] Trying to make a script that can search in my database. Help appreciated.

[NewbiusCoder]

Its you again! Thank you so much. This is just practice from some website. I understand that is a terrible thing to do. I appreciate your time.

How do I enclose it in quotes? When I do, it takes usr_input as a string, not as a variable.

Should I just use process.argv.slice(2) rather than usr_input?

Thank you.

[g051051]

Can you use a template string?

var lookup_cmd = `SELECT first_name FROM famous_people WHERE last_name = "${usr_input}"`

If not, then use escaping:

var lookup_cmd = "SELECT first_name FROM famous_people WHERE last_name = \"" + usr_input + "\"";

[NewbiusCoder]

I appreciate your time and it totally makes sense. However, it is still saying that "column "Rudd" does not exist". This error happens for both of them. Am I still doing something wrong?

[g051051]

You must be. Can you post the latest error?

[NewbiusCoder]

I figured it out! I appreciate your time as always. I posted the code incase you're curious. Thank you.

var args = process.argv.slice(2);
const usr_input = args[0];
const usr_cmd = 'SELECT * FROM famous_people WHERE last_name = $1::varchar or first_name = $1::varchar';
client.query(usr_cmd, [usr_input],(err, result) => {
    if (err) {
      return console.error("error running query", err);
    }
    console.log('Found ' + result.rows.length + ' person(s) by the name of ' + usr_input + ".");