Re: [PHP] How to output a NULL field?

2009-08-26 Thread Phpster
om] Sent: Wednesday, August 26, 2009 12:18 PM To: Andrew Ballard Cc: David Stoltz; php-general@lists.php.net Subject: Re: [PHP] How to output a NULL field? Com function is just for Windows,I don't kown why some body like use it.:( 2009/8/27 Andrew Ballard : On Wed, Aug 26, 2009 at 9:51 AM, Da

Re: [PHP] How to output a NULL field?

2009-08-26 Thread Paul M Foster
On Wed, Aug 26, 2009 at 12:48:12PM -0400, David Stoltz wrote: > Looking on Amazon and other book sites, I can't even find a book for > "PHP and MS SQL"... > > It's all "PHP and MySQL"... > > Should I avoid developing PHP application with MS SQL databases? My *opinion* is that you should avoid M

Re: [PHP] How to output a NULL field?

2009-08-26 Thread Ashley Sheridan
> > > -Original Message- > From: Paul M Foster [mailto:pa...@quillandmouse.com] > Sent: Wednesday, August 26, 2009 12:38 PM > To: php-general@lists.php.net > Subject: Re: [PHP] How to output a NULL field? > > On Thu, Aug 27, 2009 at 12:25:35AM +0800, hack988 h

Re: [PHP] How to output a NULL field?

2009-08-26 Thread Paul M Foster
On Thu, Aug 27, 2009 at 12:25:35AM +0800, hack988 hack988 wrote: > I'm sorry for my poor English,what is OP? I don't kown what is OP mean. OP = "Original Poster". That's usually the person who first started (posted) a thread on a list. Paul -- Paul M. Foster -- PHP General Mailing List (http

RE: [PHP] How to output a NULL field?

2009-08-26 Thread David Stoltz
t',$alt,SQLVARCHAR,false,false,150); mssql_bind($stmt, '@desc',$desc,SQLVARCHAR,false,false,100); // Execute mssql_execute($stmt); -Original Message- From: hack988 hack988 [mailto:hack...@dev.htwap.com] Sent: Wednesday, August 26, 2009 12:18 PM To: Andrew Ballard Cc: David Stol

Re: [PHP] How to output a NULL field?

2009-08-26 Thread Ashley Sheridan
On Thu, 2009-08-27 at 00:25 +0800, hack988 hack988 wrote: > I'm sorry for my poor English,what is OP? I don't kown what is OP mean. > It's basically the original person who asked the question. Thanks, Ash http://www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To u

Re: [PHP] How to output a NULL field?

2009-08-26 Thread hack988 hack988
I'm sorry for my poor English,what is OP? I don't kown what is OP mean. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] How to output a NULL field?

2009-08-26 Thread Andrew Ballard
On Wed, Aug 26, 2009 at 12:06 PM, hack988 hack988 wrote: > Mysql,mssql has its own feature,you can't say Mysql is better than > Mssql or Mssql it better than Mysql,Is'nt is? > My the Way ,Mssql support Top n,m form mssql 2005 :) > Perhaps, but the OP said he's using SQL Server 2000. Andrew -- P

Re: [PHP] How to output a NULL field?

2009-08-26 Thread Andrew Ballard
On Wed, Aug 26, 2009 at 12:13 PM, Andrew Ballard wrote: > On Wed, Aug 26, 2009 at 9:51 AM, David Stoltz wrote: >> Sorry - I don't know what you mean by DB class? >> >> I'm using Microsoft SQL 2000with this code: >> >> > //create an instance of the  ADO connection object >> $conn = new COM ("ADO

Re: [PHP] How to output a NULL field?

2009-08-26 Thread hack988 hack988
Com function is just for Windows,I don't kown why some body like use it.:( 2009/8/27 Andrew Ballard : > On Wed, Aug 26, 2009 at 9:51 AM, David Stoltz wrote: >> Sorry - I don't know what you mean by DB class? >> >> I'm using Microsoft SQL 2000with this code: >> >> > //create an instance of the

Re: [PHP] How to output a NULL field?

2009-08-26 Thread Andrew Ballard
On Wed, Aug 26, 2009 at 9:51 AM, David Stoltz wrote: > Sorry - I don't know what you mean by DB class? > > I'm using Microsoft SQL 2000with this code: > > //create an instance of the  ADO connection object > $conn = new COM ("ADODB.Connection") >  or die("Cannot start ADO"); > //define connect

Re: [PHP] How to output a NULL field?

2009-08-26 Thread hack988 hack988
Mysql,mssql has its own feature,you can't say Mysql is better than Mssql or Mssql it better than Mysql,Is'nt is? My the Way ,Mssql support Top n,m form mssql 2005 :) 2009/8/27 Andrew Ballard : > On Wed, Aug 26, 2009 at 10:52 AM, Ashley > Sheridan wrote: >> You should try and see if you can get it

Re: [PHP] How to output a NULL field?

2009-08-26 Thread Andrew Ballard
On Wed, Aug 26, 2009 at 10:52 AM, Ashley Sheridan wrote: > You should try and see if you can get it installed there, as it will > work on Windows servers. I've found it generally to be faster than MS > SQL, and the choice of different database engines for each table gives > you a LOT of flexibility

RE: [PHP] How to output a NULL field?

2009-08-26 Thread Ashley Sheridan
ere, so I > have to fumble my way through with MS SQL. > > Thanks! > > > -Original Message- > From: hack988 hack988 [mailto:hack...@dev.htwap.com] > Sent: Wednesday, August 26, 2009 10:13 AM > To: a...@ashleysheridan.co.uk > Cc: David Stoltz; php-genera

RE: [PHP] How to output a NULL field?

2009-08-26 Thread David Stoltz
riginal Message- From: hack988 hack988 [mailto:hack...@dev.htwap.com] Sent: Wednesday, August 26, 2009 10:13 AM To: a...@ashleysheridan.co.uk Cc: David Stoltz; php-general@lists.php.net Subject: Re: [PHP] How to output a NULL field? My code for mssql please enable the php's mssql extentions.

Re: [PHP] How to output a NULL field?

2009-08-26 Thread Ashley Sheridan
T["eval"]; > > > > $rs = $conn->execute($query); > > > > echo $rs->Fields(22); //this is where that particular field is NULL, and > > produces the error > > > > .... > > > > -Original Message- > > From: hack988 hack988 [mailto:hack..

Re: [PHP] How to output a NULL field?

2009-08-26 Thread hack988 hack988
error > > > > -Original Message- > From: hack988 hack988 [mailto:hack...@dev.htwap.com] > Sent: Wednesday, August 26, 2009 8:08 AM > To: David Stoltz > Cc: php-general@lists.php.net > Subject: Re: [PHP] How to output a NULL field? > > Could you post

Re: [PHP] How to output a NULL field?

2009-08-26 Thread hack988 hack988
My code for mssql please enable the php's mssql extentions. it used like so many mysql class that you can find by google -- 4.2.0 disable php's automatic datetime convert Class DB {

RE: [PHP] How to output a NULL field?

2009-08-26 Thread David Stoltz
>Fields(22); //this is where that particular field is NULL, and produces the error -Original Message- From: hack988 hack988 [mailto:hack...@dev.htwap.com] Sent: Wednesday, August 26, 2009 8:08 AM To: David Stoltz Cc: php-general@lists.php.net Subject: Re: [PHP] How to outpu

RE: [PHP] How to output a NULL field?

2009-08-26 Thread David Stoltz
t -- http://stut.net/ > -Original Message- > From: Paul M Foster [mailto:pa...@quillandmouse.com] > Sent: Tuesday, August 25, 2009 4:39 PM > To: php-general@lists.php.net > Subject: Re: [PHP] How to output a NULL field? > > On Tue, Aug 25, 2009 at 02:00:04PM -0400, David St

Re: [PHP] How to output a NULL field?

2009-08-26 Thread Stuart
> -Original Message- > From: Paul M Foster [mailto:pa...@quillandmouse.com] > Sent: Tuesday, August 25, 2009 4:39 PM > To: php-general@lists.php.net > Subject: Re: [PHP] How to output a NULL field? > > On Tue, Aug 25, 2009 at 02:00:04PM -0400, David Stoltz wrote: > >

RE: [PHP] How to output a NULL field?

2009-08-26 Thread TG
ere's an ifnull() function in SQL Server to adjust the data before it even gets to your DB class. -TG - Original Message - From: "David Stoltz" To: "Paul M Foster" , Date: Wed, 26 Aug 2009 07:29:53 -0400 Subject: RE: [PHP] How to output a NULL field? > Paul,

Re: [PHP] How to output a NULL field?

2009-08-26 Thread hack988 hack988
: hack988 hack988 [mailto:hack...@dev.htwap.com] > Sent: Wednesday, August 26, 2009 7:39 AM > To: David Stoltz > Cc: Paul M Foster; php-general@lists.php.net > Subject: Re: [PHP] How to output a NULL field? > > use is_null() check it > > 2009/8/26 David Stoltz : >> Paul, >

RE: [PHP] How to output a NULL field?

2009-08-26 Thread David Stoltz
I tried that -it's in the first part of my message -Original Message- From: hack988 hack988 [mailto:hack...@dev.htwap.com] Sent: Wednesday, August 26, 2009 7:39 AM To: David Stoltz Cc: Paul M Foster; php-general@lists.php.net Subject: Re: [PHP] How to output a NULL field? use is

Re: [PHP] How to output a NULL field?

2009-08-26 Thread hack988 hack988
ant could not be converted to > string in D:\Inetpub\wwwroot\evaluations\lookup2.php on line 176 > > > -Original Message- > From: Paul M Foster [mailto:pa...@quillandmouse.com] > Sent: Tuesday, August 25, 2009 4:39 PM > To: php-general@lists.php.net > Subject: Re: [P

RE: [PHP] How to output a NULL field?

2009-08-26 Thread David Stoltz
- From: Paul M Foster [mailto:pa...@quillandmouse.com] Sent: Tuesday, August 25, 2009 4:39 PM To: php-general@lists.php.net Subject: Re: [PHP] How to output a NULL field? On Tue, Aug 25, 2009 at 02:00:04PM -0400, David Stoltz wrote: > $rs->Fields(22) equals a NULL in the database > > My C

Re: [PHP] How to output a NULL field?

2009-08-25 Thread Paul M Foster
On Tue, Aug 25, 2009 at 02:00:04PM -0400, David Stoltz wrote: > $rs->Fields(22) equals a NULL in the database > > My Code: > > if(empty($rs->Fields(22))){ > $q4 = ""; > }else{ > $q4 = $rs->Fields(22); > } > > Produces this error: > Fatal error: Can't use method return value in write

Re: [PHP] How to output a NULL field?

2009-08-25 Thread Lars Torben Wilson
phps...@gmail.com] > Sent: Tuesday, August 25, 2009 2:17 PM > To: David Stoltz > Cc: php-general@lists.php.net > Subject: Re: [PHP] How to output a NULL field? > > On Tue, Aug 25, 2009 at 2:00 PM, David Stoltz wrote: >> $rs->Fields(22) equals a NULL in the dat

RE: [PHP] How to output a NULL field?

2009-08-25 Thread David Stoltz
.@gmail.com] Sent: Tuesday, August 25, 2009 2:17 PM To: David Stoltz Cc: php-general@lists.php.net Subject: Re: [PHP] How to output a NULL field? On Tue, Aug 25, 2009 at 2:00 PM, David Stoltz wrote: > $rs->Fields(22) equals a NULL in the database > > My Code: > > if(empty($

Re: [PHP] How to output a NULL field?

2009-08-25 Thread Bastien Koert
On Tue, Aug 25, 2009 at 2:00 PM, David Stoltz wrote: > $rs->Fields(22) equals a NULL in the database > > My Code: > > if(empty($rs->Fields(22))){ >        $q4 = ""; > }else{ >        $q4 = $rs->Fields(22); > } > > Produces this error: > Fatal error: Can't use method return value in write context in