The underscore is a wildcard placeholder. Try escaping it like so Name = 'email[_]text'
-Mark -----Original Message----- From: Steve Milburn [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 28, 2007 1:04 PM To: CF-Talk Subject: Re: Wtf time: "name can't be empty"?? I just looked it up - "name" does not seem to be a reserved word in SQL Server 2000, but it still may be worth a shot to enclose it in brackets (like Mik suggested as well). Steve > Damien McKenna wrote: > >> 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. >> >> > It could be that "name" is a reserved word. Try enclosing it in > brackets like so: > > where [name] = ..... > > Steve > --- > --- > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270978 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
