[PHP] NULL Problem
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
Re: [PHP] NULL Problem
On Tue, Apr 24, 2012 at 7:29 PM, David Stoltz dsto...@shh.org 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
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 tijn...@gmail.com:
On Tue, Apr 24, 2012 at 7:29 PM, David Stoltz dsto...@shh.org 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 - 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:tijn...@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 dsto...@shh.org 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,
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.fonvi...@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 tijn...@gmail.com:
On Tue, Apr 24, 2012 at 7:29 PM, David Stoltz dsto...@shh.org 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
