Am I being daft here, or is the problem because you aren't selecting name in
your query?
I thought you had to select the field you were using the WHERE clause on.
Does this work:
<cfquery name="msg_details" datasource="#application.dsn#">
select
title,
content,
name
from
content_misc_text
where
name = 'email_text'
</cfquery>
Cheers
Will
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271095
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
