Search found 7 matches

by SorryDev
Sat Sep 09, 2006 9:48 pm
Forum: Databases
Topic: Mystery type conversion in MySQL: Can you figure it out?
Replies: 4
Views: 584

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...
by SorryDev
Sat Sep 09, 2006 8:48 pm
Forum: Databases
Topic: Mystery type conversion in MySQL: Can you figure it out?
Replies: 4
Views: 584

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...
by SorryDev
Sat Sep 09, 2006 8:34 pm
Forum: Databases
Topic: Mystery type conversion in MySQL: Can you figure it out?
Replies: 4
Views: 584

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...
by SorryDev
Fri Sep 08, 2006 4:59 pm
Forum: PHP - Code
Topic: Disappearing EOL...can you solve the mystery?
Replies: 6
Views: 841

feyd wrote:
SorryDev wrote:Are you really Harkonnen? :D
I've got the slaves to prove it. :)
I ask because my usual forum name is DuneMessiah...
It would be the first time I get help from your kind. :D

Just kidding...thanks for the tip.
by SorryDev
Fri Sep 08, 2006 4:49 pm
Forum: PHP - Code
Topic: Disappearing EOL...can you solve the mystery?
Replies: 6
Views: 841

feyd wrote:Always been there as far as I can remember.
Thanks for the tip!

Are you really Harkonnen? :D
by SorryDev
Fri Sep 08, 2006 4:38 pm
Forum: PHP - Code
Topic: Disappearing EOL...can you solve the mystery?
Replies: 6
Views: 841

feyd wrote:PHP automatically removes a trailing carriage return.
Really?

Is that new in PHP 5 or was it always there?
by SorryDev
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...