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. -- Damien McKenna - Web Developer [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 #include <stdjoke.h> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:270965 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4