Not concerned with the sql syntax as much as I am about not using
cfqueryparam.

Please please please take the time to convert every query you have to use
that.

Based on your cfarguments and db permissions for your dsn, a bad bad user
might be able to delete everything from your database.

Byron Mann
Lead Engineer & Architect
HostMySite.com
On Mar 5, 2013 11:48 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:354829
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Reply via email to