Random shot in the dark: I seem to recall that MS SQL server doesn't like fields that end in things like _date (maybe it's CF that doesn't like 'em, actually).
It would be silly, but could it be the table name itself, since it ends in _text? Don't think that's it, really, but what the hey. Luck be with you! -PS guess my real advice would be, ignore the line number, as sometimes that can be misleading, and send you on a red herring. Perhaps it's the sponsor.name, or some such, in reality, and for whatever reason, it's firing the wrong error? This is where that FusionDebug would probably come in handy, if you're not already set up thru eclipse by hand. ;-) On 2/28/07, 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271048 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
