From: | <operationsengineer1(at)yahoo(dot)com> |
---|---|
To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Error |
Date: | 2005-12-01 01:12:03 |
Message-ID: | 20051201011203.33057.qmail@web33307.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
> What's the value of $customer_id before you attempt
> the insert?
>
> right after $customer_id variable is set, do the
> following:
>
> echo $customer_id . '<br />';
> echo gettype ( $customer_id );
> exit;
>
> With ADO, a couple of times, I've run into a glitch
> where bindings
> changed types. Haven't taken the time to figure out
> why. Switching
> to autoExecute solves the problem:
>
> $insert_array = array ( 'customer_id' =>
> $db->getone("select nextval
> ('t_customer_cust_id_seq')"),
> 'customer_name' =>
> $form->GetInputValue('customer_name'),
> 'customer_entry_date' => $db->DBDate(time()))
>
> $result = $db->autoExecute ( 't_customer',
> $insert_array,
> 'INSERT' );
>
> Most likely, the reason it works for me is that I
> cleaned up my error
> when switching to the autoExecute method.
>
> Charley
using php to cast to to an integer...
$customer_id = (int) $customer_id;
...worked for me. i have a note in on the adodb forum
to find out why it is casting as boolean.
__________________________________
Yahoo! Music Unlimited
Access over 1 million songs. Try it free.
http://music.yahoo.com/unlimited/
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Hight | 2005-12-01 01:46:08 | PostgreSQL questions |
Previous Message | operationsengineer1 | 2005-12-01 01:00:02 | Re: Error |