Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFUNITED 2010 (Landsdown, VA) with: Alexander Friess and Gary Gilbert
Ben Nadel at CFUNITED 2010 (Landsdown, VA) with: Alexander Friess@AlexanderFriess ) and Gary Gilbert@garyrgilbert )

Pinal Dave

Member since Dec 11, 2008

Recent Blog Comments By Pinal Dave

  • Running UPDATE And DELETE SQL Statements Using ColdFusion Query Of Queries

    Posted on Sep 12, 2009 at 1:03 PM

    This blog I have been reading for almost 3 years. I am commenting again on this particular post after almost one year. Ben, This is totally creative and hats off to you. Few may think what a big deal but if someone who have experience with SQL and ColdFusion both, can only truly appreciate the dept... read more »

  • Datasource Names For All The Database Tags Within CFTRANSACTION Must Be The Same

    Posted on Feb 8, 2008 at 3:11 AM

    Great Post! The workaround for the problem of CFTRANSACTION with different data source we have used earlier was. Use the same datasource but prefix the table with desired database. Following solution is not good and many times gives unexpected results. Not RECOMMENDED. I am listing it here for ... read more »

  • Thanks Adobe!

    Posted on Jan 21, 2008 at 1:43 AM

    Hey Ben, Wonderful wonderful. Actually your services to community are well noted by Adobe, you very well deserve this honor. Congratulations congratulations!!!... read more »

  • Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)

    Posted on Sep 5, 2007 at 10:51 AM

    Ben, I am sure my blog readers will find it useful. Regards, Pinal... read more »

  • Using A SQL JOIN In A SQL DELETE Statement (Thanks Pinal Dave!)

    Posted on Sep 4, 2007 at 3:22 PM

    Ben, Thanks for posting this article. I glad that you find it useful. I think my blog reader will find this details very useful as I never wrote about this on my own blog. Tomorrow I will write down summary and point to this two wonderful (and well explained) post you have. I like your examples. ... read more »

  • Using A SQL JOIN In A SQL UPDATE Statement (Thanks John Eric!)

    Posted on Sep 4, 2007 at 10:46 AM

    Ben, As general rule you can write all your UPDATE, DELETE query the same way you can write SELECT Query. They have same structure of syntax. You could also DELETE using JOIN as well. Try following query you will love it. DELETE tableName FROM tableName tn INNER JOIN JoinedTable jn ON jn.col = tn.... read more »

  • Using CASE Statements In A SQL UPDATE Query

    Posted on Aug 30, 2007 at 7:26 PM

    SQL can do many magical stuff. I use SQL for all the business logic. I use ColdFusion for presentation. CASE statement can be effectively used in ORDER BY : People do create whole anoth... read more »

  • Ask Ben: Protecting Database Table Names In ColdFusion CFQuery

    Posted on Jul 26, 2007 at 4:05 PM

    Ben, Good post. That is very true that if we specify explicit names of tables it is the safest. Let us see with real example that SQL can do the table exist check how application help database with the task. We are using application where we create lots of dynamically created tables, all are real... read more »

  • Ask Ben: Getting the Previous Day In ColdFusion, Excluding Saturday And Sunday

    Posted on Jul 23, 2007 at 4:02 PM

    Hi Ben, Not as simple as your solution. However, I use the similar function in SQL. I dig it up after I read your blog. Good post Ben! Pinal Dave... read more »

  • I Just Felt The Awesome Power Of SQL Table Indexing (Thanks Nate Nelson!)

    Posted on Jul 13, 2007 at 2:57 AM

    I recommend Thanks Tony. Pinal Dave... read more »

  • I Just Felt The Awesome Power Of SQL Table Indexing (Thanks Nate Nelson!)

    Posted on Jul 12, 2007 at 9:06 PM

    Hi Ben, First congratulations. Indexing is very important. In SQL Server 2005, the functionality of non-clustered indexes is extended by adding non-key columns to the leaf level of the non-clustered index. Non-key columns, can help to create cover indexes.By including non-key columns, you can crea... read more »