What if you put square brackets around the column [name], or try using a different column for a test to see if the compiler is confused between name and name (or, is that name, and name?... now I'm confused).
Mik At 01:42 PM 2/28/2007, you wrote: >The same error, the only difference is that the debugger highlights the >cfquery line rather than the name= line. > > >On 2/28/07 1:26 PM, Brad Wood wrote: >> What happens if you remove the cfqueryparam since it isn't needed given >> the fact you are passing a constant in? >> >> Where name = 'email_text' >> >> ~Brad >> >> -----Original Message----- >> From: Damien McKenna [mailto:[EMAIL PROTECTED] >> Sent: Wednesday, February 28, 2007 12:04 PM >> To: CF-Talk >> Subject: Wtf time: "name can't be empty"?? >> >> OK. Major confusion here with something that should be drop-dead >> simple. >> CFMX 6.1 hitting a SQL Server 2000 server. >> >> <cfquery name="msg_details" datasource="#application.dsn#"> >> select >> title, >> content >> from >> content_misc_text >> where >> name = <cfqueryparam value="email_text" >> cfsqltype="cf_sql_varchar" >> /> >> </cfquery> >> >> Anyone have any idea why it would give the error "name can't be empty" >> for >> the above statement? I'm thoroughly flummoxed. >> >> Thanks. >> >> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270970 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4