[PHP] NULL Problem

RE: [PHP] NULL Problem

David Stoltz — Tue, 24 Apr 2012 20:20:02 +0200

Serge,

We don't use MSSQL for much, mostly use MySQL...

But I don't want to switch out all the drivers for this one issue, which is now resolved (thanks Matijn)

-----Original Message-----
From: Serge Fonville [mailto:serge.fonville@gmail.com]
Sent: Tuesday, April 24, 2012 1:45 PM
To: Matijn Woudt
Cc: David Stoltz; php-general@lists.php.net
Subject: Re: [PHP] NULL Problem

Have you considered the PHP MSSQL driver?
http://www.microsoft.com/download/en/details.aspx?id=20098

Kind regards/met vriendelijke groet,

Serge Fonville

http://www.sergefonville.nl

Convince Google!!
They need to add GAL support on Android (star to agree)
http://code.google.com/p/android/issues/detail?id=4602

2012/4/24 Matijn Woudt :
> On Tue, Apr 24, 2012 at 7:29 PM, David Stoltz wrote:
>> Here's my code (using MSSQL):
>>
>> $conn = new COM ("ADODB.Connection")or die("Cannot start ADO");
>> $conn->open($connStr);
>> $query = "SELECT * FROM TABLE WHERE id = ".$id;
>> $rs = $conn->execute($query);
>>
>> This code works fine, and I retrieve the values like this:
>>
>> $tmp1 = $rs->fields("column1");
>> $tmp2 = $rs->fields("column2");
>> Etc...
>>
>>
>> Here's the problem - I'm trying to get a date column that I know is
>> NULL, but I can't seem to get my code right:
>>
>> $tmp = $rs->fields("followup_on");
>> if(is_null($tmp)){
>> $followup = "";
>> }else{
>> $followup = $rs->fields("followup_on");
>> }
>>
>> //this results in: Catchable fatal error: Object of class variant could
>> not be converted to string
>> //When I try to ECHO the $followup results (and I know the database
>> value is NULL)
>>
>>
>> So confused - any advice?
>>
>
> It's been a long time ago I worked with ADO (Thank god), but shouldn't
> you echo $followup->value instead of $followup?
> If that's not working, try a var_dump($followup), so you can check
> exactly what it is.
>
> - Matijn
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] NULL Problem

David Stoltz — Tue, 24 Apr 2012 20:20:02 +0200

Matijn - it worked! Geez...

Strange - I don't need the ->value if it actually has a value, only if it's NULL...

But it works! Thanks!

-----Original Message-----
From: Matijn Woudt [mailto:tijnema@gmail.com]
Sent: Tuesday, April 24, 2012 1:40 PM
To: David Stoltz
Cc: php-general@lists.php.net
Subject: Re: [PHP] NULL Problem

On Tue, Apr 24, 2012 at 7:29 PM, David Stoltz wrote:
> Here's my code (using MSSQL):
>
> $conn = new COM ("ADODB.Connection")or die("Cannot start ADO");
> $conn->open($connStr);
> $query = "SELECT * FROM TABLE WHERE id = ".$id;
> $rs = $conn->execute($query);
>
> This code works fine, and I retrieve the values like this:
>
> $tmp1 = $rs->fields("column1");
> $tmp2 = $rs->fields("column2");
> Etc...
>
>
> Here's the problem - I'm trying to get a date column that I know is
> NULL, but I can't seem to get my code right:
>
> $tmp = $rs->fields("followup_on");
> if(is_null($tmp)){
> $followup = "";
> }else{
> $followup = $rs->fields("followup_on");
> }
>
> //this results in: Catchable fatal error: Object of class variant could
> not be converted to string
> //When I try to ECHO the $followup results (and I know the database
> value is NULL)
>
>
> So confused - any advice?
>

It's been a long time ago I worked with ADO (Thank god), but shouldn't
you echo $followup->value instead of $followup?
If that's not working, try a var_dump($followup), so you can check
exactly what it is.

- Matijn

Re: [PHP] NULL Problem

Serge Fonville — Tue, 24 Apr 2012 19:50:01 +0200

Have you considered the PHP MSSQL driver?
http://www.microsoft.com/download/en/details.aspx?id=20098

Kind regards/met vriendelijke groet,

Serge Fonville

http://www.sergefonville.nl

Convince Google!!
They need to add GAL support on Android (star to agree)
http://code.google.com/p/android/issues/detail?id=4602

2012/4/24 Matijn Woudt :
> On Tue, Apr 24, 2012 at 7:29 PM, David Stoltz wrote:
>> Here's my code (using MSSQL):
>>
>> $conn = new COM ("ADODB.Connection")or die("Cannot start ADO");
>> $conn->open($connStr);
>> $query = "SELECT * FROM TABLE WHERE id = ".$id;
>> $rs = $conn->execute($query);
>>
>> This code works fine, and I retrieve the values like this:
>>
>> $tmp1 = $rs->fields("column1");
>> $tmp2 = $rs->fields("column2");
>> Etc...
>>
>>
>> Here's the problem - I'm trying to get a date column that I know is
>> NULL, but I can't seem to get my code right:
>>
>> $tmp = $rs->fields("followup_on");
>> if(is_null($tmp)){
>> $followup = "";
>> }else{
>> $followup = $rs->fields("followup_on");
>> }
>>
>> //this results in: Catchable fatal error: Object of class variant could
>> not be converted to string
>> //When I try to ECHO the $followup results (and I know the database
>> value is NULL)
>>
>>
>> So confused - any advice?
>>
>
> It's been a long time ago I worked with ADO (Thank god), but shouldn't
> you echo $followup->value instead of $followup?
> If that's not working, try a var_dump($followup), so you can check
> exactly what it is.
>
> - Matijn
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] NULL Problem

Matijn Woudt — Tue, 24 Apr 2012 19:50:01 +0200

On Tue, Apr 24, 2012 at 7:29 PM, David Stoltz wrote:
> Here's my code (using MSSQL):
>
> $conn = new COM ("ADODB.Connection")or die("Cannot start ADO");
> $conn->open($connStr);
> $query = "SELECT * FROM TABLE WHERE id = ".$id;
> $rs = $conn->execute($query);
>
> This code works fine, and I retrieve the values like this:
>
> $tmp1 = $rs->fields("column1");
> $tmp2 = $rs->fields("column2");
> Etc...
>
>
> Here's the problem - I'm trying to get a date column that I know is
> NULL, but I can't seem to get my code right:
>
> $tmp = $rs->fields("followup_on");
> if(is_null($tmp)){
> $followup = "";
> }else{
> $followup = $rs->fields("followup_on");
> }
>
> //this results in: Catchable fatal error: Object of class variant could
> not be converted to string
> //When I try to ECHO the $followup results (and I know the database
> value is NULL)
>
>
> So confused - any advice?
>

It's been a long time ago I worked with ADO (Thank god), but shouldn't
you echo $followup->value instead of $followup?
If that's not working, try a var_dump($followup), so you can check
exactly what it is.

- Matijn

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] NULL Problem

David Stoltz — Tue, 24 Apr 2012 19:31:13 +0200

Here's my code (using MSSQL):

$conn = new COM ("ADODB.Connection")or die("Cannot start ADO");
$conn->open($connStr);
$query = "SELECT * FROM TABLE WHERE id = ".$id;
$rs = $conn->execute($query);

This code works fine, and I retrieve the values like this:

$tmp1 = $rs->fields("column1");
$tmp2 = $rs->fields("column2");
Etc...

Here's the problem - I'm trying to get a date column that I know is
NULL, but I can't seem to get my code right:

$tmp = $rs->fields("followup_on");
if(is_null($tmp)){
$followup = "";
}else{
$followup = $rs->fields("followup_on");
}

//this results in: Catchable fatal error: Object of class variant could
not be converted to string
//When I try to ECHO the $followup results (and I know the database
value is NULL)

So confused - any advice?

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php