Avoid Select *

Posted At : April 17, 2006 1:41 PM | Posted By : Steve
Related Categories: SQL

A recent discussion on CF-Talk implied cfqueryparam as the culprit in a query problem. It seems, however that the problem only happens when using cfqueryparam in conjuction with "select *".

In the discussion, Ben Nadel pointed out reasons he recommends listing out columns instead of using of "select *". His words:

[More]

Comments (2) | Print | del.icio.us | Digg It! | Linking Blogs
Comments (Comment Moderation is enabled. Your comment will not appear until approved.)
[Add Comment]
I blogged about this particular issue ages ago:

http://www.1pixelout.net/2004/06/16/cfqueryparam/

I totally agree with you: always avoid using SELECT *
# Posted By Martin | 4/17/06 3:26 PM
Martin,

Thanks for pointing out that blog entry.

I hadn't considered the problem of adding a column before the end. I didn't know the database referenced the column list ordinally.

Another reason to avoid "select*".
# Posted By | 4/17/06 5:52 PM
[Add Comment]
BlogCFC was created by Raymond Camden. This blog is running version 5.8.001.