Use cfqueryparam to rule out the value of the arguments variable causing
syntax related issues.

When an error tells you the line number and it is in a query, it rarely is
that actual line; it just knows it is in the query somewhere.



On 3/5/13 11:47 AM, "Rick Faircloth" <r...@whitestonemedia.com> wrote:

>
><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:354825
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Reply via email to