[GENERAL] ERROR: there is no parameter $1

2007-11-15 Thread Steve Manes
This one has me stumped. Does anyone know under which circumstances this error would be returned by PHP's pg_query_params() even if the procedure completed without an apparent error? The procedure and PHP API code haven't changed in weeks. I started getting this after I upgraded the database

Re: [GENERAL] ERROR: there is no parameter $1 --> PLEASE IGNORE!

2007-11-15 Thread Steve Manes
Steve Manes wrote: Steve Manes wrote: This one has me stumped. Does anyone know under which circumstances this error would be returned by PHP's pg_query_params() even if the procedure completed without an apparent error? The answer was right in front of me. An (*ahem*) associate was screwin

Re: [GENERAL] ERROR: there is no parameter $1

2007-11-15 Thread Steve Manes
Steve Manes wrote: This one has me stumped. Does anyone know under which circumstances this error would be returned by PHP's pg_query_params() even if the procedure completed without an apparent error? The procedure and PHP API code haven't changed in weeks. I started getting this after I u

Re: [GENERAL] ERROR: there is no parameter $1

2006-06-19 Thread Tom Lane
Kevin Jenkins <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Hm, nothing obviously wrong there. What PG version is this exactly? >> Can you supply a self-contained test case? > I made the smallest test case that I can and uploaded it here: > http://www.rakkarsoft.com/PostgreBug.zip > I'm sorry

Re: [GENERAL] ERROR: there is no parameter $1

2006-06-19 Thread Kevin Jenkins
Tom Lane wrote: Kevin Jenkins <[EMAIL PROTECTED]> 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; out

Re: [GENERAL] ERROR: there is no parameter $1

2006-06-19 Thread Tom Lane
Kevin Jenkins <[EMAIL PROTECTED]> 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]=s

[GENERAL] ERROR: there is no parameter $1

2006-06-19 Thread Kevin Jenkins
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) VALUE