Kevin Jenkins <gameprogrammer@xxxxxxxxxx> 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
