Error

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