can anyone help me translate this FROM in my SQL query so CF will like it?
it works fine in SQL but bombs in CF with syntax errors.
FROM ((((INT_AUX_LISTING
LEFT JOIN int_aux_listing as CompanyListing
ON (int_aux_listing.company_list_id =
CompanyListing.Listing_ID)
AND (int_aux_listing.Company_list_src_id =
CompanyListing.Listing_src_id))
left JOIN INT_AUX_LST_ADDR
ON (INT_AUX_LISTING.LISTING_SRC_ID =
INT_AUX_LST_ADDR.LISTING_SRC_ID)
AND (INT_AUX_LISTING.LISTING_ID =
INT_AUX_LST_ADDR.LISTING_ID))
left JOIN INT_AUX_ADDRESS
ON (INT_AUX_LST_ADDR.ADDRESS_SRC_ID =
INT_AUX_ADDRESS.ADDRESS_SRC_ID)
AND (INT_AUX_LST_ADDR.ADDRESS_ID =
INT_AUX_ADDRESS.ADDRESS_ID)
left JOIN INT_AUX_LST_PHONE
ON (int_aux_listing.LISTING_ID =
INT_AUX_LST_PHONE.LISTING_ID)
AND (int_aux_listing.LISTING_SRC_ID =
INT_AUX_LST_PHONE.LISTING_SRC_ID))
left JOIN INT_AUX_PHONE
ON (INT_AUX_PHONE.PHONE_ID = INT_AUX_LST_PHONE.PHONE_ID)
AND (INT_AUX_PHONE.PHONE_SRC_ID =
INT_AUX_LST_PHONE.PHONE_SRC_ID))
left join int_phone_typ
on (int_aux_phone.phone_typ_id = int_phone_typ.phone_typ_id)
left join int_relation_typ as Phone_Relation_TYP
on (int_aux_lst_phone.rltn_typ_id =
phone_relation_typ.rltn_typ_id)
i was working with the query builder and it seemed like it was using {
instead of (.
thanks for your help
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
