Some help with CFINPUT please?

[r937]

Originally Posted by cfStarlight

Whenever a statement does _not_ explicitly state what it needs, the database has to do some extra steps (lookups) to figure out what you need.

it is a common misconception that this is less work

the database has to look up every column you type in, just to verify that it actually ~is~ a column in the table(s) you're referencing

SELECT cust_id
     , cust_name
     , yabba_dabba_ding_dong
     , cust_address 
  FROM customers

if anything, the dreaded, evil "select star" is actually marginally faster to parse...

... but has so many other drawbacks that it should never be used

(well, except in those cases when it doesn't have drawbacks, for example in EXISTS subqueries)

[cfStarlight]

the database has to look up every column you type in, just to verify that it actually ~is~ a column in the table(s) you're referencing

Of course it does, but the less information you give it .. the more looking it has to do. I hope you are not saying that retrieving _all_ column details is just as efficient as looking for specific columns. Cause if you are I'd like to see some docs on that. I'm happy to be proven wrong, but I want some docs to prove it ! ;-)