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 --- --- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270971 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
