
By Sanda Borlea on December 7, 2009
A simple solution to a complicated error for anyone to try out before searching any further : Having to write a WCF service to handle complex LINQ entities with various foreign key references I came across the following exception when trying to consume the respective service :
Object graph for type “EntityType” contains [...]
Posted in .NET | Tagged cycled, graph, linq, object, reference, serialized, type, WCF

By Sanda Borlea on November 12, 2009
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.
Posted in .NET | Tagged .net, c#, linq, sql

By Sanda Borlea on October 29, 2009
This note refers to Visual Studio snippets and shows how you can easily add your own. Very useful when having to create many classes with lots of properties such snippets save a lot of time.
They are usually to be found in the Visual Studio folder under My Documents (i.e. for VS 2008 : C:\Documents and [...]
Posted in .NET | Tagged c#, snippets, visual studio, xml

By Sanda Borlea on November 29, 2008
Recently needed some quick method to use objects generated from an existing xml file without bothering to create an xml schema for it. After a few attempts and searching for explanations why a simple task like this wouldn´t work, finally put the steps together:
Posted in .NET | Tagged .net, c#, xml

By Sanda Borlea on June 22, 2006
In case of a master report containing various subreports it is sometimes very useful to have a field containing the common information for all or some of the other reports.
I encountered this problem when making visible or invisible images in the report based on a specific group of products. The solution I have found might [...]
Posted in .NET | Tagged microsoft, reporting services

By Sanda Borlea on April 3, 2006
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 the [...]
Posted in ColdFusion | Tagged ColdFusion, sql, tutorial

By Sanda Borlea on December 23, 2005
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 the current [...]
Posted in Oracle | Tagged Oracle, pl/sql, sql

By Sanda Borlea on December 14, 2005
When developing Web-based applications many times one has to test it and see it is working before going further.
Very often emails need to be send from within those applications.
Here are the steps to easily setup a mail server on the local computer and test email sending.
Posted in ColdFusion | Tagged ColdFusion, iis, smtp

By Sanda Borlea on November 22, 2005
I was asked by a client to test some application features onsite and needed to re-create the environment on a single computer using ColdFusion with Oracle as database and had a hard time figuring out what the installation order is and get everything work together.
Posted in ColdFusion, Oracle | Tagged ColdFusion, Oracle, tutorial