error: there is no parameter $1

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

Responses

Browse pgsql-novice by date

  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