ERROR: there is no parameter $1

From: Kevin Jenkins <gameprogrammer(at)rakkar(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: ERROR: there is no parameter $1
Date: 2006-06-19 15:22:57
Message-ID: 4496C151.3090402@rakkar.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm using PQexecParams so I can upload filenames including path that
have '\' characters. It works everywhere else I used it but not with
this query.

I get ERROR: there is no parameter $1.

INSERT INTO FileVersionHistory(applicationID, filename, createFile,
changeSetID, userName) VALUES (1,$1::text,FALSE,9,'postgres');

outTemp[0]=deletedFiles.fileList[fileListIndex].filename;
outLengths[0]=strlen(deletedFiles.fileList[fileListIndex].filename);
formats[0]=0;
result = PQexecParams(pgConn, query,1,0,outTemp,outLengths,formats,0);

There obviously is a $1 parameter.

Ideas?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Golden 2006-06-19 17:03:06 Interface Guidance and Opinions Needed
Previous Message Florian G. Pflug 2006-06-19 15:08:00 Re: Adding foreign key constraints without integrity check?