I can already see that I'm not going to enjoy the experience, but I have to do some sql cleanup on this 1000 file asp classic web-app without any prior knowledge of asp, and before I get to hacking away at it I'd like to be aware of any major gotchas to watch out for while coding in asp classic/sql parameter preparing/making asp whitespa...
Hey,
Since I am using DB2, in order to select a portion of a database in the middle (like a limit/offset pairing), I need to do a different kind of prepare statement. The example I was given was this:
SELECT *
FROM (SELECT col1, col2, col3, ROW_NUMBER() OVER () AS RN FROM table) AS cols
WHERE RN BETWEEN 1 AND 10000;
Which I adapted ...
I'm having a crack at using the MediaPlayer object and not having much success. If I add a sound asset to my raw folder and call it using the int value within R, it works fine. But I want to be able to pull things off of url.
According to all of the documentation I've read setDataSource() should accept a string param with a url to a f...
Im trying to find out the best way to execute these types of queries
What I want to do is build a filter type function where i was in an array and the query is constructed!
the problem is with PDO before you can bind a value you need to prepare the statement, but if i prepare the statement I cant change the query.
Let me show you an e...