<cfquery name = "qGetAllPropertiesAndOpenHouses"
datasource="#arguments.real_estate_dsn#">
select substring_index(p.mls_number, '_', 1) as p.mls_number,
p.street_number, p.street_name, p.city, p.state,
oh.mls_number, oh.date, oh.start_time, oh.end_time, oh.host_name
from properties p
left join fortstewart.open_houses oh
on substring_index(p.mls_number, '_', 1) = oh.mls_number
where p.listing_office_mls_id = '#arguments.listing_office_mls_id#'
order by p.street_name, p.street_number
</cfquery>
I keep getting a CF error stating I have a syntax error on this line:
where p.listing_office_mls_id = '#arguments.listing_office_mls_id#'
Anything?
Thanks!
Rick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354817
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
