Skip site navigation (1) Skip section navigation (2)


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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
i have the following code...

// start

        $db = &ADONewConnection('postgres');
        $db ->
//        $db -> debug=true;

        $customer_name =
        $customer_id = $db->getone("select

$sql_insert = <<<_EOSQL

    INSERT INTO t_customer (customer_id,
customer_name, customer_entry_date)
    VALUES (?,?,?)


        $result = $db->Execute($sql_insert,
array($customer_id, $customer_name,

//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


  • Re: Error at 2005-12-01 00:33:49 from Charley Tiggs

pgsql-novice by date

Next:From: Marcus EngeneDate: 2005-11-30 23:37:36
Subject: Re: Combinatorial problem
Previous:From: Marcus EngeneDate: 2005-11-30 21:32:52
Subject: Re: Combinatorial problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group