Error with a simple function (Count) in MySQL

theguillerstar1

PROOP

10 months ago

thanks

Solved$10 Bounty

Pinned Solution

idiegea21

HOBBY

10 months ago

The issue happens because the query in Node.js doesn’t specify the schema (railway.vendedores) and dni may be stored as a string, causing the request to hang or return nothing.

Use the full table path and cast dni as a string in your query:

const query = 'SELECT COUNT(*) as count FROM railway.vendedores WHERE dni = ?';
db.query(query, [String(req.params.dni)], (error, results) => {
  if (error) return res.status(500).json({ error: 'Error al verificar DNI' });
  console.log(results);
  res.json({ available: results[0].count === 0 });
});

2 Replies

Railway

BOT

10 months ago

Hey there! We've found the following might help you get unblocked faster:

If you find the answer from one of these, please let us know by solving the thread!

idiegea21

HOBBY

10 months ago

The issue happens because the query in Node.js doesn’t specify the schema (railway.vendedores) and dni may be stored as a string, causing the request to hang or return nothing.

Use the full table path and cast dni as a string in your query:

const query = 'SELECT COUNT(*) as count FROM railway.vendedores WHERE dni = ?';
db.query(query, [String(req.params.dni)], (error, results) => {
  if (error) return res.status(500).json({ error: 'Error al verificar DNI' });
  console.log(results);
  res.json({ available: results[0].count === 0 });
});

Status changed to Solved brody • 9 months ago

Welcome!