many changes to php.ini to get this far..whew!
PHP 5.2.7 just got jerked out from underneathe me (I have't replaced it since
this is a simple script)
phpinfo works!
\ or
// , when using a non default port number
$server = 'LANDON\SQLEXPRESS';
$link = mssql_connect($server, 'sa', 'PW');
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, 12/8/08,
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 playi
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 equates
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 ro
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:
I tested this, and it worked. Here is
--- 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 ex
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:
I tested this,