Ricardo Parente's Blog

Announcing a new Meetup for The Online ColdFusion Meetup! What: “One DAO to Rule Them All…!!”, with Wes Byrd Our 6pm (US ET) talk on Thursday June 2 will be “One DAO to Rule Them All…!!”, with Wes Byrd. TOPIC DESCRIPTION: (provided by the speaker) The DADAO is a single CFC that will act as a Data [...]

Pinal Dave, my SQL Guru, completed today 1500 posts on his blog SQLAuthority, with 20 million views in iyts 4th year. That’s amazing! Good job. He explains how he came up with the blog’s name on this article. Keep up the good work Pinal !

This week I had to write a stored procedure for retrieving real estate properties and use the data in a ColdFusion template with pagination.  I had the following input arguments: StartRow, EndRow, PriceFrom, PriceTo and SortBy. Since I use Fusebox, all parameters passed in the URL query string are converted to the scope “attributes”.  So, [...]

We, at the company,  had to find all cities in my city table which name were composed of more than one word and the last word should have only two characters, like “Berlin SO”, “Santa Fe”… Phillip Gagnon, our I.T. manager, showed us two simple ways to list them using wildcards: 1 2 3 SELECT [...]

Microsoft released the SQL 2008 Service Pack 2. You may download it here. Reference: Pinal Dave

I have found many solutions to pass a list parameter from ColdFusion to a stored procedure, and this one is a very simple and efficient way to convert a string to a table. Thanks to Amit Gaur posting to SQL ServerCentral. I modified his original function which returns only integers (forcing you to pass only [...]

We are constantly implementing new tasks and developing web sites for about 12 customers. We have a development server at our office and our live servers are at our datacenter. Many times we have to rewrite or modify stored procedures and then after testing, we need to copy them to the live server.

My friend Pedro Claudio posted a link on my Facebook Wall about this presentation made by Bernardo D. A. Guimarães at the Black Hat Briefings Europe, Amsterdam in April 2009. I found it interesting and here is the slide presentation: Advanced SQL injection to operating system full control (slides) View more documents from Bernardo Damele [...]

I was following the SQL list and came across a post from Jim Gotwald where he showed his solution to convert a time string into a decimal value (ex: ’10:30′ to 10.5). So I decided to write a custom function where you can either pass a complete date as a string or just the time [...]