From: | <operationsengineer1(at)yahoo(dot)com> |
---|---|
To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Error |
Date: | 2005-11-30 21:35:46 |
Message-ID: | 20051130213546.45625.qmail@web33314.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
i have the following code...
// start
$db = &ADONewConnection('postgres');
$db ->
Connect($db_string,$db_owner,$db_pw,$db_name);
// $db -> debug=true;
$customer_name =
$form->GetInputValue('customer_name');
$customer_id = $db->getone("select
nextval('t_customer_cust_id_seq')");
$sql_insert = <<<_EOSQL
INSERT INTO t_customer (customer_id,
customer_name, customer_entry_date)
VALUES (?,?,?)
_EOSQL;
$result = $db->Execute($sql_insert,
array($customer_id, $customer_name,
$db->DBDate(time())));
//end code
it produces the following error...
ERROR: column "customer_id" is of type integer but
expression is of type boolean HINT: You will need to
rewrite or cast the expression.
any ideas?
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Marcus Engene | 2005-11-30 23:37:36 | Re: Combinatorial problem |
Previous Message | Marcus Engene | 2005-11-30 21:32:52 | Re: Combinatorial problem |