Search found 7 matches
- Sat Sep 09, 2006 9:48 pm
- Forum: Databases
- Topic: Mystery type conversion in MySQL: Can you figure it out?
- Replies: 4
- Views: 582
My version of MySQL returns 73786976294838206460. It's MySQL version 5.0.22. Apparently, results vary from version to version and none are correct. 8O Well, that would be correct if the logic is to upcast signed to unsigned. That result indicates that your install uses 64bit integers. :) Upon consi...
- Sat Sep 09, 2006 8:48 pm
- Forum: Databases
- Topic: Mystery type conversion in MySQL: Can you figure it out?
- Replies: 4
- Views: 582
Generally I would expect that the signed integers would be upcast to unsigned as I recall C would do it. However, I see that at least my local version of MySQL (5.0.18) returns NULL. My version of MySQL returns 73786976294838206460. It's MySQL version 5.0.22. Apparently, results vary from version t...
- Sat Sep 09, 2006 8:34 pm
- Forum: Databases
- Topic: Mystery type conversion in MySQL: Can you figure it out?
- Replies: 4
- Views: 582
Mystery type conversion in MySQL: Can you figure it out?
Look at: SELECT SUM(-1 + CAST(1 AS UNSIGNED INT) * 0) FROM <a table of your choice> LIMIT 1; What result do you anticipate? Now replace "<a table of your choice>" and run the query...what result did you get? Explain why... Obviously, my actual case was not that stupid...I had a sum followi...
- Fri Sep 08, 2006 4:59 pm
- Forum: PHP - Code
- Topic: Disappearing EOL...can you solve the mystery?
- Replies: 6
- Views: 841
- Fri Sep 08, 2006 4:49 pm
- Forum: PHP - Code
- Topic: Disappearing EOL...can you solve the mystery?
- Replies: 6
- Views: 841
- Fri Sep 08, 2006 4:38 pm
- Forum: PHP - Code
- Topic: Disappearing EOL...can you solve the mystery?
- Replies: 6
- Views: 841
- Fri Sep 08, 2006 3:54 pm
- Forum: PHP - Code
- Topic: Disappearing EOL...can you solve the mystery?
- Replies: 6
- Views: 841
Disappearing EOL...can you solve the mystery?
I have this PHP code: <p> Your request was invalid.<br /> The following error was reported: "<?php echo $errorMessage; ?>"<br /><br /> <?php echo $GLOBALS['baseName']; ?> @ <?php echo $GLOBALS['baseUri']; ?> </p> When interpreted by the Web server, I get the following output: <p> Your requ...