The 2nd Monitor

Yea, I read something about that. Colours, borders, alignment, a lot shifted to the CSS.

Basically any styling moved to CSS. HTML became the content layer, CSS became the presentation layer.

my pc is so crap, i have no idea why i do not get a better pc for development than this (in work)

its frustrating

And JS does the dynamic stuff?

Essentially, yeah, JS does everything else.

It handles user interaction

You can have some limited user interaction via input[type=submit] and a html elements which is provided by the browser

but, aside from that, button and so forth are all handled by js

1:05 PM

I ~~stole~~ made a carousel two years back or so. Mainly JavaScript.

yeah, that would only work with JS.. maybe CSS and HTML alone if you were a real god at it

@DanPantry Button is handled by JS now? I thought you just made button in a form in a div and be done with it.

I mean, a carousel could work with CSS animations/transforms these days

@Mast a button doesn't do anything on its own

@DanPantry I've seen people make moving solar systems in CSS, quite nice.

you're thinking of a submit button, which is input[type=submit] - browsers will automatically recognise that button as submitting the parent form

1:06 PM

Yea, no JS required.

Checkboxes, radio boxes, all HTML.

in addition, an input[type=submit] will be triggered if you press return while inside an input element in the same form!

so if you are inside an input[type=text] (and the form is valid) and you press enter the browser wil automatically submit the form if you have an input[type=submit] in that form

VBA has a string-matching LIKE operator. everything-is-awesome

the stuff that browsers can do with semantic HTML these days is amazing

@Zak lol

@Zak Like SQL?

yep

If <string> Like "##/##/####" Then...

1:07 PM

@DanPantry So, should it be moved to JS or stick in HTML?

@Mast wait, what? what are we talking about here? :P

Oh, the pre element?

BRB. I need a dump. :^)

Office is having an Ugly Christmas jumper day, I think I'l be wearing this

@Zak where can I buy that? Asking for a friend

3

@DanPantry Google Image Search

ouch, $50

1:18 PM

It's Star Wars branded merchandise, what did you expect :p

@Zak Do it, and make pictures ^^

Apparently, my problem with dim refEditBox as RefEdit earlier was because it should have been dim refEditBox as RefEdit.RefEdit

RefEdit.RefEdit, seriously?

1:36 PM

RefEditception?

Q: Is it okay to save a serializable object with JPA?

0

So I am making a dashboard with widgets for the user homepage. So I have created the entity UserWidget. With my current design I have this. What I have in mind is the following. A user only has one UserWidget, and when he moves around the widgets it gets updated in the WidgetData list. So the lis...

React looks a lot nicer in CoffeeScript than in plain JS..

React = require 'react'

class App extends React.Component
  render: () =>
    <h1>Hello, World!</h1>

module.exports = App

hooray for whitespace significance

@Zak sounds pretty dim :)

2

Q: Retrying web request in Python?

0

Is it fine to retry a web service call like this in Python? Would there be any scenarios the exception might not work the way we expect it? I expect it to continue only if its fine otherwise just retry and if that doesn't work just throw the error out. def getblob(html): num_of_retries = 2 ...

python

@Zak I like the partial string match, have used it a good bit in Access

Far simpler than regular expressions, albeit less powerful

I want to pull out what little hair I have left when I see ORDER BY 1,2 in queries.

1:57 PM

@Phrancis I can live with less powerful for the time being. I started learning regex recently and it made my head hurt

@Zak Funny how it does that no? :)

Donald.McLean

Greetings, Programs.

Today starts with an unusually high level of unfortunate.

I don't know about VBA, but I know SQL Server supports some basic pattern matching natively, without regex. So you can do things such as WHERE SomeVal LIKE 'Hello[_ -]World' to look for either an underscore, space or hyphen

@Donald.McLean Oh, sorry to hear that, what's up?

Donald.McLean

@Zak The couple who was going to buy our house today, the wife was let go by their employer last night.

2:05 PM

@Donald.McLean woops

That sucks

Donald.McLean

Yeah, it's a great big pile of suck all around. They have no place to live, we're stuck paying rent AND a mortgage.

Ouch

@Heslacher Done! :p See, half-way through my answer I thought about a change in implementation. So I removed the line of code that took care of the first character. Then I reverted to the first implementation and forgot to add it back. :p

Morning @all!

@TopinFrassi Salut

2:17 PM

I love logging in in the morning and having more rep than when I left. It's a good start for the day

2

@DanPantry I received my first spam mail on the secret-santa mail. It's a good thing we didn't write our email addresses here!

@TopinFrassi lol

BTW, we're now 8 participants for the Secret Santa! Will we reach 10 today!!?! :D

*wink wink*

I keep forgetting to send mine in, I will when I get home tonight :)

janos

^^^ kinda takes about 0 minutes ;-) (nudge nudge wink wink)

@Phrancis Can you help me with yet another SQL query? (This one should be quick.)

2:23 PM

For sure

Wait, actually, I might have it somewhere else.

Ok, either way I'll be in the SQL room if you need me :)

Sweet.

Just found out I have over 2600 tables in this one DB.

I might need some VBA help here in a while, we'll see. I want to write a small script for Outlook

And I have to write a cursor to go through all of them.

2:25 PM

@Phrancis Cool! :)

@EBrown To do what?

@Phrancis Well, I want to merge them all into one table again.

Well, not all of them, but about 2650 of the 2670 of them.

And I need to merge all of those to two tables.

Which is gonna be fun.

Can't you JOIN EXCEPT or something?

codereview.stackexchange.com — Vsevolod Golovanov 36 secs ago

@Mast Do what?

2:27 PM

I don't think so, there's 2600 tables...lol

Well, 2670 to be exact.

@Mast You can set inclusion and exclusion conditions on joins (in addition to just equality conditions on keys)

He wants to merge 2650 out of 2670 tables.

And I'm currently copying all of them to another server.

I'm kind of lost at what he needs a custom cursor for.

Somebody asked a cobol fizzbuzz

You can do lots of things with cursors that you can't do with "regular" set-based queries

2:30 PM

> As the FizzBuzz seems fashion here, I made one.

2

death-to-fizzbuzz

Most common use case that I've seen for cursors is to perform set based operations on a large number of tables, which can even be in multiple database catalogs spanning multiple server instances

Yeah, the idea I have is to schedule a cursor to run over one Server's DB, copy all the tables that match two patterns to the other DB, then merge them in the destination DB for now.

Eventually I'll rewrite the applications to use the destination DB.

Copy to destination -> Run merge -> Delete as merges pass.

what have you tried, and what were the results? you need to explain what the problem is, not ask for a code review. — Erik Nyquist 51 secs ago

Q: Fizzbuzz in COBOL, Verbose dinosaur style

0

I was long a professional in COBOL, but noone ever dared comment my style. As the FizzBuzz seems fashion here, I made one. Verbose, of course, we're speaking about COBOL. I know I could have made in 15 lines, but decided instead to provide the full structure for a production program. Result makes...

fizzbuzz cobol

0

Q: Multi class-type Object pool based on Libgdx Pool - What do you think about this code?

I've done some code so you can obtain Object of any Class from Pool, take a look at it, is it safe? At least it works. MultiPool class has method obtain with Class param, so can know from which inner-pool obtain Object. import com.badlogic.gdx.utils.Pool; import java.lang.reflect.Modifier; imp...

java android generics libgdx

2:36 PM

> I've done some code so you can obtain Object of any Class from Pool, take a look at it, is it safe? At least it works.

"At least it works" Is a good programmer motto.

Wow, COBOL looks so archaic

Hah, wow it looks like an error log.

@TopinFrassi Removed my comment

I'm guessing lines that start with * are comments in COBOL eh?

Guys, what's the complexity of a join call in Linq?

@Heslacher Thanks!

I'd expect O(n^2) but well, maybe it's something else I don't know about

2:40 PM

Well, my copy failed.

Debug time.

\o/

How, how am I out of stars already :)

@EBrown I'll be in Helpline ;)

@Phrancis Is there a way to delete all tables in a DB?

@EBrown Without dropping the database / schema I assume?

2:44 PM

Yeah. Preferably.

Tricky. You might have to delete all the FK constraints first

There are none.

Oh

Wait, do you want to delete all tables or just the contents?

All the tables.

2:45 PM

Make a cursor using the sys.tables.name values then

@EBrown Give them to my colleague, he'll find a way. He's really good at dropping production tables

4

@DanPantry These aren't production. :P

Actually you could even just do it with a while loop

I'm in the SQL room.

I honestly don't think you will get this resolved with your existing code - especially as your formulas are calling an another add-in there is far too much going on at once. Honestly, I'd go back and look at the design of your code and find a simpler, effective way of doing what you're doing. Maybe post your code on the CodeReview site and see what you get there. — Macro Man 36 secs ago

2:51 PM

rm -rf * doesn't work on tables I suppose?

@Mast lol

Lol

SQLite seems to have something like that though.

20

A: Drop all tables command

rm db/development.sqlite3

Which will pretty much nuke your database if I read it correctly, not just your tables.

That looks pretty hardcore. ahah

HEY CHRISTMAS TREE, YOU SET US UP. God I love that language — TopinFrassi 1 min ago

Anyway, I'm off robbing the bank.

2:57 PM

@Mast Whoever thought about that language deserves all the cookies

@SuperBiasedMan Is there some rule in English I didn't know about?

@Mast It's English, so yes.

You use 'an' before a word that begins with a vowel, so any world that starts with a e i o or u.

It's meant to make the sound better, because "a Arnold" blends together weirder than having a definite break between the words with "an Arnold"

Hmmm, yes, I had my grammar rules mixed up with something completely unrelated. For some reason I thought if it was a FizzBuzz, it didn't matter there was an adjective in between.

I guess that's what happens when you post at 4 AM.

Although I'm not sure why I didn't catch it afterwards.

It's bloody obvious.

It's English. Nothing is obvious.

3:03 PM

^that

Yeah the only obvious thing is that it's all obscured and full of exceptions

Technically you're meant to write "an history", but that's not clear cut.

I've got a more extensive vocabulary than about 95% of the people I know, and I still have WTF moments fairly frequently.

skiwi

@SuperBiasedMan like "a-nistory"? or "an-istory"

possible answer invalidation by aswin mohan on question by aswin mohan: codereview.stackexchange.com/posts/112753/revisions

@SuperBiasedMan Depends on the context of the usage

@Duga needs rolling back

3:05 PM

> 30000 rows transferred.

@skiwi "an-istory"

It's cause some people basically make the h silent.

So "a-istory" isn't a nice sound.

As with most things English, you can legitimately do either in most situations.

@Zak I was about to rollback but I forgot I don't have the privilege anymore D':

@Duga Rolled back.

possible answer invalidation by Mark Omo on question by Mark Omo: codereview.stackexchange.com/posts/112260/revisions

3:10 PM

@Duga Also needs rolling back

@Zak done

Oh, I still have the privilege. I just didn't know where the rollback button was.. lol

@Phrancis added a comment for you

@TopinFrassi I think you get it at 2K rep with the rest of the edit privileges.

@Heslacher Danke:)

3:12 PM

@EBrown Yeah that'd make sense!

Bitte :)

I think you can still suggest it even without that privilege, just it's treated like any other suggested edit.

Also woop, got my first bounty!

6

Congrats @SuperBiasedMan

3:14 PM

@Phrancis I figured it out afterwards ahah

Man, it's gonna be hard to stay on the second rep page until we get swag.. People are working hard to go up

But second page by what standard? Cause there's multiple options for how many people to have per page

@TopinFrassi Well, you've got plenty of time

@SuperBiasedMan IIRC, convention is 72 for 2 pages

@SuperBiasedMan Actually no. Or well, there's an option I don't see :p

@Zak Yeah but the rest of people also have plenty of time :p I'm at the bottom of the 2nd page and I'd need 1000 rep to go up by like... 5 positions. :p

@TopinFrassi Cutoff point has gone up by about 200 since graduation. So it's not going too fast just yet, perhaps 20 rep/day

Maybe I'm looking at a different page to both of you, cause there's no 36 per page option here:
http://stackexchange.com/leagues/86/alltime/codereview

3:19 PM

> 111000 rows transfered.

@SuperBiasedMan codereview.stackexchange.com/users

@SuperBiasedMan Yeah, we're not looking at the same page. :p I hope they'll be checking MY page. ahah

@Zak It's not that bad. 20rep/day is nothing

Now that page makes a ton more sense.

Woot! Second run of the transfer succeeded.

@TopinFrassi You say that, but I swear I've never seen at least half of the people on the first 2 pages

3:26 PM

@TopinFrassi I'm almost on Page 2.

@Zak Yeah same here! But I think it's because they're working on different tags than I do. I work in a very small set of tags (C# and Java, lol). So anyone that does the same as me, but in Python, C, C++, etc will never see me.

Unless they're on chat.

So, I really want swag:

4

LOL

Q: Using VBA to "apply names" to named range references

1

So there's a known bug in excel where applying named ranges via ribbon doesn't work properly (for 2010 and 2013 and possibly 2016). There was a question about it on superuser - Apply names in excel bugged?. I took a shot at it. This code will find all of the named ranges in the book and then s...

vba excel

Q: Excel Manipulation in Single Procedure part 2

Also, I dislike people who accept their own answers over other, much better ones (me? bitter? not at all :p )

-2

So again I modified my last posted code as other fellow friends said me. So please review and let me know what more modifications and optimisation I can do in This code now. Previous Post Spreadsheet Manipulations in Single Procedure Option Explicit Sub new_comment() 'Coded by Vij, Atul (Contr...

vba excel

3:33 PM

Lol Zak, we told him eh :p

This is not a review, posting as a self-answer doesn't exclude you from the site rules that state you must not dump code. Explain why your code is better. — TopinFrassi 41 secs ago

(Lights the Santa-Signal):

0

A: Clean up VBA search?

You'll have to either manually type a list of terms into VBA, or have them written in a sheet and pull them into an array/collection. Assuming the former: I'd have a separate procedure like so: Public Sub FillSearchStrings(ByRef arrayList As Variant) Dim ix As Long ix = 0 array...

Ah, I have fond memories of this one: "Let's start with the obvious. If you're trying to do anything with a 10-d array other than put it in a proper database, you're doing it wrong."

And there should be an award for best one-liner from a new user: "It's a kludgy mess of stuff I've managed to make work"

possible answer invalidation by Ricardo on question by Ricardo: codereview.stackexchange.com/posts/112583/revisions

@Duga Strange one. Invalidates their own Selfie-answer.

Damn, @Jamal really is fast on that. :p

Some say that he used to be a stormtrooper, but he was kicked out when he tried to correct Darth Vader. All we know is that he's called @Jamal!

Some say he's wanted by the CIA, and that he sleeps upside down like a bat... All we know is he’s called @Jamal!

(and so on)

3:49 PM

4

@JeroenVannevel lol

I would star Dilbert, if I had any stars left to give.

@Zak RSA

My kingdom for one day of silence about those damn stars

@Zak How can you use them SO fast. ahah

@JeroenVannevel Is your kingdom big?

3:53 PM

That's between me and my lover

So inappropriate

@JeroenVannevel she's spanish, right?

they aren't known for their kingdoms

the British are though. <:

sure, there are spanish ones

@JeroenVannevel Your lover? I missed something!

empire

@TopinFrassi you don't realize the appeal I have on woman

I have to schedule them when I meet who

3:55 PM

@JeroenVannevel I schedule them too. But my schedule is kinda empty these days. Ahah

Kingdom of Aragon

The Kingdom of Aragon (Aragonese: Reino d'Aragón, Catalan: Regne d'Aragó, Latin: Regnum Aragonum, Spanish: Reino de Aragón) was a medieval and early modern kingdom in the Iberian Peninsula, corresponding to the modern-day autonomous community of Aragon, in Spain. It should not be confused with the larger Crown of Aragon, that also included other territories — the County of Barcelona and other Catalan Counties, the Kingdom of Valencia, the Kingdom of Majorca, and other possessions that are now part of France, Italy, and Greece — that were also under the rule of the King of Aragon, but were a...

There's an R missing in that name.

@JeroenVannevel don't go all history on me now

though apparently I'm in the Crown of Aragon right now

but are you taking the hobbits to Isengard-gard-gard-gard?

2

Taking the Hobbits to Isengard - HD

4:01 PM

@Zak Even then you're probably doing it wrong. 10 dimensions? I usually don't go above 5.

►

Q: Check if page was scrolled all the way to the end

0

I am not sure if this is the best way of doing this or if it works in all situations. function atPageEnd() { var height; height = window.document.documentElement.scrollHeight; return window.pageYOffset + window.innerHeight === height; }

javascript portability

0

Q: Style and best practices with AngularJS directive-oriented approach

In anticipation of the new Angular release and since I've only just begun learning it, I have been developing a project in a directive-oriented way. Below is a sample of a section that handles message posting, and I was wondering how I could improve it using some best practices or conventions tha...

angular.js

IMO, this isn't a great question, but it probably doesn't deserve to be in negative territory:

-1

Q: Clean up VBA search?

I have code, that is identical minus two changes that would happen each time, which I can use variable for, but I dont want to use a bunch of if statements. the code I have is C = 1 fnd = Sheet1.Cells(C, 8) While InStr(fnd, "Customer Name:") <= 0 And C <= 300 C = C + 1 fnd = Sheet1.Cells(C, 8) ...

vba excel

@Zak Current score is +1/-2.

It lacks context.

4:20 PM

possible answer invalidation by Nishant on question by Nishant: codereview.stackexchange.com/posts/112868/revisions

Mat's Mug

@Zak you missed a number of bugs

;-)

@Mat'sMug I'll admit, I wasn't looking for them. I saw my angle, took it, didn't feel like delving any further :)

Mat's Mug

@Raystafarian this is why Code Review is here =) — Mat's Mug ♦ 5 secs ago

Q: Bash: Return the first number found greater than the provided input number (Base 13)

4:39 PM

0

For use with timestamps... I'm having issues with it being very slow. I wanted an alternative to grepping for one specific UNIX_MS timestamp and not finding it and then having to grep multiple more times... For the output I wanted the line number in the file (for slicing) as well as the original...

bash logging

SO is not a codereview site! But you can always post on: codereview.stackexchange.com — Peter Varo just now

5:03 PM

@Duga Deleted.. but, no, code is broken (giving wrong output)

possible answer invalidation by Rahul Desai on question by Rahul Desai: codereview.stackexchange.com/posts/112828/revisions

@Duga simple typo fix not mentioned AFAICT in the answers.

'I have been awake for too many hours. 'night @all

Mat's Mug

5:24 PM

'night! (another VBA review coming your way ;-)

Greetings

Hi.

How's it going?

My phone locked up.

It won't accept any input.

I know one input devide your phone will accept, but it may not be able to handle it: an hammer!

5:32 PM

I can't afford that.

It should fall asleep soon enough, and start working again.

Wow, are hammers that expencive? Last time I checked, they were 5€ or less.

The phone was $50.

I wouldn't be able to replace it.

And I don't think they have any Windows Phones that cheap now.

What provider?

@EBrown AT&T pay-as-you-go.

Ah, I don't know about that.

5:35 PM

Why Windows Phone?

So, I bought the phone, but I haven't paid for minutes.

@IsmaelMiguel Testing purposes.

Q: Eratosthenes Sieve optimized in C

0

I wrote yet another optimized single-threaded Eratosthenes Sieve implementation in C: erato.c // #include <stdio.h> #include <stdlib.h> #define N 1000000000 #define num_t unsigned long int main() { register char *b = malloc(N * sizeof(char)); for(num_t i = 0; i ^ N; ++i) b[i] ...

c sieve-of-eratosthenes

Testing what? IE? :/

I'm running the Windows 10 Mobile preview, and it locks sometimes.

@IsmaelMiguel Nah, my app for Windows Phone.

I think the full-on version is already out

Wow

First time I've heard someone developing a Windows Phone app

5:36 PM

It is usually quite good, if a mite slow, but sometimes it locks up.

Actually, this is the first time it locked up for this build.

@Hosch250 att.com/cellphones/microsoft/…

This is probably better suited for Code Review , as it seems that this is functional code. — Dev-iL 11 secs ago

@EBrown I got a new 520.

Maybe your phone hates you?

Just looked and a new 640 is $70.

5:38 PM

I don't think there is a way to hard-restart the phone.

Pull the battery?

Oh, power and volume down.

And that works on Windows Phone?

Aha. :)

I tried holding power down, but that is the soft-restart sequence.

5:40 PM

On Android, holding the power down for over 5 seconds, completelly kills it

I'm going to order myself a 950 soon.

Like pulling the plug on your desktop

I have a Huawey Y625, and I'm happy with it

I know. Sounds like a cool phone.

Great screen, alright-ish camera, bad interface, great internet speed (3.5G), long-lasting battery (3-6 days), resilient (smashed it against a traffic sign) and quite fast (runs my IMGJS decoding of the jQuery library in ~300 milliseconds, where my desktop takes 3-20 seconds)

I can't get the final version yet. It is supposed to come out sometime in December for existing phones, and it hasn't yet (at least not for the 520).

5:45 PM

Weird

Edge is one cool browser on the phone, although I boycott it on the desktop.

And the Office apps are just brilliant.

Edge is just IE in disguise

At the very bottom of my plan list is to write a universal Python IDE inspired by the Office apps.

In what language?

@IsmaelMiguel No, it is better than IE for phone. And it uses a completely new rendering engine.

@IsmaelMiguel C#/XAML.

5:46 PM

@Hosch250 On desktop, still IE.

@Hosch250 Need help?

IE is better on the desktop.

I use IE at home

@IsmaelMiguel When I get the framework up, I'll make it open-viewing on GitHub.

Conversion failed when converting the varchar value '321.3' to data type int.

You guys can make PR's if you wish.

5:47 PM

#Fun

@Phrancis Try a float.

@Hosch250 PR?

321.3 is not an integer, so it can't become an int.

Yeah I'll have to convert this crap

@IsmaelMiguel Pull Request.

5:48 PM

Oh

Well, I hope I can help on something

Even if it is just for testing

Sure. You know Python?

My C# is as strong as the world economy

No :/

I don't know it very well.

LOL. XAML is easy, anyway.

SirPython might know Python

Mat's Mug knows some XAML, I think

But, I have to get a couple papers written. TTYL.

@IsmaelMiguel He's good at WPF.

WPF uses C#/XAML (usually, anyway - not sure about always).

5:52 PM

> Conversion failed when converting the varchar value 'B, ALICE' to data type int.

4

lmao

@Phrancis What in the world are you trying to do?

Overcompensating for how badly this thing is designed

What you need to do is this:

First, design a new DB with good designs. I'll do it for $75/hour.

Next, import all the data from the other DB using queries.

Next, rewrite all the current queries, applications, etc.

Finally, profit.

@Phrancis But ... But .... We all know that Alice is a solid 10!!!

@Hosch250 Oh, yeah, it's WPF. Sorry, my memory is playing tricks on me latelly.

@Hosch250 May as well rewrite the whole application while we're at it

5:55 PM

@Phrancis You'd better watch out before she uses her scissors, bat, fist of death, and concentrated anger on you.

@Phrancis I'll do that too.

OK, better get started, got about 1.6 million LOC to go ;)

If you give me the whole contract, I'll reduce my rate to $65/hour.

Oh wait, I was off-by-one, make that 16 million

4

PHP Question: would you follow me with your pitchforks if I used a lambda, in PHP, to force a local scope and help with garbage collection?

I might chase you with a pitchfork for using PHP, but probably not for the lambda.

5:58 PM

But I can't use Python for web development!

Well, you could.

I'm not going to use CGI!!!

skiwi

@IsmaelMiguel PHP has lambdas?

If only mod_python worked...

Computer Generated Imagery or Common Gateway Interface?