Ok, I just learned how to do levels and partitioning in an Oracle query today, and I have to say it's pretty cool. Basically, I have a view that returns groups of data; i.e. multiple rows with matching "key" attributes but different non-prime...
Ok, I just learned how to do levels and partitioning in an Oracle query today, and I have to say it's pretty cool. Basically, I have a view that returns groups of data; i.e. multiple rows with matching "key" attributes but different non-prime...
I was trying to call an Oracle function from ColdFusion today and was just receiving error, after error, after error... well you get the point. Long story short, I couldn't successfully get a response since there is no binding between ColdFusion and the...
November 5, 2007 | In: ajax, coldfusion, database, development
As I was explaining my latest application to another developer this morning, I realized that I was a serious framework junky on this one. I like frameworks, but I also like to scatter in my own personal touches to them based on the needs of the...
May 8, 2007 | In: coldfusion, database
Download the MySQL Connector J library and drop it in your lib directory, then restart your instance. Go to Data & Services > Data Sources section of the ColdFusion Administrator and select "Other" from the type dropdown box. JDBC URL:...
June 1, 2006 | In: database
I discovered a free tool today that is incredible, and I can't believe that it's free. SQL Prompt will make my query authoring oodles faster! I've tried it so far in the query editor for SQL Server 2000 and SQL Server 2005 Express and it works like a...