From: | Kinnard Hockenhull <kinnard(at)bitbox(dot)mx> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | error: there is no parameter $1 |
Date: | 2013-10-14 22:30:47 |
Message-ID: | CADxWJUr6t9na-eA-e_GtsLtb=os5MZkcu5FpRwoDw0MJ7TFduw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I get "error: there is no parameter $1" when I try to run this code using
the node-postgres <https://github.com/brianc/node-postgres> client:
client = pg.connect(connectionString, function(err, client, done){
if(err) console.log(err);
client.query('INSERT INTO causes (cause_name, goal, organization,
sponsor, submitter) VALUES ($1,$2,$3,$4,$5)', r, function(err){
console.log('This is r' + r)
if (err) console.log(err);
});
});
Any advice?
PS:
This is the full error statement:
{ [error: there is no parameter $1]
name: 'error',
length: 87,
severity: 'ERROR',
code: '42P02',
detail: undefined,
hint: undefined,
position: '81',
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
file: 'parse_expr.c',
line: '812',
routine: 'transformParamRef' }
--
All the best,
Kinnard Hockenhull
Founder + CEO,
BitBox <http://bitbox.mx/>
**********************************************************
Electronic Mail is not secure, may not be read every day, and should not be
used for urgent or sensitive issues
From | Date | Subject | |
---|---|---|---|
Next Message | David Johnston | 2013-10-14 23:51:53 | Re: error: there is no parameter $1 |
Previous Message | Payal Singh | 2013-10-14 16:30:57 | Re: How to Monitor backups |