On Wednesday 14 February 2001 17:55, you wrote:
> On Wed, Feb 14, 2001 at 12:35:10PM +0000, Butler, Shaun wrote:
> > So I want to bind multiple values that are in an associative array
> >
> > I have this code
> >
> >
> > foreach ($binds as $key=>$value)
> > {
> > OCIBindByName($this->m_cursor,":$key",$value,-1);
> > }
> >
> > but it only seems to work for one value in the array, the array conetents
> > would be something like
> >
> > $binds["id"] = 54;
> > $binds["name"] = Dick;
> >
> > anyone get this to work or have any idea why it works when the array only
> > has one thing in it? Thanks in advance
>
> the values bound by ocibindbyname are "taken" from
> script-space when you call ociexecute() and then $value will
> have only one value.
>
> tc
in case anyone needs this I fixed it by doing this
foreach ($binds as $key=>$value)
{
$$key = $value;
OCIBindByName($this->m_cursor,":$key",$$key,-1);
}
thanks tc
--
Shaun Butler
[EMAIL PROTECTED]
x2905
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
