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

Re: Error

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 (view raw or flat)
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/

In response to

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

Responses

  • Re: Error at 2005-12-01 15:50:15 from Charley Tiggs

pgsql-novice by date

Next:From: Gregory HightDate: 2005-12-01 01:46:08
Subject: PostgreSQL questions
Previous:From: operationsengineer1Date: 2005-12-01 01:00:02
Subject: Re: Error

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