Kevin Jenkins <gameprogrammer(at)rakkar(dot)org> writes:
> 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.
Hm, nothing obviously wrong there. What PG version is this exactly?
Can you supply a self-contained test case?
regards, tom lane