INSERT INTO acc_trans
(trans_id, chart_id, transdate,
amount, source, memo)
VALUES (?, (SELECT id
FROM chart
WHERE accno = ?),
?, ?, ?, ?)
ERROR: invalid input syntax for type date: ""
Any pointers to what this might be?
Thanks
Rob