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@xxxxxxxxx] Sent: Tuesday, April 24, 2012 1:45 PM To: Matijn Woudt Cc: David Stoltz; php-general@xxxxxxxxxxxxx Subject: Re: 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 <tijnema@xxxxxxxxx>: > On Tue, Apr 24, 2012 at 7:29 PM, David Stoltz <Dstoltz@xxxxxxx> 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
