And to balance out the argument some, writing all the columns takes longer to write!
Go on, fire away, I'm in my bunker and the flaps are down :OD Adrian -----Original Message----- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: 14 April 2006 20:32 To: CF-Talk Subject: RE: 19 >= 19 - query error Rick, This is the easiest problem in the world to fix.... Don't use SELECT *. Name the column in the select statement. Not only does this cut out your problem, it also: 1. Makes the select statement more clear to anyone else reading. 2. Increases speed of the query. 3. Decreases the amount (most likely) of info that SQL has to transfer to the CF memory space. Cheers, ben ........................ Ben Nadel www.nylontechnology.com Sanders: Lightspeed too slow? Helmet: Yes we'll have to go right to ludacris speed. -----Original Message----- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Friday, April 14, 2006 11:51 AM To: CF-Talk Subject: 19 >= 19 - query error what the heck is this? 19 >= 19 The error occurred in E:\Inetpub\wwwroot\tools\email_responses\respond.cfm: line 20 18 : A.*, B.name as PRMLNAME 19 : FROM dbo.results A left join dbo.results2 b on a.fromAddress=b.email 20 : where id=<cfqueryparam cfsqltype="cf_sql_integer" value="#id#"> 21 : </CFQUERY> 22 : <cfoutput query="data"> It's worth noting that there are 18 columns in the table. I dropped another column and ran the query again and I got "18 >= 18" (now there are only 17 columns) here's the full query: SELECT A.*, B.name as PRMLNAME FROM dbo.results A left join dbo.results2 b on a.fromAddress=b.email where id=<cfqueryparam cfsqltype="cf_sql_integer" value="#id#"> Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237796 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
