php-windows Digest 1 Feb 2001 17:17:32 -0000 Issue 423
Topics (messages 5299 through 5314):
Win2K/PHP4.0.4pl1 - include_path mess (won't include from the current directory)
5299 by: PHPBeginner.com
5303 by: Doug Brewer
5307 by: PHPBeginner.com
system function doesn't work
5300 by: Emile Schenk
Re: links to php install bundles and tutorials
5301 by: Simon Willison
5302 by: Tom Mathews
5304 by: kill-9
5305 by: Tom Mathews
Re: Problem with Oracle
5306 by: Bikes
Newbie - Help!!!!!
5308 by: Robert Trembath
5309 by: Toby Miller
5310 by: Tom Mathews
Nulls in database
5311 by: Conover, Ryan
5312 by: Richard
Re: PHP vs JSP ?
5313 by: Svensson, B.A.T.
Re: [PHP] Nulls in database
5314 by: Juan
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
Hello guys,
I have the following problem:
in my PHP.ini (which stays under c:\WINNT) I have
include_path = "P:\includes; " ; UNIX: "/path1:/path2"
Windows: "\path1;\path2"
doc_root = ; the root of the php
pages, used only if nonempty
under "P:\includes" are PHPLIB and some few scripts that I need to
auto_prepend under all the roots on my local server.
PHPLIB is being included properly, but, if I try to include a file within a
current directory like:
include ("header.inc");
I get the following error:
Warning: Failed opening 'header.inc' for inclusion
(include_path='P:\includes; ') in p:\phpbeginner\index.html on line 17
(NOTE: include ("$DOCUMENT_ROOT/header.inc"); will work perfectly )
I know that on Linux to fix the problem would be enough to add something
like this into PHP.INI
include_path = ".: /full/path/to/includes: " ; UNIX:
"/path1:/path2" Windows: "\path1;\path2"
How do I do this under Win2K ?
Anyone had this problem before?
Cheers,
Maxim Maletsky
Founder, Chief Developer
PHPBeginner.com (Where PHP Begins)
[EMAIL PROTECTED]
www.phpbeginner.com
include_path = ".;e:\apache\lib\php\;"
use a semi-colon to separate paths
DB
| -----Original Message-----
| From: PHPBeginner.com [mailto:[EMAIL PROTECTED]]
| Sent: Thursday, February 01, 2001 2:54 AM
| To: PHPLIB; [EMAIL PROTECTED]; PHP
| Subject: [PHP-WIN] Win2K/PHP4.0.4pl1 - include_path mess
| (won't include
| from the current directory)
|
|
| Hello guys,
|
| I have the following problem:
|
| in my PHP.ini (which stays under c:\WINNT) I have
|
| include_path = "P:\includes; " ; UNIX:
| "/path1:/path2"
| Windows: "\path1;\path2"
| doc_root =
| ; the root of the php pages, used only if nonempty
|
| under "P:\includes" are PHPLIB and some few scripts that I need to
| auto_prepend under all the roots on my local server.
|
|
|
| PHPLIB is being included properly, but, if I try to include
| a file within a
| current directory like:
|
| include ("header.inc");
|
| I get the following error:
|
| Warning: Failed opening 'header.inc' for inclusion
| (include_path='P:\includes; ') in p:\phpbeginner\index.html
| on line 17
|
| (NOTE: include ("$DOCUMENT_ROOT/header.inc"); will work perfectly )
|
| I know that on Linux to fix the problem would be enough to
| add something
| like this into PHP.INI
|
| include_path = ".: /full/path/to/includes: "
| ; UNIX:
| "/path1:/path2" Windows: "\path1;\path2"
|
| How do I do this under Win2K ?
|
| Anyone had this problem before?
|
| Cheers,
|
| Maxim Maletsky
| Founder, Chief Developer
|
| PHPBeginner.com (Where PHP Begins)
| [EMAIL PROTECTED]
| www.phpbeginner.com
|
|
|
| --
| PHP Windows Mailing List (http://www.php.net/)
| To unsubscribe, e-mail: [EMAIL PROTECTED]
| For additional commands, e-mail: [EMAIL PROTECTED]
| To contact the list administrators, e-mail:
| [EMAIL PROTECTED]
|
Thanks Doug!
You have just fixed it for me!
I've tried it before (since I know how to do it on Linux) except that I
haven't close the path with a backslash. At that point I though it won't
work the way on Linux does.
Thanks a bunch,
I appreciate your help.
Cheers,
Maxim Maletsky
www.PHPBeginner.com
-----Original Message-----
From: Doug Brewer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 01, 2001 10:19 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-WIN] Win2K/PHP4.0.4pl1 - include_path mess (won't
include from the current directory)
include_path = ".;e:\apache\lib\php\;"
use a semi-colon to separate paths
DB
| -----Original Message-----
| From: PHPBeginner.com [mailto:[EMAIL PROTECTED]]
| Sent: Thursday, February 01, 2001 2:54 AM
| To: PHPLIB; [EMAIL PROTECTED]; PHP
| Subject: [PHP-WIN] Win2K/PHP4.0.4pl1 - include_path mess
| (won't include
| from the current directory)
|
|
| Hello guys,
|
| I have the following problem:
|
| in my PHP.ini (which stays under c:\WINNT) I have
|
| include_path = "P:\includes; " ; UNIX:
| "/path1:/path2"
| Windows: "\path1;\path2"
| doc_root =
| ; the root of the php pages, used only if nonempty
|
| under "P:\includes" are PHPLIB and some few scripts that I need to
| auto_prepend under all the roots on my local server.
|
|
|
| PHPLIB is being included properly, but, if I try to include
| a file within a
| current directory like:
|
| include ("header.inc");
|
| I get the following error:
|
| Warning: Failed opening 'header.inc' for inclusion
| (include_path='P:\includes; ') in p:\phpbeginner\index.html
| on line 17
|
| (NOTE: include ("$DOCUMENT_ROOT/header.inc"); will work perfectly )
|
| I know that on Linux to fix the problem would be enough to
| add something
| like this into PHP.INI
|
| include_path = ".: /full/path/to/includes: "
| ; UNIX:
| "/path1:/path2" Windows: "\path1;\path2"
|
| How do I do this under Win2K ?
|
| Anyone had this problem before?
|
| Cheers,
|
| Maxim Maletsky
| Founder, Chief Developer
|
| PHPBeginner.com (Where PHP Begins)
| [EMAIL PROTECTED]
| www.phpbeginner.com
|
|
|
| --
| PHP Windows Mailing List (http://www.php.net/)
| To unsubscribe, e-mail: [EMAIL PROTECTED]
| For additional commands, e-mail: [EMAIL PROTECTED]
| To contact the list administrators, e-mail:
| [EMAIL PROTECTED]
|
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
when I use the system function (or similars) on my system: win2k+apache I
get tghe following error:
unable to fork
Anyone got a solution?
Emile.
Does this mailing list have an FAQ anywhere?
[Simon Willison] -----Original Message-----
From: Paul Trapnell [mailto:[EMAIL PROTECTED]]
Sent: 01 February 2001 01:00
To: php
Subject: re: links to php install bundles and tutorials
--thanks for the additional tutorial link (the Meloni one at WebMonkey).
If anyone wishes to add any additional links to install bundles and
tutorials, post them here and I'll add them to this list. An updated
list can then be reposted (either by me or anyone who saves a copy)
each time a new reader requests the locations of install bundles or
tutorials.
To post a reply to the list, click here: [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
If there is a FAQ, I've never found it. However, the list is archived daily
(twice daily?) on php.net and you can search the archive if you can be
bothered!
Anyone know who to contact about setting up a FAQ on php.net? Or has anyone
got a reliable site with space (and the time to manage) a FAQ? I'd quite
happily manage the FAQ, but the only reliable sites I've got are on
commercial servers and I can't take the traffic hit.
I've only been reading the list for a couple of months or so, and am already
seeing the same questions cropping up again and again. There's loads of
people out there (hopefully including me) who are more than willing to try
and give answers, but a FAQ really would help to filter out the 'How can I
run PHP on Windows 98' RTFM! type of things.
Tom
Simon Willison wrote:
> Does this mailing list have an FAQ anywhere?
>
> [Simon Willison] -----Original Message-----
> From: Paul Trapnell [mailto:[EMAIL PROTECTED]]
> Sent: 01 February 2001 01:00
> To: php
> Subject: re: links to php install bundles and tutorials
>
>
> --thanks for the additional tutorial link (the Meloni one at WebMonkey).
>
> If anyone wishes to add any additional links to install bundles and
> tutorials, post them here and I'll add them to this list. An updated
> list can then be reposted (either by me or anyone who saves a copy)
> each time a new reader requests the locations of install bundles or
> tutorials.
>
>
> To post a reply to the list, click here: [EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]>
>
>
>
>
>
I would put something like that up on www.kill-9.dk or on
www.php-unlimited.com (when it is done.) and am willing to help out. The
server running both sites can take the load with no problem. Space is also
no problem and mysql included so it could be searchable.
But are you sure there isn't already some kind of FAQ out there in net land?
Not that I have looked for one.
kill-9
----- Original Message -----
From: "Tom Mathews" <[EMAIL PROTECTED]>
Cc: "php" <[EMAIL PROTECTED]>
Sent: Thursday, February 01, 2001 12:52 PM
Subject: Re: [PHP-WIN] RE: links to php install bundles and tutorials
> If there is a FAQ, I've never found it. However, the list is archived
daily
> (twice daily?) on php.net and you can search the archive if you can be
> bothered!
>
> Anyone know who to contact about setting up a FAQ on php.net? Or has
anyone
> got a reliable site with space (and the time to manage) a FAQ? I'd quite
> happily manage the FAQ, but the only reliable sites I've got are on
> commercial servers and I can't take the traffic hit.
> I've only been reading the list for a couple of months or so, and am
already
> seeing the same questions cropping up again and again. There's loads of
> people out there (hopefully including me) who are more than willing to try
> and give answers, but a FAQ really would help to filter out the 'How can I
> run PHP on Windows 98' RTFM! type of things.
>
> Tom
>
> Simon Willison wrote:
>
> > Does this mailing list have an FAQ anywhere?
> >
> > [Simon Willison] -----Original Message-----
> > From: Paul Trapnell [mailto:[EMAIL PROTECTED]]
> > Sent: 01 February 2001 01:00
> > To: php
> > Subject: re: links to php install bundles and tutorials
> >
> >
> > --thanks for the additional tutorial link (the Meloni one at WebMonkey).
> >
> > If anyone wishes to add any additional links to install bundles and
> > tutorials, post them here and I'll add them to this list. An updated
> > list can then be reposted (either by me or anyone who saves a copy)
> > each time a new reader requests the locations of install bundles or
> > tutorials.
> >
> >
> > To post a reply to the list, click here: [EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]>
> >
> >
> >
> >
> >
>
>
----------------------------------------------------------------------------
----
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
I suggest we leave this thread until end of play on Monday (then the weekenders
can have a chance to see it as well).
If no-one has any info about a FAQ by then, then maybe we should go ahead with
the kill-9 idea?
Tom
[EMAIL PROTECTED] wrote:
> I would put something like that up on www.kill-9.dk or on
> www.php-unlimited.com (when it is done.) and am willing to help out. The
> server running both sites can take the load with no problem. Space is also
> no problem and mysql included so it could be searchable.
>
> But are you sure there isn't already some kind of FAQ out there in net land?
> Not that I have looked for one.
>
> kill-9
>
> ----- Original Message -----
> From: "Tom Mathews" <[EMAIL PROTECTED]>
> Cc: "php" <[EMAIL PROTECTED]>
> Sent: Thursday, February 01, 2001 12:52 PM
> Subject: Re: [PHP-WIN] RE: links to php install bundles and tutorials
>
> > If there is a FAQ, I've never found it. However, the list is archived
> daily
> > (twice daily?) on php.net and you can search the archive if you can be
> > bothered!
> >
> > Anyone know who to contact about setting up a FAQ on php.net? Or has
> anyone
> > got a reliable site with space (and the time to manage) a FAQ? I'd quite
> > happily manage the FAQ, but the only reliable sites I've got are on
> > commercial servers and I can't take the traffic hit.
> > I've only been reading the list for a couple of months or so, and am
> already
> > seeing the same questions cropping up again and again. There's loads of
> > people out there (hopefully including me) who are more than willing to try
> > and give answers, but a FAQ really would help to filter out the 'How can I
> > run PHP on Windows 98' RTFM! type of things.
> >
> > Tom
> >
> > Simon Willison wrote:
> >
> > > Does this mailing list have an FAQ anywhere?
> > >
> > > [Simon Willison] -----Original Message-----
> > > From: Paul Trapnell [mailto:[EMAIL PROTECTED]]
> > > Sent: 01 February 2001 01:00
> > > To: php
> > > Subject: re: links to php install bundles and tutorials
> > >
> > >
> > > --thanks for the additional tutorial link (the Meloni one at WebMonkey).
> > >
> > > If anyone wishes to add any additional links to install bundles and
> > > tutorials, post them here and I'll add them to this list. An updated
> > > list can then be reposted (either by me or anyone who saves a copy)
> > > each time a new reader requests the locations of install bundles or
> > > tutorials.
> > >
> > >
> > > To post a reply to the list, click here: [EMAIL PROTECTED]
> > > <mailto:[EMAIL PROTECTED]>
> > >
> > >
> > >
> > >
> > >
> >
> >
>
> ----------------------------------------------------------------------------
> ----
>
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
I have a very big problem please. I installed Oracle on my Windows
Professional server. However, whenever I try to call the Oracle OIC connect
function, it tells me that the function is invalid. Please, I need to know
if there is anything I need to do to enable me to connect to the Oracle
server using PHP because I can connect to mySql on the same machine using
the same PHP function for mySQL.
Bikes
-----Original Message-----
From: Asendorf, John
To: Jean-Christophe Le Brun; [EMAIL PROTECTED]
Sent: 1/31/01 2:38 PM
Subject: RE: [PHP-WIN] Problem with Oracle
Since the list was down yesterday, I figured it out before I got some
help
(Thanks Jean-Christophe). I did it a little differently and thought I'd
post it here.
$sql_getID = "SELECT max(CUSTID_NUM) from cfull2.tbl_dl_customers";
$stmt_getID = OCIParse ( $connection , $sql_getID );
OCIExecute ( $stmt_getID );
OCIFetch ( $stmt_getID );
$Max_ID = OCIResult($stmt_getID,1);
OCIFreeStatement ( $stmt_getID );
$Max_ID++;
I was able to echo the result but was unable to put it in to a variable
until I did the above.
---------------------
John Asendorf - [EMAIL PROTECTED]
Web Applications Developer
http://www.lcounty.com - NEW FEATURES ADDED DAILY!
Licking County, Ohio, USA
740-349-3631
The benefit to the government of replacing all $1 Federal Reserve notes
with
$1 coins would be $522.2 million per year, according to estimates of the
General Accouting Office released on April 7, 2000.
> -----Original Message-----
> From: Jean-Christophe Le Brun [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 31, 2001 2:19 AM
> To: Asendorf, John; [EMAIL PROTECTED]
> Subject: Re: [PHP-WIN] Problem with Oracle
>
>
> Hi !
>
> > I'm trying to run some SQL in Oracle that returns a single value...
> >
> > $sql_getID = "SELECT max(CUSTID_NUM) from cfull2.tbl_dl_customers";
> >
> > how the hell do I get that number into a variable?
> >
> > I've tried a dozen different things, but the documentation
> is so sparse
> and
> > it's all about getting rows of data...
>
> Do this :
>
> $Requete = "SELECT max(CUSTID_NUM) MAX_ID from
> cfull2.tbl_dl_customers";
> OCIDefineByName($Requete, "MAX_ID", &$Max_Id);
> OCIExecute($Requete, OCI_DEFAULT);
> while (OCIFetch($Requete))
> {
> echo $Max_Id;
> }
>
> the While is not necessary here cause your query send only one row...
>
> if (OCIFetch($Requete))
> {
> echo Max_Id;
> }
>
> is better !
>
> JCLB Soft
> Jean-Christophe Le Brun
> [EMAIL PROTECTED]
> http://www.multimania.com/jclb
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
I don't understand why I getting an error on this. it ran on my IIS/PHP machine but on
my Apache/PHP I get errors. Here the code and the results, Please help:
<?php
session_start();
include("./inc/php_header.php")
?>
<font face=Arial size=2>
<?php
include("./mysql_connect_inc.php");
print "<h3>New Vehicle Search</h3><p>";
mysql_select_db( $db )
or die ( "Couldn't open $db: ".mysql_error() );
$result = mysql_query( "SELECT * from nctd_reviews WHERE model_year='$year'AND
manufacturer_name='$make' ORDER BY 'model_year', 'manufacturer_name'" );
$rows = mysql_num_rows( $result );
print "There are currently $rows vehicles that match your criteria.<p>";
print "<table width=475 border=0 cellpadding=0 cellspacing=1>\n";
print "<tr bgcolor=#D0D4E8><td width=50><font size=2><b>Year</b></font></td>";
print "<td width=325><font size=2><b>Make & Model</b></font></td><td width=100><font
size=2><b>MSRP</b></font></td></tr>";
while ($r = mysql_fetch_array($result))
{
extract($r);
print "<tr>\n";
print "<td><font size=2>$model_year</font></td><td><font size=2><a
href='vehicledetail.php?id=$ID'>$manufacturer_name
$model_name</a></font></td><td><font size=2>$ $base_price</td></font>\n";
print "</tr>\n";
$selectedyear = "$year";
$selectedmake = "$make";
}
print "</font></table>\n";
mysql_close( $link );
include("./inc/php_footer.php")
?>
Now the errors:
Warning: Supplied argument is not a valid MySQL result resource in
c:\apache\htdocs\ishophouston\newvehicles.php on line 12
There are currently vehicles that match your criteria.
Year Make & Model MSRP
Warning: Supplied argument is not a valid MySQL result resource in
c:\apache\htdocs\ishophouston\newvehicles.php on line 17
There seems to be a problem with your database connection. Can we see the
header include?
-Toby
----- Original Message -----
From: "Robert Trembath" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 01, 2001 10:20 AM
Subject: [PHP-WIN] Newbie - Help!!!!!
I don't understand why I getting an error on this. it ran on my IIS/PHP
machine but on my Apache/PHP I get errors. Here the code and the results,
Please help:
<?php
session_start();
include("./inc/php_header.php")
?>
<font face=Arial size=2>
<?php
include("./mysql_connect_inc.php");
print "<h3>New Vehicle Search</h3><p>";
mysql_select_db( $db )
or die ( "Couldn't open $db: ".mysql_error() );
$result = mysql_query( "SELECT * from nctd_reviews WHERE
model_year='$year'AND manufacturer_name='$make' ORDER BY 'model_year',
'manufacturer_name'" );
$rows = mysql_num_rows( $result );
print "There are currently $rows vehicles that match your criteria.<p>";
print "<table width=475 border=0 cellpadding=0 cellspacing=1>\n";
print "<tr bgcolor=#D0D4E8><td width=50><font
size=2><b>Year</b></font></td>";
print "<td width=325><font size=2><b>Make & Model</b></font></td><td
width=100><font size=2><b>MSRP</b></font></td></tr>";
while ($r = mysql_fetch_array($result))
{
extract($r);
print "<tr>\n";
print "<td><font size=2>$model_year</font></td><td><font size=2><a
href='vehicledetail.php?id=$ID'>$manufacturer_name
$model_name</a></font></td><td><font size=2>$ $base_price</td></font>\n";
print "</tr>\n";
$selectedyear = "$year";
$selectedmake = "$make";
}
print "</font></table>\n";
mysql_close( $link );
include("./inc/php_footer.php")
?>
Now the errors:
Warning: Supplied argument is not a valid MySQL result resource in
c:\apache\htdocs\ishophouston\newvehicles.php on line 12
There are currently vehicles that match your criteria.
Year Make & Model MSRP
Warning: Supplied argument is not a valid MySQL result resource in
c:\apache\htdocs\ishophouston\newvehicles.php on line 17
If there was an error with the DB connection, then the 'or die' clause should
pick it up?
If nothing has changed between the IIS nad Apache implementation then I don't
know what is happenning
If however you have changed the table structure at the same time... or maybe
don't have any records on your DB?
Tom
Toby Miller wrote:
> There seems to be a problem with your database connection. Can we see the
> header include?
>
> -Toby
>
> ----- Original Message -----
> From: "Robert Trembath" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, February 01, 2001 10:20 AM
> Subject: [PHP-WIN] Newbie - Help!!!!!
>
> I don't understand why I getting an error on this. it ran on my IIS/PHP
> machine but on my Apache/PHP I get errors. Here the code and the results,
> Please help:
>
> <?php
> session_start();
> include("./inc/php_header.php")
> ?>
> <font face=Arial size=2>
> <?php
> include("./mysql_connect_inc.php");
> print "<h3>New Vehicle Search</h3><p>";
> mysql_select_db( $db )
> or die ( "Couldn't open $db: ".mysql_error() );
> $result = mysql_query( "SELECT * from nctd_reviews WHERE
> model_year='$year'AND manufacturer_name='$make' ORDER BY 'model_year',
> 'manufacturer_name'" );
> $rows = mysql_num_rows( $result );
> print "There are currently $rows vehicles that match your criteria.<p>";
> print "<table width=475 border=0 cellpadding=0 cellspacing=1>\n";
> print "<tr bgcolor=#D0D4E8><td width=50><font
> size=2><b>Year</b></font></td>";
> print "<td width=325><font size=2><b>Make & Model</b></font></td><td
> width=100><font size=2><b>MSRP</b></font></td></tr>";
> while ($r = mysql_fetch_array($result))
> {
> extract($r);
> print "<tr>\n";
> print "<td><font size=2>$model_year</font></td><td><font size=2><a
> href='vehicledetail.php?id=$ID'>$manufacturer_name
> $model_name</a></font></td><td><font size=2>$ $base_price</td></font>\n";
> print "</tr>\n";
> $selectedyear = "$year";
> $selectedmake = "$make";
> }
> print "</font></table>\n";
> mysql_close( $link );
> include("./inc/php_footer.php")
> ?>
>
> Now the errors:
>
> Warning: Supplied argument is not a valid MySQL result resource in
> c:\apache\htdocs\ishophouston\newvehicles.php on line 12
> There are currently vehicles that match your criteria.
> Year Make & Model MSRP
>
> Warning: Supplied argument is not a valid MySQL result resource in
> c:\apache\htdocs\ishophouston\newvehicles.php on line 17
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
I am trying to write a query to bring back rows that have null values set in
them. I cannot figure out how to do this. I can bring back all rows that do
not have nulls with the following query.
SELECT [ID], [Project Name], [Start Construction Date], [Actual Completion
Date]
FROM common WHERE [Start Construction Date] != ' ' OR [Actual Completion
Date] != ' '
I tried changing the != to = but it does not return anything.
I am running these queries off a MSSQL 7.0 Server
Ryan
I don't know ANYTHING about ANY of this stuff...but where I come from (C)
you would use 2 equal signs (==) to match values. Dunno if that applies
here, but usually when you use 1 equal sign, you are assigning values.
Rick
-----Original Message-----
From: Conover, Ryan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 01, 2001 12:05 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-WIN] Nulls in database
I am trying to write a query to bring back rows that have null values set in
them. I cannot figure out how to do this. I can bring back all rows that do
not have nulls with the following query.
SELECT [ID], [Project Name], [Start Construction Date], [Actual Completion
Date]
FROM common WHERE [Start Construction Date] != ' ' OR [Actual Completion
Date] != ' '
I tried changing the != to = but it does not return anything.
I am running these queries off a MSSQL 7.0 Server
Ryan
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
But still there is much of truth in that remark. The answer is of course,
both for softdrinks and scriptlanguages: it depends on.
I guess in most case it is not actually about the language, but more related
to the skills of the one who develops the system. As the story says: there
are tools available today that can make anybody build their own house. The
different though between a craftsman and common person lies in the fact that
the craftsman can use any tool (of house building) to build a house...
>From: Michael Stearne
>
>Which is better Coke or Pepsi?
>
>I'm kidding, but there was just a really long discussion on
[...]
>On Monday, January 29, 2001, at 06:08 AM, Antonio Lopez wrote:
>> PHP or JSP ?
>>
>> I need to know what language is better to develop powerful dinamic web
pages.
Réponse au message
| [PHP] Nulls in database |
du jeudi 1 février 2001, 18:05 :
This is from memory concerning my old SQL class but isn't there
something specific in sql lines saying that to find null values you
should use :
ISNULL
Since an empty string is different from a null entry.
CR> I am trying to write a query to bring back rows that have null values set in
CR> them. I cannot figure out how to do this. I can bring back all rows that do
CR> not have nulls with the following query.
CR> SELECT [ID], [Project Name], [Start Construction Date], [Actual Completion
CR> Date]
CR> FROM common WHERE [Start Construction Date] != ' ' OR [Actual Completion
CR> Date] != ' '
CR> I tried changing the != to = but it does not return anything.
CR> I am running these queries off a MSSQL 7.0 Server
CR> Ryan
_______________________________________
Massuelles Jean-Baptiste([EMAIL PROTECTED])
Société A Comme...
Tel : 03 80 700 702
