Arjan

Netherlands

1d
comment Using column alias in WHERE clause of MySQL query produces an error
A few examples: some claim that for them select @code:=sum(2), 2*@code works in MySQL 5.5, but for me in 5.6 the second column yields NULL on first invocation, and returns 2 times the previous result when run again. Interesting enough, both select @code:=2, 2*@code and select @code:=rand(), 2*@code do seem to work in my 5.6 (today). But those are indeed writing and reading in the SELECT clause; in your case you're setting it in WHERE.
2d
awarded Nice Answer
Nov
19
comment Using column alias in WHERE clause of MySQL query produces an error
Doesn't this conflict with the documentation that says "As a general rule, you should never assign a value to a user variable and read the value within the same statement. You might get the results you expect, but this is not guaranteed."?
Nov
19
comment MySQL - Define a variable within select and use it within the same select
I very much expect @z:=someProcedure(item), 2*@z working above is just a happy coincidence.
Nov
19
comment MySQL - Define a variable within select and use it within the same select
No, this does not work in my MySQL 5.6 setup; the second column yields NULL on first invocation, and returns 2 times the previous result if run again, which might fool one into thinking it did work. Now, interesting enough, both select @code:=2, 2*@code and select @code:=rand(), 2*@code; do work in the same installation (today). So, given the documentation (see Gordon's answer), I'd not rely on this to return some defined result.
Nov
18
comment Can cross-posts actually be valuable to two communities, with the exception of being worded identically?
And if the multi-posted questions get different answers, then the asker is also wasting the time of people who have the same question, as now the answers are spread across two sites.
Nov
18
revised Looking for HTTP debugging proxy for Mac similar to Fiddler on Windows
Better image
Nov
18
comment Looking for HTTP debugging proxy for Mac similar to Fiddler on Windows
@Purefan, without more detail we cannot help; it works for me, see the screenshot I just added. You may have run into mozdev.org/bugs/show_bug.cgi?id=25831
Nov
18
revised Looking for HTTP debugging proxy for Mac similar to Fiddler on Windows
Added screenshot; fixed some URLs; removed obsolete bug report
Nov
16
revised How can I disable laptop keyboard but not wireless keyboard? (Windows 7)
Merged comment posted as other (now deleted?) answer into this post
Nov
16
comment Is it okay to encourage users to serial-vote in one's profile?
You'll never know, unless you add a questionnaire to your profile ;-)
Nov
16
comment Is it okay to encourage users to serial-vote in one's profile?
Bummer, now you've broken your test by making people look at your profile for different reasons.
Nov
16
revised What should we do about Greatest Hits?
Fixed for user display name change of http://meta.stackexchange.com/users/259867/rafflesia-arnoldii, which is probably not the last
Nov
15
revised How to take a screenshot of Window's secure desktop?
Embedded images
Nov
15
awarded Necromancer
Nov
15
comment Win8.1: how to Get fingerprint sensor EgisTec ES603 to work?
It seems this link is dead. Any other way to share for future visitors?
Nov
13
comment Compatibility between Mac and PC Microsoft Office database
When saving as "Unicode" CSV in Excel (to preserve special characters), unfortunately you always get "UTF-16 encoding" (at least in the versions I used). One option to try is OpenOffice or LibreOffice, as those allow for exporting as UTF-8 CSV directly. Maybe Apple's Numbers allows for that too. All should be able to open your Excel file as a start. (As an aside: that's not called a "database" but a "spreadsheet". Also, leaving Excel open while opening in Notepad seems unnecessary.)
Nov
12
comment Mac OS X virtualization on a PC
possible duplicate of Is there a way to virtualize Mac OSX in Windows?
Nov
11
revised Free download manager issue in Chrome?
Embedded image, and its text for search engines
Nov
9
comment How to make ^ and ` non-dead-keys on Windows 7 with German keyboard layout
For non-German keyboards, see also When I type " nothing comes out, and if I type it again, 2 of it comes out as such: "" which explains about choosing some non-"US International" keyboard layout.
1 2 3 4 5