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 Web Developer Nylon Technology 350 7th Ave. Suite 1005 New York, NY 10001 212.691.1134 x 14 212.691.3477 fax 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:237794 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
