Re: pass date type data to PQexecparams - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: pass date type data to PQexecparams
Date
Msg-id 20060927133233.GA9681@winnie.fuhr.org
Whole thread Raw
In response to Re: pass date type data to PQexecparams  (pr0v4 <josip.povreslo@gmail.com>)
Responses Re: pass date type data to PQexecparams
List pgsql-novice
On Wed, Sep 27, 2006 at 12:41:21PM +0200, pr0v4 wrote:
> Sorry because uncompiled example program, yesterday I was very busy so I've
> probably forget to compile it. I thought I done that.
> Well about my problem, I have done what you said to me to try, well it
> isn't help.
> Now I'm getting following error message:
> Insert new records FAILED: ERROR:  invalid input syntax for type date: ""

Have you used PQgetisnull() to check if the value you retrieved is
NULL?  If that's not the problem then please post a minimal but
complete program that compiles and runs and demonstrates the behavior
you're seeing.  Include any SQL statements necessary to set up the
test (CREATE TABLE, INSERT, etc.).  We need to see exactly what
you're doing to be able to say why it doesn't work.

--
Michael Fuhr

pgsql-novice by date:

Previous
From: Ilan Volow
Date:
Subject: Re: Backup & Restore
Next
From: developer_student
Date:
Subject: Postgre cannot delete from a table