Re: Error
От | |
---|---|
Тема | Re: Error |
Дата | |
Msg-id | 20051201011203.33057.qmail@web33307.mail.mud.yahoo.com обсуждение исходный текст |
Ответ на | Error (<operationsengineer1@yahoo.com>) |
Ответы |
Re: Error
|
Список | 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/
В списке pgsql-novice по дате отправления: