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
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
>
>
> -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
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
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
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
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
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
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
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
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
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
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
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
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.
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..
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
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 {
>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
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
> -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:
>
>
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,
: 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,
>
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
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
-
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
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
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
.@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($
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
30 matches
Mail list logo