I was just thinking about something I've never understood completely!
mssql_connect($server, 'sa', 'PW'); presumes the server doesn't have all the
permissions in spite of the fact that it has the password.
The password I gave is the XP Prof login PW.
Maybe some other PW.
--- On Mon,
Fred,
If you're using integrated security (e.g., a domain account such as
domain\bob), you won't supply a password. However, the sa account is
a SQL login (v.s. a domain login). In that case, it would make sense
that you supply a password. See the following page for some code to
connect using
Original Message
Subject: [PHP-DB] MySQL Conditional Trigger
From: Dee Ayy [EMAIL PROTECTED]
To: php-db@lists.php.net
Date: 31.10.2008 17:09
I don't think my trigger likes a comparison with a variable which is
NULL. The docs seem to have a few interesting variations on
Dee,
If all you're trying to code is that a value of NULL equates to FALSE
and a date value (whatever date value) equates to true, you can use
something like this:
If ($MyVariable) {
//... true path blah...
} else {
//... false path blah...
}
You can use this because NULL
anything compared to NULL is always false
Actually it's null.
mysql select false = null;
+--+
| false = null |
+--+
| NULL |
+--+
1 row in set (0.01 sec)
mysql select 1 = null;
+--+
| 1 = null |
+--+
| NULL |
+--+
1 row
All,
Chris makes a good point i.e., unknown compared to anything is
unknown. His comment made me want to clarify my earlier note. In my
earlier example, I wasn't suggesting that-that logic be coded in the
database. I was assuming it would be in the page:
?php
$TestNullValue = NULL;
If
--- On Mon, 12/8/08, Fortuno, Adam [EMAIL PROTECTED] wrote:
From: Fortuno, Adam [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Re: MS SQL error...I've come a long way to get this far
To: [EMAIL PROTECTED]
Date: Monday, December 8, 2008, 10:56 PM
Fred,
Hmm, that makes me think the extension
Fortuno, Adam wrote:
All,
Chris makes a good point i.e., unknown compared to anything is
unknown. His comment made me want to clarify my earlier note. In my
earlier example, I wasn't suggesting that-that logic be coded in the
database. I was assuming it would be in the page:
?php
