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 Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270968 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4