When we query with a star (*) in the SELECT statement,
does MS-Access return all the fields, even if they are empty?
I have over 50 fields in a perticuar table, but some pages only
use 3 or 4 of them. The rest are empty.
For performances sake, am I better off using:
<CFQUERY DATASOURCE="CSM" NAME="Data">
SELECT a1,a2,a3
FROM test
</cfquery>
instead of:
<CFQUERY DATASOURCE="CSM" NAME="Data">
SELECT *
FROM test
</cfquery>
Will it make a difference in speed?
(It would be alot simpler to use the *
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
