Move cfargument above the cfset
-----Original Message-----
From: Rick Faircloth [mailto:[email protected]]
Sent: Tuesday, June 01, 2010 5:00 PM
To: cf-talk
Subject: Can anyone see what's wrong with this cfc method?
I'm getting this error:
Context validation error for the cffunction tag.
The start tag must have a matching end tag. An explicit end tag can be
provided
by adding </cffunction>. ...
For this cffunction, and I cannot figure out why:
<cfcomponent displayName="properties" hint="Handles Property Data"
output="false">
<cffunction name = "mGetFeaturedProperty"
displayName = "mGetFeaturedProperty"
hint = "Gets Featured Property"
output = "false"
returnType = "query" >
<cfset var qGetFeaturedProperty = "" />
<cfargument name = "dsn2" type = "string" required =
"yes" />
<cfquery name = "qGetFeaturedProperty"
datasource="#arguments.dsn2#">
select p.property_id, p.property_type,
p.street_number,
p.street_name, p.city, p.remarks,
p.state, p.rental,
pl.propertyPhotoLink,
pl.photoLabel, fp.featured_property_id
from properties p,
hmls_property_photo_links pl, cbhr.featured_properties_cbhr fp
where p.mls_number = fp.mls_number
and substring_index(p.mls_number, '_',
1) = pl.mlsNumber
and pl.photoLabel = 'Main View'
group by p.property_id
order by rand()
limit 1
</cfquery>
<cfreturn qGetFeaturedProperty />
</cffunction>
</cfcomponent>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334203
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
