Hello,
I'm having some trouble with the DBD::Pg driver. I'm tring to insert a
record, and it tells me that I have a invalid placeholder. I'm not
trying to use a placeholder at all, so I'm a little confused as to where
it came from. Here is the statement:
INSERT INTO test
(user_id,status,dockpfx,mcno,company,responsible,contact,address,city,state,zipcode,country,email,contactno,local_phone,toll_phone,ext,faxno,url,signup,inactive_date,bill_date,comments,cr,last_issue,method)
VALUES
(currval('member_user_id_seq'),'suspend','','','Grandad\\\\','','My
Name','123 Home Rd.', 'mycity', 'TN', '38456', 'US', '[EMAIL PROTECTED]',
'999-999-9999', '999-999-9999', '', '', '999-999-9999', '', '2000-12-14
11\:16\:43', '2001-01-17 00\:00\:00', '2001-01-16', 'Phoned re\:mc and
suspn- no answer- 1/17/01', 0, 0, 'CC')
and I get this error:
Placeholder :0 invalid, placeholders must be >= 1 at
/usr/lib/perl5/site_perl/5.005/i386-linux/DBD/Pg.pm line 118.
This statement runs correctly through the psql shell. I'm not sure what
exactly is getting interpreted as a placeholder, because I'm not
(intentionally) using any. Any help would be appreciated. THX.
