MDB2 column "object" does not exist

I'm trying to use getOne() and am seeing strange results.

$emails = Array([LIST OF EMAIL ADDRESSES HERE]);

$mdb2->loadModule('Extended');
$sql = 'SELECT id FROM member WHERE email = ?';

foreach ($emails as $email)
{
$data = $mdb2->extended->getOne($sql1, null, array($email),
array('string'));

...
}

I'm receiving this error:

_doQuery: [Error message: Could not execute statement]
[Last query: EXECUTE
mdb2_statement_pgsqlad71a4301905dca52f90dba959ae20 1f (Object)]
[Native message: ERROR: column "object" does not exist]

So, is my syntax for getOne() incorrect?

b

brian wrote:
> I'm trying to use getOne() and am seeing strange results.
>
> $emails = Array([LIST OF EMAIL ADDRESSES HERE]);
>
> $mdb2->loadModule('Extended');
> $sql = 'SELECT id FROM member WHERE email = ?';
>
> foreach ($emails as $email)
> {
> $data = $mdb2->extended->getOne($sql1, null, array($email),
> array('string'));
>
> ...
> }


first: you defined $sql and then used $sql1

second: 'string' isn't a MDB2 data type, use 'text' instead.

Best regards,
--
Lorenzo Alberton
http://pear.php.net/user/quipo
__________________________________________________ _________________
Quipo Free Internet - 2 email, 150 Mb di spazio web e molto di più.
ADSL, Hardware & Software Online Store

Lorenzo Alberton wrote:
> brian wrote:
>
>> I'm trying to use getOne() and am seeing strange results.
>>
>> $emails = Array([LIST OF EMAIL ADDRESSES HERE]);
>>
>> $mdb2->loadModule('Extended');
>> $sql = 'SELECT id FROM member WHERE email = ?';
>>
>> foreach ($emails as $email)
>> {
>> $data = $mdb2->extended->getOne($sql1, null, array($email),
>> array('string'));
>> ...
>> }
>
>
>
> first: you defined $sql and then used $sql1
>

Oops--i'd altered the code for simplicity's sake.

> second: 'string' isn't a MDB2 data type, use 'text' instead.
>

Perfect, thanks!

b