value (28,663)


Binary Data in MySQL

Binary Data in MySQL

How do I store binary data in MySQL ?…


Decoding T-SQL CAST in C#/VB.NET

Recently our site has been deluged with the resurgence of the Asprox botnet SQL injection attack. Without going into details, the attack attempts to execute SQL code by encoding the T-SQL commands in…


SQL Server 2005 implementation of MySQL REPLACE INTO?

MySQL has this incredibly useful yet properitary REPLACE INTO SQL Command. Can this easily be emulated in SQL Server 2005? Starting a new Transaction, doing a Select() and then either UPDATE or INSER…


c# How do you sort a dictionary by value?

I often have to sort a dictionary, consisting of keys & values, by value. For example, I have a hash of words and respective frequencies, that I want to order by frequency. There is a SortedList which…


XML Processing in Python

I am about to build a piece of a project that will need to construct and post an XML document to a web service and I'd like to do it in Python, as a means to expand my skills in it. Unfortunately, w…



python cx_Oracle: How do I iterate over a result set?

There are several ways to iterate over a result set. What are the tradeoff of each?…


sql Swap unique indexed column values in database

I have a database table and one of the fields(not the primary key) is having a unique index on it. Now I want to swap values under this column for two rows. How could this be done? Two hacks I know…


Python and MySQL

I can get Python to work with Postgresql but I cannot get it to work with MySQL. The main problem is that on the shared hosting account I have I do not have the ability to install things such as Djan…


Are PHP Variables passed by value or by reference?

Are PHP variables passed by value or by reference?…


Windows Help files-what are the options?

Back in the old days, Help was not trivial but possible: generate some funky.rtf file with special tags, run it through a compiler, and you got a WinHelp file(.hlp) that actually works really well.…


sql What is the best way to handle multiple permission types?

I often encounter the following scenario where I need to offer many different types of permissions. I primarily use ASP.NET/VB.NET with SQL Server 2000. Scenario I want to offer a dynamic permissio…


php Using object property as default for method property

I'm trying to do this(which produces an unexpected T_VARIABLE error): public function createShipment($startZip, $endZip, $weight=$this->getDefaultWeight()){} I don't want to put a magic number in…




get how from example with javascript array set string values