I am encountering a strange issue with my insert statement where I am receiving an unexpected value, ideally it should be a numeric value.
Below is the button code snippet found on my .pug page:
input(type="submit" value="Add Line" @click="addLine")
Here is my insert statement along with a post request:
output Inserted.*
Values (
'${req.query.quote_number || ''}',
((select count(quote_number) as [count]
from quote_line
where quote_number = ${req.query.quote_number || ''}) + 1),
'new item line',
getDate()
)
However, instead of the expected data for req.query.quote_number, I am receiving [object mouseEvent].