the final statement prepared is
INSERT INTO tbl_ul_received
(unmask_id,seq_no,received_id,received_from,received_by,
received_via,received_with,received_for,received_date_time,received_comments)
VALUES S (223, 1, 'localhost',
'127.0.0.1', 'UnMask1.mshome.net', 'UnMask1.mshome.net',
'Tue, 1 Jan 2002 13:15:35 -0500 (EST)', 'ESMTP', 'g01IFZlU002773',
'[EMAIL PROTECTED]'
)
The table creation script for tbl_ul_received is as follows:-
CREATE TABLE tbl_ul_header_received
(
unmask_id int4 NOT NULL,
seq_no int4 NOT NULL,
received_id text,
received_from text,
received_by text,
received_via text,
received_with text,
received_for text,
received_date_time text,
received_comments text,
CONSTRAINT pk_received PRIMARY KEY (unmask_id, seq_no)
)
WITHOUT OIDS;
ALTER TABLE tbl_ul_header_received OWNER TO postgres;
When this insert statement gets executed (in perl) using
$query_tbl_ul_received->execute; it throws the following error
DBD::Pg::st execute failed: execute called with an unbound placeholder
at email_parser.pl line 566, <FILE> line 1.
In my perl code, query is formed as follows:-
my $query_tbl_ul_received = $dbh->prepare("INSERT INTO tbl_ul_received
(unmask_id,seq_no,received_id,received_from,received_by,received_via,received_with,received_for,received_date_time,received_comments)
VALUES
(".$unmask_id.",".$count.",'".$id."','".$from_from."','".$by_domain."'',',".$with."','".$for."','".$date_time."','".$rcomm."')");
I'm kind of badly stuck with this problem and have no clue about its solution.
A quick help would be highly appreciated.
Thanks,
Jas
On 1/21/07, Andrew Dunstan <[EMAIL PROTECTED]> wrote:
Jasbinder Singh Bali wrote:
> Hi,
>
> I'm trying to insert following values in one my tables in potgres 8.2.
>
> 223, 1, localhost, 127.0.0.1, UnMask1.mshome.net, UnMask1.mshome.net,
> Tue, 1 Jan 2002 13:15:35 -0500 (EST), ESMTP, g01IFZlU002773,
> [EMAIL PROTECTED]
>
> Except for the first two fields (that happend to be int4 datatype),
> rest all the fields are of data type text.
>
> When this query gets executed using command
>
> $query_tbl_ul_received->execute;
>
> I get the followring error:
>
> DBD::Pg::st execute failed: execute called with an unbound placeholder
> at email_parser.pl line 561, <FILE> line 1.
>
> Can anyone please throw some light on it.
>
>
not with this info - you need to show us the statement prepared and any
param bindings.
cheers
andrew
