Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Reelya]

Also, there are the #pragma versions of library includes, and also linker settings. I recommend using them instead of hacking through the VS project settings. At least having your settings in a text file is portable to new projects, just have a cpp file specify its lib dependencies. Anyone who's wrangled with the VS project settings menus will get why I'm recommending this.

[LoSboccacc]

what if we started keeping knowledge of foundational programming events as a set of parables, so that people can be enlightened of the old ways and avoid common pitfalls hundred years from now?

Spoiler (click to show/hide)

In the years after the first bubble, Experts-Exchange, a greater SEO monster, awoken in the Internet lands, hungry for knowledge and keywords. It was trapping unaware programmers with promises of problem solving and it was lying to the great content indexer, Google, about its true intentions, as for all the allure it’s content was closed in the name of the false God Paywall.

The great keepers of blogs, Spolsky and Atwood, saw the great tribulations of programmers and raised with their flaming keyboard and chanted in the language of lint: “begone foul clickbaiters, your days of kidnapping knowledge are at an end”. They conjured an aggregator of all the known programming knowledge future, present and past, and thus the SEO monster was forever slain. The children of their original program still populate the internet land as of these days, protecting every topic from the rise of yet another one.

[Putnam]

It's Experts Exchange, not Expert Exchange. Makes the URL way better.

[Reelya]

If I wanted one, I'd prefer it to be an expert one.

[Gatleos]

Code: [Select]

SELECT * FROM OPENQUERY (REMOTE_SERVER, 'SELECT * FROM REMOTE.dbo.Person WHERE PersonFirst = ' + @CustomerFirst + ' AND PersonLast = ' + @CustomerFirst) AS PASSTHROUGH
For some reason, sql server won't let me concatenate strings to create a passthrough query. No matter what I do, all it will allow is a single, unbroken string literal. Which means I can't pass those @ parameters in. Is there something I'm missing?

[Shadowlord]

Aren't you supposed to be doing parameterized queries to protect against sql injection anyways? http://rosettacode.org/wiki/Parametrized_SQL_statement

I should note that I don't know what PASSTHROUGH is, and only used SQL in one program, and learned enough to make that and then haven't used it again since.

[Telgin]

I've never used SQL Server, but in MySQL anyway I always use the CONCAT() function to do string concatenation, and a very quick search for SQL Server documentation indicates that it's supported there too.  Might be worth a try, but I've got not idea what passthrough queries are in this context so it may make no difference.

[Parsely]

I have my Murach SQL book and there's nothing in here about a PASSTHROUGH keyword. Is there any documentation online about this function?

[Gatleos]

I'm not even sure PASSTHROUGH is a keyword. It's just an alias for the returned query results or something. Anyway, I can always just perform another query on the results... but you'd think sql would give you every filtering option available to decrease bandwidth.

[jaked122]

Code: [Select]

SELECT * FROM OPENQUERY (REMOTE_SERVER, 'SELECT * FROM REMOTE.dbo.Person WHERE PersonFirst = ' + @CustomerFirst + ' AND PersonLast = ' + @CustomerFirst) AS PASSTHROUGH
For some reason, sql server won't let me concatenate strings to create a passthrough query. No matter what I do, all it will allow is a single, unbroken string literal. Which means I can't pass those @ parameters in. Is there something I'm missing?

It looks as though passthrough is a temporary query result. I'm a bit rusty with sql, as I've been using mongodb recently(I like it a bit more).


You might need to write some additional code to set the variables that you want... I've never used that part of SQL before, but this looks to be along the lines of what you want.


I'm sure you've already seen it though.

[EnigmaticHat]

So, ah, errors are dumb.  Sometimes.

Just wrote the rough beginnings of an A* pathing algorithm for a roguelike, in one sitting on a plane flight.  Got home, finished it, and aside from a few simple mistakes it seemed to work.  But then I actually tried it and the enemies still couldn't path around corners.  Everything seemed correct and I couldn't figure it out.

Turns out that, drum roll... I never told it that impassable terrain was off limits for pathing.  So this algorithm was dutifully plotting out straight lines through walls because they were invisible to it.  Even though it knew how to go around.

[MoonyTheHuman]

Yea, i need some help with this code: http://pastebin.com/7RdsCW2d
i marked problem sections with a comment that has PROBLEM: in it

[MagmaMcFry]

Yea, i need some help with this code: http://pastebin.com/7RdsCW2d
i marked problem sections with a comment that has PROBLEM: in it

I don't see the problem with the "R" command, but the "r" command does not appear to update i correctly.

[MoonyTheHuman]

I found out the problem (SCANF, DARN U)

[Avis-Mergulus]

Bluh. So I made a robot, which is a fancy name for a raspberry pi on a really derpy chassis. So far, my stuff's been working perfectly, but then I decided to make a direct control script, so I can drive it around like an RC car.
The problem is this: I generally run the pi headless, and use SSH or a bluetooth terminal on my tablet to control it. The script I wrote uses pygame to detect keystrokes and set the motors accordingly, but apparently, a remote keyboard doesn't count as a real keyboard for pygame event purposes. I mean, if I physically hook the keyboard up to the pi, it works perfectly, but that sort of defeats the purpose.

So my question: how does one make it detect remote keystrokes?