CODEWITHSUNDEEP
javascriptsqlnode.jspostgresqlkoa
user11074500
user11074500

Reputation:

postgresql error: column "" does not exist in where clause

I'm trying to check if email already exists and i'm sending [email protected] in email parameter but getting error column "daniyal" does not exist.

ctx.app.pool.query("SELECT * FROM users WHERE email = " + ctx.request.body.email, (err, result) => {
            if (err) {
                ctx.body = {
                    status: 500,
                    message: 'Something went wrong'
                };
                console.log('Query Error: ', err);
                throw err
            } else {
                ctx.body = {
                    exceptions: "",
                    status: 200,
                    error: false,
                    message: "user already exists with this email",
                };
            }
        });

Upvotes: 0

Views: 1988

Answers (1)

GMB
GMB

Reputation: 222512

Your immediate issue is that you are missing single quotes around the value that you are passing (hence, Postgres considers it a column name).

But for this, you do want to use a parameterized query, for both security and efficiency

ctx.app.pool.query(
    "SELECT * FROM users WHERE email = ?", 
    [ctx.request.body.email], 
    function(err, result) => {
        if (err) {
            ctx.body = {
                status: 500,
                message: 'Something went wrong'
            };
            console.log('Query Error: ', err);
            throw err
        } else {
            ctx.body = {
                exceptions: "",
                status: 200,
                error: false,
                message: "user already exists with this email",
            };
        }
    }
);

Upvotes: 3

Related Questions