LINQ Demystified : Using LINQ on Existing Data Model
As many other times, I came across this issue having to begin at the wrong end, i.e. having the result and in need of the problem. The samples and recommended procedures offer – as in most cases – only the simplest examples. The workaround is often tedious and in absence of feedback uncertain.
Full Story
Access 2007 and NULLs
I wasted several hours not realizing that MS Access 2007 doesn’t display NULLs in a table. It all started when we’ve been asked to patch up an old project whose authors have gone missing. The application was ASP.NET 1.1 with an Access db and no source code and no documentation. Oh, the joy!
Full Story
Converting rootless XmlReader to XmlDocument in .NET
MS SQL has the ability to retrieve data as XML by using the “FOR XML [RAW | AUTO [ELEMENTS] | EXPLICIT]” parameters, which is very useful especially when used in a web service that communicates with a Flash / Flex client as the results don’t have to be converted, but just output to the client. [...]
Full Story
Forgot or lost SQL Server “sa” password
Here’s a neat thing to remember if you’re using MSSQL: To change the “sa” password, login to your computer using an administrator account. Open your SQL Server and log in using Windows Authentication. Open a new query window and type in the following command:
Full Story
A very fast introduction on Mysql triggers
I started to work on a pet project for tracking deleted/pending domains (myDomainTracker) and after starting development I was facing a big problem: How to do the data validation directly from MySQL ? Many times I wanted to do data validation directly when inserting into a MySQL table and leave the source code of my [...]
Full Story
Multiple queries and one transaction
I just need to post this as all examples I found were explaining how to use transaction in a <cftry> and <cfcatch> block with only one query. But if you have a query file to include in your Fusebox application, that does multiple queries and only one needed to be in a transaction block, then [...]
Full Story
Get the Current Date for PL/SQL
This is not really a post, just a small note on an item that can make you lose precious time hunting for… To get the current date in a PL/SQL query in order to compare it with other fields or data from the Oracle database, do this: select extract(year from sysdate) from dual This gets [...]
Full Story